CN113127442B - Method, device and storage medium for visualizing data model - Google Patents
Method, device and storage medium for visualizing data model Download PDFInfo
- Publication number
- CN113127442B CN113127442B CN202010026314.4A CN202010026314A CN113127442B CN 113127442 B CN113127442 B CN 113127442B CN 202010026314 A CN202010026314 A CN 202010026314A CN 113127442 B CN113127442 B CN 113127442B
- Authority
- CN
- China
- Prior art keywords
- data model
- application
- html document
- sql
- sql script
- 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.)
- Active
Links
- 238000013499 data model Methods 0.000 title claims abstract description 174
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000003860 storage Methods 0.000 title claims abstract description 21
- 238000013515 script Methods 0.000 claims abstract description 56
- 238000011161 development Methods 0.000 claims abstract description 31
- 230000000007 visual effect Effects 0.000 claims abstract description 10
- 238000004590 computer program Methods 0.000 claims description 13
- 238000010276 construction Methods 0.000 claims description 13
- 230000003068 static effect Effects 0.000 claims description 9
- 238000012800 visualization Methods 0.000 claims description 8
- 230000008569 process Effects 0.000 abstract description 13
- 238000012552 review Methods 0.000 abstract description 8
- 238000009826 distribution Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 8
- 238000007726 management method Methods 0.000 description 8
- 238000013461 design Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 238000004806 packaging method and process Methods 0.000 description 6
- 230000000694 effects Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- VYZAMTAEIAYCRO-UHFFFAOYSA-N Chromium Chemical compound [Cr] VYZAMTAEIAYCRO-UHFFFAOYSA-N 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- G06F16/986—Document structures and storage, e.g. HTML extensions
Abstract
The embodiment of the invention provides a method, a device and a storage medium for visualizing a data model, wherein the method comprises the following steps: acquiring an SQL script of an application; analyzing according to the SQL script to obtain a data model of the application; an HTML document of the data model is generated to provide visual browsing of the data model at any stage of development of the application. According to the embodiment of the invention, the convenience of related personnel for consulting the application software table data model can be greatly improved, and the operation cost is reduced. In the development process of application software, an HTML document of a data model is generated according to SQL scripts. Because the HTML document has the characteristics of easy distribution and being supported by all browsers, a user can easily review the data model information of the application software in a visual mode without installing any additional software and other complex operations, and the efficiency and convenience are greatly improved.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a method and a device for visualizing a data model and a computer readable storage medium.
Background
Software systems widely employ a relational database as a basic service component for data storage, the relational database using a scripting language known as structured query language (Structured Query Language, SQL) to manage the database and perform data access operations, the data in the relational database being stored in units of data tables. The data model refers to a structure of all data tables in a database of a certain software, each data table is composed of 0 to a plurality of data rows and 1 to a plurality of attribute columns, the structure of the data tables is defined by data definition language (Data definition language, DDL) sentences in the SQL language, and the data model comprises names of the data tables, names, types, lengths, default values, constraint conditions, comments and the like of all attribute columns, and information such as a main key, an index definition and the like.
In the related art, a data model is generally managed and referred to using a management interface provided by a database management system or a third party client, for example: the Oracle database system is provided with a management console, a Navicat client and other database management tools. The use of database management tools typically requires management and review on a running database and often requires the installation of corresponding software or clients, which is inconvenient if the address of the database service is not known or the application software is in the design stage where the database has not been deployed.
Referring to fig. 1, the basic flow of developing relational database-based application software is: and designing a data model, converting the data model into an SQL script, storing data into a database by a development application program, installing a database server when the application is deployed, and executing the SQL script to initialize the database. When related personnel want to consult the data model of a certain application software system, the related personnel need to install a database client program (such as Navicat and the like) first, then connect to a database server through a client, and open the database of the application through a client interface to consult the data model of the application.
From this, the following problems exist in the existing scheme of managing and consulting data models: first, it is necessary to install the database server software at the deployment stage, initialize the database table structure, and visually review the data model after installing the database client software, i.e. the dependency condition is relatively large. Second, the data model must be consulted by connecting to the running database server through the installed database client, such as if the database is not deployed during the design phase or if the user does not know the address of the database server, the data model cannot be reviewed.
Disclosure of Invention
An object of the embodiments of the present invention is to provide a method, an apparatus, and a storage medium for visualizing a data model, which solve the problem that the existing steps of managing and referring to the data model are complicated, and the working efficiency is affected.
In a first aspect, an embodiment of the present invention provides a method for visualizing a data model, including:
acquiring a Structured Query Language (SQL) script of an application;
analyzing according to the SQL script to obtain a data model of the application;
a hypertext markup language (HTML) document of the data model is generated to provide a visual navigation of the data model at any stage of development of the application.
Optionally, after generating the HTML document of the data model, the method further includes:
and publishing the HTML document when the program package of the application is published, and/or uploading the HTML document to a Web server for a browser to open or access the HTML document.
Optionally, the parsing according to the SQL script obtains a data model of the application, which specifically includes:
and analyzing the SQL script by using an SQL analyzer to obtain a data model of the application, wherein the data model comprises table structure metadata information.
In a second aspect, an embodiment of the present invention further provides a method for visualizing a data model, including:
acquiring a Structured Query Language (SQL) script of an applied data model;
generating a hypertext markup language (HTML) document of the data model according to the SQL script;
issuing an HTML document of a program package of the application and a data model of the application; alternatively, the HTML document for the data model is uploaded to a Web server.
Optionally, the generating the HTML document of the data model according to the SQL script includes:
and generating the HTML document of the data model by the SQL script through a plug-in a construction tool.
Optionally, the generating, by the plug-in the building tool, the HTML document of the data model according to the SQL script includes:
analyzing the SQL script by using an SQL analyzer through a plug-in the construction tool to obtain table structure metadata information of the data model;
generating static HTML codes according to the metadata information;
and generating an HTML document of the data model according to the static HTML code, wherein the information of the data model is displayed in a table form in the HTML document.
Optionally, the acquiring the SQL script of the data model of the application includes:
and establishing development engineering of the application, wherein the development engineering of the application comprises SQL scripts of a data model of the application.
In a third aspect, an embodiment of the present invention further provides an apparatus for visualizing a data model, including: a processor, a memory and a program stored on the memory and executable on the processor, which when executed by the processor implements the steps of a method comprising data model visualization as described in the first or second aspect.
In a fourth aspect, embodiments of the present invention also provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of a method comprising data model visualization according to the first or second aspect.
According to the embodiment of the invention, the convenience of related personnel for consulting the application software table data model can be greatly improved, and the operation cost is reduced. In the development process of application software, an HTML document of a data model is generated according to SQL scripts. Because the HTML document has the characteristics of easy distribution and being supported by all browsers, a user can easily review the data model information of the application software in a visual mode without installing any additional software and other complex operations, and the efficiency and convenience are greatly improved.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:
FIG. 1 is a flow chart of a prior art development of relational database based application software;
FIG. 2 is a flow chart of a method of visualizing a data model in accordance with an embodiment of the present invention;
FIG. 3 is a flow chart of a method of visualizing a data model in accordance with an embodiment of the present invention;
FIG. 4 is a flow chart of developing relational database based application software in accordance with an embodiment of the present invention;
FIG. 5 is a flow chart of developing a relational database based financial system in accordance with an embodiment of the present invention;
FIG. 6 is one of the device diagrams for visualizing the data model according to an embodiment of the present invention;
FIG. 7 is a second schematic diagram of a device for visualizing a data model according to an embodiment of the invention.
Detailed Description
In order to facilitate understanding of the embodiments of the present invention, the following technical terms are introduced.
(1) Data Model (Data Model): the storage structure of data of a certain application in a database.
(2) Database: software that stores data, such as: oracle, mySQL, etc. are the more mainstream relational database systems, which generally comprise two parts, a server and a client.
(3) Data table: a table in the relational database is used to store the data.
(4) SQL: the relational database is used to access data and manage a language used by the database.
(5) Apache Maven: a software package relies on management and construction tools to support a variety of rich plug-ins (including custom plug-ins).
(6) Java: a software programming language.
(7) HTML: hypertext markup language, web pages written using HTML can be opened by various browsers.
(8) And (3) a browser: such as microsoft IE, firefox Firfox, google Chrome, etc.
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus. Furthermore, the use of "and/or" in the specification and claims means at least one of the connected objects, e.g., a and/or B, meaning that it includes a single a, a single B, and that there are three cases of a and B.
In embodiments of the invention, words such as "exemplary" or "such as" are used to mean serving as an example, instance, or illustration. Any embodiment or design described herein as "exemplary" or "e.g." in an embodiment should not be taken as preferred or advantageous over other embodiments or designs. Rather, the use of words such as "exemplary" or "such as" is intended to present related concepts in a concrete fashion.
Referring to fig. 2, an embodiment of the present invention provides a method for visualizing a data model, where an execution subject of the method may be a plug-in a build tool, such as a Maven plug-in tool, including: step 201, step 202 and step 203.
Step 201: acquiring a Structured Query Language (SQL) script of an application;
step 202: analyzing according to the SQL script to obtain a data model of the application;
in some embodiments, the SQL script is parsed with a SQL parser to obtain a data model of the application, wherein the data model includes table structure metadata information.
Step 203: a hypertext markup language (Hyper Text Markup Language, HTML) document of the data model is generated to provide visual navigation through the data model at any stage of development of the application.
Optionally, after the generating the HTML document of the data model, the method shown in fig. 2 further includes:
and publishing the HTML document when the program package of the application is published, and/or uploading the HTML document to a Web server for a browser to open or access the HTML document.
According to the embodiment of the invention, the convenience of related personnel for consulting the application software table data model can be greatly improved, and the operation cost is reduced. In the development process of application software, an HTML document of a data model is generated according to SQL scripts. Because the HTML document has the characteristics of easy distribution and being supported by all browsers, a user can easily review the data model information of the application software in a visual mode without installing any additional software and other complex operations, and the efficiency and convenience are greatly improved.
Referring to fig. 3, an embodiment of the present invention provides a method for visualizing a data model, the method comprising: step 301, step 302, step 303 and step 304.
Step 301: acquiring an SQL script of the applied data model, and then executing step 302;
for example, after the data model design is completed, a development stage is entered, and a development project of the application is established, wherein the development project of the application comprises SQL scripts of the data model of the application.
Step 302: generating an HTML document of the data model according to the SQL script, and then executing step 303 or step 304;
when packaging is built by a build tool, the SQL script is generated into an HTML document of the data model by a plug-in (e.g., maven plug-in) in the build tool. The HTML document of the data model can be automatically generated by constructing and packaging plug-ins, and the process is independent of the deployment of applications and databases and independent of other development activities such as code writing, testing and the like.
For example, the plug-in may be written in Java, and the working principle of the plug-in is: analyzing the SQL script through an SQL analyzer to obtain table structure metadata information (such as table names, all column names, column attributes and the like) of the data model; generating static HTML codes according to the metadata information; and generating an HTML document of the data model according to the static HTML code, wherein the information of the data model is displayed in a table form in the HTML document.
Step 303: issuing an HTML document of a program package of the application and a data model of the application;
for example, a package of the application is published, where the package of the application includes: an HTML document of the data model; that is, the HTML document of the generated data model is published along with the package of the application through the publishing process. In the embodiment of the invention, the application package and the application data model can be issued at the same time, so that the application data model can be associated with the version number of the application package. When the user needs to know the data model corresponding to the appointed version number of a certain application, the corresponding data model can be queried according to the appointed version number, and the user can manage the data model according to the version number.
Step 304: and uploading the HTML document of the data model to a Web server.
For example, the HTML document of the data model is uploaded to the Web server through a preset tool. The preset tool may be scp, ftp, jenkins in this embodiment. After the HTML document of the data model is uploaded to the Web server, the HTML document can be opened by all the browsers, and the browsers are application software commonly existing on personal computers, so that a user can easily read the applied data model without installing any additional software, websites of the Web server can be easily distributed to other users, and the operation cost is greatly reduced especially for non-technical users.
In some implementations, the HTML document of the data model in the Web server can be accessed by the user by: opening an HTML document of the data model in the program package through a browser; alternatively, the HTML document of the data model in the Web server is accessed through a browser.
According to the embodiment of the invention, the convenience of related personnel for consulting the application software table data model can be greatly improved, and the operation cost is reduced. In the development process of application software, an HTML document of a data model is generated according to SQL scripts. Because the HTML document has the characteristics of easy distribution and being supported by all browsers, a user can easily review the data model information of the application software in a visual mode without installing any additional software and other complex operations, and the efficiency and convenience are greatly improved.
Referring to fig. 4, a flow of developing relational database based application software is schematically illustrated, comprising:
step 1: entering a development stage after finishing the design of the data model, and establishing an application development project, wherein the project comprises an SQL script of the data model.
Step 2: and constructing a packaging development project by using Apache Maven.
Step 3: and generating an HTML document of the data model according to the SQL script through a pre-developed custom Maven plugin.
The custom Maven plug-in is written in Java language, and the working principle is that an SQL parser is used for parsing an input SQL script to obtain table structure metadata information (including table names, all column names, column attributes and the like), static HTML codes are generated according to the metadata information and written into an output file, and data model information is displayed in a table form in the HTML file.
Step 4: the HTML document of the automatically generated data model is uploaded to a Web server or published with a package.
Step 5: a user can review the visualized data model by opening an HTML document of the data model in the program package or a webpage address on a Web server through a browser.
In the embodiment of the invention, the development project containing the SQL script of the data model is established in the application development stage, and the HTML document of the data model can be automatically generated by constructing and packaging the custom maven plug-in, and the process does not depend on the deployment of the application and the database or other development activities such as code writing, testing and the like. The HTML document of the generated data model may be published with the package or automatically uploaded to the Web server at daily build time. Because the HTML document can be opened by the browser, and the browser is the application software commonly existing on the personal computer, a user can easily read the data model information of the application without installing any additional software, and Web addresses can also be easily distributed to other users, especially to non-technical users, so that the operation cost is greatly reduced.
The following takes the development of a relational database based financial system as an example.
The data model of the accounting system comprises hundreds of data tables, each table structure comprises tens to hundreds of attribute columns, and development, maintenance and management personnel of the accounting system often need to consult the data model information in daily work, and sometimes introduce the data model to business personnel.
In a conventional manner, to visually refer to the information of the data model of the accounting system, a database client software (such as Navicat) is installed on a personal computer, then the database client software is connected to a server where the database of the accounting system is deployed, and a browsing interface of the database is opened by the client to view the data model. First, the complexity and cost of this series of operations is high, and it is difficult for non-technical users. Second, there must be an address and account number of the accounting system database server, and if the server address is not known or the account number is not accessed, it cannot be referred to. Finally, the data model cannot be associated with the software version number of the accounting system, and the data model corresponding to a certain appointed version of the accounting system cannot be conveniently consulted.
Referring to FIG. 5, a flow of developing a relational database based financial system is illustrated.
Step 1: and adding the SQL script of the accounting data model to the engineering directory.
The accounting system is an existing software project, and the design stage and development engineering construction are completed when the data model visualization scheme of the invention is used. The example directly starts from the code engineering of the accounting system and adds the accounting data model SQL script to the engineering directory.
Step 2: and adding the custom Maven plug-in into the construction flow of the accounting code engineering.
Step 3: under the engineering directory, executing the Maven construction packaging operation, and automatically generating an HTML document of the data model by the custom Maven plugin according to the SQL script.
Step 4: issuing the generated HTML document of the data model along with the program package through an issuing flow; the HTML document of the data model is uploaded to the Web server through a daily build flow.
Step 5: and the user can visually consult the data model of the accounting system by opening the website of the Web server through a browser or opening the HTML file with the table structure of the program package.
Compared with the traditional method, the data model visualization technology can effectively improve the convenience of consulting the accounting system data model by different roles.
According to the embodiment of the invention, the convenience of related personnel for consulting the application software table data model can be greatly improved, and the operation cost is reduced. In the development process of application software, by introducing a custom plug-in into a construction tool, the plug-in generates an HTML document of a data model according to an SQL script when constructing packaging, and the process is automatically performed. Because the HTML document has the characteristics of easy distribution and being supported by all browsers, a user can easily review the data model information of the application software in a visual mode without installing any additional software and other complex operations, and the efficiency and convenience are greatly improved.
Referring to fig. 6, an embodiment of the present invention provides an apparatus for visualizing a data model, the apparatus 600 comprising:
a first obtaining module 601, configured to obtain a structured query language SQL script of an application;
the parsing module 602 is configured to parse the SQL script to obtain a data model of the application;
a first generation module 603 is configured to generate a hypertext markup language HTML document of the data model to provide visual browsing of the data model at any stage of development of the application.
In some embodiments, the apparatus 600 further comprises:
and the first issuing module is used for issuing the HTML document when the program package of the application is issued and/or uploading the HTML document to a Web server so as to enable a browser to open or access the HTML document.
In some implementations, the parsing module 602 is further to: and analyzing the SQL script by using an SQL analyzer to obtain a data model of the application, wherein the data model comprises table structure metadata information.
The device for visualizing a data model according to the embodiment of the present invention may execute the method embodiment shown in fig. 2, and its implementation principle and technical effects are similar, and this embodiment will not be described herein.
Referring to fig. 7, an embodiment of the present invention further provides an apparatus for visualizing a data model, where the apparatus 700 includes:
a second obtaining module 701, configured to obtain a structured query language SQL script of a data model of an application;
a second generating module 702, configured to generate a hypertext markup language HTML document of the data model according to the SQL script;
a second publishing module 703 for publishing HTML documents of the package of the application and the data model of the application; alternatively, the HTML document for the data model is uploaded to a Web server.
In some embodiments, the second generating module 702 is further configured to: when the package is constructed by the construction tool, the SQL script is used for generating an HTML document of the data model by a plug-in the construction tool.
In some embodiments, the second generating module 702 is further configured to: analyzing the SQL script by using an SQL analyzer through a plug-in the construction tool to obtain table structure metadata information of the data model; generating static HTML codes according to the metadata information; and generating an HTML document of the data model according to the static HTML code, wherein the information of the data model is displayed in a table form in the HTML document.
In some embodiments, the second acquisition module 701 is further to: and establishing development engineering of the application, wherein the development engineering of the application comprises SQL scripts of a data model of the application.
In some implementations, the second publishing module 703 is further to: and issuing a program package of the application, wherein the program package of the application comprises the following components: HTML documents of the data model. Alternatively, the HTML document of the data model is uploaded to the Web server through a build flow.
The device for visualizing a data model according to the embodiment of the present invention may execute the method embodiment shown in fig. 3, and its implementation principle and technical effects are similar, and this embodiment will not be described herein.
The embodiment of the invention also provides a device for visualizing the data model, which comprises: a processor, a memory and a program stored on the memory and executable on the processor, which when executed by the processor performs the steps of a method comprising data model visualization as described in fig. 2 or fig. 3.
The embodiment of the present invention further provides a computer readable storage medium, on which a computer program is stored, where the computer program when executed by a processor implements each process including the method embodiment of data model visualization as described in fig. 2 or fig. 3, and the same technical effects can be achieved, and for avoiding repetition, a detailed description is omitted herein. Wherein the computer readable storage medium is selected from Read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic disk or optical disk.
The steps of a method or algorithm described in connection with the present disclosure may be embodied in hardware, or may be embodied in software instructions executed by a processor. The software instructions may be comprised of corresponding software modules that may be stored in RAM, flash memory, ROM, EPROM, EEPROM, registers, hard disk, a removable disk, a read-only optical disk, or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an ASIC. In addition, the ASIC may be carried in a core network interface device. The processor and the storage medium may reside as discrete components in a core network interface device.
Those skilled in the art will appreciate that in one or more of the examples described above, the functions described in the present invention may be implemented in hardware, software, firmware, or any combination thereof. When implemented in software, these functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
The foregoing embodiments have been provided for the purpose of illustrating the general principles of the present invention in further detail, and are not to be construed as limiting the scope of the invention, but are merely intended to cover any modifications, equivalents, improvements, etc. based on the teachings of the invention.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the invention may take the form of a computer program product on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various modifications and variations can be made to the embodiments of the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the embodiments of the present invention fall within the scope of the claims and the equivalents thereof, the present invention is also intended to include such modifications and variations.
Claims (6)
1. A method for visualizing a data model, applied to a plug-in a construction tool, comprising:
acquiring a Structured Query Language (SQL) script of an application;
analyzing according to the SQL script to obtain a data model of the application;
generating a hypertext markup language (HTML) document of the data model, wherein the HTML document presents data model information in a form of a table so as to provide visual browsing of the data model in any development stage of the application;
the parsing according to the SQL script to obtain the data model of the application comprises the following steps:
and analyzing the SQL script by using an SQL analyzer to obtain a data model of the application, wherein the data model comprises table structure metadata information, and the table structure metadata information comprises table names, all column names and column attributes.
2. The method of claim 1, wherein after generating the HTML document for the data model, further comprising:
and publishing the HTML document when the program package of the application is published, and/or uploading the HTML document to a Web server for a browser to open or access the HTML document.
3. A method of visualizing a data model, comprising:
acquiring an SQL script of an applied data model;
generating an HTML document of the data model according to the SQL script;
issuing an HTML document of a program package of the application and a data model of the application; or uploading the HTML document of the data model to a Web server;
the generating the HTML document of the data model according to the SQL script comprises the following steps:
generating an HTML document of the data model by the SQL script through a plug-in a construction tool;
the generating, by the plugin in the build tool, an HTML document of the data model according to the SQL script includes:
analyzing the SQL script by using an SQL analyzer through a plug-in the construction tool to obtain table structure metadata information of the data model, wherein the table structure metadata information comprises table names, all column names and column attributes;
generating static HTML codes according to the metadata information;
and generating an HTML document of the data model according to the static HTML code, wherein the information of the data model is displayed in a table form in the HTML document.
4. A method according to claim 3, wherein the obtaining the SQL script of the data model of the application comprises:
and establishing development engineering of the application, wherein the development engineering of the application comprises SQL scripts of a data model of the application.
5. An apparatus for visualizing a data model, comprising:
a processor, a memory and a program stored on the memory and executable on the processor, which when executed by the processor performs the steps of a method comprising data model visualization according to any of claims 1 to 2; alternatively, the method of visualizing a data model as in any of claims 3 to 4.
6. A computer-readable storage medium, on which a computer program is stored, which computer program, when being executed by a processor, carries out the steps of a method comprising data model visualization according to any of claims 1 to 2; alternatively, the method of visualizing a data model as in any of claims 3 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010026314.4A CN113127442B (en) | 2020-01-10 | 2020-01-10 | Method, device and storage medium for visualizing data model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010026314.4A CN113127442B (en) | 2020-01-10 | 2020-01-10 | Method, device and storage medium for visualizing data model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113127442A CN113127442A (en) | 2021-07-16 |
| CN113127442B true CN113127442B (en) | 2023-12-22 |
Family
ID=76771076
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010026314.4A Active CN113127442B (en) | 2020-01-10 | 2020-01-10 | Method, device and storage medium for visualizing data model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113127442B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113467774B (en) * | 2021-07-30 | 2024-01-30 | 北京鼎普科技股份有限公司 | WEB terminal business software development framework and method |
| CN117234466B (en) * | 2023-08-07 | 2024-02-23 | 北京冠群信息技术股份有限公司 | Enterprise management software development method, system, equipment and storage medium |
Citations (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546260A (en) * | 2008-03-28 | 2009-09-30 | 国际商业机器公司 | Method and device thereof for reconstructing service-oriented applications |
| CN101946257A (en) * | 2007-12-20 | 2011-01-12 | 惠普开发有限公司 | Modelling computer based business process and simulating operation |
| CN103714129A (en) * | 2013-12-12 | 2014-04-09 | 用友软件股份有限公司 | Device and method for buildingg dynamic data structures and relationships based on condition rules |
| CN104111828A (en) * | 2013-04-22 | 2014-10-22 | 易保网络技术(上海)有限公司 | Automatic generation method and system of human-computer interaction interface |
| CN104933239A (en) * | 2015-06-09 | 2015-09-23 | 江苏大学 | Hybrid model based personalized position information recommendation system and realization method therefor |
| CN105302575A (en) * | 2015-11-19 | 2016-02-03 | 中国移动通信集团广东有限公司汕头分公司 | Foundational development framework |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN106154865A (en) * | 2016-07-01 | 2016-11-23 | 中国汽车技术研究中心 | A kind of vehicle bus phantom self-generating method and system |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN106951305A (en) * | 2017-03-24 | 2017-07-14 | 南京大学 | It is a kind of based on method of the model conversion by QVT R language generation midCore scripts |
| CN107368346A (en) * | 2017-07-06 | 2017-11-21 | 万惠投资管理有限公司 | A kind of code generating method and device based on metadata and script engine |
| AU2018101217A4 (en) * | 2018-08-23 | 2018-09-27 | Dixon, Rohan MR | This is a web-based Ebay style auction site, but in 'reverse'. Members of the public log in, submit their current service and price, and allow competing suppliers to bid against each other, each bid being lower than the previous. |
| CN108595610A (en) * | 2018-04-20 | 2018-09-28 | 中国计量大学 | A kind of electri forklift operating mode visualization system based on Internet of Things |
| CN108804503A (en) * | 2018-04-12 | 2018-11-13 | 北京明朝万达科技股份有限公司 | A kind of online method for previewing of document and system |
| CN108804400A (en) * | 2018-06-13 | 2018-11-13 | 深圳市轱辘汽车维修技术有限公司 | A kind of electronic document processing method, device and relevant device |
| CN109542438A (en) * | 2018-11-19 | 2019-03-29 | 成都淞幸科技有限责任公司 | One kind being based on visual chart development approach |
| CN110020834A (en) * | 2019-04-15 | 2019-07-16 | 浩鲸云计算科技股份有限公司 | A kind of on-line intelligence big data development approach of modeling and debugging fusion |
| CN110058846A (en) * | 2019-04-19 | 2019-07-26 | 深圳市康拓普信息技术有限公司 | A kind of service application software development system and method |
| CN110245270A (en) * | 2019-05-09 | 2019-09-17 | 重庆天蓬网络有限公司 | Data genetic connection storage method, system, medium and equipment based on graph model |
| CN110399698A (en) * | 2019-08-06 | 2019-11-01 | 北京理工大学 | A kind of visualization conceptual design method of modularization spacecraft |
| CN110941422A (en) * | 2019-11-21 | 2020-03-31 | 山东鲁能软件技术有限公司 | Code automatic generation method, code generator and readable storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020087416A1 (en) * | 2000-04-24 | 2002-07-04 | Knutson Roger C. | System and method for providing learning material |
| US20170310927A1 (en) * | 2016-04-26 | 2017-10-26 | Raketu Communications, Inc. | System And Method For Determining And Overlaying Emotion Animation On Calls |
| IL259201B (en) * | 2017-05-10 | 2021-12-01 | Checkmarx Ltd | Using the same query language for static and dynamic application security testing tools |
-
2020
- 2020-01-10 CN CN202010026314.4A patent/CN113127442B/en active Active
Patent Citations (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101946257A (en) * | 2007-12-20 | 2011-01-12 | 惠普开发有限公司 | Modelling computer based business process and simulating operation |
| CN101546260A (en) * | 2008-03-28 | 2009-09-30 | 国际商业机器公司 | Method and device thereof for reconstructing service-oriented applications |
| CN104111828A (en) * | 2013-04-22 | 2014-10-22 | 易保网络技术(上海)有限公司 | Automatic generation method and system of human-computer interaction interface |
| CN103714129A (en) * | 2013-12-12 | 2014-04-09 | 用友软件股份有限公司 | Device and method for buildingg dynamic data structures and relationships based on condition rules |
| CN104933239A (en) * | 2015-06-09 | 2015-09-23 | 江苏大学 | Hybrid model based personalized position information recommendation system and realization method therefor |
| CN105302575A (en) * | 2015-11-19 | 2016-02-03 | 中国移动通信集团广东有限公司汕头分公司 | Foundational development framework |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN106154865A (en) * | 2016-07-01 | 2016-11-23 | 中国汽车技术研究中心 | A kind of vehicle bus phantom self-generating method and system |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
| CN106951305A (en) * | 2017-03-24 | 2017-07-14 | 南京大学 | It is a kind of based on method of the model conversion by QVT R language generation midCore scripts |
| CN107368346A (en) * | 2017-07-06 | 2017-11-21 | 万惠投资管理有限公司 | A kind of code generating method and device based on metadata and script engine |
| CN108804503A (en) * | 2018-04-12 | 2018-11-13 | 北京明朝万达科技股份有限公司 | A kind of online method for previewing of document and system |
| CN108595610A (en) * | 2018-04-20 | 2018-09-28 | 中国计量大学 | A kind of electri forklift operating mode visualization system based on Internet of Things |
| CN108804400A (en) * | 2018-06-13 | 2018-11-13 | 深圳市轱辘汽车维修技术有限公司 | A kind of electronic document processing method, device and relevant device |
| AU2018101217A4 (en) * | 2018-08-23 | 2018-09-27 | Dixon, Rohan MR | This is a web-based Ebay style auction site, but in 'reverse'. Members of the public log in, submit their current service and price, and allow competing suppliers to bid against each other, each bid being lower than the previous. |
| CN109542438A (en) * | 2018-11-19 | 2019-03-29 | 成都淞幸科技有限责任公司 | One kind being based on visual chart development approach |
| CN110020834A (en) * | 2019-04-15 | 2019-07-16 | 浩鲸云计算科技股份有限公司 | A kind of on-line intelligence big data development approach of modeling and debugging fusion |
| CN110058846A (en) * | 2019-04-19 | 2019-07-26 | 深圳市康拓普信息技术有限公司 | A kind of service application software development system and method |
| CN110245270A (en) * | 2019-05-09 | 2019-09-17 | 重庆天蓬网络有限公司 | Data genetic connection storage method, system, medium and equipment based on graph model |
| CN110399698A (en) * | 2019-08-06 | 2019-11-01 | 北京理工大学 | A kind of visualization conceptual design method of modularization spacecraft |
| CN110941422A (en) * | 2019-11-21 | 2020-03-31 | 山东鲁能软件技术有限公司 | Code automatic generation method, code generator and readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 《基于网页的可视化网络医学影像平台设计》;向俊等;《生物医学工程学杂志。;233-238 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113127442A (en) | 2021-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11036933B2 (en) | User interface component autowiring | |
| KR100661393B1 (en) | Web site management system and method applying web programming environment | |
| US20170102925A1 (en) | Automatch process and system for software development kit for application programming interface | |
| US8683315B2 (en) | System and method for creating integrated web form and database applications | |
| US9361297B2 (en) | Web service-based, data binding abstraction method | |
| US20060015839A1 (en) | Development of software systems | |
| US20140052760A1 (en) | System and method for creating, managing, and reusing schema type definitions in services oriented architecture services, grouped in the form of libraries | |
| US9514115B2 (en) | Method for creating form validation program and corresponding form interface according to result set metadata | |
| US20070282616A1 (en) | Systems and methods for providing template based output management | |
| CN108268525A (en) | A kind of report implementation method and device based on Excel template | |
| CN113127442B (en) | Method, device and storage medium for visualizing data model | |
| US20120158416A1 (en) | Web-service based generation of business objects | |
| CN101968817A (en) | Method for configuring webpage template | |
| Krishnan et al. | Google cloud dataflow | |
| Smelter et al. | A Python library for FAIRer access and deposition to the Metabolomics Workbench Data Repository | |
| Gaspar et al. | Mastering Flask Web Development: Build Enterprise-grade, Scalable Python Web Applications | |
| Martins et al. | A web portal for the certification of open source software | |
| Nen et al. | Pigeon-table: A quick prototyping tool using twitter bootstraps and AngularJS for data-driven web application development | |
| Anderson | Modeling and analysis of SQL queries in PHP systems | |
| Lin et al. | Test case minimization for regression testing of composite service based on modification impact analysis | |
| Ragupathi | Learning ASP. NET Core MVC Programming | |
| Sánchez et al. | Extraction and reconstruction of enterprise models | |
| Sklyarov | The Web service development with React, GraphQL and Apollo | |
| Johansson | The One Spider To Rule Them All: Web Scraping Simplified: Improving Analyst Productivity and Reducing Development Time with A Generalized Spider | |
| Stenroos | Headless WordPress development with React using Gatsby. js |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |