CN113239016A - Database design assistance apparatus and method - Google Patents
Database design assistance apparatus and method Download PDFInfo
- Publication number
- CN113239016A CN113239016A CN202110611048.6A CN202110611048A CN113239016A CN 113239016 A CN113239016 A CN 113239016A CN 202110611048 A CN202110611048 A CN 202110611048A CN 113239016 A CN113239016 A CN 113239016A
- Authority
- CN
- China
- Prior art keywords
- database
- page
- characteristic value
- generating
- value table
- 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.)
- Granted
Links
- 238000013461 design Methods 0.000 title claims abstract description 56
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000012360 testing method Methods 0.000 claims abstract description 31
- 238000013515 script Methods 0.000 claims abstract description 25
- 238000004458 analytical method Methods 0.000 claims abstract description 15
- 238000012545 processing Methods 0.000 claims description 8
- 230000008676 import Effects 0.000 claims description 6
- 238000012827 research and development Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 12
- 238000011161 development Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 230000001351 cycling effect Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
Images
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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/10—Requirements analysis; Specification techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a database design auxiliary device and a method, comprising the following steps: a demand analysis module: the system is used for analyzing the requirements of database design, generating a page characteristic value table and generating a JSP page prototype according to the page characteristic value table; the document generation module: generating a database script and a database table structure document according to the page characteristic value table; the database demonstration module: after the database script and the database table structure document are demonstrated, a database entity object is generated; a report generation module: and generating a test case by using the characteristic values in the page characteristic value table, comparing the page characteristic value table, and generating a database completion report. The invention has the following achievements in each stage of the whole software life cycle: the method comprises the steps of generating a demonstration model for a manager in a requirement analysis stage, generating a design module for a framework engineer in a design stage, generating business codes for an engineer in a research and development stage, and generating a test case for the engineer in a test stage.
Description
Technical Field
The invention relates to the field of databases, in particular to a database design assisting device and a database design assisting method.
Background
With the development of science and technology and the increasing pace of social life, the requirements of users on the use of software also become higher. Although the standardization degree of the Chinese software enterprise is continuously promoted, the use of software development auxiliary tools in the development process is increasingly popularized. However, most of the Chinese software enterprises are still in the original development state, so that technical personnel who really understand software engineering technology and management and self-improvement and growth of software consulting technology enterprises are needed. The current source code generation tools do not have full life cycle tracking functions from demand analysis, design, development, testing. For example, the prior art discloses a source code auxiliary generation tool, but only focuses on the development stage, and the generated code does not conform to the coding specification and has no generality. The prior art also discloses a method for generating a service test tool, but the method only focuses on the interface test in the running test stage, and has limitations. In addition, the existing source code generation tools rely on templates more in use, the maintenance amount of the templates is large, the templates are not flexible enough, and only forward generation is performed, so that the source code cannot be generated once the data source templates are wrong.
Disclosure of Invention
In view of the above problems, it is an object of the present invention to provide a database design support apparatus and method with versatility and flexibility.
To achieve the above object, the present invention provides a database design assistance device, including:
a demand analysis module: the system is used for analyzing the requirements of database design, generating a page characteristic value table and generating a JSP page prototype according to the page characteristic value table;
the document generation module: the database script and the database table structure document are generated according to the page characteristic value table;
a research and development module: the database entity object generation system is used for generating a database entity object after demonstrating a database script and a database table structure document;
a report generation module: the method is used for generating a test case by utilizing the characteristic values in the page characteristic value table, comparing the page characteristic value table and generating a database completion report.
The database design support device preferably includes:
a first import module: the standard form document is used for importing the custom made form document;
an acquisition module: the system comprises a standard form file, a document structure and a table structure, wherein the standard form file is used for storing a standard form file;
a creation module: the system is used for creating a list page field and an editing page field according to the record data of the page in the standard form document;
a circulation module: the system comprises an acquisition module, a creation module, a processing module and a display module, wherein the acquisition module and the creation module are used for sequentially processing each page in a standard form document;
a generation module: and the page feature value table is generated according to the table structure, the list page field and the edit page field of each page, and a JSP page prototype is generated according to the page feature value table.
Preferably, the database design assistance device further includes a document generation module that:
a second import module: for importing a customized standard form document;
a compiling module: the basic characteristic value table is compiled according to the page characteristic value table;
a selection module: the system is used for selecting a database and a code naming specification to generate a code characteristic value;
a table structure creation module: and the database script and database table structure document is generated according to the basic characteristic value table and the code characteristic value.
Preferably, the database entity objects in the database demonstration module include: entity files, interface files and implementation mapper files.
The database design assisting device preferably further comprises a testing module: and the automatic testing of the database entity is carried out by checking the missing or forgotten field through a regular expression.
On the other hand, in order to achieve the purpose, the invention adopts the following technical scheme: a database design assisting method comprises the following steps:
s1: analyzing the requirement of the database design, generating a page characteristic value table, and generating a JSP page prototype according to the page characteristic value table;
s2: generating a database script and a database table structure document according to the page characteristic value table;
s3: after the database script and the database table structure document are demonstrated, a database entity object is generated;
s4: and generating a test case by using the characteristic values in the page characteristic value table, and comparing the page characteristic value table to generate a database completion report.
Preferably, the database design assisting method in step S1 specifically includes the following steps:
s11: importing a standard form document customized by a customer;
s12: acquiring a document structure of a certain page in the standard form document and creating a form structure;
s13: creating a list page field and an editing page field according to the record data of the page in the standard form document;
s14: performing the processing of steps S12-S13 for each page in the standard form document in turn;
s15: and generating the page characteristic value table according to the table structure, the list page field and the edit page field of each page, and generating a JSP page prototype according to the page characteristic value table.
In the database design assisting method, preferably, the step S2 specifically includes the following steps:
s21: importing a customized standard form document;
s22: compiling a basic characteristic value table according to the page characteristic value table;
s23: selecting a database and a code naming specification to generate a code characteristic value;
s24: and generating a database script and a database table structure document according to the basic characteristic value table and the code characteristic value.
In the method for assisting database design, preferably, in step S3, the database entity object includes: entity files, interface files and implementation mapper files.
The database design assisting method preferably further includes step S5: and checking the missing or forgotten field through a regular expression, and carrying out automatic test on the database entity.
Due to the adoption of the technical scheme, the invention has the following advantages:
(1) the data source of the reporting system can be verified, and the generated result can be traced. And the verification is made in the stage of demand analysis, and the inspection is made in the stage of running test. And matching degree verification is carried out through the regular expression, so that the quality of the reporting system software is ensured.
(2) And in the requirement analysis stage, a JSP page prototype is generated according to the custom-made form, so that a product manager can conveniently and better perform requirement communication, the customer requirements are thoroughly mined, and the custom-made page characteristic form is enriched. The product manager at the stage can complete the business prototype only by simply arranging the client form, and the time for drawing the business prototype can be saved.
(3) And in the design stage, manufacturing a basic characteristic form according to the customized page characteristic form. The transition process from requirement analysis to design is solved, and the database script and the database document are generated at the same time. This process translates the requirements completely into design. The stage reduces the link of the product manager and the architect, and can save the time for writing documents and generating scripts by a database.
(4) In the research and development stage, the system is used for generating entity objects, including business operation methods of adding, modifying, deleting and inquiring, database operation classes and related SQL statements, so that the development time of programmers is shortened, the generation is accurate, and the debugging time is shortened. This stage reduces programmer repeat code writing and debugging time.
(5) And in the testing stage, a test case and a software completion report are generated, so that the testing of testers is facilitated. The software completion report can evaluate the consistency of the generated service interface and the delivery data source, and can evaluate the consistency of the generated service logic code, the input data and the delivery data source data. The stage saves the time for the testers to compile test cases and click and check the page.
(6) The system generates the system, the business logic code and the business interface completely according to the client form, and simultaneously generates the industry library, and the project framework is not limited by the industry, has very strong adaptability, and can be widely applied to the field of database design.
Drawings
FIG. 1 is a diagram of a database design assistance apparatus of the present invention;
FIG. 2 is a block diagram of a demand analysis module of the present invention;
FIG. 3 is a block diagram of a document creation module of the present invention;
FIG. 4 is a schematic diagram of the steps of the database design assistance method of the present invention;
FIG. 5 is a schematic diagram of the steps of generating an entity file according to the present invention;
FIG. 6 is a schematic diagram of the steps of generating a MyBatis interface file of the present invention;
FIG. 7 is a schematic diagram of the steps of the present invention to generate a MyBatis-implementing mapper file;
FIG. 8 is a schematic diagram of the steps of the present invention for generating a JSP page prototype;
FIG. 9 is a schematic diagram of the steps of the present invention for generating database scripts and database table structure documents.
Description of reference numerals:
1 a demand analysis module; 2, a document generating module;
3, a database demonstration module; 4 report generating module;
5, testing the module;
11, importing a module; 12 an acquisition module;
13 creating a module; 14 a cycle module;
15 generating a module.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the description of the present invention, it should be noted that the terms "upper", "lower", "front", "rear", "inside", "outside", and the like indicate orientations or positional relationships based on those shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the system or element referred to must have a specific orientation, be constructed in a specific orientation, and be operated, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," "third," and the like are used to define elements only for convenience in distinguishing between the elements, and if not otherwise stated, are not to be construed as indicating or implying any relative importance.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
Interpretation of terms:
JSP: java Server Pages; a java server page; a dynamic web page technology standard.
The database design auxiliary device and the database design auxiliary method provided by the embodiment of the invention can achieve the following results in each stage of the whole software life cycle: the method comprises the steps of generating a demonstration model for a product manager in a requirement analysis stage, generating a design module for a framework engineer in a design stage, generating a service code for a research and development engineer in a research and development stage, and generating a test case for a test engineer in a test stage.
As shown in fig. 1, the present invention provides a database design assistance device, including the following:
the demand analysis module 1: the method is used for analyzing the requirements of database design, generating a page characteristic value table K1 and generating a JSP page prototype according to the page characteristic value table K1; in practical application, the requirements of a database which needs to be designed by a client are filled into a standard form document, and the standard form document records the requirements of the client; the standard form document includes an Excel document.
The document generation module 2: the system is used for generating database scripts and database table structure documents according to the page characteristic value table K1;
the basic characteristic value table K0 includes in practical application: glossary, dictionary, english name labels, field types, and field descriptions.
The code characteristic value table K2 includes, in practical applications: serial number, condition value, parameter list and remark list.
The database table structure document comprises in practical application: column name, data type, type length, decimal number, whether primary key, allow null, default, description, and remark column.
Database demonstration module 3: the database entity object generation system is used for generating a database entity object after demonstrating a database script and a database table structure document; entity objects are generated using the field descriptions of the base feature value table K0 and the code feature value table K2, including add, delete, modify, business methods of query, database operation classes, and related SQL statements. Entity objects include Entity (Entity) files, MyBatis interface files, and MyBatis-implementation mapper (xml) files. Finally, JSP code is generated.
The report generation module 4: the method is used for generating a test case by using the characteristic values in the page characteristic value table, such as an input field length, verification of a mandatory field and a boundary value analysis case, and comparing the page characteristic value table to generate a database completion report.
As shown in fig. 2, the database design assistance apparatus, preferably, the requirement analysis module 1 includes:
the first import module 11: the standard form document is used for importing the custom made form document; the standard form document comprises an Excel document.
The acquisition module 12: the method comprises the steps of obtaining a document structure of a certain page in a standard form document and creating a form structure; the document structure includes a field name, a field type, a field length, a primary key, whether null, and a description.
The creation module 13: creating a list page field and an edit page field according to the record data of the page in the standard form document;
the circulation module 14: processing each page in the standard form document in turn by using the acquisition module 12 and the creation module 13;
the generation module 15: the method is used for generating a page characteristic value table K1 according to the table structure, the list page field and the edit page field of each page, and generating a JSP page prototype according to the page characteristic value table K1. By demonstrating the business model, engineers can judge whether the model meets the requirements of customers, if not, the page characteristic value table K1 can be modified, and then the modules are repeatedly utilized until a JSP page prototype meeting the requirements of customers is obtained.
As shown in fig. 3, the database design assistance apparatus is preferably such that the document creation module 2 includes:
a second import module: for importing a customized standard form document;
a compiling module: the basic characteristic value table is compiled according to the page characteristic value table;
a selection module: the system is used for selecting a database and a code naming specification to generate a code characteristic value;
a table structure creation module: and the database script and database table structure document is generated according to the basic characteristic value table and the code characteristic value.
The database design assisting device preferably includes the following database entity objects in the database demonstration module 3: entity files, interface files and implementation mapper files.
The database design aid preferably further comprises a test module 5: the method is used for checking the missing or forgotten fields through the regular expression, and carrying out automatic testing on the database entity.
On the other hand, to achieve the above object, as shown in fig. 4,
the invention adopts the following technical scheme: a database design assisting method comprises the following steps:
s1: analyzing the requirement of database design, generating a page characteristic value table K1, and generating a JSP page prototype according to the page characteristic value table K1;
s2: generating a database script and a database table structure document according to the page characteristic value table K1; the page feature value table K1 in practical applications includes a glossary, a dictionary, english name labels, grammatical features, query conditions, query field control features, edit page display, and original columns. According to the page characteristic value table K1, a basic characteristic value table K0 and a code characteristic value table K2 are generated at the same time. The generation of the database script comprises recording field names, recording field types, recording field lengths, recording main keys, whether the records are empty, recording description and field creation, and then circularly recording until generating a table building end statement. The module compiles a basic characteristic value table K0 according to a page characteristic value table K1, then selects a database, code naming specifications and the like according to business needs, generates a code characteristic value K2, compares the page characteristic value table K1 if the result meets the business review of a client, and generates a database script and a database design document if the page characteristic value table K1 meets the business requirements of the client. If the code characteristic value K2 is not qualified for the business review, the basic characteristic value table K0 is generated again according to the page characteristic value table K1. If the comparison page characteristic value table K1 does not meet the business requirements of the customer, a basic characteristic value table K0 is generated again according to the page characteristic value table K1.
S3: after the database script and the database table structure document are demonstrated, a database entity object is generated;
FIG. 5 is a diagram illustrating the steps of generating an Entity (Entity) file. Sequentially comprises the following steps: analyzing the package name, the class name and the class annotation; creating a project structure file according to the package name and the class name; an entity class reference, class name is created. The cyclic record sequentially comprises the steps of obtaining an attribute name, obtaining an attribute type, obtaining an attribute length, obtaining an attribute description, generating an attribute annotation and generating an attribute code; and circulating the steps and finally generating the entity file.
FIG. 6 is a schematic diagram illustrating the steps of generating a MyBatis interface file. Sequentially comprises the following steps: analyzing the package name and the class name; creating a project homostructured file according to the package name and the class name; creating an entity class reference interface name; creating a method and annotating; cycling through each page in the table document; and finally generating an interface file.
FIG. 7 is a schematic diagram illustrating the steps of generating MyBatis- -implementing a mapper file. Sequentially comprises the following steps: a basic column list splicing (Base _ column _ list), an insertion splicing (insert) method, an insertion splicing macro (insert batch) method, an update splicing (update) method and a query splicing (query) method, wherein the splicing is performed according to an identity query (queryByID) method and the splicing is performed according to an identity delete (deleteByID) method; circulating the above steps; and judging whether the field is the last field, if so, ending the method and ending the file.
S4: and generating a test case by using the characteristic values in the page characteristic value table K1, and comparing the page characteristic value table to generate a database completion report.
As shown in fig. 8, in the database design assisting method, preferably, the step S1 specifically includes the following steps:
s11: importing a standard form document customized by a customer; the standard form document includes various fields that the customer needs to customize, such as: business name, risk point location, risk factor, risk level, and the like.
S12: acquiring a document structure of a certain page in a standard form document and creating a form structure; in practice, a table structure in a database is established by adopting a document structure of a certain page in an Excel table; usually, Excel tables are in row and column format, and the table structure in the database is also in row and column format.
S13: creating a list page field and an edit page field according to the record data of the page in the standard form document; and recording the data recorded in the Excel table into a list page field and an edit page field. The record data comprises field name, field type, field length, primary key and whether the field is null or not.
S14: the processing of steps S12-S13 is performed for each page in the standard form document in turn; each page in the standard form document is subjected to the processing of steps S12-S13.
S15: and generating the page characteristic value table according to the table structure, the list page field and the edit page field of each page, and generating a JSP page prototype according to the page characteristic value table. Each page in a standard table document generates a JSP page.
As shown in fig. 9, in the method for aided design of database design, step S2 preferably includes the following steps:
s21: importing a customized standard form document;
s22: compiling a basic characteristic value table according to the page characteristic value table;
s23: selecting a database and a code naming specification to generate a code characteristic value;
s24: and generating a database script and a database table structure document according to the basic characteristic value table and the code characteristic value.
Preferably, the database entity object in step S3 includes: entity files, interface files and implementation mapper files.
The database design assistance method preferably further includes step S5: and checking the missing or forgotten fields through a regular expression to automatically test the database entity.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A database design assistance device, comprising:
the demand analysis module (1) is used for analyzing the demand of database design, generating a page characteristic value table and generating a JSP page prototype according to the page characteristic value table;
the document generation module (2) is used for generating a database script and a database table structure document according to the generated page characteristic value table;
the database demonstration module (3) is used for demonstrating the generated database script and the database table structure document to generate a database entity object;
and the report generating module (4) is used for generating a test case by using the characteristic values in the page characteristic value table, comparing the page characteristic value table and generating a database completion report.
2. The database design assistance device according to claim 1, characterized in that the requirement analysis module (1) comprises:
a first import module (11) for importing a customized standard form document;
an acquisition module (12) for acquiring a document structure of a certain page in a standard form document and creating a form structure;
a creation module (13) for creating a list page field and an edit page field based on the record data of the page in the standard form document;
the circulation module (14) is used for processing each page in the standard form document in turn by utilizing the acquisition module (12) and the creation module (13);
and the generating module (15) is used for generating a page characteristic value table according to the table structure, the list page field and the edit page field of each page, and generating a JSP page prototype according to the page characteristic value table.
3. The database design assistance device according to claim 1, wherein the document generation module (2) comprises:
a second import module (21) for importing a customized standard form document;
the compiling module (22) is used for compiling a basic characteristic value table according to the page characteristic value table;
the selection module (23) is used for selecting the database and the code naming specification to generate a code characteristic value;
and the table structure creating module (24) is used for generating database scripts and database table structure documents according to the basic characteristic value table and the code characteristic value.
4. The database design assistance device according to claim 1, characterized in that the database entity objects in the database demonstration module (3) comprise: entity files, interface files and implementation mapper files.
5. The database design assistance device according to claim 1, further comprising a test module (5): and performing character matching through the regular expression, checking missing or forgotten fields, and performing automatic test on the database entity.
6. A database design assisting method is characterized by comprising the following steps:
s1: analyzing the requirement of database design, generating a page characteristic value table, and generating a JSP page prototype according to the page characteristic value table;
s2: generating a database script and a database table structure document according to the page characteristic value table;
s3: after the database script and the database table structure document are demonstrated, a database entity object is generated;
s4: and generating a test case by using the characteristic values in the page characteristic value table, comparing the page characteristic value table, and generating a database completion report.
7. The database design assistance method according to claim 6, wherein the step S1 specifically includes the following steps:
s11: importing a pre-customized standard form document;
s12: acquiring a document structure of a certain page in a standard form document and creating a form structure;
s13: creating a list page field and an edit page field according to the record data of the page in the standard form document;
s14: the processing of steps S12-S13 is performed for each page in the standard form document in turn;
s15: and generating a page characteristic value table according to the table structure, the list page field and the edit page field of each page, and generating a JSP page prototype according to the page characteristic value table.
8. The database design assistance method according to claim 6, wherein the step S2 specifically includes the following steps:
s21: importing a pre-customized standard form document;
s22: compiling a basic characteristic value table according to the page characteristic value table;
s23: selecting a database and a code naming specification to generate a code characteristic value;
s24: and generating a database script and a database table structure document according to the basic characteristic value table and the code characteristic value.
9. The database design assistance method according to claim 6, wherein the database entity object in the step S3 includes: entity files, interface files and implementation mapper files.
10. The database design assistance method according to claim 6, further comprising step S5: and performing character matching through a regular expression, checking missing or forgotten fields, and performing automatic test on the database entity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110611048.6A CN113239016B (en) | 2021-06-01 | 2021-06-01 | Database design assistance apparatus and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110611048.6A CN113239016B (en) | 2021-06-01 | 2021-06-01 | Database design assistance apparatus and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113239016A true CN113239016A (en) | 2021-08-10 |
| CN113239016B CN113239016B (en) | 2024-04-02 |
Family
ID=77136252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110611048.6A Active CN113239016B (en) | 2021-06-01 | 2021-06-01 | Database design assistance apparatus and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113239016B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114357916A (en) * | 2022-01-11 | 2022-04-15 | 北京汤谷软件技术有限公司 | Chip FPGA prototype verification method and system |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH09319629A (en) * | 1996-05-27 | 1997-12-12 | Hitachi Ltd | Database design supporting tool |
| WO2004029755A2 (en) * | 2002-09-27 | 2004-04-08 | Enviance, Inc. | Automated report building system |
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| KR20100115048A (en) * | 2009-04-17 | 2010-10-27 | 정원석 | System for distinguishing copy document and method therefor |
| CN102830974A (en) * | 2012-08-13 | 2012-12-19 | 南京莱斯信息技术股份有限公司 | Visual auxiliary development tool for rapid generation of JAVA codes |
| US20160125050A1 (en) * | 2014-10-31 | 2016-05-05 | Beacon Intellectual Property Services, LLC | System and method for generating search reports |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
| CN108595159A (en) * | 2018-05-10 | 2018-09-28 | 天津科技大学 | A kind of method for producing software describing software requirement based on relation table |
| CN108595644A (en) * | 2018-04-26 | 2018-09-28 | 宁波银行股份有限公司 | A kind of big data platform operation management system |
| CN108984620A (en) * | 2018-06-14 | 2018-12-11 | 中国科学院重庆绿色智能技术研究院 | A kind of relevant database and its design method of dynamic scalable |
| CN109542765A (en) * | 2018-10-18 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Database script verification method, device, computer equipment and storage medium |
| EP3495971A1 (en) * | 2017-12-11 | 2019-06-12 | Wipro Limited | Method and device for database design and creation |
| CN111258579A (en) * | 2020-01-14 | 2020-06-09 | 郴州金通信息科技有限公司 | Website development system and method |
| CN112395366A (en) * | 2019-08-19 | 2021-02-23 | 阿里巴巴集团控股有限公司 | Data processing and creating method and device of distributed database and electronic equipment |
| CN112527774A (en) * | 2020-12-18 | 2021-03-19 | 通号智慧城市研究设计院有限公司 | Data center building method and system and storage medium |
| CN112527771A (en) * | 2020-12-12 | 2021-03-19 | 江西洪都航空工业集团有限责任公司 | City management-oriented database design method |
-
2021
- 2021-06-01 CN CN202110611048.6A patent/CN113239016B/en active Active
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH09319629A (en) * | 1996-05-27 | 1997-12-12 | Hitachi Ltd | Database design supporting tool |
| WO2004029755A2 (en) * | 2002-09-27 | 2004-04-08 | Enviance, Inc. | Automated report building system |
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| KR20100115048A (en) * | 2009-04-17 | 2010-10-27 | 정원석 | System for distinguishing copy document and method therefor |
| CN102830974A (en) * | 2012-08-13 | 2012-12-19 | 南京莱斯信息技术股份有限公司 | Visual auxiliary development tool for rapid generation of JAVA codes |
| US20160125050A1 (en) * | 2014-10-31 | 2016-05-05 | Beacon Intellectual Property Services, LLC | System and method for generating search reports |
| CN107357942A (en) * | 2017-09-04 | 2017-11-17 | 山东达创网络科技股份有限公司 | A kind of source code auxiliary Core Generator and its generation method |
| EP3495971A1 (en) * | 2017-12-11 | 2019-06-12 | Wipro Limited | Method and device for database design and creation |
| CN108595644A (en) * | 2018-04-26 | 2018-09-28 | 宁波银行股份有限公司 | A kind of big data platform operation management system |
| CN108595159A (en) * | 2018-05-10 | 2018-09-28 | 天津科技大学 | A kind of method for producing software describing software requirement based on relation table |
| CN108984620A (en) * | 2018-06-14 | 2018-12-11 | 中国科学院重庆绿色智能技术研究院 | A kind of relevant database and its design method of dynamic scalable |
| CN109542765A (en) * | 2018-10-18 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Database script verification method, device, computer equipment and storage medium |
| CN112395366A (en) * | 2019-08-19 | 2021-02-23 | 阿里巴巴集团控股有限公司 | Data processing and creating method and device of distributed database and electronic equipment |
| CN111258579A (en) * | 2020-01-14 | 2020-06-09 | 郴州金通信息科技有限公司 | Website development system and method |
| CN112527771A (en) * | 2020-12-12 | 2021-03-19 | 江西洪都航空工业集团有限责任公司 | City management-oriented database design method |
| CN112527774A (en) * | 2020-12-18 | 2021-03-19 | 通号智慧城市研究设计院有限公司 | Data center building method and system and storage medium |
Non-Patent Citations (4)
| Title |
|---|
| 廖述梅等: "带模板的结构化HTML文档深度标注框架", 《清华大学学报(自然科学版)》, vol. 46, no. 1, 25 June 2006 (2006-06-25) * |
| 徐小凤: "计算机辅助数据库设计的研究", 《中国优秀博硕士学位论文全文数据库 (硕士) 信息科技辑》, 15 March 2005 (2005-03-15) * |
| 李梅等: "一种数据库代码自动生成器的设计", 《太原理工大学学报》, vol. 40, no. 6, 15 November 2009 (2009-11-15) * |
| 罗铁祥: "一个数据库设计工具的功能和结构", 《中南民族学院学报(自然科学版)》, vol. 20, no. 1, 30 March 2001 (2001-03-30) * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114357916A (en) * | 2022-01-11 | 2022-04-15 | 北京汤谷软件技术有限公司 | Chip FPGA prototype verification method and system |
| CN114357916B (en) * | 2022-01-11 | 2023-03-10 | 北京汤谷软件技术有限公司 | Chip FPGA prototype verification method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113239016B (en) | 2024-04-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108805510B (en) | Construction drawing design BIM model compliance auditing method and system | |
| CN109254907B (en) | Java-based interface test report generation method and system | |
| CN110275861B (en) | Data storage method and device, storage medium and electronic device | |
| Mens et al. | Evolving software architecture descriptions of critical systems | |
| US20090198727A1 (en) | Trace-based database schema evolution method and system | |
| CN113065314A (en) | BIOS hardware adaptation method and device based on XML file format | |
| CN111367893A (en) | Method and device for database version iteration | |
| CN111367982B (en) | Method, device, computer equipment and storage medium for importing TRRIGA basic data | |
| CN112506505A (en) | Method for producing program code by code template engine | |
| CN108319466A (en) | A kind of restoration methods and device of configuration information | |
| CN113239016A (en) | Database design assistance apparatus and method | |
| CN109062816A (en) | A kind of method, device and equipment of software test | |
| CN106033338A (en) | Method and device for importing and analyzing source code based on FOG data | |
| CN114385155A (en) | vue project visualization tool generation method, device, equipment and storage medium | |
| CN112051987B (en) | Service data processing method, device and equipment, program generating method and device | |
| CN114218105A (en) | UI automatic regression testing system based on configuration application mode | |
| CN112416367A (en) | Application resource change influence analysis system based on software reverse disassembly and analysis | |
| KR100656559B1 (en) | Program Automatic Generating Tools | |
| CN117874393B (en) | Method and system for constructing SCA model engineering through XML file | |
| CN115145581A (en) | Data mapping method and device, electronic equipment and storage medium | |
| CN118567614A (en) | Energy storage monitoring platform modeling method and system based on Schema mechanism | |
| CN114691767A (en) | Data writing method, system, terminal device and computer readable storage medium | |
| CN118708605A (en) | Method for expanding Oracle ERP query conditions by virtue of Excel | |
| CN117874292A (en) | Message generation method, system, equipment and medium based on database configuration | |
| CN115048109A (en) | Code generation method and device based on metadata |
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 |