CN102541867A - Data dictionary generating method and system - Google Patents
Data dictionary generating method and system Download PDFInfo
- Publication number
- CN102541867A CN102541867A CN2010105892543A CN201010589254A CN102541867A CN 102541867 A CN102541867 A CN 102541867A CN 2010105892543 A CN2010105892543 A CN 2010105892543A CN 201010589254 A CN201010589254 A CN 201010589254A CN 102541867 A CN102541867 A CN 102541867A
- Authority
- CN
- China
- Prior art keywords
- attribute
- entity object
- name
- field
- data dictionary
- 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 discloses a data dictionary generating method and system. The data dictionary generating method comprises the following steps of: acquiring an entity object, and acquiring the name of a database table corresponding to the entity object; acquiring another name of each attribute of the entity object and definition of a field corresponding to each attribute in the database table; and integrating the table name, the another name of each attribute and the definition of each field and exporting an integrated result into an EXCEL table, so as to generate a data dictionary of the entity object. In the data dictionary generating method and system disclosed by the embodiment of the invention, a relation between the entity object and a data object is analyzed, the another name of each attribute of the entity object is obtained, the another name of each attribute and the definition of each field recorded by the data object are integrated, and finally the integrated result is exported to generate the data dictionary of the entity object. Compared with the prior art, the data dictionary generating method and system disclosed by the invention have the advantages that the data dictionary can be obtained without requiring that a developer continually copies from the definitions of the data object and the entity object, working hours and word load of the developer are reduced, and working efficiency is improved.
Description
Technical field
The present invention relates to field of information processing, relate in particular to a kind of data dictionary and generate method and system.
Background technology
BOS (Business Operating System, practice operating system) is to be the technology platform of new generation of theory research and development with the model-driven.The model data that is used for describing the business data model structure among the BOS is called metadata.Entity, tables of data, relation are wherein three kinds in many metadata type.Wherein: a kind of as in the entity object of non-abstract entity object, when its attribute that has is the instance of another business object for own attribute or this attribute, corresponding with the field in the tables of data metadata; The tables of data metadata is called data object again, corresponding to the database table in the relevant database, is used for describing the project organization of database table in the relevant database, and data object has defined the definition of database table table name, tables of data another name and field.The definition of field comprises field title, field description, data type, length, precision, default value again, whether allows for sky etc.Field value in the relevant database table is the property value of entity object.Data dictionary is the document that is used for describing the database table design in the relevant database; Mainly comprising field title, field description, data type, length, precision, default value, whether allow for the content of the attribute of description lists such as sky, is the important evidence of system design, exploitation, enforcement and maintenance.
For EAS (Enterprise Application Service; Enterprise application service) standardized product; Though it provides a cover early stage data dictionary explanation document; But in the face of a large amount of secondary development project and tasks, needing constantly increases the relevant database table of EAS system and revises according to client's demand, and then will in data dictionary, increase or revise data list structure.Yet,, no matter, all can't come to obtain automatically data dictionary according to existing capability from still BOS Studio (BOS development and Design instrument) of the relevant database of outside, EAS system itself from present circumstances.
At first, consider from the relevant database angle of physical storage data.In BOS Studio during modeling; Can generate entity object and data object automatically; And then coming to generate automatically the physical database table in the relevant database according to data object, this has successfully solved the problem of aspects such as the quality of enterprise application software in exploitation, enforcement and maintenance process, cycle, cost, risk.Yet; Can find through the query relation database; Though in the database table that is generated, defined field title, data type, length, precision, whether be information such as sky; But do not have description, promptly can't from the relevant database of outside, obtain the specific definition of database table, thereby cut off the source that obtains data dictionary about the concrete meaning of field.
Secondly, consider from EAS system itself.Query analyzer is as an EAS system part, and the effect of its maximum is at the EAS system interface database to be operated, and need not to install the relational data library software again.Query analyzer provides many functions, and one of them comes the Query Database table definition through the input data table table name exactly, is presented at Query Result on the EAS system list interface.Yet this result is also through operation obtains to relevant database; Though comprise in the result displayed outside the information such as field title, data type, length, precision; Do not have description about the concrete meaning of field; Though therefore the EAS system provides the export function of list interface, can not know the concrete meaning of this field through the result who derives, and then can't carry out subsequent operation the database table at this field place.
Under the BOS development environment, though when in the secondary development process, generating data object, the meaning of field is described and had corresponding value, does not have the description of field meaning in the pairing data object of the entity object of standardized product in early days.That is to say that the definition that will obtain whole complete data object fields need be browsed entity object and two kinds of metadata of data object, just can obtain complete field information, but this also only is for the developer.And BOS Studio do not provide function corresponding, can derive complete data dictionary information.Simultaneously; Though under BOS Studio, obtain to generate the sql statement of database table; But the meaning of each field representative is not described in these statements yet, just can't be obtained the complete definition of database table yet through in the relational data library software, carrying out the sql statement.
Therefore; For the staff in the IT project, the sole mode that obtains data dictionary can only constantly be copied from the definition of entity object and data object under the BOS development environment by the developer, obviously; This can be very loaded down with trivial details; Also can spend a lot of energy and times, increase developer's working time and workload, inefficiency.
Summary of the invention
In view of this, the invention provides a kind of data dictionary and generate method and system, complex operation is caused when obtaining the partial data dictionary to solve in the prior art working time and workload are long, ineffective problem.Its concrete scheme is following:
A kind of data dictionary generation method comprises:
Obtain entity object, and obtain the table name of the corresponding database table of said entity object;
Obtain the definition of field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute;
The definition integration of table name, attribute another name and field is exported in the Microsoft Excel, to generate the data dictionary of this entity object.
Preferably, the said entity object that obtains, and the table name that obtains the corresponding database table of said entity object is specially: use the query analyzer function that is provided with in the enterprise application service standardized product EAS, to obtain the table name of entity object and corresponding database table.
Preferably; The definition integration of table name, attribute another name and field is exported in the Microsoft Excel; Data dictionary to generate this entity object is specially: use the interior export function that is provided with of enterprise application service standardized product EAS that the definition of table name, attribute another name and field is exported among the EXCEL, to generate the data dictionary of this entity object.
Preferably; Also comprise: obtain after the definition of field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute; The definition integration of table name, attribute another name and field is exported in the Microsoft Excel, also to comprise before the data dictionary that generates this entity object:
Show the definition of table name, attribute another name and the field obtained.
Preferably, the said entity object that obtains, and the table name that obtains the corresponding database table of said entity object is specially:
Resolve the XML file of entity object;
Obtain that put down in writing and table name this entity object corresponding data objects in the said XML file.
Preferably, the definition of the field corresponding with each attribute is specially in said attribute another name that obtains said each attribute of entity object and the database table:
Obtain attribute alias identifications among < alias>under < ownProperty>and < linkProperty >, in < resource>of entity metadata XML, find corresponding with it < rs >, the getattr another name;
According to the field name in < mappingField>under < ownProperty>and < linkProperty >, obtain with the corresponding database table of entity object in corresponding with it < column >, to obtain the definition with the corresponding field of attribute.
Preferably, the definition of said field comprises: field title, data type, length, default value, precision, whether allow for sky.
The embodiment of the invention also provides a kind of data dictionary generation system, comprising:
The table name deriving means is used to obtain entity object, and obtains the table name of the corresponding database table of said entity object;
Information acquisition device is used for obtaining the definition of attribute another name and the database table of said each attribute of the entity object field corresponding with each attribute;
The dictionary generating apparatus is used for the definition integration of table name, attribute another name and field is exported to Microsoft Excel, to generate the data dictionary of this entity object.
Can find out from above-mentioned technical scheme; The disclosed data dictionary of the embodiment of the invention generates method and system; Be through the relation between entity object and the data object is resolved; Obtain the attribute another name of entity object, and integrate with the definition of the field of data object record, and the final data dictionary that generates this entity object of deriving.Here; The attribute another name of entity object is the field meaning of database table and describes; Such as: for entity object " Person "; The another name of attribute name is: name, the database table table name that this entity object is corresponding is: " T_DB_Person ", the just expression " name " of field FName among the T_DB_Person of attribute name mapping so.Compared with prior art, do not need the developer constantly under the BOS development environment from the definition of entity object and data object copy and then reduce developer's working time and workload obtaining data dictionary, increase work efficiency.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art; To do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below; Obviously, the accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills; Under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the mapping relations of entity object and data object;
Fig. 2 is the another kind of mapping relations of entity object and data object;
Fig. 3 is another mapping relations of entity object and data object;
Fig. 4 is the process flow diagram of data dictionary generation method disclosed by the invention;
Fig. 5 for the present invention based on the operation interface synoptic diagram;
Fig. 6 is the structural representation of data dictionary generation system disclosed by the invention.
Embodiment
For those skilled in the art can better understand the present invention, before setting forth technical scheme of the present invention, at first introduce the relation between entity object and the data object.
Entity object is the core content of metadata schema, and the metadata of other types such as data object, relationship object is all attached or depend on it.Entity object is a logical view of data storage, and it is corresponding to the entity class in the operation system, but refers to the data object of permanent storage.Entity object can be defined as " abstract ", and the abstract entity object does not define the mapping with data object, does not also just have corresponding relevant database table to produce.Therefore the entity object of being mentioned hereinafter all refers to non-abstract entity, describes at this.
Entity object is abstract to things in the real world; Be used for describing the characteristic and the behavior of a business object; For example office worker's entity object can be used for describing name, sex, age, unit one belongs to, key post, education background, work experience of office worker etc.; And unit, post, education background, work experience can be used as other entity object and exist, and describe corresponding business information.
Data object is the definition to the business datum physical memory space, is used for describing the project organization of tables of data in the relevant database, corresponding to the database table in the relevant database.Define database table name, another name, field title, another name in the data object, whether be multilingual field, default value, data type, length, precision, decimal place, whether allowed for sky etc.There is the Field Count identical with the supporting language data in the field of multilingual type in data object.For example: the field of expression office worker name is the FName among the database table T_BD_Person, and this field need provide the value under the different language environment, and then this field is exactly a multilingual field.If support English, simplified form of Chinese Character bilingual, then this field has two field FName_11 and two fields of FName_12 to represent in physical database.
Relation is an another kind of metadata type among the BOS, is used for describing the annexation between entity object.This annexation briefly, can be divided into: polymerization and two types of combinations.Are weak relations whole and part between two objects of Aggregate Expression, the life cycle of part can surmount integral body, like computer and mouse.Is strong relation whole and part between two objects of combination expression, the life cycle of part can not be more than integral body, can not surmount integral body in other words and exists." part " of syntagmatic can not be shared between integral body, like the relation of people and eyes.Defined the multiplicity of relationship type, relevant two entity objects and entity in the relationship metadata.The entity multiplicity comprises: 0...1,1,0...*, 1...*.There is a constraint condition in the relation of two inter-entity: relation can only be multi-to-multi or one-to-many or a pair of
Information such as pairing data object of this entity object and attribute have been defined in the entity object.Each non-abstract entity object is corresponding to a data object, also just indirectly corresponding to a relevant database table, and the value of in store entity object attribute in the database table.Comprise a plurality of attributes in the entity object, each attribute has its attribute-name and attribute another name.They perhaps belong to own attribute, perhaps belong to connection attribute.Own attribute maps directly to the field of data object, must define the relation of inter-entity in the connection attribute, allows indefinite benefit film showing to penetrate field.The attribute of entity object and the interfield of data object exist important getting in touch.Our purpose will be analyzed these contacts exactly, and the definition information of field in the another name of attribute in the entity object and the data object is integrated the basic data of acquisition composition data dictionary.
Facing the attribute of entity object and the relation of data object field down explains.
(1) own attribute is the simplest a kind of attribute in the entity object, maps directly to data model as the part of entity, and carries out physical store, for example the name of office worker's entity, sex, age etc.In the definition of own attribute except title, another name and some other information, the most important be specified with the place entity object in the mapping of certain field of the data object that defines.Mapping relations are as shown in Figure 1.What be worth explanation is, an own attribute id is all arranged in each entity object, is identifying the uniqueness of this entity object.The major key Fid that defines in own attribute id and the data object is corresponding.
(2) connection attribute is a kind of attribute of more complicated in the entity object.It can be the instance of another business object, and for example the unit one belongs to of office worker's entity and key post also can be the instances of business object set, the for example education background of office worker's entity and work experience.Maximum different of connection attribute and own attribute are to have defined in the connection attribute relation with other entity objects.At this, be convenient explanation, the entity object that will obtain its data dictionary is called the principal object, and other entity object is called the related entities object.
A. as the instance of another one business object
At first, specified the field corresponding in the data object of entity object definition in the connection attribute with this attribute.Simultaneously, importantly defined relation with the another one entity.Main body in the relation is the entity object that we will obtain its data dictionary.Relevant entity object provides the value of connection attribute corresponding field in the principal object, and this value is generally the id of related entities object.Be appreciated that to a certain extent into, the major key of related entities object corresponding relationship type database table is the external key of principal object corresponding relationship type database table.The connection attribute that comes to this of the key post in office worker's entity object for example.The post entity object is the related entities object.Be the paradigmatic relation of 1:0...1 between office worker's entity object and post entity object.The life cycle of post entity object can surpass office worker's entity object.The value of the field in the post, place of staff table is exactly the Major key in the quarter bill in the relevant database.Unit one belongs to's attribute of office worker also is like this.Mapping relations are as shown in Figure 2.
B, as the instance of business object set
Consult Fig. 3, when connection attribute during as the instance of business object set, connection attribute generally do not define with data object in the mapping of field.It has just defined the relation with the another one entity object.This relation is generally the syntagmatic of 1:0...*.The life cycle of related entities object can not surpass the principal object.Have a connection attribute parent in the relevant entity object, the relation that defines in relation that defines among the parent and the current said connection attribute is same metadata.It is as the instance of principal object and exist.That is to say that the data object corresponding relationship type database table of principal object definition and the data object corresponding relationship type database table of related entities object definition are that boss concerns.The value of the field Fparent of connection attribute parent in relational database of related entities object is taken from the value of the field Fid of principal object id in relational database.For example the work experience in office worker's entity is such connection attribute.Work experience is the related entities object.Office worker's entity object can not have work experience, a plurality of work experience can be arranged yet.The FparentId field value of work experience table derives from the Fid of staff table in the relevant database.The education background attribute of office worker's entity object also belongs to this type of.
In sum, the field that defines in the attribute of entity object and the data object has complicated and important relation.And data object is the definition to database table in the relevant database.Therefore through the attribute in the traversal entity object, analyze the relation between they and the relevant database field, just can obtain the essential information of composition data dictionary, thereby reach the purpose of derived data dictionary.
The applicant finds after deliberation, in the prior art, no matter is under relevant database, EAS system or BOS Studio; The sole mode that obtains data dictionary can only constantly be copied from the definition of entity object and data object under the BOS development environment by the developer; Obviously, this can be very loaded down with trivial details, also can spend a lot of energy and times; Increase developer's working time and workload, inefficiency.
In order to address the above problem; The data dictionary generation method that the embodiment of the invention provides; Be that the attribute another name of entity object attribute is integrated with the field information of data object record, obtain the essential information of composition data dictionary, and then derive and add in the data dictionary.Wherein, attribute another name is the description of attribute meaning that entity object is had, and for example: entity object A representes the office worker, and name is office worker's a attribute, and the name of attribute is called Name, and " name " is exactly the another name of attribute Name.Through the relation between analysis entities object properties and the data object field, obtain the complete information of data dictionary.Combine EAS system and XML file below respectively, data dictionary generation method shown in Figure 4 is described.
An embodiment
This embodiment combines the EAS system that data dictionary generation method shown in Figure 4 is described.Fig. 4 is the process flow diagram of the data dictionary generation method that provides of the embodiment of the invention, comprising:
S101: obtain entity object, and obtain the table name of the corresponding database table of said entity object;
Step S101 can be through using the query analyzer in the EAS system, and the operation interface synoptic diagram of query analyzer is as shown in Figure 5.Wherein: " entity list search " is one of function of query analyzer.It has set up index between entity object and data object.Carry out fuzzy query entity object and the data object relation between the database table in other words through the another name that will obtain the business object of data dictionary in " entity list search " interface input.The result of inquiry comprises physical name (entity object name), class name (entity object realization class name), entity alias (entity object description), the database table name (data object name and relational database table name) of business object.Operation interface is as shown in Figure 5, and input " office worker " can obtain result as shown in table 1 below in " entity list search ".
Table 1 interface result for retrieval
| Physical name | Class name | Entity alias | The database table table name |
| Person | com.kingdee.eas.basedata.person.app.Person | Office worker's information | T_BD_Person |
Therefore through query analyzer, can obtain full name and database table name that office worker's entity object is realized class.
Before address, exist important incidence relation between entity object and the data object.According to this incidence relation, then can confirm and the corresponding data object of entity object.According to full name of the entity object realization class that obtains, call interface or method in the BOS framework, can directly obtain this entity object.And then by the pairing data object of this entity object this entity object of acquisition.
S102: the definition of obtaining field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute;
The attribute of traversal entity object, when this attribute had the field of mapping relations, the getattr another name was described as the meaning of this field.Simultaneously from the said data object of S101, obtain the row object corresponding with this attribute according to attribute-name.Row specifically describe the definition of field to liking the instance of data object field, and whether the definition of field comprises field title, another name, type, length, default value, is sky, precision etc.Therefore whole definition information of field have also just been obtained.
S103: the definition integration of table name, attribute another name and field is exported in the Microsoft Excel, to generate the data dictionary of this entity object.
Make up set; With the attribute that obtains among the data table name that obtains among the S101, S102 another name and middle field title, data type, length, default value, precision, whether allow for information such as sky and join in this set, and be presented in the EAS system interface with the form of tabulating.Click " video data storehouse table definition " among Fig. 5 like the user, represent that then operation interface receives the instruction of video data storehouse table definition, in the definition of video data storehouse, the viewing area of operation interface table.Export function itself that utilize the EAS system to have promptly receives the user and clicks the derivation instruction that the derivation button sends, and tabulation is exported in the Microsoft Excel, thereby form our needed data dictionary.Certainly, can directly utilize export function to derive, and not carry out display operation.
Need to prove:
(1) in step S101, when through " entity list search " the functional inquiry entity object in the EAS system queries analyzer, can go out many records by fuzzy query.For example shown in Fig. 5, in " entity list search " interface input " order ", after the click " inquiry ", the below tabulation can show " purchase order ", " sales order ", " planned order " etc.Can travel through through selecting a plurality of entity objects so, repeating step S102 and S103 successively can obtain the data dictionary of a plurality of entity objects simultaneously.
When (2) in S102, traveling through the attribute of entity object; Do not specify the field of mapping when this attribute; And this attribute is the instance of related entities object set; Obtain the specified relationship object of this attribute through calling the method that the BOS framework provides so, and then obtain the other related entities object that defines in this relationship object, successively repeating step S102 and S103; Just can obtain the data dictionary of related entities object, the data dictionary of the sublist of the database table that defines in the just former entity object corresponding data objects.
(2) attribute of entity object another name can be represented with different language, for example simplified Chinese character, traditional Chinese, English etc.Through selecting different language, can below show that different language entity object attribute down calls in the tabulation, i.e. field description.And the definition of field such as field type, length, precision etc. or represent or use numeral with English need not corresponding with the language of attribute another name selection.Then can obtain the data dictionary of the different language of this entity object thus according to the difference of the language of selecting.
Use technique scheme; Through the relation between entity object and the data object is resolved; Obtain the attribute another name of each attribute of entity object, with deriving with the definition integration of the corresponding field of each attribute in attribute another name and the database table, to generate the data dictionary of this entity object.The attribute another name is described for the field meaning of database table; Such as: for " Person " entity object; Corresponding database table table name is: " T_DB_Person "; The another name of attribute Name is a name, with FName field among the T_DB_Person mapping relations is arranged, and describing about the meaning of field FName in the tables of data definition document of T_DB_Person of deriving so is exactly name.Compared with prior art, do not need the developer constantly under the BOS development environment from the definition of entity object and data object copy and then reduce developer's working time and workload obtaining data dictionary, increase work efficiency.In addition, the user then can be known the concrete meaning that each field of database table is represented through the another name of the attribute in the data query dictionary, and then knows the concrete meaning of database table institute information recorded, and then this database table is carried out subsequent operation.
Another embodiment
The foregoing description generates data dictionary and depends on the EAS client, need carry out at the EAS operation interface.In addition, under the situation that does not start the EAS client, also can generate complete data dictionary automatically.Because at the beginning of modeling, entity metadata, relationship metadata, data metadata all exist with the XML document form, thus the information that will obtain to want, and export in the data dictionary, only need the XML document analysis of these several types of metadata be got final product.Below in conjunction with the XML file, data dictionary generation method shown in Figure 4 is described.
At first introduce the XML file structure of entity metadata, relationship metadata, data metadata.
Part-structure in the entity object XML file is following:
<entityObject>
<package>Entity object bag name</package>
<name>The entity object name</name>
<alias>The entity object alias identifications</alias>
<table>Data object full name (comprising name and data object name)</table>
!-own attribute-->
<ownProperty>
<name>The entity object attribute-name</name>
<alias>Entity object attribute alias identifications</alias>
<mappingField>The map field name</mappingField>
</ownProperty>
!-connection attribute, the entity object attribute is as the instance of another business object--
<linkProperty>
<name>The entity object attribute-name</name>
<alias>Entity object attribute alias identifications</alias>
<mappingField>The map field name</mappingField>
The place bag name and the relation of < relationship>this connection attribute corresponding relationship metadata
The metadata name</relationship>
</linkProperty>
!-connection attribute, entity object attribute do not need the appointment map field this moment as the instance of another business object set, only need to indicate relation-->
<linkProperty>
<name>The entity object attribute-name</name>
<alias>Entity object attribute alias identifications</alias>
<relationship>The place bag name and the relationship metadata name of this connection attribute corresponding relationship metadata</relationship>
</linkProperty>
<resource>
< rs key=" above-mentioned entity object attribute alias identifications " >
< lang locale=" zh_CN " value=" attribute another name (simplified Chinese character) " />
< lang locale=" en_US " value=" attribute another name (English) " />
< lang locale=" zh_TW " value=" attribute another name (traditional Chinese) " />
</rs>
</resource>
</entityObject>
The part-structure of data object XML file is following:
<dataTable>
<package>Data object bag name</package>
<name>The data object name</name>
<alias>The data object alias identifications</alias>
<columns>
<column>
<name>Field name</name>
<alias>The field alias identifications</alias>
<isNullable>Whether can be empty</isNullable>
<defaultValue>Default value</defaultValue>
<sqlType>Field type</sqlType>
<length>Field length</length>
<scale>Decimal digits</scale>
<precision>Precision</precision>
</column>
</columns>
<resource>
< rs key=" above-mentioned data object field alias identifications " >
< lang locale=" zh_CN " value=" field another name (simplified Chinese character) " />
< lang locale=" en_US " value=" field another name (English) " />
< lang locale=" zh_TW " value=" field another name (traditional Chinese) " />
</rs>
</resource>
</dataTable>
Relationship metadata XML file part structure is following:
<relationship″>
<package>Relationship metadata place bag name</package>
<name>The relationship metadata title</name>
<type>Relationship type</type>
<clientCardinality>The entity object multiplicity</clientCardinality>
<supplierCardinality>and entity object attribute related entities object
</supplierCardinality>
<clientObject>Entity object place bag name and entity object name</clientObject>
<supplierObject>
Related entities object place bag name and related entities object name
</supplierObject>
</relationship>
Next combine the XML file, introduce and how to utilize data dictionary generation method shown in Figure 4 to realize generating complete data dictionary.
S101: obtain entity object, and obtain the table name of the corresponding database table of said entity object;
Through resolving entity object XML file, can obtain data object relative path and data object name according to <table>mark, the data object name is the table name of pairing database table, for reading of data object XML file is got ready.
S102: the definition of obtaining field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute;
In the part-structure in the above-mentioned entity object XML file that provides: the own attribute of ownProperty presentation-entity object, linkProperty are the connection attribute of entity object.
< ownProperty>mark under the traversal < properties>and < linkProperty>mark; Obtain attribute alias identifications among < alias>under < ownProperty>and < linkProperty >; In entity metadata XML, find corresponding with it < rs>in < resource >; Can obtain the attribute another name under the different language, with this description as the field meaning.
According to the field name in < mappingField>under < ownProperty>and < linkProperty >, in S101, obtain to find corresponding with it < column>in the database table, < name>is exactly and the corresponding field name of attribute in < column >.Other marks < isNullable>under < column >, < defaultValue/>, < sqlType >, < length >, < scale >, < precision>represent whether to allow for sky, default value, data type, length, decimal digits, precision respectively.The basic data of data dictionary is just formed in the definition of the field under < mappingField>among the attribute of attribute another name and < column >.
S103: the definition integration of table name, attribute another name and field is exported in the Microsoft Excel, to generate the data dictionary of this entity object.
Need to prove:
(1) when execution in step S101, can obtain a plurality of entity metadata XML files simultaneously, and travel through.After step S102 and step S103, can obtain the data dictionary of a plurality of entity objects simultaneously.That is to say that the data dictionary generation method that the embodiment of the invention provides can generate the data dictionary of a plurality of entity objects simultaneously.
(2) for the connection attribute that does not have < mappingField>mark among the S102, can obtain this attribute corresponding relationship metadata place relative path and relationship metadata title according to < relationship>mark, find the relationship metadata file thus.According to <supplierObject>mark in the relationship metadata, find related entities object relative path and title, can obtain the XML file of related entities object, and then, the data dictionary of the sublist of acquisition entity object corresponding relationship type database table.
(3) learn by above-mentioned, the attribute another name of different language is provided under < resource>in the entity object XML file.The category of language of selecting according to the user so obtains < lang>attribute another name of corresponding language down.For example when the user selects traditional Chinese, identification < lang>is locale=" zh_TW " mark down, obtains corresponding value value, and the attribute of Here it is traditional Chinese is called.Certainly, prerequisite finds corresponding with it < rs>according to attribute alias identifications in < alias>under < ownProperty>and < linkProperty>in < resource>in entity metadata XML.In sum,, can obtain the attribute another name under the corresponding language, also just can obtain the data dictionary of the different language of this entity object according to the selection of user to category of language.
Use technique scheme; Through the relation between entity object and the data object is resolved; Obtain the attribute another name of each attribute of entity object, with deriving with the definition integration of the corresponding field of each attribute in attribute another name and the database table, to generate the data dictionary of this entity object.Compared with prior art, do not need the developer constantly under the BOS development environment from the definition of entity object and data object copy and then reduce developer's working time and workload obtaining data dictionary, increase work efficiency.In addition, the user then can be known the concrete meaning that each field of database table is represented through the another name of the attribute in the data query dictionary, and then knows the concrete meaning of database table institute information recorded, and then this database table is carried out subsequent operation.
Corresponding with method shown in Figure 4, the embodiment of the invention also provides a kind of data dictionary generation system, and the structural representation of this system is as shown in Figure 6, comprising: table name deriving means 601, information acquisition device 602 and dictionary generating apparatus 603, wherein:
Table name deriving means 601 is used to obtain entity object, and obtains the table name of the corresponding database table of said entity object;
Information acquisition device 602 is used for obtaining the definition of attribute another name and the database table of said each attribute of the entity object field corresponding with each attribute;
Dictionary generating apparatus 603 is used for the definition integration of table name, attribute another name and field is exported to Microsoft Excel, to generate the data dictionary of this entity object.
Each embodiment adopts the mode of going forward one by one to describe in this instructions, and what each embodiment stressed all is and the difference of other embodiment that identical similar part is mutually referring to getting final product between each embodiment.For the disclosed device of embodiment, because it is corresponding with the embodiment disclosed method, so description is fairly simple, relevant part is partly explained referring to method and is got final product.
The professional can also further recognize; The unit and the algorithm steps of each example of describing in conjunction with embodiment disclosed herein; Can realize with electronic hardware, computer software or the combination of the two; For the interchangeability of hardware and software clearly is described, the composition and the step of each example described prevailingly according to function in above-mentioned explanation.These functions still are that software mode is carried out with hardware actually, depend on the application-specific and the design constraint of technical scheme.The professional and technical personnel can use distinct methods to realize described function to each certain applications, but this realization should not thought and exceeds scope of the present invention.
The method of describing in conjunction with embodiment disclosed herein or the step of algorithm can be directly with the software modules of hardware, processor execution, and perhaps the combination of the two is implemented.Software module can place the storage medium of any other form known in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or the technical field.
To the above-mentioned explanation of the disclosed embodiments, make this area professional and technical personnel can realize or use the present invention.Multiple modification to these embodiment will be conspicuous concerning those skilled in the art, and defined General Principle can realize under the situation that does not break away from the spirit or scope of the present invention in other embodiments among this paper.Therefore, the present invention will can not be restricted to these embodiment shown in this paper, but will meet and principle disclosed herein and features of novelty the wideest corresponding to scope.
Claims (8)
1. a data dictionary generation method is characterized in that, comprising:
Obtain entity object, and obtain the table name of the corresponding database table of said entity object;
Obtain the definition of field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute;
The definition integration of table name, attribute another name and field is exported in the Microsoft Excel, to generate the data dictionary of this entity object.
2. data dictionary generation method according to claim 1; It is characterized in that; The said entity object that obtains; And the table name that obtains the database table of said entity object correspondence is specially: use the query analyzer function that is provided with in the enterprise application service standardized product EAS, to obtain the table name of the entity object and the database table of correspondence.
3. data dictionary generation method according to claim 2; It is characterized in that; The definition integration of table name, attribute another name and field is exported in the Microsoft Excel; Data dictionary to generate this entity object is specially: use the interior export function that is provided with of enterprise application service standardized product EAS that the definition of table name, attribute another name and field is exported among the EXCEL, to generate the data dictionary of this entity object.
4. data dictionary generation method according to claim 3; It is characterized in that; Also comprise: obtain after the definition of field corresponding in attribute another name and the database table of said each attribute of entity object with each attribute; The definition integration of table name, attribute another name and field is exported in the Microsoft Excel, also to comprise before the data dictionary that generates this entity object:
Show the definition of table name, attribute another name and the field obtained.
5. data dictionary generation method according to claim 1 is characterized in that, the said entity object that obtains, and the table name that obtains the corresponding database table of said entity object is specially:
Resolve the XML file of entity object;
Obtain that put down in writing and table name this entity object corresponding data objects in the said XML file.
6. data dictionary generation method according to claim 5 is characterized in that, the definition of the field corresponding with each attribute is specially in said attribute another name that obtains said each attribute of entity object and the database table:
Obtain attribute alias identifications among < alias>under < ownProperty>and < linkProperty >, in < resource>of entity metadata XML, find corresponding with it < rs >, the getattr another name;
According to the field name in < mappingField>under < ownProperty>and < linkProperty >, obtain with the corresponding database table of entity object in corresponding with it < column >, to obtain the definition with the corresponding field of attribute.
7. according to any described data dictionary generation method of claim 1-6, it is characterized in that the definition of said field comprises: field title, data type, length, default value, precision, whether allow for sky.
8. a data dictionary generation system is characterized in that, comprising:
The table name deriving means is used to obtain entity object, and obtains the table name of the corresponding database table of said entity object;
Information acquisition device is used for obtaining the definition of attribute another name and the database table of said each attribute of the entity object field corresponding with each attribute;
The dictionary generating apparatus is used for the definition integration of table name, attribute another name and field is exported to Microsoft Excel, to generate the data dictionary of this entity object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105892543A CN102541867A (en) | 2010-12-15 | 2010-12-15 | Data dictionary generating method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105892543A CN102541867A (en) | 2010-12-15 | 2010-12-15 | Data dictionary generating method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102541867A true CN102541867A (en) | 2012-07-04 |
Family
ID=46348789
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010105892543A Pending CN102541867A (en) | 2010-12-15 | 2010-12-15 | Data dictionary generating method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102541867A (en) |
Cited By (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014187216A1 (en) * | 2013-09-17 | 2014-11-27 | 中兴通讯股份有限公司 | Method and device for database structure object processing |
| CN104881747A (en) * | 2015-06-01 | 2015-09-02 | 北京圆通慧达管理软件开发有限公司 | Data collaboration method and data collaboration system |
| CN105005592A (en) * | 2015-06-29 | 2015-10-28 | 用友优普信息技术有限公司 | Data dictionary generation method and data dictionary generation device |
| CN105205060A (en) * | 2014-06-12 | 2015-12-30 | 中兴通讯股份有限公司 | Method and device for generating word document database dictionary |
| CN105404509A (en) * | 2015-11-11 | 2016-03-16 | 神州数码国信信息技术（苏州）有限公司 | ExtJS UI based visual code generation method |
| CN105787282A (en) * | 2016-03-24 | 2016-07-20 | 国家卫生计生委统计信息中心 | Automatic standardization method and system for medical data dictionaries |
| CN106528885A (en) * | 2016-12-16 | 2017-03-22 | 苏州市环亚数据技术有限公司 | Processing method and device of medical business data |
| CN106933832A (en) * | 2015-12-30 | 2017-07-07 | 中国科学院沈阳自动化研究所 | A kind of construction method of the digital dictionary of oil reservoir |
| CN107025214A (en) * | 2017-04-27 | 2017-08-08 | 珠海格力电器股份有限公司 | Data processing method and device |
| CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
| CN107944013A (en) * | 2017-12-08 | 2018-04-20 | 珠海华索软件科技有限公司 | A kind of database code generation method and system |
| CN108170752A (en) * | 2017-12-21 | 2018-06-15 | 山东合天智汇信息技术有限公司 | metadata management method and system based on template |
| CN108920638A (en) * | 2018-07-02 | 2018-11-30 | 山东浪潮商用系统有限公司 | Web terminal data collector file method and device based on data dictionary configuration |
| CN109325038A (en) * | 2018-09-05 | 2019-02-12 | 天津航旭科技发展有限公司 | Knowledge mapping extended model, structural knowledge storage method and equipment |
| CN110348004A (en) * | 2019-05-23 | 2019-10-18 | 平安科技（深圳）有限公司 | Method, apparatus, electronic equipment and the storage medium that data dictionary generates |
| TWI676904B (en) * | 2016-03-01 | 2019-11-11 | 香港商阿里巴巴集團服務有限公司 | Information processing method and device |
| CN110471888A (en) * | 2018-05-09 | 2019-11-19 | 株式会社日立制作所 | A kind of method, apparatus of automatic data collection, medium, equipment and system |
| CN110515653A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Document structure tree method, apparatus, electronic equipment and computer readable storage medium |
| CN110990412A (en) * | 2019-12-25 | 2020-04-10 | 中国银行股份有限公司 | Data structure design method and device |
| CN111143461A (en) * | 2019-12-31 | 2020-05-12 | 中国银行股份有限公司 | Mapping relation processing system and method and electronic equipment |
| CN112130890A (en) * | 2020-09-17 | 2020-12-25 | 北京金和网络股份有限公司 | Business system development and maintenance method, device, storage medium and server |
| CN112667630A (en) * | 2020-12-24 | 2021-04-16 | 平安科技（深圳）有限公司 | Method, device, equipment and storage medium for integrating business report |
| CN113282283A (en) * | 2021-06-11 | 2021-08-20 | 北京拓课网络科技有限公司 | Method and device for operating database table and electronic equipment |
| CN113568696A (en) * | 2021-07-29 | 2021-10-29 | 成都卓码数智数字科技有限公司 | Method for defining service data model through interface operation in digital transformation |
| CN114238263A (en) * | 2021-10-20 | 2022-03-25 | 北银金融科技有限责任公司 | Database modeling system based on data dictionary |
| CN115033599A (en) * | 2022-08-12 | 2022-09-09 | 深圳市洞见智慧科技有限公司 | Graph query method, system and related device based on multi-party security |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN101046810A (en) * | 2006-05-26 | 2007-10-03 | 华为技术有限公司 | System for automatic setting relation model and its method |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
-
2010
- 2010-12-15 CN CN2010105892543A patent/CN102541867A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101046810A (en) * | 2006-05-26 | 2007-10-03 | 华为技术有限公司 | System for automatic setting relation model and its method |
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
Cited By (40)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014187216A1 (en) * | 2013-09-17 | 2014-11-27 | 中兴通讯股份有限公司 | Method and device for database structure object processing |
| CN105205060A (en) * | 2014-06-12 | 2015-12-30 | 中兴通讯股份有限公司 | Method and device for generating word document database dictionary |
| CN104881747A (en) * | 2015-06-01 | 2015-09-02 | 北京圆通慧达管理软件开发有限公司 | Data collaboration method and data collaboration system |
| CN105005592A (en) * | 2015-06-29 | 2015-10-28 | 用友优普信息技术有限公司 | Data dictionary generation method and data dictionary generation device |
| CN105005592B (en) * | 2015-06-29 | 2018-10-16 | 用友优普信息技术有限公司 | Data dictionary generation method and data dictionary creation device |
| CN105404509A (en) * | 2015-11-11 | 2016-03-16 | 神州数码国信信息技术（苏州）有限公司 | ExtJS UI based visual code generation method |
| CN105404509B (en) * | 2015-11-11 | 2019-06-21 | 平湖神州数码博海科技有限公司 | Method based on ExtJS UI Visual Production code |
| CN106933832A (en) * | 2015-12-30 | 2017-07-07 | 中国科学院沈阳自动化研究所 | A kind of construction method of the digital dictionary of oil reservoir |
| US11200220B2 (en) | 2016-03-01 | 2021-12-14 | Advanced New Technologies Co., Ltd. | Efficient storage of user personal attributes for service provisioning |
| TWI676904B (en) * | 2016-03-01 | 2019-11-11 | 香港商阿里巴巴集團服務有限公司 | Information processing method and device |
| 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 |
| CN105787282B (en) * | 2016-03-24 | 2018-05-01 | 国家卫生计生委统计信息中心 | A kind of method and system of medical data dictionary automatic standardizing |
| CN105787282A (en) * | 2016-03-24 | 2016-07-20 | 国家卫生计生委统计信息中心 | Automatic standardization method and system for medical data dictionaries |
| CN106528885A (en) * | 2016-12-16 | 2017-03-22 | 苏州市环亚数据技术有限公司 | Processing method and device of medical business data |
| CN107025214A (en) * | 2017-04-27 | 2017-08-08 | 珠海格力电器股份有限公司 | Data processing method and device |
| CN107025214B (en) * | 2017-04-27 | 2019-08-30 | 珠海格力电器股份有限公司 | Data processing method and device |
| CN107944013A (en) * | 2017-12-08 | 2018-04-20 | 珠海华索软件科技有限公司 | A kind of database code generation method and system |
| CN108170752A (en) * | 2017-12-21 | 2018-06-15 | 山东合天智汇信息技术有限公司 | metadata management method and system based on template |
| CN108170752B (en) * | 2017-12-21 | 2020-10-16 | 山东合天智汇信息技术有限公司 | Template-based metadata management method and system |
| CN110471888A (en) * | 2018-05-09 | 2019-11-19 | 株式会社日立制作所 | A kind of method, apparatus of automatic data collection, medium, equipment and system |
| CN108920638A (en) * | 2018-07-02 | 2018-11-30 | 山东浪潮商用系统有限公司 | Web terminal data collector file method and device based on data dictionary configuration |
| CN109325038A (en) * | 2018-09-05 | 2019-02-12 | 天津航旭科技发展有限公司 | Knowledge mapping extended model, structural knowledge storage method and equipment |
| 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 |
| CN110515653A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Document structure tree method, apparatus, electronic equipment and computer readable storage medium |
| CN110515653B (en) * | 2019-08-30 | 2023-04-11 | 望海康信(北京)科技股份公司 | Document generation method and device, electronic equipment and computer readable storage medium |
| CN110990412A (en) * | 2019-12-25 | 2020-04-10 | 中国银行股份有限公司 | Data structure design method and device |
| CN110990412B (en) * | 2019-12-25 | 2023-09-19 | 中国银行股份有限公司 | Data structure design method and device |
| CN111143461A (en) * | 2019-12-31 | 2020-05-12 | 中国银行股份有限公司 | Mapping relation processing system and method and electronic equipment |
| CN111143461B (en) * | 2019-12-31 | 2024-04-19 | 中国银行股份有限公司 | Mapping relation processing system, method and electronic equipment |
| CN112130890A (en) * | 2020-09-17 | 2020-12-25 | 北京金和网络股份有限公司 | Business system development and maintenance method, device, storage medium and server |
| CN112667630A (en) * | 2020-12-24 | 2021-04-16 | 平安科技（深圳）有限公司 | Method, device, equipment and storage medium for integrating business report |
| CN112667630B (en) * | 2020-12-24 | 2023-06-02 | 平安科技（深圳）有限公司 | Method, device, equipment and storage medium for integrating business report |
| CN113282283A (en) * | 2021-06-11 | 2021-08-20 | 北京拓课网络科技有限公司 | Method and device for operating database table and electronic equipment |
| CN113282283B (en) * | 2021-06-11 | 2022-03-22 | 北京拓课网络科技有限公司 | Method and device for operating database table and electronic equipment |
| CN113568696A (en) * | 2021-07-29 | 2021-10-29 | 成都卓码数智数字科技有限公司 | Method for defining service data model through interface operation in digital transformation |
| CN114238263A (en) * | 2021-10-20 | 2022-03-25 | 北银金融科技有限责任公司 | Database modeling system based on data dictionary |
| CN115033599A (en) * | 2022-08-12 | 2022-09-09 | 深圳市洞见智慧科技有限公司 | Graph query method, system and related device based on multi-party security |
| CN115033599B (en) * | 2022-08-12 | 2022-11-11 | 深圳市洞见智慧科技有限公司 | Graph query method, system and related device based on multi-party security |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541867A (en) | Data dictionary generating method and system | |
| CN113342821B (en) | Report configuration method, device, equipment and computer storage medium | |
| Jensen et al. | Multidimensional databases and data warehousing | |
| US8341131B2 (en) | Systems and methods for master data management using record and field based rules | |
| US7925658B2 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
| US9311334B2 (en) | Geospatial database integration using business models | |
| US9053212B2 (en) | Multi-dimensional metadata in research recordkeeping | |
| Corr et al. | Agile data warehouse design: Collaborative dimensional modeling, from whiteboard to star schema | |
| US8086592B2 (en) | Apparatus and method for associating unstructured text with structured data | |
| US9075859B2 (en) | Parameterized database drill-through | |
| CN110674228A (en) | Data warehouse model construction and data query method, device and equipment | |
| US10671671B2 (en) | Supporting tuples in log-based representations of graph databases | |
| WO2017151194A1 (en) | Atomic updating of graph database index structures | |
| WO2005070094A2 (en) | Data migration and analysis | |
| US10445370B2 (en) | Compound indexes for graph databases | |
| US9147040B2 (en) | Point-in-time query system | |
| CN111414410B (en) | Data processing method, device, equipment and storage medium | |
| US20180357328A1 (en) | Functional equivalence of tuples and edges in graph databases | |
| Nordeen | Learn Data Warehousing in 24 Hours | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN111444177B (en) | Report configuration method and device | |
| CN101908063A (en) | Universal report query tool | |
| CN111881660A (en) | Report generation method and device, computer equipment and storage medium | |
| CN108804460A (en) | A kind of query language based on SQL | |
| Reniers et al. | Schema design support for semi-structured data: Finding the sweet spot between NF and De-NF |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120704 |