CN101236568A - Dynamic data base construction method - Google Patents
Dynamic data base construction method Download PDFInfo
- Publication number
- CN101236568A CN101236568A CNA2008100340864A CN200810034086A CN101236568A CN 101236568 A CN101236568 A CN 101236568A CN A2008100340864 A CNA2008100340864 A CN A2008100340864A CN 200810034086 A CN200810034086 A CN 200810034086A CN 101236568 A CN101236568 A CN 101236568A
- Authority
- CN
- China
- Prior art keywords
- class
- attribute
- list
- hierarchical relationship
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a building method for a dynamic database, comprising the following operation steps: firstly, a classification list, an attribute list, a hierarchical relationship list, an object list and an attribute value list are generated; secondly, storage objects are identified; thirdly, the storage objects are abstracted into classes; class names and class attributes are determined; the class names are filled in the classification list; class attribute names are filled in the attribute list; fourthly, hierarchical relationships between the classes are determined; hierarchical relationship data of the classes are filled in the hierarchical relationship list; fifthly, the classes are instantiated; the abstracted class names and the abstracted class attribute names are respectively endowed with corresponding values which are then stored in the object list and the attribute value list; sixthly, hierarchical relationships between class examples are determined, and corresponding hierarchical relationship values are stored in the hierarchical relationship list; seventhly, a target database is generated. The method dynamically generates the database in virtue of an object-oriented method and all products are allowed to have consistent data description forms, thereby flexibility and compatibility of an application system are improved, and development cycle and cost of a database system are greatly reduced.
Description
Technical field
The present invention relates to a kind of dynamic data base construction method, specifically, is a kind of database construction method based on the SQL SERVER of Microsoft software.
Background technology
Traditional relation data base construction method is generally undertaken by the E-R model.The structure person is at first by each storage object of identification, and after excavating its mutual relationship, set up the corresponding E-R model of describing these storage objects and mutual relationship thereof, be converted to relational model then, finish the structure work of entire database by creating corresponding tables of data again.The method of this structure database is accurately clear, is present the most frequently used a kind of database construction method.But, the shortcoming of this method is to lack the support to dynamic modeling, constructed database structure is fixed, can only reflect static, pre-determined storage object and mutual relationship thereof, must be thereby cause at the different different database structures of database application design, and when the storage object of Database Systems or when describing attribute and changing, just have to could adapt to this variation to the structure redesign (database restructuring) of this database.Yet along with the continuous expansion of the infosystem application in modern times, the demand of dynamic modeling has proposed challenge to traditional relation data base construction method.Many specific areas all require Database Systems can manage the storage object of continuous variation, describe the management object and the attribute information of dynamic change.
Summary of the invention
The objective of the invention is to problem, a kind of dynamic data base construction method is provided at the prior art existence.Utilize this method, can in the Database Systems operational process, dynamically make up database, thereby improve service efficiency, dirigibility and the compatibility of Database Systems, reduce the cycle and the expense of information management system exploitation according to practical application request.
The core of the dynamic data base construction method that the present invention proposes is the OO thought of utilization, realizes dynamically setting up database and Dynamic Maintenance database structure.Operation steps is as follows:
1) generates classification table, attribute list, hierarchical relationship table, Object table and attribute value table;
2) identification storage object;
3) with storage object abstract be class, determine the attribute of class name and class, insert class name to the classification table, insert the attribute-name of class to attribute list;
4) determine hierarchical relationship between the class, in the hierarchical relationship table, insert the hierarchical relationship data of class;
5) instantiation class is given corresponding value respectively with the attribute-name of abstract class name that comes out and class, deposits Object table and attribute value table in;
6) determine hierarchical relationship between the class example, in the hierarchical relationship table, deposit corresponding hierarchical relationship value in;
7) generate target database
Making up in the method for database according to this method, described classification table includes 5 fields, and described attribute list has 4 fields, and described hierarchical relationship table has 5 fields, and described Object table has 4 fields, and described attribute value table has 5 fields.
Making up in the method for database according to this method, described tables of data can also comprise log sheet, subscriber's meter and authority list etc.
Making up according to this method in the method for database, the attribute of described class is various features of describing storage object.
Making up according to this method in the method for database, described class is the set that the attribute that extracts from storage object is formed, perhaps the community set that is provided with according to user's needs.
Making up according to this method in the method for database, described tables of data and database leave in the computer-internal storer or external disk of operation application system.
Implement database construction method provided by the present invention, a kind of method for the treatment of storage object with OO visual angle can either be provided, thereby more easily the storage object in the real world is converted to the data model that computing machine can be represented, again can by class generalization of dynamic perfromance description, object identifier, class and the polymerization of specialization, class with decompose isotype, thereby the method for operation parameterization is extracted the common trait of these objects uniformly to these object modelings.After the product object being carried out consistent modeling, just be formed naturally unified Database Systems, promptly all products all have identical structure, according to system requirements these product objects are connected and form tables of data and target database.Simultaneously, the consistance of product data is handled and is also made system user can revise product freely according to the needs of self, the contact of product and the data structure of product.Improve the dirigibility and the practicality of application system, significantly reduced the repeated workload that is applied to, reduced the cycle and the expense of Database Systems exploitations.
Description of drawings
Fig. 1 is that the dynamic data base of one embodiment of the invention makes up the implementation step synoptic diagram.
Embodiment
Below in conjunction with embodiment and accompanying drawing the present invention is further explained explanation.
Embodiment one: the vehicle management database, and referring to Fig. 1.
1) in the Enterprise of SQL SERVER Manager, creates classification table, attribute list, hierarchical relationship table, Object table and attribute value table; 2) according to regulatory requirement, identify storage object: automobile, truck, engine, tire etc.; 3) with these storage objects abstract be class, and determine the attribute of corresponding class name and class.As automotive-type, truck class etc., the attribute of truck: price, dead weight capacity, model and color etc.Then, each class name is inserted the classification table as an entry; Each attribute-name is inserted attribute list as an entry; 4) hierarchical relationship between the establishment class is divided into truck, car, motorbus etc. such as automobile, and truck is made up of engine, tire etc.Then these hierarchical relationship data are inserted in the hierarchical relationship table; 5) carry out the class instantiation according to the concrete object that will manage, be instantiated as east wind DF6, liberation JF6, and deposit east wind DF6 and the value of liberating JF6 and price, dead weight capacity, model and color in Object table and attribute value table respectively as the truck that will be abstract comes out; 6) determine hierarchical relationship between the class example, deposit in the corresponding hierarchical relationship table as the component relationship of east wind DF6 and the general TY6 of engine; 7) promptly generate target database after the input of all data.
Embodiment two: the management of computer, and also referring to Fig. 1.
1) in the Enterprise of SQL SERVER Manager, creates classification table, attribute list, hierarchical relationship table, Object table and attribute value table; 2) according to regulatory requirement, identify storage object: computer, desktop computer, laptop computer, display, keyboard, mainboard, cabinet etc.; 3) with these storage objects abstract be class, and determine the attribute of corresponding class name and class.As computer, desktop computer class etc., the attribute of desktop computer: price, model, color, date of manufacture etc.Then, each class name is inserted the classification table as an entry; Each attribute-name is inserted attribute list as an entry; 4) hierarchical relationship between the establishment class is divided into desktop computer, laptop computer etc. such as computer, and desktop computer is made up of display, keyboard, mainboard, cabinet etc.Then these hierarchical relationship data are inserted in the hierarchical relationship table; 5) carry out the class instantiation according to the concrete object that will manage, as the abstract desktop computer that comes out is instantiated as association's rising sun 1412, DELL 760m, and will associate the rising sun 1412 and DELL 760m and price thereof, model, color, the value of date of manufacture deposits Object table and attribute value table respectively in; 6) determine hierarchical relationship between the class example, deposit in the corresponding hierarchical relationship table as the component relationship in association's rising sun 1412 and 2 generations of the colorful office master-hand of keyboard; 7) promptly generate target database after the input of all data.
Claims (6)
1. dynamic data base construction method is characterized in that operation steps is as follows:
A. generate classification table, attribute list, hierarchical relationship table, Object table and attribute value table;
B. discern storage object;
C. with storage object abstract be class, determine the attribute of class name and class, insert class name to the classification table, insert the attribute-name of class to attribute list;
D. determine the hierarchical relationship between the class, in the hierarchical relationship table, insert the hierarchical relationship data of class;
E. instantiation class is given corresponding value respectively with the abstract class name that comes out and the attribute-name of class, deposits Object table and attribute value table in;
F. determine the hierarchical relationship between the class example, in the hierarchical relationship table, deposit corresponding hierarchical relationship value in;
G. generate target database.
2. dynamic data base construction method as claimed in claim 1, it is characterized in that described classification table includes 5 fields, described attribute list has 4 fields, and described hierarchical relationship table has 5 fields, described Object table has 4 fields, and described attribute value table has 5 fields.
3. dynamic data base construction method as claimed in claim 1, the attribute that it is characterized in that described class are the various features of describing storage object.
4. dynamic data base construction method as claimed in claim 1 is characterized in that described tables of data leaves in the computer-internal storer or external disk of operation application system.
5. dynamic data base construction method as claimed in claim 1 is characterized in that described database leaves in the computer-internal storer or external disk of operation application system.
6. dynamic data base construction method as claimed in claim 1 is characterized in that described database also comprises log sheet, subscriber's meter and authority list.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008100340864A CN101236568A (en) | 2008-02-29 | 2008-02-29 | Dynamic data base construction method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2008100340864A CN101236568A (en) | 2008-02-29 | 2008-02-29 | Dynamic data base construction method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101236568A true CN101236568A (en) | 2008-08-06 |
Family
ID=39920186
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA2008100340864A Pending CN101236568A (en) | 2008-02-29 | 2008-02-29 | Dynamic data base construction method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101236568A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105677776A (en) * | 2015-12-30 | 2016-06-15 | 厦门欣欣信息有限公司 | Data processing method and device |
CN105787013A (en) * | 2016-02-05 | 2016-07-20 | 北京天广汇通科技有限公司 | Type name distributing method and system for heterogeneous data |
CN106156971A (en) * | 2015-04-21 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Logistic resources conspiracy relation information processing method and device |
CN106802947A (en) * | 2017-01-13 | 2017-06-06 | 中国工商银行股份有限公司 | The data handling system and method for entity relationship diagram |
-
2008
- 2008-02-29 CN CNA2008100340864A patent/CN101236568A/en active Pending
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106156971A (en) * | 2015-04-21 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Logistic resources conspiracy relation information processing method and device |
CN105677776A (en) * | 2015-12-30 | 2016-06-15 | 厦门欣欣信息有限公司 | Data processing method and device |
CN105787013A (en) * | 2016-02-05 | 2016-07-20 | 北京天广汇通科技有限公司 | Type name distributing method and system for heterogeneous data |
CN105787013B (en) * | 2016-02-05 | 2019-07-02 | 北京天广汇通科技有限公司 | A kind of the typonym distribution method and system of isomeric data |
CN106802947A (en) * | 2017-01-13 | 2017-06-06 | 中国工商银行股份有限公司 | The data handling system and method for entity relationship diagram |
CN106802947B (en) * | 2017-01-13 | 2019-11-29 | 中国工商银行股份有限公司 | The data processing system and method for entity relationship diagram |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8635253B2 (en) | Decorated model architecture for efficient model-driven application development | |
CN102034152B (en) | The method for integrating of heterogeneous software system data and system based on SOA framework | |
CN103226478A (en) | Method for automatically generating and using code | |
CN111191303A (en) | BIM data processing method and device, electronic equipment and computer storage medium | |
CN101038604A (en) | Vehicle impact strength computer synergic design and simulation system | |
CN111400389B (en) | IFC expansion-based operation and maintenance 5D-BIM data integration and sharing system | |
CN101794315A (en) | Object relationship mapping model with fixed database schema | |
CN102855271A (en) | Storage and traceable management method for multi-version power grid model | |
CN101470601A (en) | Zero-code generation method of application software and generation platform thereof | |
CN103500094A (en) | Service platform monitoring model capable of supporting user visible user-definition | |
CN101236568A (en) | Dynamic data base construction method | |
CN101604240A (en) | A kind of design method of purchase-sell-stock management system based on MVC | |
CN1647040A (en) | Method and system for managing a computer system | |
CN111988173A (en) | Tenant management platform and tenant management method based on multi-layer parent-child structure tenant | |
CN105303465A (en) | Tree-shaped view defining and displaying method based on CIM model | |
CN103186620A (en) | CIM mapping method | |
CN110287223A (en) | Information storage means and device, electronic device and storage medium | |
CN101593176B (en) | Web-based parameterized cross-platform part library system | |
CN105912723A (en) | Storage method of custom field | |
CN109947459A (en) | A kind of software product construction method | |
CN104793928A (en) | Developing and running platform implementation method and system based on Java | |
CN101799822A (en) | Method for modeling layered network knowledge model and method for establishing knowledge warehouse system | |
Duan | Analysis of ERP enterprise management information system based on cloud computing mode | |
CN101308518A (en) | Topology element name corresponding method for copy type synergic modeling system | |
TW575812B (en) | Processing method and system for engineering design information |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080806 |