CN113239016B - Database design assistance apparatus and method - Google Patents
Database design assistance apparatus and method Download PDFInfo
- Publication number
- CN113239016B CN113239016B CN202110611048.6A CN202110611048A CN113239016B CN 113239016 B CN113239016 B CN 113239016B CN 202110611048 A CN202110611048 A CN 202110611048A CN 113239016 B CN113239016 B CN 113239016B
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 52
- 238000013461 design Methods 0.000 title claims abstract description 50
- 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 16
- 230000014509 gene expression Effects 0.000 claims description 7
- 238000012545 processing Methods 0.000 claims description 6
- 238000012827 research and development Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 12
- 238000011161 development Methods 0.000 description 5
- 230000008676 import Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 230000001351 cycling effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000033764 rhythmic process Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000007704 transition Effects 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
-
- 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
Abstract
The invention relates to a database design auxiliary device and a method, comprising the following steps: the demand analysis module: the method comprises the steps of 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; a document generation module: generating a database script and a database table structure document according to the page characteristic value table; database demonstration module: after the database script and the database table structure document are demonstrated, generating a database entity object; a report generation module: and generating a test case by utilizing the characteristic values in the page characteristic value table, and comparing the page characteristic value table to generate a database completion report. The invention has the following results at each stage of the full life cycle of the software: a demonstration model can be generated for a manager in a demand analysis stage, a design module can be generated for an architect in a design stage, a business code can be generated for an engineer in a research and development stage, and a test case can be generated for the engineer in a test stage.
Description
Technical Field
The invention relates to the field of databases, in particular to a database design auxiliary device and a database design auxiliary method.
Background
Along with the development of technology and the increasing of social life rhythm, the requirements of users for software use are also becoming high. Although the standardization level of the chinese software enterprises is continuously increasing, the use of software development auxiliary tools in the development process is also becoming popular. However, most of the chinese software enterprises still exist in the original development state, so that the technicians who actually understand the software engineering technology and management and the self-improvement and growth of the software consultation technology enterprises are still needed. Current source code generation tools do not have full life cycle tracking functionality from demand analysis, design, development, testing. For example, the prior art discloses a source code auxiliary generation tool, but only focuses on the research and development stage, and the generated code does not conform to the coding specification and has no universality. The prior art also discloses a method for generating a service test tool, but only focuses on the interface test in the operation test stage, and has limitations. In addition, the existing source code generation tool depends on templates more in use, the maintenance amount of the templates is large, the templates are not flexible enough, the generation can only be forward, and the source code cannot be generated once the data source templates are wrong.
Disclosure of Invention
In view of the foregoing, it is an object of the present invention to provide a database design assistance apparatus and method with versatility and flexibility.
In order to achieve the above object, the present invention provides a database design assisting apparatus, comprising:
the demand analysis module: the method comprises the steps of 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;
a document generation module: the method comprises the steps of generating a database script and a database table structure document according to a page characteristic value table;
and a research and development module: the method comprises the steps of generating a database entity object after carrying out demonstration on a database script and a database table structure document;
a report generation module: and the method is used for generating a test case by utilizing the characteristic values in the page characteristic value table, and comparing the page characteristic value table to generate a database completion report.
The database design assistance device, preferably, the requirement analysis module includes:
a first import module: for importing a custom-made standard form document;
the acquisition module is used for: the method comprises the steps of obtaining a document structure of a certain page in the standard table document and creating a table structure;
the creation module: the method comprises the steps of creating a list page field and an edit page field according to record data of the page in the standard table document;
and (3) a circulation module: the system comprises an acquisition module and a creation module, wherein the acquisition module is used for acquiring a standard form document;
the generation module is used for: and the JSP page prototype is generated according to the page characteristic value table.
The database design assistance device, preferably, the document generation module includes:
and a second import module: for importing customized standard form documents;
and (3) a compiling module: the method comprises the steps of compiling a basic characteristic value table according to a page characteristic value table;
and a selection module: generating code feature values for selecting the database and the code naming convention;
a table structure creation module: for generating database scripts and database table structured documents from the base characteristic value table and the code characteristic values.
Preferably, the database entity object in the database demonstration module includes: entity files, interface files, and implementation mapper files.
The database design auxiliary device preferably further comprises a test module: the method is used for checking missing or forgotten fields through regular expressions and performing automatic testing on the database entity.
On the other hand, in order to achieve the above object, the present invention adopts the following technical scheme: a database design assistance method, comprising the steps of:
s1: analyzing the requirements 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 utilizing the characteristic values in the page characteristic value table, and comparing the page characteristic value table to generate a database completion report.
In the database design assistance method, preferably, the 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 table document and creating a table structure;
s13: creating a list page field and an edit page field according to the record data of the page in the standard table document;
s14: sequentially carrying out the processing of steps S12-S13 on each page in the standard table document;
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.
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 database design assistance method, 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 missing or forgotten fields through regular expressions, and performing automatic testing 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. Verification is done during the demand analysis phase and verification is done during the run test phase. 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 demand analysis stage, a JSP page prototype is generated according to the customer customization form, so that a product manager can conveniently and well conduct demand communication, customer demands are thoroughly mined, and the customization page feature form is enriched. The manager of the product can complete the business prototype by simply arranging the client form, and the time for drawing the business prototype can be saved.
(3) And in the design stage, a basic feature table is manufactured according to the custom page feature table. The transition process from demand 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 a design. The stage reduces the abutting link of a product manager and a 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 utilized to generate entity objects, including business operation methods of adding, modifying, deleting and inquiring, database operation classes and related SQL sentences, so that the development time of programmers is shortened, the generation is accurate, and the debugging time is shortened. This stage reduces the repeated code writing and debugging time for the programmer.
(5) And in the test stage, a test case and a software completion report are generated, so that the test is convenient for a tester. The software completion report can evaluate the consistency of the generated business interface and the reporting data source, and can evaluate the consistency of the generated business logic code, the input data and the reporting data source data. The test case and the page click checking time written by the tester are saved.
(6) The system generates the system, generates the business logic code and the business interface according to the client form, generates the industry library, has strong adaptability, and can be widely applied to the field of database design, wherein the project framework is not limited by the industry.
Drawings
FIG. 1 is a block diagram of a database design assistance apparatus of the present invention;
FIG. 2 is a schematic 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 illustrating steps of a database design assistance method of the present invention;
FIG. 5 is a schematic diagram illustrating steps for generating an entity file according to the present invention;
FIG. 6 is a schematic diagram of steps for generating a MyBatis interface file in accordance with the present invention;
FIG. 7 is a schematic diagram of steps for generating MyBatis-implementation mapper files in accordance with the present invention;
FIG. 8 is a schematic diagram of the steps of generating a JSP page prototype of the present invention;
FIG. 9 is a schematic diagram of the steps of generating a database script and database table structural document of the present invention.
Reference numerals illustrate:
1. a demand analysis module; 2, a document generation module;
3. a database demonstration module; 4, a report generating module;
5. a test module;
11. an import module; 12, an acquisition module;
13. creating a module; 14 a circulation module;
15. and 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 will be apparent that the described embodiments 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.
In the description of the present invention, it should be noted that the positional or positional relationship indicated by the terms such as "upper", "lower", "front", "rear", "inner", "outer", etc. are based on the positional or positional relationship shown in the drawings, are merely for convenience of describing the present invention and simplifying the description, and do not indicate or imply that the system or element referred to must have a specific orientation, be configured and operated in a specific orientation, and thus should not be construed as limiting the present invention. Moreover, the use of the terms first, second, third, etc. to define elements is merely for convenience in distinguishing the elements from each other, and the terms have no special meaning unless otherwise specified, and should not be construed as indicating or implying any particular importance.
In the description of the present invention, it should be noted that, unless explicitly specified and limited otherwise, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be either fixedly connected, detachably connected, or integrally connected, for example; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present invention will be understood in specific cases by those of ordinary skill in the art.
Term interpretation:
JSP: java Server Pages; a java server page; a dynamic webpage technical standard.
The database design auxiliary device and the method provided by the embodiment of the invention can realize the achievement in each stage of the full life cycle of software: a demonstration model can be generated for a product manager in a demand analysis stage, a design module can be generated for an architect in a design stage, a service code can be generated for a research and development engineer in a research and development stage, and a test case can be generated for a test engineer in a test stage.
As shown in fig. 1, the present invention provides a database design assisting apparatus, comprising:
demand analysis module 1: the method comprises the steps of 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 is required to be designed by a customer are filled into a standard form document, and the standard form document records the requirements of the customer; the standard form document includes an Excel document.
Document generation module 2: the method comprises the steps of generating a database script and a database table structure document according to a page characteristic value table K1;
the basic characteristic value table K0 includes, in practical applications: glossary, dictionary, english name label, field type, and field description.
The code feature value table K2 includes in practical application: sequence number, condition value, parameter list and remark column.
The database table structure document includes in practical application: column name, data type, type length, decimal number, whether primary key, allowed null, default, description, and remark column.
Database demonstration module 3: the method comprises the steps of generating a database entity object after carrying out demonstration on a database script and a database table structure document; the field description of the basic eigenvalue table K0 and the code eigenvalue table K2 are utilized to generate entity objects, including business methods of adding, deleting, modifying and inquiring, database operation classes and related SQL sentences. The Entity objects include Entity (Entity) files, myBatis interface files, and MyBatis-implementation mapper (xml) files. And finally generating JSP codes.
Report generation module 4: the method is used for generating test cases by utilizing the characteristic values in the page characteristic value table, such as input field length, checking of necessary filling fields and boundary value analysis cases, and generating a database completion report by comparing the page characteristic value table.
As shown in fig. 2, the database design assistance device, preferably, the demand analysis module 1 includes:
the first import module 11: for importing a custom-made standard form document; the standard form document comprises an Excel document.
Acquisition module 12: the method comprises the steps of obtaining a document structure of a certain page in a standard table document and creating a table structure; the document structure includes a field name, a field type, a field length, a primary key, whether empty, and a description.
Creation module 13: creating a list page field and an edit page field according to the record data of the page in the standard table document;
the circulation module 14: for processing each page in the standard form document in turn by the acquisition module 12 and the creation module 13;
the generation module 15: the method comprises the steps of generating a page characteristic value table K1 according to a table structure, a list page field and an edit page field of each page, and generating a JSP page prototype according to the page characteristic value table K1. Through the demonstration service model, engineers can judge whether the model meets the requirements of clients, if not, the page characteristic value table K1 can be modified, and then the modules are repeatedly utilized until the JSP page prototype meeting the requirements of clients is obtained.
As shown in fig. 3, the database design assistance device shown, preferably, the document generation module 2 includes:
and a second import module: for importing customized standard form documents;
and (3) a compiling module: the method comprises the steps of compiling a basic characteristic value table according to a page characteristic value table;
and a selection module: generating code feature values for selecting the database and the code naming convention;
a table structure creation module: for generating database scripts and database table structured documents from the base characteristic value table and the code characteristic values.
The database design assistance device preferably includes the database entity object 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 missing or forgotten fields through regular expressions and performing automatic testing on database entities.
On the other hand, to achieve the above object, as shown in fig. 4,
the invention adopts the following technical scheme: a database design assistance method, comprising the steps of:
s1: analyzing the design requirement of the database, 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 characteristic value table K1 in practical application comprises a glossary, a dictionary, english name labels, grammar characteristics, query conditions, query area control characteristics, 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 includes record field name, record field type, record field length, record primary key, whether the record is empty, record description and creation field, and then looping the record until the build end statement is generated. The module compiles a basic characteristic value table K0 according to the page characteristic value table K1, then selects a database, a code naming standard and the like according to service requirements, generates a code characteristic value K2, compares the page characteristic value table K1 if the result accords with the service review of a client, and generates a database script and a database design document if the page characteristic value table K1 accords with the service requirements of the client. If the code characteristic value K2 does not accord with 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 requirement of the client, the 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, generating a database entity object;
fig. 5 is a diagram showing steps for generating an Entity (Entity) file. The method 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 and class name are created. The circulation record sequentially comprises an acquisition attribute name, an acquisition attribute type, a length, an acquisition attribute description, an generation attribute annotation and an generation attribute code; and circulating the steps to finally generate the entity file.
FIG. 6 is a schematic diagram showing steps for generating a MyBatis interface file. The method sequentially comprises the following steps: analyzing the package name and the class name; creating a project common structure file according to the package name and the class name; creating an entity class reference interface name; creating a method and an annotation; cycling each page in the form document; and finally generating an interface file.
FIG. 7 is a schematic diagram illustrating steps for generating MyBatis-implementation mapper files. The method sequentially comprises the following steps: a base_column_list (base_column_list), a splice insert (insert) method, a splice insert macro (insert batch) method, a splice update (update) method, a splice query (query) method, a splice according to identity query (queryByID) method, and a splice according to identity delete (deleteByID) method; circulating the above; and judging whether the field is the last field, and if so, ending the method and ending the file.
S4: and generating a test case by utilizing 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, the database design assistance method preferably includes the following steps in step S1:
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 factors, risk level, etc.
S12: acquiring a document structure of a certain page in a standard table document and creating a table structure; in practice, a document structure of a certain page in an Excel table is adopted to establish a table structure in a database; typically, an Excel table is in a row and column format, and then the table structure in the database is also in a 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 table document; the data record recorded in the Excel table is recorded into a list page field and an edit page field. The record data includes field name, field type, field length, primary key, whether null or not.
S14: sequentially carrying out the processing of steps S12-S13 on each page in the standard form document; 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 form document generates a JSP page.
As shown in fig. 9, the database design aided design method preferably includes the following steps in step S2:
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 missing or forgotten fields through regular expressions, and performing automatic testing on the database entity.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (6)
1. A database design assistance apparatus, 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 carrying out demonstration on the generated database script and the database table structure document to generate a database entity object;
the report generating module (4) 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 demand analysis module (1) comprises:
a first importing module (11) for importing customized standard form documents;
an acquisition module (12) for acquiring a document structure of a certain page in the standard table document and creating a table structure;
a creation module (13) for creating a list page field and an edit page field from the record data of the page in the standard form document;
a circulation module (14) for 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) 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;
the document generation module (2) includes:
a second importing module (21) for importing customized standard form documents;
the compiling module (22) is used for compiling a basic characteristic value table according to the page characteristic value table;
a selection module (23) for selecting a database and a code naming convention to generate a code feature value;
a table structure creation module (24) for generating database scripts and database table structure documents from the base characteristic value table and the code characteristic values.
2. The database design assistance device according to claim 1, wherein the database entity object in the database discourse module (3) comprises: entity files, interface files, and implementation mapper files.
3. 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.
4. A database design assistance method, comprising the steps of:
s1: 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;
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, generating a database entity object;
s4: 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 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 table document and creating a table structure;
s13: creating a list page field and an edit page field according to the record data of the page in the standard table document;
s14: sequentially carrying out the processing of steps S12-S13 on each page in the standard form document;
s15: 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;
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.
5. The database design assistance method according to claim 4, wherein the database entity object in step S3 includes: entity files, interface files, and implementation mapper files.
6. The database design assistance method according to claim 4, further comprising step S5: character matching is carried out through the regular expression, missing or forgotten fields are checked, and automatic testing is carried out 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 CN113239016A (en) | 2021-08-10 |
| CN113239016B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114357916B (en) * | 2022-01-11 | 2023-03-10 | 北京汤谷软件技术有限公司 | Chip FPGA prototype verification method and system |
Citations (15)
| 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 |
| 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 |
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160125050A1 (en) * | 2014-10-31 | 2016-05-05 | Beacon Intellectual Property Services, LLC | System and method for generating search reports |
-
2021
- 2021-06-01 CN CN202110611048.6A patent/CN113239016B/en active Active
Patent Citations (15)
| 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 |
| 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 |
|---|
| 一个数据库设计工具的功能和结构;罗铁祥;《中南民族学院学报(自然科学版)》;20010330;第20卷(第1期);全文 * |
| 一种数据库代码自动生成器的设计;李梅等;《太原理工大学学报》;20091115;第40卷(第6期);全文 * |
| 带模板的结构化HTML文档深度标注框架;廖述梅等;《清华大学学报(自然科学版)》;20060625;第46卷(第S1期);全文 * |
| 计算机辅助数据库设计的研究;徐小凤;《中国优秀博硕士学位论文全文数据库 (硕士) 信息科技辑》;20050315;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113239016A (en) | 2021-08-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106445536B (en) | Automatic business design management system | |
| CN111309313A (en) | Method for quickly generating HTML (hypertext markup language) and storing form data | |
| CN111078555B (en) | Test file generation method, system, server and storage medium | |
| CN110955410B (en) | Code automatic generation method, device, equipment and medium | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN110609826A (en) | Data extraction method | |
| CN111309317A (en) | Code automation method and device for realizing data visualization | |
| CN113239016B (en) | Database design assistance apparatus and method | |
| CN112506505A (en) | Method for producing program code by code template engine | |
| CN116661756A (en) | Object analysis method and device based on low-code DSL | |
| CN114238527A (en) | Data processing method and data processing device based on object relation mapping | |
| CN111124380A (en) | Front-end code generation method | |
| CN113297831A (en) | Method and system for generating verifiable report webpage by Excel | |
| CN112506488A (en) | Method for generating programming language class based on sql creating statement | |
| CN111831624A (en) | Data table creating method and device, computer equipment and storage medium | |
| CN109471637B (en) | Circuit diagram examination script debugging method | |
| CN114911466B (en) | Data quality control system of acquisition terminal | |
| CN115469860A (en) | Method and system for automatically generating demand-to-software field model based on instruction set | |
| KR100656559B1 (en) | Program Automatic Generating Tools | |
| CN115373655B (en) | Information protocol code automatic generation method based on standardized template | |
| CN117874393A (en) | Method and system for constructing SCA model engineering through XML file | |
| Cuka et al. | Specifying executable commands: An example of FAST domain engineering | |
| Kossmann | A graphic SDL support environment | |
| CN117762401A (en) | Method for developing industrial software configuration by low codes | |
| CN114637532A (en) | Method for automatically obtaining comments and generating interface document according to fields |
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 |