System and method for extension of data schema

Details System and method for extension of data schema System and method for extension of data schema

2006-02-07

2006-02-07

Robinson, Greta (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C715S252000

Reexamination Certificate

active

06996568

ABSTRACT:
A system and method for defining and using logical extensions to a set of data stored in a relational database. A metadata definition for various extensions is stored to explain how to extend data as it is stored into a logical representation suitable for reporting and calculating purposes. An analytical engine translates report requests into SQL queries to access the physically stored data using the metadata extension definitions if necessary to generate appropriate results. Here, data is stored in at least one table that is physically keyed by a set of attributes with the attribute determining the granularity or level of data contained within the tables. A report request causes the engine to calculate and/or display the data at a lower level of granularity than exists, thereby invoking the metadata definitions. The extension definitions may describe how to extend data from the physical to the logical including joins and allocation rules.

REFERENCES:
patent: 4688195 (1987-08-01), Thompson
patent: 4829423 (1989-05-01), Tennant
patent: 5197005 (1993-03-01), Shwartz
patent: 5276870 (1994-01-01), Shan
patent: 5418943 (1995-05-01), Borgida
patent: 5421008 (1995-05-01), Banning
patent: 5555403 (1996-09-01), Cambot
patent: 5584024 (1996-12-01), Shwartz
patent: 5664182 (1997-09-01), Nirenberg
patent: 5692181 (1997-11-01), Anand et al.
patent: 5864856 (1999-01-01), Young
patent: 5870746 (1999-02-01), Knutson
patent: 5905985 (1999-05-01), Malloy
patent: 5914878 (1999-06-01), Yamamoto
patent: 5918225 (1999-06-01), White
patent: 5918232 (1999-06-01), Pouschine
patent: 5940818 (1999-08-01), Malloy
patent: 5943668 (1999-08-01), Malloy
patent: 5943677 (1999-08-01), Hicks
patent: 5970476 (1999-10-01), Fahey
patent: 5978796 (1999-11-01), Malloy
patent: 6094651 (2000-07-01), Agrawal
patent: 6122636 (2000-09-01), Malloy
patent: 6154766 (2000-11-01), Yost
patent: 6195653 (2001-02-01), Bleizeffer et al.
patent: 6233583 (2001-05-01), Hoth
patent: 6247008 (2001-06-01), Cambot
patent: 6279033 (2001-08-01), Selvarajan
Gupta, Himanshu et al., “Index Selection for OLAP,” IEEE 1063-6382, pp. 208-219.
Ho, Ching-Tien et al., “Partial-Sum Queries in OLAP Data Cubes Using Covering Codes,” ACM 0-89791-910-6, pp. 228-237.
Robert C. Stern, Bruce M. Anderson and Craig W. Thompson, A Menu-Based Natural Language Interface To A Large Database, Texas Instruments Incorporated, P. O. Box 660246, MS 238, Dallas, Texas 75266, NAECON: National Aerospace & Electronics Conference, Dayton, Ohio, May 20-24, 1985.
Harry R. Tennant, Kenneth M. Ross, Richard M. Saenz, Craig W. Thompson, and James R. Miller, Computer Science Laboratory, Central Research Laboratories, Texas Instruments Incorporated, Dallas, Texas, 21st Annual Meeting of the Association for Computational Linguistics, MIT, Jun., 1983, pp 151-158.
Harry R. Tennant, Member, IEEE, Roger R. Bate, Member, IEEE, Stephen M. Corey, Lawrence Davis, Paul Kline, LaMott G. Oren, Malipatola Rajinikanth, Richard Saenz, Daniel Stenger, Member, IEEE, and Craig W. Thompson, Software Innovations for the Texas Instruments Explorer Computer, Proceedings of the IEEE, vol. 73, No. 12, Dec. 1985.
Craig W. Thompson, Kenneth M. Ross, Harry R. Tennant and Richard M. Saenz, Buiding Usable Menu-Based Natural Language Interfaces To Databases, Proceedings of the Ninth International Conference on Very Large Data Bases, Florence, Italy, Oct. 31-Nov. 2, 1983, pp. 43-55.
Craig W. Thompson, John Kolts, and Kenneth W. Ross, A Toolkit for Building “Menu-Based Natural Language” Interfaces, Texas Instruments Incorporated, P. O. Box 226015, MS 238, Dallas, Texas 75265, 1985.
Craig Warren Thompson, M.A., B.A., Using Menu-Based Natural Language Understanding to Avoid Problems Associated with Traditional Natural Language Interfaces to Databases, Dissertation Presented to the Faculty of the Graduate School of The University of Texas at Austin, May 1984.
Business Objects User's Guide Version 5.1 (electronic copy on enclosed CD).
Getting Started with Business Objects Version 5.1 (electronic copy on enclosed CD).
Business Objects Deployment Guide (electronic copy on enclosed CD).
Broadcast Agent 5.1 (electronic copy on enclosed CD).
Business Objects 5.1 (electronic copy on enclosed CD).
Web Intelligence 2.6 (electronic copy on enclosed CD).
Business Objects Designer's Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects Error Message Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects Generic ODBC Access Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects Info View User's Guide (electronic copy on enclosed CD).
Business Objects Installation and Upgrade Guide (electronic copy on enclosed CD).
Business Objects MS Access Database Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects MS SQL Server Database Guide Version 5.1 (electronic copy on enclosed CD).
Business Objections Supervisor's Guide Verison 5.1 (electronic copy on enclosed CD).
GIS/LIS'88 Proceedings accessing the world, vol. 2 pp. 741-750.
Quick Start MicroStrategy Agent Version 6.0 (electronic copy on enclosed CD).
User Guide MicroStrategy Agent Version 6.0 (electronic copy on enclosed CD).
User Guide MicroStrategy Architect Version 6.0 (electronic copy on enclosed CD).
User Guide MicroStrategy Objects Version 6.0 (electronic copy on enclosed CD).
Excel Add-In MicroStrategy Objects Version 6.0 (electronic copy on enclosed CD).
User Guide MicroStrategy Intelligence Server Version 6.0 (electronic copy on enclosed CD).
User Guide MicroStrategy Administrator Version 6.0 (electronic copy on enclosed CD).
Administrator Guide MicroStrategy Administrator Version 6.5 (electronic copy in enclosed CD).

Affiliated with

Also associated with

Rating

System and method for extension of data schema does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for extension of data schema, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for extension of data schema will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3653100