Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-05-06
2010-06-15
Colbert, Ella (Department: 3696)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C709S201000
Reexamination Certificate
active
07739224
ABSTRACT:
A method of defining a well-formed database system by defining the organization of the data in the database, and by defining the operations for that data, is described. The definition can be used to automatically create and populate the well-formed database system. The well-formed database system conforms to rules of correctness and produces results that conform to the rules. The organization is defined by a data organization definition that specifies tables, their columns, and the relationships between tables. The operations define procedures that operate on the tables and the table columns. Importantly, the operations are defined along with the tables, columns, and relationships, so that the resulting system is well-formed.
REFERENCES:
patent: 5249300 (1993-09-01), Bachman et al.
patent: 5272628 (1993-12-01), Koss
patent: 5295256 (1994-03-01), Bapat
patent: 5386556 (1995-01-01), Hedin et al.
patent: 5428776 (1995-06-01), Rothfield
patent: 5550971 (1996-08-01), Brunner et al.
patent: 5659724 (1997-08-01), Borgida et al.
patent: 5675785 (1997-10-01), Hall et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5721903 (1998-02-01), Anand et al.
patent: 5806060 (1998-09-01), Borgida et al.
patent: 5832496 (1998-11-01), Anand et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5905985 (1999-05-01), Malloy et al.
patent: 5978811 (1999-11-01), Smiley
patent: 5995958 (1999-11-01), Xu
patent: 6014670 (2000-01-01), Zamanian et al.
patent: 6032158 (2000-02-01), Mukhopadhyay et al.
patent: 6055541 (2000-04-01), Solecki et al.
patent: 6085198 (2000-07-01), Skinner et al.
patent: 6108004 (2000-08-01), Medl
patent: 6128624 (2000-10-01), Papierniak et al.
patent: 6161103 (2000-12-01), Rauer et al.
patent: 6167405 (2000-12-01), Rosensteel, Jr. et al.
patent: 6189004 (2001-02-01), Rassen et al.
patent: 6212524 (2001-04-01), Weissman et al.
patent: 6263341 (2001-07-01), Smiley
patent: 6282544 (2001-08-01), Tse et al.
Brachman, Ronald J., Khabaza, Tom, Kloesgen, Willi, Piatetsky-Shapiro, Gregory, and Simoudis, Evangelos; “Mining Business Databases,” vol. 39, issue 11; Nov. 1996; pp. 42-48.
Friedland, Liam; “Accessing the Data Warehouse: Designing Tools to Facilitate Business Understanding”; vol. 5, issue 1; Jan. 1998; pp. 25-36.
Michael Krippendorf and Il-Yeol Song; “The Translation of Star Schema into Entity-Relationship Diagrams”; IEEE; Sep. 1-2, 1997; pp. 390-395.
Matteo Golfarelli, Dario Maio, and Stefano Rizzi;“Conceptual Design of Data Warehouses from E/R Schema”; IEEE; Jan. 6-9, 1998; pp. 1-10.
Ralph Kimball; “DBMS Online Data Warehouse Architect: Is Data Staging Relational? Or does it have more to do with sequentil processing?”; Apr. 1998; pp. 1-6.
Ralph Kimball; “DBMS online Data Warehouse Architect: Turbocharge Your Query Tools”; Sep. 1997; pp. 1-5.
Star Schema; From Wikipedia, the free encyclopedia; http://en.wilipedia.org/wiki/Star—schema; Unknown date; pp. 1-4.
PR Newswire; “Influence Software to Integrate Aperio With Silicon Graphics MineSet for Web-Based Data Mining/Data Warehouse Suite”; Apr. 14, 1998; pp. 1 and 2.
Diane Vint-Johnson and Deborah Henderson; “A Short Course on OLAP Tools”; Apr. 1998; pp. 15-17.
Tim Fielden; “Speedware's Media Makes OLAP Easy”; Mar. 23, 1998; p. 124.
Shawn Willet; “Beyond the Warehouse: IBM Banks on Channel to Restructure Now Corporations Organize, Store and Access Data Via Business Intelligence”; Mar. 16, 1998; pp. 111 and 113.
Business Wire; “Hyperon Software Announces New Family of Multi-Dimensional Business Analysis Applications; Purpose-Built Applications Move Beyond Raw OLAP Tools and Technologies”; Mar. 2, 1998; pp. 1-5.
Kimball, R., “The Data Warehouse Toolkit”, (1996) John-Wiley & Sons, Inc., 388 pages (includes CD ROM).
Chawathe, S. et al., “Change Detection in Hierarchically Structured Information”,SIGMOD Record, vol. 25, No. 2, Jun. 1996, pp. 493-504.
Chawathe, S. et al., “Meaningful Change Detection in Structured Data”,Proceedings of the 1997 ACM SIGMOD International Conference, ACM Press, 1997, pp. 26-37.
Labio, W. et al., “Efficient Snapshot Differential Algorithms for Data Warehousing”, Department of Computer Science, Stanford University, (1996), pp. 1-13.
Wiener, J. et al., “A System Prototype for Warehouse View Maintenance”,The Workshop on Materialized Views, pp. 26-33, Montreal, Canada, Jun. 1996.
Kawaguchi, A. et al., “Concurrency Control Theory for Deferred Materialized Views”, Database Theory—ICDT '97,Proceedings of the 6th International Conference, Delphi, Greece, Jan. 1997, pp. 306-320.
Zhuge, Y. et al., “Consistency Algorithms for Multi-Source Warehouse View Maintenance”,Distributed and Parallel Databases, vol. 6, pp. 7-40 (1998), Kluwer Academic Publishers.
Zhuge, Y. et al., “View Maintenance in a Warehousing Environment”,SIGMOD Record, vol. 24, No. 2, Jun. 1995, pp. 316-327.
Widom, J., “Research Problems in Data Warehousing”,Proc. of 4th Int'l Conference on Information and Knowledge Management(CIKM), Nov. 1995, 6 pages.
Yang, J. et al., “Maintaining Temporal Views Over Non-Historical Information Sources for Data Warehousing”,Advances in Database Technology—EDBT '98, Proceedings of the 6th International Conference on Extending Database Technology, Valencia, Spain, Mar. 1998, pp. 389-403.
Quass, D., “Maintenance Expressions for Views with Aggregation”,Proceedings of the 21st International Conference on Very Large Data Bases, IEEE, Zurich, Switzerland, (Sep. 1995), 9 pages.
Mumick, I. et al., “Maintenance of Data Cubes and Summary Tables in a Warehouse”,Proceedings of the 1997 ACM SIGMOD International Conference, ACM Press, 1997, pp. 100-111.
Huyn, N., “Multiple-View Self-Maintenance in Data Warehousing Environments”,Proceedings of the 23rd International Conference on Very Large Data Bases, IEEE, (1997), pp. 26-35.
Quass, D. et al., “Making Views Self-Maintainable for Data Warehousing”,Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems, IEEE, Dec. 1996, pp. 158-169.
Quass, D. et al., “On-Line Warehouse View Maintenance”,Proceedings of the 1997 ACM SIGMOD International Conference, ACM Press, 1997, pp. 393-404.
Gupta, H., “Selection of Views to Materialize in a Data Warehouse”, Database Theory—ICDT '97,Proceedings of the 6th International Conference, Delphi, Greece, Jan. 1997, pp. 98-112.
Harinarayan, V. et al., “Implementing Data Cubes Efficiently”,SIGMOD Record, vol. 25, No. 2, Jun. 1996, pp. 205-216.
Gupta, H. et al., “Index Selection for OLAP”, IEEE Paper No. 1063-6382/97,IEEE(1997), pp. 208-219.
Labio, W. et al., “Physical Database Design for Data Warehouses”, IEEE Paper No. 1063-6382/97,IEEE(1997), pp. 277-288.
Gupta, A. et al., “Aggregate-Query Processing in Data Warehousing Environments”,Proceedings of the 21st VLDB Conference, Zurich, Switzerland, Sep. 1995, pp. 358-369.
O'Neill, P. et al., “Improved Query Performance with Variant Indexes”,Proceedings of the 1997 ACM SIGMOD International Conference, ACM Press, 1997, pp. 38-49.
McAlpine, G. et al., “Integrated Information Retrieval in a Knowledge Worker Support System”, Proc. of the Intl. Conf. on Research and Development in Information Retrieval (SIGIR), Cambridge, MA, Jun. 25-28, 1989, Conf. 12, pp. 48-57.
Tsuda, K. et al., “IconicBrowser: An Iconic Retrieval System for Object-Oriented Databases”, Proc. of the IEEE Workshop on Visual Languages, Oct. 4, 1989, pp. 130-137.
“Multiple Selection List Presentation Aids Complex Search”, IBM Technical Disclosure Bulletin, vol. 36, No. 10, Oct. 1993, pp. 317-318.
Mike Feuche, “Index Interface Links CASE and IBM's DB2,” Oct. 24, 1988, Index
Walsh Gregory Vincent
Wegbreit Eliot Leonard
Weissman Craig David
Blank Rome LLP
Colbert Ella
Infor Global Solutions (Michigan), Inc.
LandOfFree
Method and system for creating a well-formed database using... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for creating a well-formed database using..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for creating a well-formed database using... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4238891