Apparatus for providing a reverse star schema data model
Patent 6411961 Issued on June 25, 2002. Estimated Expiration Date: May 6, 2019. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.
707/102, Generating database or data structure (e.g., via user interface)705/10, Market analysis, demand forecasting or surveying707/104.1Application of database or data structure (e.g., distributed, multimedia, image)
According to the invention, techniques for organizing information from systems in a data warehousing environment are provided. In a particular embodiment, the invention provides an apparatus for analyzing data in at least data source of an enterprise. The apparatus can include a meta model for an enterprise. The enterprise is typically a business activity, but can also be other loci of human activity. A data schema derived from the meta model can also be part of the apparatus. The apparatus can also include a database organized according to the data schema. The apparatus can translate data from a variety of sources to the data schema. The apparatus can incorporate data into the database and perform a variety of analyses on the data in the database.
Other References
Gopalkrishnan et al. Star/Snow-flake Schema Driven Object-Relationship Data Warehouse Design and Query Processing Strategy. star schema conversion to object-relational warehouse.
Brooks. Mark of the data marts. DBMS, Mar. 1997, v10, n3, pp 55(4).
Krippendorf et al. The translation of star schema into entity relationship diagrams. Database and Expert Systems Applications, Sep. 1997, pp. 390-395.
Greene. Oracle8 Server Unleashed. Sams, 1998, chapter 30 "Data Warehouses".
Brachman et al. Mining Business Databases. Communications of the ACM, Nov. 1996, pp. 42-48.
Firestone. Object-oriented Data Warehousing. Executive Information Systems, Inc. White Paper No. 5, Aug. 7, 1997, downloaded Jul. 25, 2001 http://dkms.co