Dynamic database management system and method
First Claim
Patent Images
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 importerforming 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, andupdates 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 Assignments
0 Petitions
Accused Products
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.
-
Citations
10 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
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. - View Dependent Claims (10)
-
Specification