CN105205060A - Method and device for generating word document database dictionary - Google Patents
Method and device for generating word document database dictionary Download PDFInfo
- Publication number
- CN105205060A CN105205060A CN201410258837.6A CN201410258837A CN105205060A CN 105205060 A CN105205060 A CN 105205060A CN 201410258837 A CN201410258837 A CN 201410258837A CN 105205060 A CN105205060 A CN 105205060A
- Authority
- CN
- China
- Prior art keywords
- database
- application system
- business application
- dictionary
- system database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and device for automatically generating a word document database dictionary. The method includes the steps that connection with a service application system database is established, wherein the service application system database comprises the word document database dictionary needing to be updated; a preset sql supporting query of the service application system database is executed to automatically update the database dictionary of the service application system database. By establishing connection with the service application system database of the word document database dictionary needing to be generated and executing the preset sql, the word document database dictionary of the service application system database is automatically updated, and therefore database developers can be freed from the heavy work of synchronizing the word document database dictionary.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of method and the device that generate the database dictionary of word document.
Background technology
For various reasons, database in use needs increase table or carries out list structure change etc., such as, in the R&D process of online education, because demand is many, it is fast to upgrade, often need newly increase table or carry out list structure change, this just makes database design developer write except database script except designing, must the word document of continuous synchronized update database dictionary, task is heavy.If database design developer forgets the word document of synchronized update database dictionary, the structure in the description of the word document in database dictionary and actual database can be caused inconsistent, thus cause unnecessary trouble to service application developer, tester and operation personnel.
Summary of the invention
In view of above-mentioned analysis, the present invention aims to provide a kind of method and the device that generate the database dictionary of word document, in order to solve for newly increasing table or carrying out the situations such as list structure change in prior art, database design developer needs the word document in continuous synchronized update database dictionary and causes increasing the weight of the problem of workload.
For solving the problem, the present invention is mainly achieved through the following technical solutions: one aspect of the present invention provides a kind of method of database dictionary of automatic generation Word document, and the method comprises:
Be connected with business application system Database, in described business application system database, comprise the database dictionary needing to upgrade Word document;
By performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, automatically upgrade the described database dictionary of described business application system database.
Preferably, described connection with business application system Database specifically comprises:
The relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
Preferably, described link information comprises: one or more in the IP address of relational database, port, login username and password.
Preferably, described in described default support, the Structured Query Language (SQL) sql statement of business application system data base querying specifically comprises:
By the database dictionary in the relational database corresponding with described business application system database, write the sql statement of list structure for inquiring about this business application system database and annotation.
Preferably, the described Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support, the described database dictionary automatically upgrading described business application system database specifically comprises:
By performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
Preferably, described business application system database comprises: the software database of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
The present invention additionally provides a kind of device of database dictionary of automatic generation Word document on the other hand, and this device comprises:
Link block, for being connected with business application system Database, comprises the database dictionary needing to upgrade Word document in described business application system database;
Generation module, for the Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support, upgrades the described database dictionary of described business application system database automatically.
Preferably, described link block specifically for, the relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
Preferably, described link information comprises: one or more in the IP address of relational database, port, login username and password.
Preferably, described generation module specifically for, by the database dictionary in the relational database corresponding with described business application system database, writing the sql statement of list structure for inquiring about this business application system database and annotation, automatically upgrading the described database dictionary of described business application system database.
Preferably, described generation module also for, by performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
Preferably, described business application system database comprises: the software database of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
Beneficial effect of the present invention is as follows:
The present invention is by being connected with needing the business application system Database of the database dictionary generating Word document, after performing the sql statement preset, the database dictionary of the Word document of automatic renewal business application system database, database development personnel are freed from the database dictionary heavy labor of synchronous word document, thus efficiently solve in prior art owing to newly increasing table or carrying out the situations such as list structure change, database design developer is made to need the word document of continuous synchronized update database dictionary, increase the weight of the problem of the workload of database design developer.
Other features and advantages of the present invention will be set forth in the following description, and the becoming apparent from instructions of part, or by implementing the present invention and understanding.Object of the present invention and other advantages realize by structure specifically noted in write instructions, claims and accompanying drawing and obtain.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the method for the database dictionary of the automatic generation Word document of the embodiment of the present invention;
Fig. 2 is the process flow diagram that the another kind of the embodiment of the present invention generates the method for the database dictionary of Word document automatically;
Fig. 3 is the structural representation of the device of the database dictionary of the automatic generation Word document of the embodiment of the present invention.
Embodiment
Specifically describe the preferred embodiments of the present invention below in conjunction with accompanying drawing, wherein, accompanying drawing forms the application's part, and together with embodiments of the present invention for explaining principle of the present invention.For purpose of clarity and simplification, when it may make theme of the present invention smudgy, illustrating in detail of known function and structure in device described herein will be omitted.
The fundamental purpose of the embodiment of the present invention is to provide a kind of method and device of database dictionary of automatic generation Word document, by being connected with needing the business application system Database of the database dictionary generating Word document, after performing the sql statement preset, the database dictionary of the Word document of automatic renewal business application system database, enables database development personnel free from the database dictionary heavy labor of synchronous word document.Just by several specific embodiment, technical scheme of the present invention is described in detail below.
Embodiments provide a kind of method of database dictionary of automatic generation Word document, see Fig. 1, comprising:
S101, to be connected with business application system Database, in described business application system database, to comprise the database dictionary needing to upgrade Word document;
S102, by performing Structured Query Language (SQL) (StructuredQueryLanguage, the sql) statement of business application system data base querying described in the support preset, automatically upgrade the described database dictionary of described business application system database.
The present invention is by presetting the sql statement of the database dictionary supporting the inquiry of different business application system database, after being connected with business application system Database, perform corresponding sql statement, then automatically upgrade the database dictionary of the Word document of business application system database, thus database development personnel are freed from the heavy labor of the database dictionary of synchronous word document.
Business application system database in the embodiment of the present invention can be the software database etc. of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
Described connection with business application system Database in the embodiment of the present invention specifically comprises:
The relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
Dissimilar business application system database is divided in dissimilar relational database by the embodiment of the present invention respectively, and in different relational databases, different database dictionaries is set respectively, during use, first corresponding relational database type is selected, in the relational database type selected, select the business application system database needing the database dictionary generating Word document more further, and connect.
Relevant database in the embodiment of the present invention specifically comprises: oracle, mysql, sybase and mssqlserver etc.
Database linkage information in the embodiment of the present invention comprises IP address and the port of relational database, if business application system database is provided with login username and password, then also should be provided with corresponding login username and encrypted message in database linkage information, certain those skilled in the art also can according to the concrete setting of business application system database, other database linkage information is set, to be connected with needing the business application system Database of the database dictionary generating Word document.
Described in described default support in the embodiment of the present invention, the Structured Query Language (SQL) sql statement of business application system data base querying specifically comprises:
By the database dictionary in the relational database corresponding with described business application system database, write the sql statement of list structure for inquiring about this business application system database and annotation.
Because the database dictionary recording mode of different relational databases is different, different relational databases comprises again different business application system databases respectively, and different relational databases has the inquiry sql of oneself, but the resultative construction returned is the same.Therefore need to write corresponding sql to the kinds of relationships database supported is customized, so, the database dictionary of the relational database that utilization of the present invention is corresponding with business application system database writes the sql statement of the list structure and annotation etc. inquiring about this business application system database, and the result that sql is returned, utilize word assembly, write in word document, generate the operation system database dictionary table word document meeting form.
The described Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support in the embodiment of the present invention, the described database dictionary automatically upgrading described business application system database specifically comprises:
By performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
If the sql statement of Non-precondition inquiry annotation, or in this business application system database, there is not the annotation of inquiry, can not annotate in this results set yet.
Fig. 2 is the process flow diagram that the another kind of the embodiment of the present invention generates the method for the database dictionary of Word document automatically, comes that the present invention is described in detail below in conjunction with Fig. 2:
The sql statement of database dictionary of S201, configuration supporting business application system database type and inquiry.
Configuration file content form is as follows: the wherein type of database that expresses support for of bracket, sql statement below represents the sql statement of this business application system wide area information server dictionary of inquiry, question mark in sql is a parameter can importing business application system database name into, can set up business application system DataBase combining after input.
2)[oracle]
The sql statement of inquiry oracle database dictionary;
3)[sybase]
The sql statement of inquiry sybase database dictionary;
4)[mssqlserver]
The sql statement of inquiry mssqlserver database dictionary.
S202, user is at the relational database type (oracle at interface, mysql, sybase, mssqlserver) corresponding relational database is selected in drop-down choice box, system is according to link information (the ip address of the relational database of input, port, login username and password) connect with this relational database, the list that system obtains its business application system database according to the type of relational database returns to interface, user selects the business application system database needing the database dictionary generating word document again, system is connected with this business application system Database,
S203, user click the button generating word document, system now reads the sql query statement of business application system database corresponding inside configuration file, and selected business application system database name is imported into as parameter, after performing this sql, the results set of list structure and annotation can be returned.
The above results set is finally passed through word assembly by S204, system, and write generates database dictionary word document.
S205, user use the database dictionary after renewal.
The embodiment of the present invention additionally provides a kind of device of database dictionary of automatic generation Word document, and see Fig. 3, this device comprises interconnective link block 11 and generation module 12;
Link block 11, for being connected with business application system Database, comprises the database dictionary needing to upgrade Word document in described business application system database;
Generation module 12, for the Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support, upgrades the described database dictionary of described business application system database automatically.
The embodiment of the present invention additionally provides a kind of preferred link block 11, concrete, described link block 11 specifically for, the relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
Described database linkage information in the embodiment of the present invention comprises: one or more in the IP address of relational database, port, login username and password.
Described generation module 12 in the embodiment of the present invention also for, by the database dictionary in the relational database corresponding with described business application system database, write the sql statement of list structure for inquiring about this business application system database and annotation, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
Described business application system database in the embodiment of the present invention comprises: the software database of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
The related content of apparatus of the present invention embodiment is identical with embodiment of the method, specifically can refer to embodiment of the method, does not repeat them here.
The method of the database dictionary of a kind of automatic generation Word document provided by the invention and device, can bring following beneficial effect:
The present invention is by being connected with needing the business application system Database of the database dictionary generating Word document, after performing the sql statement preset, the database dictionary of the Word document of automatic renewal business application system database, enables database development personnel free from the database dictionary heavy labor of synchronous word document.
The above; be only the present invention's preferably embodiment, but protection scope of the present invention is not limited thereto, is anyly familiar with those skilled in the art in the technical scope that the present invention discloses; the change that can expect easily or replacement, all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claims.
Claims (12)
1. automatically generate a method for the database dictionary of Word document, it is characterized in that, comprising:
Be connected with business application system Database, in described business application system database, comprise the database dictionary needing to upgrade Word document;
By performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, automatically upgrade the described database dictionary of described business application system database.
2. method according to claim 1, is characterized in that, described connection with business application system Database specifically comprises:
The relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
3. method according to claim 2, is characterized in that, described link information comprises: one or more in the IP address of relational database, port, login username and password.
4. method according to claim 1, is characterized in that, described in described default support, the Structured Query Language (SQL) sql statement of business application system data base querying specifically comprises:
By the database dictionary in the relational database corresponding with described business application system database, write the sql statement of list structure for inquiring about this business application system database and annotation.
5. method according to claim 1, it is characterized in that, the described Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support, the described database dictionary automatically upgrading described business application system database specifically comprises:
By performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
6., according to the method in claim 1-5 described in any one, it is characterized in that,
Described business application system database comprises: the software database of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
7. automatically generate a device for the database dictionary of Word document, it is characterized in that, comprising:
Link block, for being connected with business application system Database, comprises the database dictionary needing to upgrade Word document in described business application system database;
Generation module, for the Structured Query Language (SQL) sql statement by performing business application system data base querying described in default support, upgrades the described database dictionary of described business application system database automatically.
8. device according to claim 7, is characterized in that,
Described link block specifically for, the relational database corresponding with described business application system database according to link information connects, then is connected with the described business application system Database in described relational database further.
9. device according to claim 8, is characterized in that, described link information comprises: one or more in the IP address of relational database, port, login username and password.
10. device according to claim 7, is characterized in that,
Described generation module specifically for, by the database dictionary in the relational database corresponding with described business application system database, writing the sql statement of list structure for inquiring about this business application system database and annotation, automatically upgrading the described database dictionary of described business application system database.
11. devices according to claim 7, is characterized in that,
Described generation module also for, by performing the Structured Query Language (SQL) sql statement of business application system data base querying described in default support, obtain the described list structure of business application system database and the results set of annotation that inquire, and by described results set by Word assembly, generate the Word document that described business application system database is corresponding, replace corresponding Word document in described database dictionary.
12., according to the device in claim 7-11 described in any one, is characterized in that,
Described business application system database comprises: the software database of online education database, online store database, instant communication data storehouse, social network data storehouse, enterprise management information database and every profession and trade.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410258837.6A CN105205060A (en) | 2014-06-12 | 2014-06-12 | Method and device for generating word document database dictionary |
| PCT/CN2014/086660 WO2015188488A1 (en) | 2014-06-12 | 2014-09-16 | Method and apparatus for generating database dictionary of word documents |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410258837.6A CN105205060A (en) | 2014-06-12 | 2014-06-12 | Method and device for generating word document database dictionary |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105205060A true CN105205060A (en) | 2015-12-30 |
Family
ID=54832795
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410258837.6A Withdrawn CN105205060A (en) | 2014-06-12 | 2014-06-12 | Method and device for generating word document database dictionary |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN105205060A (en) |
| WO (1) | WO2015188488A1 (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111897573A (en) * | 2020-05-28 | 2020-11-06 | 广州市玄武无线科技股份有限公司 | Method, device and equipment for generating database dictionary document and storage medium |
| CN112000690A (en) * | 2020-08-19 | 2020-11-27 | 北京人大金仓信息技术股份有限公司 | Method and device for analyzing structured operation statement |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112416938B (en) * | 2020-11-25 | 2024-02-09 | 深圳集智数字科技有限公司 | Database dictionary generation method, device, equipment and storage medium |
| CN112507011A (en) * | 2020-12-16 | 2021-03-16 | 江苏龙虎网信息科技股份有限公司 | Method for establishing program automation database model |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1222272A (en) * | 1996-06-20 | 1999-07-07 | 瑞典保密公司 | Method and appts. for data processing |
| CN1351299A (en) * | 2000-10-28 | 2002-05-29 | 深圳市中兴通讯股份有限公司 | Method and device for accessing database |
| CN102495832A (en) * | 2011-12-12 | 2012-06-13 | 方正国际软件有限公司 | System for automatically generating document in software development process |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102682035A (en) * | 2011-03-18 | 2012-09-19 | 富泰华工业（深圳）有限公司 | Data management method and system |
| CN102722540B (en) * | 2012-05-23 | 2018-08-17 | 南京中兴新软件有限责任公司 | Data processing method and device in real-time memory database system |
| CN103067483B (en) * | 2012-12-25 | 2017-04-05 | 广东邮电职业技术学院 | Teledata increment synchronization method based on packet |
-
2014
- 2014-06-12 CN CN201410258837.6A patent/CN105205060A/en not_active Withdrawn
- 2014-09-16 WO PCT/CN2014/086660 patent/WO2015188488A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1222272A (en) * | 1996-06-20 | 1999-07-07 | 瑞典保密公司 | Method and appts. for data processing |
| CN1351299A (en) * | 2000-10-28 | 2002-05-29 | 深圳市中兴通讯股份有限公司 | Method and device for accessing database |
| CN102541867A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Data dictionary generating method and system |
| CN102495832A (en) * | 2011-12-12 | 2012-06-13 | 方正国际软件有限公司 | System for automatically generating document in software development process |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111897573A (en) * | 2020-05-28 | 2020-11-06 | 广州市玄武无线科技股份有限公司 | Method, device and equipment for generating database dictionary document and storage medium |
| CN112000690A (en) * | 2020-08-19 | 2020-11-27 | 北京人大金仓信息技术股份有限公司 | Method and device for analyzing structured operation statement |
| CN112000690B (en) * | 2020-08-19 | 2024-03-19 | 北京人大金仓信息技术股份有限公司 | Method and device for analyzing structured operation statement |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2015188488A1 (en) | 2015-12-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111027921B (en) | Service processing method and device, electronic equipment and storage medium | |
| US11514076B2 (en) | Cooperative naming for configuration items in a distributed configuration management database environment | |
| CN110019350B (en) | Data query method and device based on configuration information | |
| US10191736B2 (en) | Systems and methods for tracking configuration file changes | |
| US10216826B2 (en) | Database query system | |
| WO2019134340A1 (en) | Salary calculation method, application server, and computer readable storage medium | |
| CN107480198A (en) | A kind of distributed NewSQL Database Systems and text searching method | |
| JP2021515330A (en) | Data retention handling for data object stores | |
| EP3462315A2 (en) | Systems and methods for service mapping | |
| US10127218B2 (en) | Object templates for data-driven applications | |
| CN108829746B (en) | Main data management system and device based on memory database | |
| US20150269198A1 (en) | Conforming data structure instances to shema versions | |
| KR101212778B1 (en) | Cloud computing based smart office system and server for managing the same and method for managing the same | |
| CN103020064A (en) | Method and configuration for generating query condition in annotation way | |
| EP2842034B1 (en) | Providing client and service compatibility through cloud-hosted adapters | |
| CN109376153B (en) | System and method for writing data into graph database based on NiFi | |
| US11487707B2 (en) | Efficient file path indexing for a content repository | |
| CN112084208A (en) | Data visualization method and system, storage medium and electronic device | |
| US20190108163A1 (en) | Database expansion system, equipment, and method of expanding database | |
| CN111125064B (en) | Method and device for generating database schema definition statement | |
| CN105205060A (en) | Method and device for generating word document database dictionary | |
| CN103914572A (en) | Database construction system, device and method | |
| WO2015171916A1 (en) | System and method for managing data transactions between applications | |
| CN113760948A (en) | Data query method and device | |
| CN108255959A (en) | Data query method and device in a kind of Redis |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20151230 |
|
| WW01 | Invention patent application withdrawn after publication |