CN105005592A - Data dictionary generation method and data dictionary generation device - Google Patents
Data dictionary generation method and data dictionary generation device Download PDFInfo
- Publication number
- CN105005592A CN105005592A CN201510370318.3A CN201510370318A CN105005592A CN 105005592 A CN105005592 A CN 105005592A CN 201510370318 A CN201510370318 A CN 201510370318A CN 105005592 A CN105005592 A CN 105005592A
- Authority
- CN
- China
- Prior art keywords
- data dictionary
- entity object
- data
- entity
- described multiple
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
Abstract
The invention provides a data dictionary generation method and device. The method comprises the steps of according to a plurality of entity objects, attribute information of each of the plurality of entity objects, and entity relationships of the plurality of entity objects, generating a plurality of pieces of data dictionary format data corresponding to the plurality of entity objects; adding annotation information of the plurality of entity objects in the plurality of pieces of data dictionary format data, so as to form data dictionary specification definitions comprising the annotation information; and generating a data dictionary according to the plurality of pieces of data dictionary format data and the data dictionary specification definitions. Through adoption of the data dictionary generation method, the data dictionary is generated by use of the characteristic of the normalized data structure of a database, so that generation of the data dictionary is prevented from totally relying on the annotation information of the entity objects, the difficulty of generation of the data dictionary is also lowered, and the generation of the data dictionary is operable.
Description
Technical field
The present invention relates to technical field of information processing, in particular to a kind of data dictionary generation method and data dictionary generating apparatus.
Background technology
At present, in the products such as application software system, usual use relevant database is as the storage medium of software system data, wherein, software system data can be divided into system configuration data and the large module of operation flow data two: system configuration data comprises configurations and the parameter of system environments operation; Operation flow data: comprise the multiple business relation datas such as file data, flow data, process parameter.Often there is following characteristics in software system data: clue, standardization and consistance.
In the related, in advance annotation information is added to entity object in relevant database, then copy or export in Excel and carry out editing to generate data dictionary, or directly from database, generate data dictionary by other method, but the data dictionary of correlation technique relies on the annotation information of entity object completely.In addition, owing to participating in the research and development of product and the participant of later maintenance ignores the consciousness and the custom that annotate or do not formed annotation to the entity object in database in the life cycle of product, directly increase the difficulty and non-operability that generate data dictionary like this.
Therefore, the annotation information how avoiding relying on completely entity object generates data dictionary, reduces the difficulty generating data dictionary simultaneously, thus makes the generation of data dictionary have operability to become problem demanding prompt solution.
Summary of the invention
The present invention is just based on the problems referred to above, propose a kind of new technical scheme, make full use of the feature of the data structure of data base normalization to generate data dictionary, avoid the annotation information relying on entity object completely and generate data dictionary, and also reduce the difficulty generating data dictionary, thus the generation of data dictionary is made to have operability.
In view of this, an aspect of of the present present invention proposes a kind of data dictionary generation method, comprise: according to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate multiple data dictionary format data of corresponding described multiple entity object; Add the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information; Data dictionary is generated according to described multiple data dictionary format data and described data dictionary specification.
In this technical scheme, because the participant of the research and development and later maintenance that participate in product in the life cycle of product often upgrades and replaces, therefore, by multiple data dictionary format data and the data dictionary specification generation data dictionary of entity object multiple in the database of product, not only make participant more fast and easily can understand the database structure of product according to data dictionary, also make full use of feature (i.e. multiple entity object in database of the data structure of data base normalization, entity relationship in multiple entity object between the attribute information of each entity object and multiple entity object) generate data dictionary, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, entity relationship between the described attribute information according to each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate the step of multiple data dictionary format data of corresponding described multiple entity object respectively, specifically comprise: obtain the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database; According to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, define the data dictionary format rule of described each entity object; Multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
In this technical scheme, the data dictionary format rule of each entity object is defined according to the entity relationship between the attribute information of entity object multiple in database, each entity object and multiple entity object, thus can according to the data dictionary format data of each entity object of data dictionary format generate rule, make full use of the feature of the data structure of data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, the step of the annotation information of multiple entity object described in the described multiple data dictionary format data of described interpolation, specifically comprises: arrange the self-defined relation between user-defined described multiple entity object; According to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation, described multiple data dictionary format data are compressed; Add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
In this technical scheme, owing to also there are other relations except entity relationship in actual applications between multiple entity object, effectively can be reduced the scope of data dictionary specification by the self-defined relation arranged between multiple entity object, thus data dictionary can be generated more accurately and efficiently.In addition, because the annotation information of entity object may exist repetition, therefore, according to the entity relationship between the principle of consent of the same name and multiple entity object and self-defined relation, multiple data dictionary format data are compressed, thus the redundancy of annotation information can be reduced while ensureing the data dictionary accuracy of producing.
In technique scheme, preferably, the described step generating data dictionary according to described multiple data dictionary format data and described data dictionary specification, specifically comprise: according to the described entity relationship between described multiple entity object and described self-defined relation, the described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data; Data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
In this technical scheme, by the annotation information in data dictionary specification being written in the comments forms data in multiple data dictionary format data, and generate data dictionary according to multiple data dictionaries with annotation information, make participant more fast and easily can understand the database structure of product according to data dictionary.
In technique scheme, preferably, described multiple entity object comprises: physics table, view sum functions; And described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
In this technical scheme, multiple entity object includes but not limited to: physics table, view sum functions, such as, entity object can also be storing process, and wherein, the attribute information of physics table comprises table name, sets of fields, major key, external key etc., the attribute information of view comprises view name, sets of fields etc., and the attribute information of function comprises function name, parameter set, rreturn value etc., and the attribute information of storing process comprises storing process name, parameter set etc.In addition, entity relationship includes but not limited to: the relation between physics table and physics table, the relation between physics table and view and the relation between view and view, wherein, relation between physics table and physics table embodies with foreign key constraint relation in a database, the relation between view and physics table and the relation between view and view originate with view query in a database in annexation embody.
Another aspect of the present invention proposes a kind of data dictionary generating apparatus, comprise: the first generation unit, for according to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate multiple data dictionary format data of corresponding described multiple entity object; Processing unit, for adding the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information; Second generation unit, for generating data dictionary according to described multiple data dictionary format data and described data dictionary specification.
In this technical scheme, because the participant of the research and development and later maintenance that participate in product in the life cycle of product often upgrades and replaces, therefore, by multiple data dictionary format data and the data dictionary specification generation data dictionary of entity object multiple in the database of product, not only make participant more fast and easily can understand the database structure of product according to data dictionary, also make full use of feature (i.e. multiple entity object in database of the data structure of data base normalization, entity relationship in multiple entity object between the attribute information of each entity object and multiple entity object) generate data dictionary, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, described first generation unit comprises: acquiring unit, for obtaining the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database; Definition unit, for according to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, defines the data dictionary format rule of described each entity object; Described first generation unit is specifically for, multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
In this technical scheme, the data dictionary format rule of each entity object is defined according to the entity relationship between the attribute information of entity object multiple in database, each entity object and multiple entity object, thus can according to the data dictionary format data of each entity object of data dictionary format generate rule, thus make full use of the feature of the data structure of data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, described processing unit comprises: setting unit, for arranging the self-defined relation between user-defined described multiple entity object; Compression unit, for compressing described multiple data dictionary format data according to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation; Described processing unit specifically for, add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
In this technical scheme, owing to also there are other relations except entity relationship in actual applications between multiple entity object, effectively can be reduced the scope of data dictionary specification by the self-defined relation arranged between multiple entity object, thus data dictionary can be generated more accurately and efficiently.In addition, because the annotation information of entity object may exist repetition, therefore, according to the entity relationship between the principle of consent of the same name and multiple entity object and self-defined relation, multiple data dictionary format data are compressed, thus the redundancy of annotation information can be reduced while ensureing the data dictionary accuracy of producing.
In technique scheme, preferably, described second generation unit specifically for: according to the described entity relationship between described multiple entity object and described self-defined relation, described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data, data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
In this technical scheme, by the annotation information in data dictionary specification being written in the comments forms data in multiple data dictionary format data, and generate data dictionary according to multiple data dictionaries with annotation information, make participant more fast and easily can understand the database structure of product according to data dictionary.
In technique scheme, preferably, described multiple entity object comprises: physics table, view sum functions; And described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
In this technical scheme, multiple entity object includes but not limited to: physics table, view sum functions, such as, entity object can also be storing process, and wherein, the attribute information of physics table comprises table name, sets of fields, major key, external key etc., the attribute information of view comprises view name, sets of fields etc., and the attribute information of function comprises function name, parameter set, rreturn value etc., and the attribute information of storing process comprises storing process name, parameter set etc.In addition, entity relationship includes but not limited to: the relation between physics table and physics table, the relation between physics table and view and the relation between view and view, wherein, relation between physics table and physics table embodies with foreign key constraint relation in a database, the relation between view and physics table and the relation between view and view originate with view query in a database in annexation embody.
By technical scheme of the present invention, data dictionary is generated by the feature of the data structure utilizing data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary, and also reduce the difficulty generating data dictionary, thus the generation of data dictionary is made to have operability.
Accompanying drawing explanation
Fig. 1 shows the schematic flow sheet of data dictionary generation method according to an embodiment of the invention;
Fig. 2 shows the schematic flow sheet of the generation of data dictionary format data according to an embodiment of the invention;
Fig. 3 shows the schematic flow sheet of the generation of data dictionary specification according to an embodiment of the invention;
Fig. 4 shows the schematic flow sheet of data dictionary generation method according to another embodiment of the invention;
Fig. 5 shows the structural representation of data dictionary generating apparatus according to an embodiment of the invention;
Fig. 6 shows the structural representation of data dictionary generating apparatus according to another embodiment of the invention.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine mutually.
Set forth a lot of detail in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not by the restriction of following public specific embodiment.
Fig. 1 shows the schematic flow sheet of data dictionary generation method according to an embodiment of the invention.
As shown in Figure 1, data dictionary generation method according to an embodiment of the invention, comprising:
Step 102, according to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generates multiple data dictionary format data of corresponding described multiple entity object;
Step 104, adds the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information;
Step 106, generates data dictionary according to described multiple data dictionary format data and described data dictionary specification.
In this technical scheme, because the participant of the research and development and later maintenance that participate in product in the life cycle of product often upgrades and replaces, therefore, by multiple data dictionary format data and the data dictionary specification generation data dictionary of entity object multiple in the database of product, not only make participant more fast and easily can understand the database structure of product according to data dictionary, also make full use of feature (i.e. multiple entity object in database of the data structure of data base normalization, entity relationship in multiple entity object between the attribute information of each entity object and multiple entity object) generate data dictionary, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, step 102, specifically comprises: obtain the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database; According to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, define the data dictionary format rule of described each entity object; Multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
In this technical scheme, the data dictionary format rule of each entity object is defined according to the entity relationship between the attribute information of entity object multiple in database, each entity object and multiple entity object, thus can according to the data dictionary format data of each entity object of data dictionary format generate rule, thus make full use of the feature of the data structure of data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, the step of the annotation information of multiple entity object described in the described multiple data dictionary format data of described interpolation, specifically comprises: arrange the self-defined relation between user-defined described multiple entity object; According to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation, described multiple data dictionary format data are compressed; Add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
In this technical scheme, owing to also there are other relations except entity relationship in actual applications between multiple entity object, effectively can be reduced the scope of data dictionary specification by the self-defined relation arranged between multiple entity object, thus data dictionary can be generated more accurately and efficiently.In addition, because the annotation information of entity object may exist repetition, therefore, according to the entity relationship between the principle of consent of the same name and multiple entity object and self-defined relation, multiple data dictionary format data are compressed, thus the redundancy of annotation information can be reduced while ensureing the data dictionary accuracy of producing.
In technique scheme, preferably, step 106, specifically comprise: according to the described entity relationship between described multiple entity object and described self-defined relation, the described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data; Data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
In this technical scheme, by the annotation information in data dictionary specification being written in the comments forms data in multiple data dictionary format data, and generate data dictionary according to multiple data dictionaries with annotation information, make participant more fast and easily can understand the database structure of product according to data dictionary.
In technique scheme, preferably, described multiple entity object comprises: physics table, view sum functions; And described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
In this technical scheme, multiple entity object includes but not limited to: physics table, view sum functions, such as, entity object can also be storing process, and wherein, the attribute information of physics table comprises table name, sets of fields, major key, external key etc., the attribute information of view comprises view name, sets of fields etc., and the attribute information of function comprises function name, parameter set, rreturn value etc., and the attribute information of storing process comprises storing process name, parameter set etc.In addition, entity relationship includes but not limited to: the relation between physics table and physics table, the relation between physics table and view and the relation between view and view, wherein, relation between physics table and physics table embodies with foreign key constraint relation in a database, the relation between view and physics table and the relation between view and view originate with view query in a database in annexation embody.
Fig. 2 shows the schematic flow sheet of the generation of data dictionary format data according to an embodiment of the invention.
As shown in Figure 2, the generation of data dictionary format data according to an embodiment of the invention, comprising:
Step 202, obtains entity object and attribute information in database.Wherein, entity object comprises physics table, view, function, storing process etc.; The different attribute information of entity object can obtain from the system table database, such as: the attribute information of physics table comprises table name, sets of fields, major key, external key etc.; The attribute information of view comprises view name, sets of fields etc.; The attribute information of function comprises function name, parameter set, rreturn value etc.; The attribute information of storing process comprises storing process name, parameter set etc.The attribute information of sets of fields and parameter set includes title, data type, data length, default value, whether allows for sky, field annotation etc.
Step 204, obtains the entity relationship between multiple entity object.Relation between entity object can be divided into relation, the relation between view and physics table, the relation between view and view between physics table and physics table.Wherein, the relation between physics table and physics table embodies with foreign key constraint relation in a database; View and physics table and the relation between view and view originate with view query in a database in annexation embody.
Step 206, define the data dictionary format rule of each entity object, data dictionary format rule (such as, data dictionary format rule is XML data dictionary format rule, XML represents Extensible Markup Language, extend markup language) for multiple entity objects of the databases such as physics table, view, function, storing process are converted to data dictionary format data (such as, XML data dictionary format data).Data dictionary format rule includes attribute information and the entity relationship of multiple entity objects of database, and the comments forms data of entity object.
Such as, shown in XML data dictionary format rule is defined as follows:
<DataDictionary>
<DataObject ObjectName=' entity object name ' ObjectType=' physics table/view/function/storing process ' >
<Comments LocaleID=' zh-CN ' Comment=' Chinese annotation describes '/>
<Comments LocaleID=' zh-TW ' Comment=' traditional font annotation describes '/>
<Comments LocaleID=' en-US ' Comment=' english note describes '/>
<Fields FieldName=' field/parameter name ' >
<Attrs Name=' Property Name ' Value=' property value '/>
……
<Foreignkey DataObject=' associated entity ' Field=' associate field '/>
<Comments LocaleID=' zh-CN ' Comment=' Chinese annotation describes '/>
<Comments LocaleID=' zh-TW ' Comment=' traditional font annotation describes '/>
<Comments LocaleID=' en-US ' Comment=' english note describes '/>
</Fields>
</DataObject>
</DataDictionary>
1. the entity object in the database of acquisition is recorded in the <DataObject> metadata node of XML data dictionary format.ObjectName records the title of entity object, the type of ObjectType mark-up entity object.
2. in the <Fields> metadata node of XML data dictionary format, record the relevant field of entity object or parameter information.The title of FieldName record field or parameter.
3. in the <Attrs> metadata node of XML data dictionary format, record the various correlation attribute information of sets of fields that entity object is correlated with or parameter set.The Property Name of Name tag field or parameter, the property value of Value record field or parameter.Field and parameter comprise attribute information data type, data length, default value, whether allow for sky etc.
4. the relation of the field in the <Foreignkey> metadata node of XML data dictionary format in record field and other entity object sets of fields.The entity object of DataObject mark association, the field of the entity object of Field mark association.
5. the annotation information of database of record entity object or field or parameter in the <Comments> metadata node of XML data dictionary format.The language information that LocaleID marker annotations information is corresponding, Comment records the detailed description of corresponding languages.
Step 208, the XML data dictionary format data corresponding according to the data dictionary format generate rule of each entity object.
Fig. 3 shows the schematic flow sheet of the generation of data dictionary specification according to an embodiment of the invention.
As shown in Figure 3, the generation of data dictionary specification according to an embodiment of the invention, comprising:
, there are other relations except entity relationship in actual applications between entity object, reduced the annotation information of redundancy like this by the self-defined relation arranged between multiple entity object in step 302.Wherein, the setting of self-defined relation can be realized by arranging Foreignkey attribute in XML data dictionary format data.
Step 304, according to the entity relationship between the principle of consent of the same name and multiple entity object and self-defined relation packed data dictionary format data.Such as, compression is carried out to data dictionary format data as shown in table 1:
Table 1
Step 306, adds annotation information, to generate data dictionary specification to the entity object in the data dictionary format data after compression.Such as, the annotation information of adding entity object is as shown in table 2,
Table 2
Fig. 4 shows the schematic flow sheet of data dictionary generation method according to another embodiment of the invention.
As shown in Figure 4, data dictionary generation method according to another embodiment of the invention, comprising:
Step 402, obtains XML data dictionary format data.
Step 404, obtains data dictionary specification.
Step 406, data dictionary is generated according to XML data dictionary format data and data dictionary specification, particularly, according to the entity relationship between multiple entity object and self-defined relation, annotation information in data dictionary specification is written in the comments forms data in multiple data dictionary format data, according to the multiple data dictionary format data genaration data dictionaries including annotation information.
Fig. 5 shows the structural representation of data dictionary generating apparatus according to an embodiment of the invention.
As shown in Figure 5, data dictionary generating apparatus 500 according to an embodiment of the invention, comprise: the first generation unit 502, for according to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate multiple data dictionary format data of corresponding described multiple entity object; Processing unit 504, for adding the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information; Second generation unit 506, for generating data dictionary according to described multiple data dictionary format data and described data dictionary specification.
In this technical scheme, because the participant of the research and development and later maintenance that participate in product in the life cycle of product often upgrades and replaces, therefore, by multiple data dictionary format data and the data dictionary specification generation data dictionary of entity object multiple in the database of product, not only make participant more fast and easily can understand the database structure of product according to data dictionary, also make full use of feature (i.e. multiple entity object in database of the data structure of data base normalization, entity relationship in multiple entity object between the attribute information of each entity object and multiple entity object) generate data dictionary, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, described first generation unit 502 comprises: acquiring unit 5022, for obtaining the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database; Definition unit 5024, for according to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, defines the data dictionary format rule of described each entity object; Described first generation unit 502 is specifically for, multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
In this technical scheme, the data dictionary format rule of each entity object is defined according to the entity relationship between the attribute information of entity object multiple in database, each entity object and multiple entity object, thus can according to the data dictionary format data of each entity object of data dictionary format generate rule, thus make full use of the feature of the data structure of data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary.
In technique scheme, preferably, described processing unit 504 comprises: setting unit 5042, for arranging the self-defined relation between user-defined described multiple entity object; Compression unit 5044, for compressing described multiple data dictionary format data according to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation; Described processing unit 504 specifically for, add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
In this technical scheme, owing to also there are other relations except entity relationship in actual applications between multiple entity object, effectively can be reduced the scope of data dictionary specification by the self-defined relation arranged between multiple entity object, thus data dictionary can be generated more accurately and efficiently.In addition, because the annotation information of entity object may exist repetition, therefore, according to the entity relationship between the principle of consent of the same name and multiple entity object and self-defined relation, multiple data dictionary format data are compressed, thus the redundancy of annotation information can be reduced while ensureing the data dictionary accuracy of producing.
In technique scheme, preferably, described second generation unit 506 specifically for: according to the described entity relationship between described multiple entity object and described self-defined relation, described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data, data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
In this technical scheme, by the annotation information in data dictionary specification being written in the comments forms data in multiple data dictionary format data, and generate data dictionary according to multiple data dictionaries with annotation information, make participant more fast and easily can understand the database structure of product according to data dictionary.
In technique scheme, preferably, described multiple entity object comprises: physics table, view sum functions; And described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
In this technical scheme, multiple entity object includes but not limited to: physics table, view sum functions, such as, entity object can also be storing process, and wherein, the attribute information of physics table comprises table name, sets of fields, major key, external key etc., the attribute information of view comprises view name, sets of fields etc., and the attribute information of function comprises function name, parameter set, rreturn value etc., and the attribute information of storing process comprises storing process name, parameter set etc.In addition, entity relationship includes but not limited to: the relation between physics table and physics table, the relation between physics table and view and the relation between view and view, wherein, relation between physics table and physics table embodies with foreign key constraint relation in a database, the relation between view and physics table and the relation between view and view originate with view query in a database in annexation embody.
Fig. 6 shows the structural representation of data dictionary generating apparatus according to another embodiment of the invention.
As shown in Figure 6, data dictionary generating apparatus 600 according to another embodiment of the invention, comprises data dictionary format data module 602, data dictionary specification module 604 and data dictionary generation module 606, introduces this three modules below in detail:
Data dictionary format data module 602, for realizing obtaining the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object from database, according to the data dictionary format generate rule XML data dictionary format data of each entity object.
Data dictionary specification module 604, carries out redundancy process to the information in XML data dictionary format data, to form data dictionary specification for realizing.
Data dictionary generation module 606, for generating data dictionary according to XML data dictionary format data and data dictionary specification.
More than be described with reference to the accompanying drawings technical scheme of the present invention, data dictionary is generated by the feature of the data structure utilizing data base normalization, avoid the annotation information relying on entity object completely and generate data dictionary, and also reduce the difficulty generating data dictionary, thus the generation of data dictionary is made to have operability.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data dictionary generation method, is characterized in that, comprising:
According to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate multiple data dictionary format data of corresponding described multiple entity object;
Add the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information;
Data dictionary is generated according to described multiple data dictionary format data and described data dictionary specification.
2. data dictionary generation method according to claim 1, it is characterized in that, entity relationship between the described attribute information according to each entity object in multiple entity object, described multiple entity object and described multiple entity object, generate the step of multiple data dictionary format data of corresponding described multiple entity object respectively, specifically comprise:
Obtain the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database;
According to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, define the data dictionary format rule of described each entity object;
Multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
3. data dictionary generation method according to claim 1, is characterized in that, the step of the annotation information of multiple entity object described in the described multiple data dictionary format data of described interpolation, specifically comprises:
Self-defined relation between user-defined described multiple entity object is set;
According to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation, described multiple data dictionary format data are compressed;
Add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
4. data dictionary generation method according to claim 3, is characterized in that, the described step generating data dictionary according to described multiple data dictionary format data and described data dictionary specification, specifically comprises:
According to the described entity relationship between described multiple entity object and described self-defined relation, the described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data;
Data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
5. data dictionary generation method according to any one of claim 1 to 4, is characterized in that,
Described multiple entity object comprises: physics table, view sum functions; And
Described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
6. a data dictionary generating apparatus, is characterized in that, comprising:
First generation unit, for according to the entity relationship between the attribute information of each entity object in multiple entity object, described multiple entity object and described multiple entity object, generates multiple data dictionary format data of corresponding described multiple entity object;
Processing unit, for adding the annotation information of multiple entity object described in described multiple data dictionary format data, to form the data dictionary specification including described annotation information;
Second generation unit, for generating data dictionary according to described multiple data dictionary format data and described data dictionary specification.
7. data dictionary generating apparatus according to claim 6, is characterized in that, described first generation unit comprises:
Acquiring unit, for obtaining the described entity relationship between described multiple entity object, the described attribute information of described each entity object and described multiple entity object in a database;
Definition unit, for according to the described entity relationship between the described attribute information of described each entity object, described each entity object and described multiple entity object, defines the data dictionary format rule of described each entity object;
Described first generation unit is specifically for, multiple data dictionary format data according to the described data dictionary format generate rule of each entity object described in described multiple entity object.
8. data dictionary generating apparatus according to claim 6, is characterized in that, described processing unit comprises:
Setting unit, for arranging the self-defined relation between user-defined described multiple entity object;
Compression unit, for compressing described multiple data dictionary format data according to the described entity relationship between the principle of consent of the same name and described multiple entity object and described self-defined relation;
Described processing unit specifically for, add the described annotation information of multiple entity object described in the described multiple data dictionary format data after compression.
9. data dictionary generating apparatus according to claim 8, is characterized in that, described second generation unit specifically for:
According to the described entity relationship between described multiple entity object and described self-defined relation, the described annotation information in described data dictionary specification is written in the comments forms data in described multiple data dictionary format data,
Data dictionary according to the described multiple data dictionary format data genaration including described annotation information.
10. the data dictionary generating apparatus according to any one of claim 6 to 9, is characterized in that,
Described multiple entity object comprises: physics table, view sum functions; And
Described entity relationship comprises: the relation between described physics table and described physics table, the relation between described physics table and described view and the relation between described view and described view.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510370318.3A CN105005592B (en) | 2015-06-29 | 2015-06-29 | Data dictionary generation method and data dictionary creation device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510370318.3A CN105005592B (en) | 2015-06-29 | 2015-06-29 | Data dictionary generation method and data dictionary creation device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105005592A true CN105005592A (en) | 2015-10-28 |
| CN105005592B CN105005592B (en) | 2018-10-16 |
Family
ID=54378268
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510370318.3A Active CN105005592B (en) | 2015-06-29 | 2015-06-29 | Data dictionary generation method and data dictionary creation device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105005592B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106202008A (en) * | 2016-06-28 | 2016-12-07 | 武汉斗鱼网络科技有限公司 | A kind of MySQL database structured document generates method and device |
| CN106933832A (en) * | 2015-12-30 | 2017-07-07 | 中国科学院沈阳自动化研究所 | A kind of construction method of the digital dictionary of oil reservoir |
| CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
| CN108038203A (en) * | 2017-12-13 | 2018-05-15 | 明算科技（北京）股份有限公司 | The storage device of data dictionary |
| CN110348004A (en) * | 2019-05-23 | 2019-10-18 | 平安科技（深圳）有限公司 | Method, apparatus, electronic equipment and the storage medium that data dictionary generates |
| CN110471995A (en) * | 2019-08-14 | 2019-11-19 | 中电科新型智慧城市研究院有限公司 | A kind of cross-cutting information share-and-exchange data model modeling method |
| CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| CN110825805A (en) * | 2019-11-12 | 2020-02-21 | 北京东软望海科技有限公司 | Data visualization method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060136452A1 (en) * | 2004-12-22 | 2006-06-22 | Lim Myung E | Method of generating database schema to provide integrated view of dispersed data and data integrating system |
| CN102096670A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data dictionary generation method and device |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
| CN102999600A (en) * | 2012-11-20 | 2013-03-27 | 中兴通讯股份有限公司 | Method and system for automatically generating embedded database |
| CN103970855A (en) * | 2014-05-06 | 2014-08-06 | 车智互联（北京）科技有限公司 | Device and method for processing data |
| CN104462108A (en) * | 2013-09-17 | 2015-03-25 | 中兴通讯股份有限公司 | Database structure object processing method and device |
-
2015
- 2015-06-29 CN CN201510370318.3A patent/CN105005592B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060136452A1 (en) * | 2004-12-22 | 2006-06-22 | Lim Myung E | Method of generating database schema to provide integrated view of dispersed data and data integrating system |
| CN102096670A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data dictionary generation method and device |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
| CN102999600A (en) * | 2012-11-20 | 2013-03-27 | 中兴通讯股份有限公司 | Method and system for automatically generating embedded database |
| CN104462108A (en) * | 2013-09-17 | 2015-03-25 | 中兴通讯股份有限公司 | Database structure object processing method and device |
| CN103970855A (en) * | 2014-05-06 | 2014-08-06 | 车智互联（北京）科技有限公司 | Device and method for processing data |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106933832A (en) * | 2015-12-30 | 2017-07-07 | 中国科学院沈阳自动化研究所 | A kind of construction method of the digital dictionary of oil reservoir |
| CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
| CN107203525B (en) * | 2016-03-16 | 2020-03-06 | 北大方正集团有限公司 | Database processing method and device |
| CN106202008A (en) * | 2016-06-28 | 2016-12-07 | 武汉斗鱼网络科技有限公司 | A kind of MySQL database structured document generates method and device |
| CN106202008B (en) * | 2016-06-28 | 2019-04-05 | 武汉斗鱼网络科技有限公司 | A kind of MySQL database structured document generation method and device |
| CN108038203A (en) * | 2017-12-13 | 2018-05-15 | 明算科技（北京）股份有限公司 | The storage device of data dictionary |
| CN108038203B (en) * | 2017-12-13 | 2021-08-03 | 明算科技（北京）股份有限公司 | Storage device of data dictionary |
| CN110348004A (en) * | 2019-05-23 | 2019-10-18 | 平安科技（深圳）有限公司 | Method, apparatus, electronic equipment and the storage medium that data dictionary generates |
| CN110348004B (en) * | 2019-05-23 | 2022-05-06 | 平安科技（深圳）有限公司 | Method and device for generating data dictionary, electronic equipment and storage medium |
| WO2020232896A1 (en) * | 2019-05-23 | 2020-11-26 | 平安科技（深圳）有限公司 | Data dictionary generation method and apparatus, electronic device and storage medium |
| CN110471995A (en) * | 2019-08-14 | 2019-11-19 | 中电科新型智慧城市研究院有限公司 | A kind of cross-cutting information share-and-exchange data model modeling method |
| CN110471995B (en) * | 2019-08-14 | 2022-04-15 | 中电科新型智慧城市研究院有限公司 | Cross-domain information sharing exchange data model modeling method |
| CN110502535B (en) * | 2019-08-28 | 2022-02-22 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| CN110502535A (en) * | 2019-08-28 | 2019-11-26 | 上海达梦数据库有限公司 | Data access method, device, equipment and storage medium |
| CN110825805A (en) * | 2019-11-12 | 2020-02-21 | 北京东软望海科技有限公司 | Data visualization method and device |
| CN110825805B (en) * | 2019-11-12 | 2022-07-19 | 望海康信(北京)科技股份公司 | Data visualization method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105005592B (en) | 2018-10-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105005592A (en) | Data dictionary generation method and data dictionary generation device | |
| US9058407B2 (en) | Persistent multimedia content versioning | |
| US9607061B2 (en) | Using views of subsets of nodes of a schema to generate data transformation jobs to transform input files in first data formats to output files in second data formats | |
| WO2020253399A1 (en) | Log classification rule generation method, device, apparatus, and readable storage medium | |
| US7720885B2 (en) | Generating a word-processing document from database content | |
| KR20060095448A (en) | File system represented inside a database | |
| CN106469140A (en) | A kind of report generating system and its method | |
| US20150032689A1 (en) | Data definition language (ddl) expression annotation | |
| CN102708203A (en) | Database dynamic management method based on XML metadata | |
| US7529758B2 (en) | Method for pre-processing mapping information for efficient decomposition of XML documents | |
| CN113761859B (en) | Electronic report definition method and device and electronic equipment | |
| CN114661832A (en) | Multi-mode heterogeneous data storage method and system based on data quality | |
| Thang et al. | XML schema automatic matching solution | |
| CN101788977A (en) | Method for implementing editing and modifying of medical examination report | |
| Sun et al. | Cf-prov: A content-rich and fine-grained scientific workflow provenance model | |
| CN104063386B (en) | A kind of method and apparatus of content object multiplexing | |
| CN108170422A (en) | A kind of report form generation method and system based on Word annotations | |
| CN117744615A (en) | Form data processing method and device, electronic equipment and readable storage medium | |
| KR100904890B1 (en) | MPEG-7 meta-data storage method suitable for the embedded multimedia device | |
| Deng et al. | Research and Development of a XML Modeling Tool | |
| Fu et al. | Research on the Extraction Method of Requirement Modeling Data Based on XML | |
| CN116610693A (en) | Method and device for generating structured query statement and computer equipment | |
| Beebe | A Bibliography of Publications about SGML, the Standard Generalized Markup Language: 2000–2009 | |
| Wang | XML-based support for database histories and document versions | |
| Panescu et al. | Targeted annotation of scientific literature and data resources in Invenio digital libraries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |