Method for conducting database definition through schema format

A database and definition technology, applied in the field of database establishment, can solve the problems of inconvenient and unified management of the database, mismatch of data tables and tables, and troublesome management, and achieve the effect of simple program operation.

Inactive Publication Date: 2018-05-04
商派软件有限公司
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the traditional method of creating database tables, the operation of the database may need to write SQL statements by oneself, such as the establishment of data tables, the addition, deletion, and modification of table fields need to be operated by third-party PDO or handwritten SQL , it is inconvenient to manage the tables and fields of the database in a unified manner, and it is also necessary to remember the types of many tables. Defined in the schema file of the data table

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the technical solutions of the present invention clearer and clearer to those skilled in the art, the present invention will be further described in detail below in conjunction with examples, but the embodiments of the present invention are not limited thereto.

[0033] A method for defining a database through a schema format provided in this embodiment is characterized in that by defining a set of xml / json / yaml format files, the table name of the data table and the field name, field type, and field corresponding to the data table are The description is defined in a file, the rule matching is performed through the definition file, and then the file is automatically parsed through the analysis program to generate the corresponding data table, and the addition, deletion, modification, and query of the data table are operated through the analysis program, including the following steps:

[0034] Step 1: By defining a set of xml / json / yaml format files, define...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for conducting database definition through a schema format, and belongs to the technical field of database building. By means of a group of xml / json / yal format files,a table name of a data table and a field name, a field type and field description which correspond to the data table are defined in one file, rule matching is conducted by defining the file, the fileis parsed automatically through a parser, a corresponding data table is generated, and increasing, deleting, modifying and checking of the data table are performed through the parser. Accordingly, bymeans of the group of xml / json / yal format files, the table name of the data table and the field name, the field type and the field description which correspond to the data table are defined in one file, the corresponding data table is generated, uniform definition is achieved for management of the data table, and a program operation is easier.

Description

technical field [0001] The invention relates to a method for defining a database, in particular to a method for defining a database through a schema format, and belongs to the technical field of database establishment. Background technique [0002] In the traditional method of creating database tables, the operation of the database may need to write SQL statements by oneself, such as the establishment of data tables, the addition, deletion, and modification of table fields need to be operated by third-party PDO or handwritten SQL , it is inconvenient to manage the tables and fields of the database in a unified manner, and it is also necessary to remember the types of many tables. Defined in the schema file of the data table. Contents of the invention [0003] The main purpose of the present invention is to provide a method for defining a database through a schema format, to uniformly define the management of data tables, and to make the program operation easier. [0004]...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F8/20G06F17/30
CPCG06F8/22G06F16/211G06F16/2282
Inventor 卢军义徐唤春裴大鹏
Owner 商派软件有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap