Dynamic database management system and method

• US 7,174,341 B2
• Filed: 05/31/2001
• Issued: 02/06/2007
• Est. Priority Date: 05/31/2001
• Status: Expired due to Fees

• Current Assignee: Synopsys Incorporated
• Original Assignee: Synopsys Incorporated
• Inventors: Chilingaryan, Suren, Lepejian, Yervant D., Ghukasyan, Hovhannes
• Primary Examiner(s): Vo; Tim
• Assistant Examiner(s): PHAM, HUNG Q
• Application Number:
  US09/871,485
• Publication Number:
  US 20020184228A1
• Time in Patent Office: 2,077 Days
• Field of Search: 707/200, 707/3, 707/2, 707/4, 707/103.Y, 707/1, 707/100, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A dynamic database management system includes a data dictionary, a data importer and a query front-end. The data importer automatically imports data from an input file into a database, while adding new tables for new attributes as necessary, and updating parameters and folders tables in the data dictionary accordingly, so that end-users may access the imported data by database queries through the query front-end.

Claims

1. A dynamic database management comprising:

a processor in conjunction with;

a data dictionary including identifications of related groups of tables in a database, information of tables in said related groups, and identifications of parameters of said related groups; and

a data importer receiving an input from an input file including data to be imported into said database, an indication of one of said related groups that is associated with said data, and parameters associated with said data,

wherein said data importer

forming a set of existing parameters and a set of new parameters from said parameters associated with said input data, based upon identification of parameter of said related groups stored in said data dictionary;

determines input data associated with said set of existing parameters, and input data associated with said set of new parameters;

appends one or more portions of said determined input data associated with said set of existing parameters to corresponding one or more existing tables associated with said set of existing parameters and having said related groups of tables as references;

creates a new table having said related groups of tables as references and fields corresponding to said new parameters;

imports said determined input data associated with new parameters to said created new table, and

updates said data dictionary to include said identifications and information of said new table and said new parameters, whereby said updated information includes identification of both of said one or more existing tables and said new table.

2. The system according to claim 1, further comprising:

a query front-end providing a parameter tree to be displayed to users for facilitating database queries,

wherein said data dictionary further includes information for said parameter tree, and said data importer further updates said information for said parameter tree to include information of said new table and new parameters.

3. The system according to claim 1, wherein said data dictionary has a reference groups table for storing indications of related groups of tables, and including columns for reference groups identifications and reference groups names.

4. The system according to claim 1, wherein said data dictionary has a references table for storing information of reference tables for individual of said related group of tables.

5. The system according to claim 1, wherein said data dictionary has a parameters table for storing information of parameters associated with individual of said related group of tables.

6. The system according to claim 2, wherein said data dictionary has a folders table for storing information of a parameter tree to be provided to said query front-end.

7. The system according to claim 6, wherein said data dictionary has a parameters table for storing information of parameters associated with individual of said related group of tables.

8. The system according to claim 7, wherein said data dictionary has a parameters-to-folders mapping table for mapping said information of parameters to corresponding information in said parameters-to-folders table.

9. A method for managing a dynamic database in a processing system, comprising:

creating a data dictionary including identifications of related groups of tables in said dynamic database, information of tables in said related groups, and identifications of parameters of said related groups;

receiving an input from an input file including data to be imported into said dynamic database, an indication of a related group of tables that is associated with said data, and parameters associated with said data;

determining input data associated with existing parameters and data associated with new parameters;

forming a set of existing parameters and a set of new parameters from said parameters associated with said input data, based upon identification of parameter of said related groups stored in created data dictionary;

determining input data associated with said set of existing parameters and input data associated with said set of new parameters;

appending said determined input data associated with said set of existing parameters to corresponding one or more existing tables having said related group of tables as references;

creating a new table having said related groups of tables as references and fields corresponding to said set of new parameters;

importing said determined input data associated with said set of new parameters to said created new table; and

updating said data dictionary to include identifications and information of said new table and said new parameters, whereby said updated information includes identification of both of said one or more existing tables and said new table.

10. The method according to claim 9, further comprising identifying said one or more existing tables having said related group of tables as references in said database from information in said data dictionary linking said one or more existing tables to said existing parameters.