Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-05-31
2004-04-06
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06718335
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Technical Field
This invention generally relates to meta data, and more specifically, to a meta data repository that stores summary information about data.
2. Prior Art
Meta data is information about data. For example, meta data about a particular database might contain descriptions about what type of information is held in each table and field within the database. The databases meta data would also explain the physical attributes of the database such as the types and lengths of the fields, table spacing, indexing, etc. Basically, the meta data repository should be the one place to find out everything and anything about a database.
Meta data catalogs are collections or repositories of meta data. These catalogs are playing an increasingly vital role in publishing authenticated information and in storing and disseminating such information through a controlled but uniform interface. While these catalogs are of substantial use, the normal meta data catalog has several constraints. For instance, these catalogs are inactive—that is, nothing can really be done to the data in the catalogs. Also, these catalogs provide only limited information. The meta data catalog may provide complete information about a particular database, but all the information in that database came from another database, and often a user needs to know more about that other database.
Various attempts have been made to eliminate or alleviate these constraints. A persistent problem, however, is that the catalogs do not hold all the information a user might want. In particular, while a meta data catalog may hold all the physical information of a database, a user is normally not able to determine from the catalog, where the information came from—that is, the mappings indicating how one database maps to another.
In addition, when several systems are used that all need meta data to function and that all have their own meta data repositories, these repositories must be kept in synchronization with each other. For instance, typically in a data warehouse, extraction programs are used to move data from the operational system to the warehouse, and reporting tools are used to allow business analysts to analyze the warehoused data. Both the extraction programs and the reporting tools have their own meta data; and if a field on one table in the operation system changes, this information must be updated in several places: the warehouse itself, the extraction programs, and the reporting tools.
SUMMARY OF THE INVENTION
An object of this invention is to provide an improved meta data catalogue.
Another object of the present invention is to provide a meta data catalog with the ability to drive changes in associated systems.
These and other objective are achieved with a data warehouse, comprising means for database modeling, and means for extracting data from the database and storing the extracted data. A reporting tool is used to make inquiries of the stored data and to format the results of the inquiries, and a single meta data catalog is coupled to the means for modeling, the means for extracting and storing, and the reporting tool. With the preferred embodiment of this invention, a user needs to update information only once. The catalog meta data then drives changes in associated systems, such as a warehouse, extraction programs and reporting tools. In order to accomplish this, the meta data catalog holds enough information to control all these various parts of the process.
The present invention allows a developer to quickly model a new database based on an existing database, identify how the two databases are linked to each other (mapping information), create the database definition, and then use all this captured information in a variety of reporting methods. All the pertinent data are in one location. The meta data catalog is of particular use in very large databases (1000+tables), because much of the functionality included allows changes to the data model to be made quickly and globally when needed.
Further benefits and advantages of the invention will become apparent from a consideration of the following detailed description, given with reference to the accompanying drawing, which specifies and shows a preferred embodiment of the invention.
REFERENCES:
patent: 5586326 (1996-12-01), Ryu et al.
patent: 5644766 (1997-07-01), Coy et al.
patent: 5692181 (1997-11-01), Anand et al.
patent: 5721922 (1998-02-01), Dingwall
patent: 5778368 (1998-07-01), Hogan et al.
patent: 5787412 (1998-07-01), Bosch et al.
patent: 5835959 (1998-11-01), McCool et al.
patent: 5857197 (1999-01-01), Mullins
patent: 5860071 (1999-01-01), Ball et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5999947 (1999-12-01), Zollinger et al.
patent: 6003039 (1999-12-01), Barry et al.
patent: 6018742 (2000-01-01), Herbert, III
patent: 6044374 (2000-03-01), Nesamoney et al.
patent: WO 97-15018 (1997-04-01), None
patent: WO 99/00745 (1999-01-01), None
Stephen R. Gardner, “Building the Data Warehouse”, Sep. 1998, ACM, Communications of the ACM, vol. 41, No. 9, p. 52-60.*
Charles Bontempo, George Zagelow, “The IBM Warehouse Architecture”, Sep. 1998, ACM, Communications of the ACM, vol. 41, No. 9, p. 38-48.*
Dr. Katherine Jones, “An Introduction to Data Warehousing: What are the Implications for the Network?”, 1998, John Wiley & Sons, Ltd., Internation Journal of Network Management, vol. 8, p. 42-56.*
Rajasekar, Arcot, “MCAT-A Meta Information Catalog (Version 1.1)”, (last modified: May 11, 1998), <http://www.npaci.edu/Research/DI/srb/mcat.html>.
Homere Jean R.
Schiesser William E.
Scully Scott Murphy & Presser
LandOfFree
Datawarehouse including a meta data catalog does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Datawarehouse including a meta data catalog, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Datawarehouse including a meta data catalog will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3192722