WO2015188488A1

WO2015188488A1 - Method and apparatus for generating database dictionary of word documents

Info

Publication number: WO2015188488A1
Application number: PCT/CN2014/086660
Authority: WO
Inventors: 姜志强; 孙放宽
Original assignee: 中兴通讯股份有限公司
Priority date: 2014-06-12
Filing date: 2014-09-16
Publication date: 2015-12-17
Also published as: CN105205060A

Abstract

Disclosed are a method and apparatus for generating a database dictionary of Word documents, the method comprising: establishing a connection with a service application system database comprising a database dictionary in which Word documents need to be updated (S101), and then automatically updating the database dictionary of the service application system database by executing preset structured query language sql statements supporting query for the service application system database (S102). A connection with the service application system database requiring generation of the database dictionary of Word documents is established and then the database dictionary of Word documents in the service application system database is automatically updated by executing preset sql statements, so that database developers can be relieved from laborious work of synchronization of the database dictionary of Word documents.

Description

Method and device for generating database dictionary of word document

Technical field

The present invention relates to the field of computer technologies, and in particular, to a method and apparatus for generating a database dictionary of a word document.

Background technique

For various reasons, the database needs to add tables or change the table structure during use. For example, in the development process of online education, due to the high demand and rapid upgrade, it is often necessary to add a new table or change the table structure, which makes In addition to designing and writing database scripts, database design developers must constantly update the word dictionary of the database dictionary, which is a arduous task. Moreover, if the database design developer forgets to synchronously update the word document of the database dictionary, the description of the word document in the database dictionary is inconsistent with the structure in the actual database, thereby causing unnecessary trouble to the business application developers, testers and operators. .

Summary of the invention

In view of the above analysis, the present invention aims to provide a method and a device for generating a database dictionary of a word document, which are used to solve the situation in the prior art for newly adding a table or changing a table structure, and the database design developer needs to continuously update and update. The word document in the database dictionary causes an increase in the workload.

In order to solve the above problem, the embodiment of the present invention is mainly implemented by the following technical solutions: The embodiment of the present invention provides a method for automatically generating a database dictionary of a Word document, and the method includes:

Establishing a connection with the business application system database, where the business application system database includes a database dictionary that needs to update the Word document;

The database dictionary of the business application system database is automatically updated by executing a preset structured query language sql statement supporting the business application system database query.

Preferably, the establishing a connection with the business application system database specifically includes:

And connecting to the relational database corresponding to the business application system database according to the connection information, and further establishing a connection with the business application system database in the relational database.

Preferably, the connection information includes one or more of an IP address, a port, a login user name, and a password of the relational database.

Preferably, the preset structured query language sql statement supporting the business application system database query specifically includes:

The sql statement for querying the table structure and the annotation of the business application system database is written by the database dictionary in the relational database corresponding to the business application system database.

Preferably, the automatically updating the database dictionary of the business application system database by executing a preset structured query language sql statement that supports the query of the business application system database includes:

Obtaining a table set of the queryed business application system database and a result set of the annotation by executing a preset structured query language sql statement supporting the business application system database query, and collecting the result set through the Word component. Generating a Word document corresponding to the business application system database, and replacing the corresponding Word document in the database dictionary.

Preferably, the business application system database comprises: an online education database, an online shopping mall database, an instant messaging database, a social network database, an enterprise management information database, and a software database of various industries.

Another embodiment of the present invention further provides an apparatus for automatically generating a database dictionary of a Word document, the apparatus comprising:

a connection module, configured to establish a connection with a business application system database, where the business application system database includes a database dictionary that needs to update a Word document;

And a generating module, configured to automatically update the database dictionary of the business application system database by executing a preset structured query language sql statement supporting the business application system database query.

Preferably, the connection module is configured to connect with a relational database corresponding to the business application system database according to the connection information, and further establish a connection with the business application system database in the relational database.

Preferably, the generating module is configured to: write, by using a database dictionary in a relational database corresponding to the business application system database, a SQL statement for querying a table structure and a comment of the business application system database, and automatically updating the The database dictionary of the business application system database.

Preferably, the generating module is further configured to obtain, by executing a preset structured query language sql statement that supports the query of the business application system database, obtaining a table structure of the queryed business application system database and a result set of the annotation And collecting the result through the Word component, generating a Word document corresponding to the business application system database, and replacing the corresponding Word document in the database dictionary.

The beneficial effects of the embodiments of the present invention are as follows:

The embodiment of the invention establishes a connection with the business application system database of the database dictionary that needs to generate the Word document, and automatically updates the database dictionary of the Word document of the business application system database after executing the preset SQL statement, so that the database developer can synchronize the word from the database. The database dictionary of the document is freed from labor, which effectively solves the problem of the new design of the table or the change of the table structure in the prior art, so that the database design developer needs to continuously update the word dictionary of the database dictionary, and the database design developer is aggravated. The problem of the workload.

