Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-11-28
2006-11-28
Rimell, Sam (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C715S252000
Reexamination Certificate
active
07143107
ABSTRACT:
A reporting engine for generating customized reports from relational data stored in a database. Metadata associated with the data in the database describes the data according to one or more characteristics of the data. One or more of tables organizing the metadata is exposed as a dimension having at least one column of attributes. The reporting enging compares search criteria, specified by a request from a user, to the metadata attributes, and executes a predefined procedure for retrieving selected data from the database. The procedure constructs a query as a function of the comparison between the search criteria and the metadata attributes for implementing the query to optimize retrieval of the selected data from the database. Other aspects of the invention are directed to computer-readable media for use in connection with the reporting engine.
REFERENCES:
patent: 5201047 (1993-04-01), Maki et al.
patent: 5590324 (1996-12-01), Leung et al.
patent: 5692181 (1997-11-01), Anand et al.
patent: 5822751 (1998-10-01), Gray et al.
patent: 6047284 (2000-04-01), Owens et al.
patent: 6105043 (2000-08-01), Francisco et al.
patent: 6134564 (2000-10-01), Listou
patent: 6269368 (2001-07-01), Diamond
patent: 6356906 (2002-03-01), Lippert et al.
patent: 6442560 (2002-08-01), Berger et al.
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6502089 (2002-12-01), Amundsen et al.
patent: 6507835 (2003-01-01), Amundsen et al.
patent: 6535874 (2003-03-01), Purcell
patent: 6542893 (2003-04-01), Quernemoen
patent: 6549907 (2003-04-01), Fayyad et al.
patent: 6564204 (2003-05-01), Amundsen et al.
patent: 6574623 (2003-06-01), Leung et al.
patent: 6581052 (2003-06-01), Slutz
patent: 2003/0028550 (2003-02-01), Lee et al.
patent: 2004/0139043 (2004-07-01), Lei et al.
Wyss et al., “A Relational Algebra for Data/Metadata Integration in a Federated Database System,” Proceedings of the Tenth International Conference on Information and Knowledge Management, 2001, pp. 65-72, ACM Press, New York, U.S.A.
Jones, “An Introduction to Data Warehousing: What Are the Implications for the Network?,” International Journal of Network Management, Jan.-Feb. 1998, vol. 8, Issue 1, pp. 42-56, John Wiley & Sons, Inc., New York, U.S.A.
Rahm et al., “A Survey of Approaches to Automatic Schema Matching,” The VLDB Journal—The International Journal on Very Large Data Bases, Dec. 2001, vol. 10, Issue 4, pp. 334-350, Springer-Verlag New York, Inc., Secaucus, New Jersey, U.S.A.
Lakshmanan et al., “SchemaSQL: An Extension to SQL for Multidatabase Interoperability,” ACM Transactions on Database Systems (TODS), 2001, vol. 26, Issue 4, pp. 476-519, ACM Press, New York, U.S.A.
Babcock et al., “Dynamic Sample Selection for Approximate Query Processing,” Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data, 2003, pp. 539-550, ACM Press, New York, U.S.A.
Lipton et al., “Query Size Estimation by Adaptive Sampling (extended abstract),” Proceedings of the Ninth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, 1990, pp. 40-46, ACM Press, New York, U.S.A.
Kim Paul
Microsoft Corporation
Rimell Sam
Senniger Powers
LandOfFree
Reporting engine for data warehouse does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Reporting engine for data warehouse, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Reporting engine for data warehouse will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3697139