CN102096670A - Data dictionary generation method and device - Google Patents
Data dictionary generation method and device Download PDFInfo
- Publication number
- CN102096670A CN102096670A CN2009102137741A CN200910213774A CN102096670A CN 102096670 A CN102096670 A CN 102096670A CN 2009102137741 A CN2009102137741 A CN 2009102137741A CN 200910213774 A CN200910213774 A CN 200910213774A CN 102096670 A CN102096670 A CN 102096670A
- Authority
- CN
- China
- Prior art keywords
- information
- data
- html
- markup language
- hypertext markup
- 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
Abstract
The embodiment of the invention provides a data dictionary generation method. The method comprises the following steps of: acquiring object information of database objects in a system view of a database; converting the data format of the object information to generate the object information in the data format of hypertext markup language; generating construction information of a data dictionary; and generating the data dictionary of which the data format is an electronic book format according to the construction information and the object information in the data format of the hypertext markup language. Accordingly, the embodiment of the invention also provides a data dictionary generation device. By implementing the embodiment of the invention, the operating speed can be kept while the number of the database objects in the data dictionary is increased, so that the method and the device can be conveniently used by a user.
Description
Technical field
The present invention relates to field of telecommunications, relate in particular to a kind of data dictionary generation method and device.
Background technology
Operation support system (Operational Support System, OSS) mainly serve telecom operators, comprehensive functions such as user management, price policy, Account Disposal, statement analysis are provided, can support PSTN (Public Switched Telephone Network simultaneously, PSTN), Web TV (Internet Protocol Television, IPTV), the management of multiple business such as broadband.OSS has the database object of complicated service logic and One's name is legion, and for the purpose that these objects are described in detail, we have set up the set of OSS data message, and this set is called data dictionary again.
Present data dictionary is to adopt the file of document format to preserve, this document has write down the base table structure, but lack objects such as trigger, storing process, lack the incidence relation between each object simultaneously, and the quantity of the database object in the data dictionary arrives to a certain degree the back, operations such as it opens, inquires about, revises, search all become slowly, and this use to the user is made troubles.
Summary of the invention
In view of the problem that prior art exists, the embodiment of the invention proposes a kind of data dictionary generation method and device, in the time of can increasing the quantity of database object in the data dictionary, keeps the speed of operation simultaneously, is user-friendly to.
In order to solve the problems of the technologies described above, the embodiment of the invention proposes a kind of data dictionary generation method, comprising:
Obtain the object information of the database object in the system view of database;
To the Data Format Transform of carrying out of described object annotation information, generating data layout is the object information of HTML (Hypertext Markup Language);
Generate the tectonic information of data dictionary;
According to described tectonic information and described data layout is that to generate data layout be the data dictionary of e-book form for the object information of HTML (Hypertext Markup Language).
Correspondingly, the embodiment of the invention proposes a kind of data dictionary generating apparatus, comprises the memory module of the system view that is used for stored data base, also comprises:
Acquisition module is used for obtaining the object information of the database object in the system view of database of described memory module;
Format converting module is used for the Data Format Transform of carrying out of object annotation information that described acquisition module is obtained, and generating data layout is the object information of HTML (Hypertext Markup Language);
The tectonic information generation module is used to generate the tectonic information of data dictionary;
The data dictionary generation module, it is the data dictionary of e-book form that the object information that is used for data layout that the tectonic information that generates according to described tectonic information generation module and described format converting module generate and is HTML (Hypertext Markup Language) generates data layout.
Implement the embodiment of the invention, by the object information of the database object in the system view that obtains database; To the Data Format Transform of carrying out of described object annotation information, generate the tectonic information of data dictionary; According to described tectonic information and described data layout is that to generate data layout be the data dictionary of e-book form for the object information of HTML (Hypertext Markup Language), the page of the data dictionary of e-book form is a Web page or leaf, can easily read as browsing web sites, and it can support operations such as hyperlink, realize increasing the quantity of database object in the data dictionary, keep the speed of operation simultaneously, be user-friendly to.
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, apparently, 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 process flow diagram of data dictionary generation method in the embodiment of the invention;
Fig. 2 is the process flow diagram of conversion method of data format in the embodiment of the invention;
Fig. 3 is the structure principle chart of data dictionary generating apparatus in the embodiment of the invention.
Embodiment
The embodiment of the invention proposes a kind of data dictionary generation method and device, in the time of can increasing the quantity of database object in the data dictionary, keeps the speed of operation simultaneously, is user-friendly to.
Fig. 1 is the process flow diagram of data dictionary generation method in the embodiment of the invention, and data dictionary generation method comprises in the embodiment of the invention:
Herein, database object comprises data table object, trigger object, storing process object, function object and field object etc.Database object leaves in the Oracle system view, and the explanation of the system view that need use is as shown in table 1:
| View?Name | Description |
| USER_TABLES | describes?all?relational?tables accessible?to?the?user. |
| USER_TAB_COMMENTS | describes?comments?on?tables. |
| USER_TAB_COLUMNS | describes?the?columns?of?all?tables. |
| USER_COL_COMMENTS | lists?comments?on?columns?of?tables. |
| USER_CONSTRAINTS | describes?constraint?definitions?on tables. |
| USER_INDEXES | describes?indexes?on?all?tables. |
| USER_TRIGGERS | describes?owned?by?the?current?user and?triggers?on?tables?owned?by?the current?user. |
| USER_TRIGGER_COLS | describes?the?use?of?columns?in triggers?owned?by?user?or?in?triggers?on tables?owned?by?user. |
| USER_DEPENDENCIES | describes?dependencies?between procedures，packages，functions，package bodies，and?triggers?accessible?to?the?user. |
| USER_VIEWS | describes?all?views?accessible?to?the current?user. |
| USER_OBJECTS | describes?all?Objects?in?DB |
| USER_SOURCE | describes?procedure，function?and package?body?source?code |
| USER_ARGUMENTS | describes?procedure，function argument |
Table 1
Database object comprises the object annotation information, wherein view USER_TAB_COMMENTS and USER_COL_COMMENTS have write down the note of data table object and field object respectively, these notes need add in script, after setting up database, could read out from system view; For trigger object, storing process object and function object, there is not corresponding view to read note, need in advance the object annotation information to be written in the system view, so that can the reading object annotation information from system view USER_SOURCE.
Herein, during concrete enforcement, for data table object, at least obtain following object information: the tables of data table name claims, tables of data note, field name, field note, field type, field length, field constraint and be attached to index, the trigger on this tables of data and be associated with other table objects of this tables of data, the storing process object that uses this tables of data table and function object etc., if data table object also has the additional information of picture or literal etc., also obtain this additional information.For the trigger object, need to obtain following object information at least: table, trigger event, trigger fields that trigger title, trigger note, trigger are relied on, and table of using of trigger itself, storing process, function etc.For storing process and function, need to obtain following object information at least: object oriented, object note, parameter name, parameter type, parameter default value, parameter note, and table of using of object, other storing processs, function etc.
Herein, the generation data layout is that (Hyper Text Mark-up Language, HTML) object information, detailed process are seen data transfer device shown in Figure 2 to HTML (Hypertext Markup Language).
Herein, tectonic information comprises data dictionary format information, index information and directory information, and format information is the configuration file of a text formatting, has preserved set informations such as homepage, language, title, full-text search.Index file is to have write down database object and corresponding html file title in fact.Catalogue file also is the variation of the module relationship of record data dictionary.
Fig. 2 is the process flow diagram of conversion method of data format in the embodiment of the invention, and step 103 specifically comprises:
Herein, for trigger object, storing process object, function object and field object etc., the object information that generally generates data layout and be HTML (Hypertext Markup Language) gets final product, need not execution in step 203 and step 204.For data table object, then need execution in step 203 and step 204.
Herein, for additional informations such as picture in the data table object or literal, need carry out content to described object additional information according to described data-switching template and replace, generating data layout is the object additional information of HTML (Hypertext Markup Language).Detailed process is to add embedded document information in the note of database script; Set up outside document, form is html file, derivation instrument assembly unit file.
Herein, detailed process is to add embedded document information in the note of database script; Set up outside document, form is html file, derivation instrument assembly unit file, after the derivation instrument obtains object information from database, need to use template to replace, generate final html file, for embedded outside document, the database object template need be split into two parts, the derivation instrument generates File1 and File2 respectively, obtains the embedded document information of appointment then from the database object note, and the order according to the embedded document+File2 of File1+ generates final html file at last.
Fig. 3 is the structure principle chart of data dictionary generating apparatus in the embodiment of the invention, the data dictionary generating apparatus comprises memory module 31 in the embodiment of the invention, presetting module 32, acquisition module 33, format converting module 34, tectonic information generation module 35 and data dictionary generation module 36, wherein:
Herein, during concrete enforcement, for data table object, at least obtain following object information: the tables of data table name claims, tables of data note, field name, field note, field type, field length, field constraint and be attached to index, the trigger on this tables of data and be associated with other table objects of this tables of data, the storing process object that uses this tables of data table and function object etc., if data table object also has the additional information of picture or literal etc., also obtain this additional information.For the trigger object, need to obtain following object information at least: table, trigger event, trigger fields that trigger title, trigger note, trigger are relied on, and table of using of trigger itself, storing process, function etc.For storing process and function, need to obtain following object information at least: object oriented, object note, parameter name, parameter type, parameter default value, parameter note, and table of using of object, other storing processs, function etc.
Conversion module is set up unit 341, is used to set up the data-switching template, and the data layout and the content that have defined HTML (Hypertext Markup Language) in the described data-switching template are replaced positional information;
First content is replaced unit 342, is used for setting up data-switching template that the unit generates according to described conversion module and described object information is carried out content replaces, and generating data layout is the object information of HTML (Hypertext Markup Language).
Herein, for trigger object, storing process object, function object and field object etc., the object information that general generation data layout is a HTML (Hypertext Markup Language) gets final product, herein, for additional informations such as picture in the data table object or literal, need carry out content to described object additional information according to described data-switching template and replace, generating data layout is the object additional information of HTML (Hypertext Markup Language), and format converting module 34 also comprises:
Second content is replaced unit 343, is used for setting up data-switching template that the unit generates according to described conversion module and described object additional information is carried out content replaces, and generating data layout is the object additional information of HTML (Hypertext Markup Language);
Herein, detailed process is to add embedded document information in the note of database script; Set up outside document, form is html file, derivation instrument assembly unit file, after the derivation instrument obtains object information from database, need to use template to replace, generate final html file, for embedded outside document, the database object template need be split into two parts, the derivation instrument generates File1 and File2 respectively, obtains the embedded document information of appointment then from the database object note, and the order according to the embedded document+File2 of File1+ generates final html file at last.
Tectonic information generation module 35 is used to generate the tectonic information of data dictionary;
Herein, tectonic information generation module 35 specifically comprises:
Format information generation unit 351 is used to generate the format information of described data dictionary;
Index information generation unit 352 is used to generate the index information of described data dictionary;
Directory information generation unit 353 is used to generate the directory information of described data dictionary.
Data dictionary generation module 36, being used for generating data layout that 35 tectonic information and described format converting module 34 generate according to described tectonic information generation module is that to generate data layout be the data dictionary of e-book form for the object annotation information of HTML (Hypertext Markup Language).
Above disclosed is a kind of preferred embodiment of the present invention only, can not limit the present invention's interest field certainly with this, and therefore the equivalent variations of doing according to claim of the present invention still belongs to the scope that the present invention is contained.
Claims (10)
1. a data dictionary generation method is characterized in that, comprising:
Obtain the object information of the database object in the system view of database;
To the Data Format Transform of carrying out of described object information, generating data layout is the object information of HTML (Hypertext Markup Language);
Generate the tectonic information of data dictionary;
According to described tectonic information and described data layout is that to generate data layout be the data dictionary of e-book form for the object information of HTML (Hypertext Markup Language).
2. data dictionary generation method as claimed in claim 1 is characterized in that,
The object information of described database object comprises the object annotation information;
Comprise before the object information step of the database object in the described system view that obtains database:
Object annotation information with described database object writes in the described system view in advance.
3. data dictionary generation method as claimed in claim 2 is characterized in that, the described Data Format Transform of carrying out to described object information, and the generation data layout is that the object information step of HTML (Hypertext Markup Language) is specially:
Set up the data-switching template, the data layout and the content that have defined HTML (Hypertext Markup Language) in the described data-switching template are replaced positional information;
According to described data-switching template described object information is carried out content and replace, generating data layout is the object information of HTML (Hypertext Markup Language).
4. data dictionary generation method as claimed in claim 3 is characterized in that,
Described database object is a data table object, and described data table object contains the object additional information;
Describedly according to described data-switching template described object annotation information is carried out content and replaces, comprise after generating data layout and be the object information step of HTML (Hypertext Markup Language):
According to described data-switching template described object additional information is carried out content and replace, generating data layout is the object additional information of HTML (Hypertext Markup Language);
With described data layout is that the object additional information of HTML (Hypertext Markup Language) is embedded in the object information that described data layout is a HTML (Hypertext Markup Language).
5. data dictionary generation method as claimed in claim 1 is characterized in that,
Described tectonic information comprises data dictionary format information, index information and directory information.
6. data dictionary generating apparatus comprises it is characterized in that the memory module of the system view that is used for stored data base, also comprises:
Acquisition module is used for obtaining the object information of the database object in the system view of database of described memory module;
Format converting module is used for the Data Format Transform of carrying out of object information that described acquisition module is obtained, and generating data layout is the object information of HTML (Hypertext Markup Language);
The tectonic information generation module is used to generate the tectonic information of data dictionary;
The data dictionary generation module, it is the data dictionary of e-book form that the object information that is used for data layout that the tectonic information that generates according to described tectonic information generation module and described format converting module generate and is HTML (Hypertext Markup Language) generates data layout.
7. data dictionary generating apparatus as claimed in claim 6 is characterized in that,
The object information of described database object comprises the object annotation information;
Described data dictionary generating apparatus comprises:
Presetting module is used in advance described object annotation information being write described system view.
8. data dictionary generating apparatus as claimed in claim 7 is characterized in that, described format converting module comprises:
Conversion module is set up the unit, is used to set up the data-switching template, and the data layout and the content that have defined HTML (Hypertext Markup Language) in the described data-switching template are replaced positional information;
First content is replaced the unit, is used for setting up data-switching template that the unit generates according to described conversion module and described object information is carried out content replaces, and generating data layout is the object information of HTML (Hypertext Markup Language).
9. data dictionary generating apparatus as claimed in claim 7 is characterized in that,
Described database object is a data table object, and described data table object contains the object additional information;
Described format converting module also comprises:
Second content is replaced the unit, is used for setting up data-switching template that the unit generates according to described conversion module and described object additional information is carried out content replaces, and generating data layout is the object additional information of HTML (Hypertext Markup Language);
Embed the unit, be used for that the object additional information that described second content replacement unit generates is embedded into described first content and replace the object information that the unit generates.
10. data dictionary generating apparatus as claimed in claim 9 is characterized in that, the tectonic information generation module comprises:
The format information generation unit is used to generate the format information of described data dictionary;
The index information generation unit is used to generate the index information of described data dictionary;
The directory information generation unit is used to generate the directory information of described data dictionary.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102137741A CN102096670A (en) | 2009-12-14 | 2009-12-14 | Data dictionary generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009102137741A CN102096670A (en) | 2009-12-14 | 2009-12-14 | Data dictionary generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102096670A true CN102096670A (en) | 2011-06-15 |
Family
ID=44129766
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009102137741A Pending CN102096670A (en) | 2009-12-14 | 2009-12-14 | Data dictionary generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102096670A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104462108A (en) * | 2013-09-17 | 2015-03-25 | 中兴通讯股份有限公司 | Database structure object processing method and device |
| CN105005592A (en) * | 2015-06-29 | 2015-10-28 | 用友优普信息技术有限公司 | Data dictionary generation method and data dictionary generation device |
| CN105278961A (en) * | 2015-10-28 | 2016-01-27 | 广州华多网络科技有限公司 | Method and system for generating database table structure document |
| CN107203525A (en) * | 2016-03-16 | 2017-09-26 | 北大方正集团有限公司 | The treating method and apparatus of database |
| CN110348004A (en) * | 2019-05-23 | 2019-10-18 | 平安科技（深圳）有限公司 | Method, apparatus, electronic equipment and the storage medium that data dictionary generates |
| CN111951488A (en) * | 2020-08-17 | 2020-11-17 | 深圳市丰巢网络技术有限公司 | Structure configuration method and device of intelligent cabinet, computer equipment and storage medium |
| CN111984671A (en) * | 2020-07-27 | 2020-11-24 | 北京天健源达科技股份有限公司 | Method for generating view creating script |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101055578A (en) * | 2006-04-12 | 2007-10-17 | 龙搜（北京）科技有限公司 | File content dredger based on rule |
| US7401286B1 (en) * | 1993-12-02 | 2008-07-15 | Discovery Communications, Inc. | Electronic book electronic links |
-
2009
- 2009-12-14 CN CN2009102137741A patent/CN102096670A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7401286B1 (en) * | 1993-12-02 | 2008-07-15 | Discovery Communications, Inc. | Electronic book electronic links |
| CN101055578A (en) * | 2006-04-12 | 2007-10-17 | 龙搜（北京）科技有限公司 | File content dredger based on rule |
Non-Patent Citations (4)
| Title |
|---|
| 匡景炜: "利用HTML文件模板转换PB6.5数据窗口格式成HTML超文本文件", 《华南金融电脑》 * |
| 匡松: "《中文版Visual Foxpro 6.0入门与提高》", 31 January 2004, 电子科技大学出版社 * |
| 陈菁华等: "《电子商务数据库应用技术》", 28 February 2009, 华中师范大学出版社 * |
| 龚元明等: "数据字典管理系统的设计和实现", 《冶金自动化》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104462108A (en) * | 2013-09-17 | 2015-03-25 | 中兴通讯股份有限公司 | Database structure object processing method and device |
| 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 |
| CN105278961A (en) * | 2015-10-28 | 2016-01-27 | 广州华多网络科技有限公司 | Method and system for generating database table structure document |
| 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 |
| 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 |
| CN111984671A (en) * | 2020-07-27 | 2020-11-24 | 北京天健源达科技股份有限公司 | Method for generating view creating script |
| CN111984671B (en) * | 2020-07-27 | 2023-09-12 | 北京天健源达科技股份有限公司 | Method for generating view script |
| CN111951488A (en) * | 2020-08-17 | 2020-11-17 | 深圳市丰巢网络技术有限公司 | Structure configuration method and device of intelligent cabinet, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102096670A (en) | Data dictionary generation method and device | |
| CN100565524C (en) | A kind of system, method and browser of preserving web page contents | |
| US7913173B2 (en) | Method and apparatus for acquiring data presented within a web browser | |
| US20060156220A1 (en) | System and method for managing dynamic content assembly | |
| CN102349087A (en) | Automatically providing content associated with captured information, such as information captured in real-time | |
| CN103389969A (en) | Method, device and system for previewing PDF (portable document format) file on mobile terminal | |
| CN102662928A (en) | Rich text editing method for importing documents and device thereof | |
| JP3944014B2 (en) | Document editing method, document editing system, and document processing program | |
| EP3444725A1 (en) | Man-machine interaction method and device therefor | |
| CN101316147B (en) | Apparatus and method for presenting multimedia contents on terminal | |
| CN103473234A (en) | Method, device and system for deriving report forms from web inquiring system | |
| CN107943915A (en) | The method and device of OFD file Real time displayings based on HTML5 | |
| US20100306307A1 (en) | System and method for social bookmarking/tagging at a sub-document and concept level | |
| CA2764819A1 (en) | System and method for providing sub-publication content in an electronic device | |
| CN105589959A (en) | Form processing method and form processing system | |
| CN101452468A (en) | Method and system for providing conversation dictionary services based on user created dialog data | |
| WO2007139913A2 (en) | Locating a portion of data on a computer network | |
| CN107562450A (en) | A kind of cross-platform method for visualizing of local chronicle resource | |
| JP2007328750A (en) | Compound document preparing method and registering method to blog | |
| US20080077641A1 (en) | System and method for editing contract clauses in static web pages | |
| CN101145936B (en) | A method and system for adding tags in Web pages | |
| JP2007041983A (en) | Application form creation program and application form creation apparatus | |
| CN104317935A (en) | Method and system for generating HTML (hypertext markup language) pages from XML (extensible markup language) bill files in batches | |
| CN112711404A (en) | Method for generating special topic webpage template once and automatically releasing special topic webpage | |
| CN106156015A (en) | A kind of method and system being checked application use record by calendar |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C53 | Correction of patent of invention or patent application | ||
| CB03 | Change of inventor or designer information |
Inventor after: Yuan Jun Inventor before: He Jinhui |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: INVENTOR; FROM: HE JINHUI TO: YUAN JUN |
|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20160803 |
|
| C20 | Patent right or utility model deemed to be abandoned or is abandoned |