Other features and advantages of the invention will be set forth in the description in the description which follows. The objectives and other advantages of the invention may be realized and obtained by means of the structure particularly pointed in the appended claims.

DRAWINGS

1 is a flowchart of a method for automatically generating a database dictionary of a Word document according to an embodiment of the present invention;

2 is a flowchart of another method for automatically generating a database dictionary of a Word document according to an embodiment of the present invention;

FIG. 3 is a schematic structural diagram of an apparatus for automatically generating a database dictionary of a Word document according to an embodiment of the present invention.

detailed description

The preferred embodiments of the present invention are described in detail below with reference to the accompanying drawings, in which FIG. For the sake of clarity and simplicity, detailed descriptions of known functions and structures in the devices described herein will be omitted when they may obscure the subject matter of the present invention.

The main object of the embodiments of the present invention is to provide a method and a device for automatically generating a database dictionary of a Word document, and establishing a connection with a business application system database of a database dictionary that needs to generate a Word document. After the default SQL statement, the database dictionary of the Word document of the business application system database is automatically updated, so that the database developer can be freed from the laborious work of the database dictionary of the synchronous word document. The technical solutions of the present invention will be described in detail below through several specific embodiments.

An embodiment of the present invention provides a method for automatically generating a database dictionary of a Word document. Referring to FIG. 1, the method includes:

S101: Establish a connection with a business application system database, where the business application system database includes a database dictionary that needs to update a Word document;

S102. Automatically update the database dictionary of the business application system database by executing a preset Structured Query Language (sql) statement that supports the business application system database query.

By presetting the sql statement supporting the database dictionary of different business application system database query, the invention executes the corresponding sql statement after establishing the connection with the business application system database, and then automatically updates the database dictionary of the Word document of the business application system database, thereby Enables database developers to free themselves from the tedious work of synchronizing word documents into database dictionaries.

The business application system database in the embodiment of the present invention may be an online education database, an online shopping mall database, an instant messaging database, a social network database, an enterprise management information database, a software database of various industries, and the like.

The establishing the connection with the business application system database in the embodiment of the present invention specifically includes:

In the embodiment of the present invention, different types of business application system databases are respectively divided into different types of relational databases, and different database databases are set in different relational databases, and when used, the corresponding relational database types are first selected, and then further In the selected relational database type, select the business application system database that needs to generate the database dictionary of the Word document, and connect.

The relational database in the embodiment of the present invention specifically includes: oracle, mysql, sybase, and ms sql server.

The database connection information in the embodiment of the present invention includes the IP address and port of the relational database. If the business application system database has a login user name and password, the database connection information should also have a corresponding login user name and password information, of course, the field. The technical staff can also be based on the specific settings of the business application system database. To set up other database connection information to establish a connection with the business application system database of the database dictionary that needs to generate the Word document.

The preset structured query language sql statement supporting the query of the business application system database in the embodiment of the present invention specifically includes:

Because the database dictionary records of different relational databases are different, different relational databases respectively include different business application system databases, and different relational databases have their own query sql, but the returned result structure is the same. Therefore, it is necessary to tailor the corresponding sql to the supported relational databases. Therefore, the present invention uses the database dictionary of the relational database corresponding to the business application system database to write a table structure and annotations for querying the business application system database. The statement, and the result returned by sql, using the word component, writes to the word document, and generates a business system database dictionary table word document that satisfies the format.

In the embodiment of the present invention, the database dictionary that automatically updates the business application system database by executing a preset structured query language sql statement that supports the query of the business application system database includes:

If there is no sql statement that presets the query comment, or there is no comment for the query in the business application system database, there is no comment in the result set.

2 is a flow chart of another method for automatically generating a database dictionary of a Word document according to an embodiment of the present invention. The present invention will be described in detail below with reference to FIG. 2:

S201: Configuring a SQL statement supporting a business application system database type and a query database dictionary.

The format of the configuration file is as follows: the brackets indicate the supported database type, and the following sql statement indicates the sql statement of the database dictionary that queries the business application system database. The question mark in sql is a parameter that can be passed to the name of the business application system database. After entering, you can establish a business application system database connection.

1)[mysql]

2)[oracle]

Query the sql statement of the oracle database dictionary;

3) [sybase]

Query the sql statement of the Sybase database dictionary;

4) [mssqlserver]

Query the sql statement of the ms sql server database dictionary.

S202: The user selects a corresponding relational database in the relational database type (oracle, mysql, sybase, ms sql server) drop-down selection box of the interface, and the system according to the input relational database connection information (ip address, port, login user name and password) Establishing a connection with the relational database, the system obtains a list of its business application system database according to the type of the relational database and returns it to the interface, and the user selects a business application system database of the database dictionary that needs to generate the word document, and the system establishes with the business application system database. connection;

S203: The user clicks a button for generating a word document, and the system reads the sql query statement of the corresponding business application system database in the configuration file, and inputs the selected business application system database name as a parameter, and after executing the sql, Returns a collection of results for the table structure and comments.

S204. The system finally writes the above result set through the word component, and writes the generated database dictionary word document.

S205. The user uses the updated database dictionary.

The embodiment of the present invention further provides an apparatus for automatically generating a database dictionary of a Word document. Referring to FIG. 3, the apparatus includes a connection module 11 and a generation module 12 connected to each other;

The connection module 11 is configured to establish a connection with the business application system database, where the business application system database includes a database dictionary that needs to update the Word document;

The generating module 12 is configured to automatically update the database dictionary of the business application system database by executing a preset structured query language sql statement supporting the business application system database query.

The embodiment of the present invention further provides a preferred connection module 11. Specifically, the connection module 11 is specifically configured to connect with a relational database corresponding to the business application system database according to the connection information, and further relate to the relationship. The business application system database in the database establishes a connection.

The database connection information in the embodiment of the present invention includes one or more of an IP address, a port, a login user name, and a password of the relational database.

The generating module 12 in the embodiment of the present invention is further configured to: write, by using a database dictionary in a relational database corresponding to the business application system database, a sql statement for querying a table structure and a comment of the business application system database. Obtaining the table structure of the queryed business application system database and the result set of the annotation, and collecting the result set through the Word component to generate a Word document corresponding to the business application system database, replacing the corresponding corresponding in the database dictionary Word document.

The business application system database in the embodiment of the present invention includes: an online education database, an online mall database, an instant messaging database, a social network database, an enterprise management information database, and a software database of various industries.

The related content of the device embodiment of the present invention is the same as the method embodiment, and the method embodiment is specifically referred to, and details are not described herein again.

The method and device for automatically generating a database dictionary of a Word document provided by the embodiments of the present invention can bring the following beneficial effects:

The embodiment of the invention establishes a connection with the business application system database of the database dictionary that needs to generate the Word document, and automatically updates the database dictionary of the Word document of the business application system database after executing the preset SQL statement, so that the database developer can synchronize the word from the database. The database dictionary of documents is freed from heavy labor.

The above is only a preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily think of changes or within the technical scope disclosed by the present invention. Alternatives are intended to be covered by the scope of the present invention. Therefore, the scope of the invention should be determined by the scope of the claims.

Industrial applicability

Claims

A method for automatically generating a database dictionary of a Word document, comprising:

Establishing a connection with the business application system database, where the business application system database includes a database dictionary that needs to update the Word document;

The database dictionary of the business application system database is automatically updated by executing a preset structured query language sql statement supporting the business application system database query.
The method of claim 1, wherein the establishing a connection with the business application system database specifically comprises:

And connecting to the relational database corresponding to the business application system database according to the connection information, and further establishing a connection with the business application system database in the relational database.
The method of claim 2, wherein the connection information comprises one or more of an IP address, a port, a login user name, and a password of the relational database.
The method according to claim 1, wherein the predetermined structured query language sql statement supporting the business application system database query specifically comprises:

The sql statement for querying the table structure and the annotation of the business application system database is written by the database dictionary in the relational database corresponding to the business application system database.
The method according to claim 1, wherein the automatically updating the database dictionary of the business application system database by executing a predetermined structured query language sql statement that supports the business application system database query comprises:

Obtaining a table set of the queryed business application system database and a result set of the annotation by executing a preset structured query language sql statement supporting the business application system database query, and collecting the result set through the Word component. Generating a Word document corresponding to the business application system database, and replacing the corresponding Word document in the database dictionary.
A method according to any one of claims 1 to 5, wherein

The business application system database includes: an online education database, an online shopping mall database, an instant messaging database, a social network database, an enterprise management information database, and a software database of various industries.
A device for automatically generating a database dictionary of a Word document, comprising:

a connection module, configured to establish a connection with a business application system database, where the business application system database includes a database dictionary that needs to update a Word document;

And a generating module, configured to automatically update the database dictionary of the business application system database by executing a preset structured query language sql statement supporting the business application system database query.
The apparatus according to claim 7, wherein

The connection module is configured to connect with a relational database corresponding to the business application system database according to the connection information, and further establish a connection with the business application system database in the relational database.
The apparatus of claim 8, wherein the connection information comprises one or more of an IP address, a port, a login user name, and a password of a relational database.
The apparatus according to claim 7, wherein

The generating module is configured to, by using a database dictionary in a relational database corresponding to the business application system database, write a sql statement for querying a table structure and a comment of the business application system database, and automatically updating the business application system. The database dictionary of the database.
The apparatus according to claim 7, wherein

The generating module is further configured to: obtain, by using a preset structured query language sql statement that supports the query of the business application system database, obtain a table set of the queryed business application system database and a result set of the annotation, and The result set is generated by the Word component, and the Word document corresponding to the business application system database is generated, and the corresponding Word document in the database dictionary is replaced.
A device according to any one of claims 7-11, wherein

The business application system database includes: an online education database, an online shopping mall database, an instant messaging database, a social network database, an enterprise management information database, and a software database of various industries.