CN107992292A - A kind of method defined by schema forms progress database - Google Patents
A kind of method defined by schema forms progress database Download PDFInfo
- Publication number
- CN107992292A CN107992292A CN201711220694.XA CN201711220694A CN107992292A CN 107992292 A CN107992292 A CN 107992292A CN 201711220694 A CN201711220694 A CN 201711220694A CN 107992292 A CN107992292 A CN 107992292A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- file
- database
- json
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
- G06F8/22—Procedural
-
- 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
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method defined by schema forms progress database, belong to Database technical field, by defining one group of xml/json/yaml formatted file, by the table name of tables of data and the corresponding field name of tables of data, field type, field description definition in one file, rule match is carried out by defining file, then by the automatic resolution file of analysis program, corresponding tables of data is generated, by the increasing of analysis program operation data table, deletes, change, look into.The present invention is defined the table name of tables of data and the corresponding field name of tables of data, field type, field description in one file by one group of xml/json/yaml form, generate corresponding tables of data, management for tables of data has unified definition, and procedure operation is also simpler.
Description
Technical field
The present invention relates to a kind of method that database defines, and database is carried out by schema forms more particularly to one kind
The method of definition, belongs to Database technical field.
Background technology
Established in tradition in the method for database table, the operation carried out to database may need to go to write sql by oneself
Sentence, such as the foundation of tables of data, increasing to literary name section, delete, change, it is necessary to be operated by third party pdo or the side of hand-written sql
Formula, it has not been convenient to be managed collectively the table of database and the field of table, it is also desirable to remember the type of many tables, management is got up can be number
It is tired, tables of data also be easy to cause in procedure operation with the unmatched situation of table because the data of all operations are all defined on number
Among the schema files of table.
The content of the invention
The main object of the present invention is to provide for a kind of method defined by schema forms progress database, logarithm
Unified definition is carried out according to the management of table, makes procedure operation simpler.
The purpose of the present invention can reach by using following technical solution:
A kind of method defined by schema forms progress database, passes through and defines one group of xml/json/yaml form
File, the table name of tables of data and the corresponding field name of tables of data, field type, field description are defined in one file, led to
Cross definition file and carry out rule match, then by the automatic resolution file of analysis program, generate corresponding tables of data, pass through parsing
The increasing of procedure operation tables of data, delete, change, looking into.
Further, comprise the following steps:
Step 1:It is by defining one group of xml/json/yaml formatted file, the table name of tables of data and tables of data is corresponding
Field name, field type, field description definition are in one file;
Step 2:Rule match is carried out by defining file;
Step 3:By the automatic resolution file of analysis program, corresponding tables of data is generated;
Step 4:By the increasing of analysis program operation data table, delete, change, look into.
Further, the step 1 includes:
Needed to describe file and database knot to the xml/json/yaml in the institutional framework of individuation data storehouse according to user
Structure description information is described;
Based on individuation data storehouse institutional framework, using the form of xml/json/yaml documents to individuation data management
Structure is described;
Structure is managed based on individuation data, database is managed and safeguarded using individuation data management structure;
By the table name of tables of data and the corresponding field name of tables of data, field type, field description definition in one file.
Further, needed to describe file to the xml/json/yaml in the institutional framework of individuation data storehouse according to user
It is described with database structure description information, including:
By defining the hierarchical relationship of data base organization's structure come descriptive data base structure;
Database rank is defined using the mode of the interpolation data storehouse rank title in different database ranks;
File is described using xml/json/yaml the membership of database table and database is described.
Further, the individuation data management structure includes the information description of data list structure, the table name of tables of data
And the information description of the corresponding field name of tables of data, field type, field.
Further, using xml/json/yaml documents form to individuation data management structure be described, be
In the document of xml/json/yaml forms, the title of each column data item, the type of data item, data in the tables of data are grown
Spend and whether search index item is described.
Further, it is described that database is managed and safeguarded using individuation data management structure, including:
Xml/json/yaml in data management structure is described file and uploaded under corresponding database tier by user,
Tables of data is safeguarded as needed, data query, modification and deletion;
User data is identified automatically by user's level of confidentiality and authority, obtains the details of the data.
Further, in the step 3, by the automatic resolution file of analysis program, corresponding tables of data is generated, including:
Unique file sequence number is distributed to xml/json/yaml formatted files and is parsed;
According to analysis result, unique element is distributed to appearing in each element name in xml/json/yaml formatted files
Name ID is simultaneously registered in masurium dictionary;
According to analysis result, unique pathname is distributed to appearing in the pathname in xml/json/yaml formatted files
ID is simultaneously registered in pathname dictionary;
According to analysis result, using masurium ID as keyword, by the file sequence number occurred including at least object element, word
Accord with position, pathname ID, the element of information of branch's order are registered into row information, near and using pathname ID as keyword
File sequence number, character position, pathname ID, the routing information of the information of branch's order less comprising object element appearance are deposited
Storage;
According to analysis result, corresponding tables of data is generated.
The advantageous effects of the present invention:The method according to the invention defined by schema forms progress database,
The method provided by the invention defined by schema forms progress database, by defining one group of xml/json/yaml form,
By the table name of tables of data and the corresponding field name of tables of data, field type, field description definition in one file, then pass through
The automatic resolution file of program, generates corresponding tables of data, the increasing of procedure operation tables of data, delete, change, looking into, by defining file
Rule match is carried out, the management for tables of data has unified definition, and procedure operation is also simpler.
Embodiment
To make those skilled in the art more clear and clear and definite technical scheme, with reference to embodiment to this hair
It is bright to be described in further detail, but the implementation of the present invention is not limited to this.
A kind of method defined by schema forms progress database provided in this embodiment, it is characterised in that pass through
One group of xml/json/yaml formatted file is defined, by the table name of tables of data and the corresponding field name of tables of data, field type, word
Segment description defines in one file, and rule match is carried out by defining file, then by the automatic resolution file of analysis program,
Corresponding tables of data is generated, by the increasing of analysis program operation data table, deletes, change, look into, comprise the following steps:
Step 1:It is by defining one group of xml/json/yaml formatted file, the table name of tables of data and tables of data is corresponding
Field name, field type, field description definition are in one file;
Step 2:Rule match is carried out by defining file;
Step 3:By the automatic resolution file of analysis program, corresponding tables of data is generated;
Step 4:By the increasing of analysis program operation data table, delete, change, look into.
Further, in the present embodiment, the step 1 includes:
Needed to describe file and database knot to the xml/json/yaml in the institutional framework of individuation data storehouse according to user
Structure description information is described;
Based on individuation data storehouse institutional framework, using the form of xml/json/yaml documents to individuation data management
Structure is described;
Structure is managed based on individuation data, database is managed and safeguarded using individuation data management structure;
By the table name of tables of data and the corresponding field name of tables of data, field type, field description definition in one file.
Further, in the present embodiment, needed according to user to the xml/json/ in the institutional framework of individuation data storehouse
Yaml describes file and database structure description information is described, including:
By defining the hierarchical relationship of data base organization's structure come descriptive data base structure;
Database rank is defined using the mode of the interpolation data storehouse rank title in different database ranks;
File is described using xml/json/yaml the membership of database table and database is described.
Further, in the present embodiment, individuation data management structure include data list structure information description,
The information description of the corresponding field name of table name and tables of data, field type, field of tables of data.
Further, in the present embodiment, structure is managed to individuation data using the form of xml/json/yaml documents
It is described, is in the document of xml/json/yaml forms, to title, the data item of each column data item in the tables of data
Type, data length and whether search index item is described.
Further, in the present embodiment, it is described that database is managed and tieed up using individuation data management structure
Shield, including:
Xml/json/yaml in data management structure is described file and uploaded under corresponding database tier by user,
Tables of data is safeguarded as needed, data query, modification and deletion;
User data is identified automatically by user's level of confidentiality and authority, obtains the details of the data.
Further, in the present embodiment, it is corresponding by the automatic resolution file of analysis program, generation in the step 3
Tables of data, including:
Unique file sequence number is distributed to xml/json/yaml formatted files and is parsed;
According to analysis result, unique element is distributed to appearing in each element name in xml/json/yaml formatted files
Name ID is simultaneously registered in masurium dictionary;
According to analysis result, unique pathname is distributed to appearing in the pathname in xml/json/yaml formatted files
ID is simultaneously registered in pathname dictionary;
According to analysis result, using masurium ID as keyword, by the file sequence number occurred including at least object element, word
Accord with position, pathname ID, the element of information of branch's order are registered into row information, near and using pathname ID as keyword
File sequence number, character position, pathname ID, the routing information of the information of branch's order less comprising object element appearance are deposited
Storage;
According to analysis result, corresponding tables of data is generated.
Below by one group of embodiment, the present invention will be further described:
First step structure individuation data storehouse institutional framework
User carries out the customization of data base organization's structure according to demand, including Database structure description information and
Xml/json/yaml describes file.Database structure description information is the layer by defining data base organization's structure
Level relation, carrys out descriptive data base structure, in Database Systems, user adds number in different database ranks as needed
According to storehouse rank title, the other definition of database level is completed, a database rank can include multiple lower floor's ranks.xml/
Json/yaml describes file, as follows for the membership of descriptive data base table and database, example:
After xml/json/yaml document definitions, the description of database class information can be carried out in Database Systems,
Corresponding xml/json/yaml is added under the rank and describes file, the description information in the xml/json/yaml files is should
The other information of database level.
Second step structure individuation data management structure
Structure individuation data management structure needs to customize the data list structures such as data list structure, data directory query term
Description information.The information description of data list structure includes the data list structure composition i.e. title of each column data item, the number of data item
According to type, data length and whether search index item, example is as follows:
Data type is mainly varchar2 and blob types, when running into long article notebook data either picture, selection
Blob types;The value of query is " yes ", when Database Systems are inquired about, can be used as querying condition, the value of query is " no "
When, occur not as querying condition in Database Systems;When the value of show is " yes ", when inquiring about data message, in database page
Face directly displays the column data information, when the value of show is " no ", clicks on the particular content that can just check the column data in detail, number
According to type if the value of blob, show are necessary for no, based on the above-mentioned personalized customization for realizing data directory query term.
In conclusion in the present embodiment, according to the side defined by schema forms progress database of the present embodiment
Method, the method provided in this embodiment defined by schema forms progress database, passes through and defines one group of xml/json/yaml
Form, the table name of tables of data and the corresponding field name of tables of data, field type, field description are defined in one file, so
Afterwards by the automatic resolution file of program, corresponding tables of data is generated, the increasing of procedure operation tables of data, delete, change, looking into, by fixed
Adopted file carries out rule match, and the management for tables of data has unified definition, and procedure operation is also simpler.
The above, is only further embodiment of the present invention, but protection scope of the present invention is not limited thereto, any
In scope disclosed in this invention, technique according to the invention scheme and its design add those familiar with the art
With equivalent substitution or change, protection scope of the present invention is belonged to.
Claims (8)
- A kind of 1. method defined by schema forms progress database, it is characterised in that pass through and define one group of xml/json/ Yaml formatted files, a text is defined on by the table name of tables of data and the corresponding field name of tables of data, field type, field description In part, rule match is carried out by defining file, then by the automatic resolution file of analysis program, generates corresponding tables of data, By the increasing of analysis program operation data table, delete, change, look into.
- A kind of 2. method defined by schema forms progress database according to claim 1, it is characterised in that bag Include following steps:Step 1:By defining one group of xml/json/yaml formatted file, by the table name of tables of data and the corresponding field of tables of data Name, field type, field description definition are in one file;Step 2:Rule match is carried out by defining file;Step 3:By the automatic resolution file of analysis program, corresponding tables of data is generated;Step 4:By the increasing of analysis program operation data table, delete, change, look into.
- A kind of 3. method defined by schema forms progress database according to claim 2, it is characterised in that institute Stating step 1 includes:Need to describe file to the xml/json/yaml in the institutional framework of individuation data storehouse according to user and database structure is retouched Information is stated to be described;Based on individuation data storehouse institutional framework, structure is managed to individuation data using the form of xml/json/yaml documents It is described;Structure is managed based on individuation data, database is managed and safeguarded using individuation data management structure;By the table name of tables of data and the corresponding field name of tables of data, field type, field description definition in one file.
- A kind of 4. method defined by schema forms progress database according to claim 3, it is characterised in that root Need to describe file and database structure description information to the xml/json/yaml in the institutional framework of individuation data storehouse according to user It is described, including:By defining the hierarchical relationship of data base organization's structure come descriptive data base structure;Database rank is defined using the mode of the interpolation data storehouse rank title in different database ranks;File is described using xml/json/yaml the membership of database table and database is described.
- A kind of 5. method defined by schema forms progress database according to claim 3, it is characterised in that institute Stating individuation data management structure includes information description, the table name of tables of data and the corresponding field of tables of data of data list structure The information description of name, field type, field.
- A kind of 6. method defined by schema forms progress database according to claim 3, it is characterised in that profit Individuation data management structure is described with the form of xml/json/yaml documents, is in xml/json/yaml forms In document, to the title of each column data item in the tables of data, the type of data item, data length and whether search index item into Row description.
- A kind of 7. method defined by schema forms progress database according to claim 3, it is characterised in that institute State and database is managed and safeguarded using individuation data management structure, including:Xml/json/yaml in data management structure is described file and uploaded under corresponding database tier by user, according to Need to safeguard tables of data, data query, modification and deletion;User data is identified automatically by user's level of confidentiality and authority, obtains the details of the data.
- A kind of 8. method defined by schema forms progress database according to claim 2, it is characterised in that institute State in step 3, by the automatic resolution file of analysis program, generate corresponding tables of data, including:Unique file sequence number is distributed to xml/json/yaml formatted files and is parsed;According to analysis result, unique masurium ID is distributed to appearing in each element name in xml/json/yaml formatted files And it is registered in masurium dictionary;According to analysis result, unique pathname ID is distributed simultaneously to appearing in the pathname in xml/json/yaml formatted files It is registered in pathname dictionary;According to analysis result, using masurium ID as keyword, by the file sequence number occurred including at least object element, character bit Put, the element of the information of pathname ID, branch's order is registered into row information, and using pathname ID as keyword, will at least wrapped The file sequence number that occurs containing object element, character position, pathname ID, the routing information of information of branch's order are stored;According to analysis result, corresponding tables of data is generated.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711220694.XA CN107992292A (en) | 2017-11-29 | 2017-11-29 | A kind of method defined by schema forms progress database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711220694.XA CN107992292A (en) | 2017-11-29 | 2017-11-29 | A kind of method defined by schema forms progress database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107992292A true CN107992292A (en) | 2018-05-04 |
Family
ID=62033834
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711220694.XA Pending CN107992292A (en) | 2017-11-29 | 2017-11-29 | A kind of method defined by schema forms progress database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107992292A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109284463A (en) * | 2018-08-15 | 2019-01-29 | 山东鲁能软件技术有限公司 | A kind of method of data capture and system based on dynamic template |
CN109918050A (en) * | 2019-02-01 | 2019-06-21 | 上海交通大学 | A kind of software requirement description rule language and conversion method |
CN111124548A (en) * | 2019-12-31 | 2020-05-08 | 科大国创软件股份有限公司 | Rule analysis method and system based on YAML file |
CN111309734A (en) * | 2020-02-20 | 2020-06-19 | 第四范式(北京)技术有限公司 | Method and system for automatically generating table data |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050131895A1 (en) * | 2003-12-16 | 2005-06-16 | Software Ag | Method for searching a database and database |
CN1914613A (en) * | 2004-11-30 | 2007-02-14 | 松下电器产业株式会社 | Database configuring device, database retrieving device, database device, database configuring method, and database retrieving method |
CN101059799A (en) * | 2006-04-20 | 2007-10-24 | 上海宝信软件股份有限公司 | Method for introducing regular file into data base |
CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
CN104598592A (en) * | 2015-01-20 | 2015-05-06 | 北京仿真中心 | XML (Extensive Markup Language)-based database custom method and system |
-
2017
- 2017-11-29 CN CN201711220694.XA patent/CN107992292A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050131895A1 (en) * | 2003-12-16 | 2005-06-16 | Software Ag | Method for searching a database and database |
CN1914613A (en) * | 2004-11-30 | 2007-02-14 | 松下电器产业株式会社 | Database configuring device, database retrieving device, database device, database configuring method, and database retrieving method |
CN101059799A (en) * | 2006-04-20 | 2007-10-24 | 上海宝信软件股份有限公司 | Method for introducing regular file into data base |
CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
CN104598592A (en) * | 2015-01-20 | 2015-05-06 | 北京仿真中心 | XML (Extensive Markup Language)-based database custom method and system |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109284463A (en) * | 2018-08-15 | 2019-01-29 | 山东鲁能软件技术有限公司 | A kind of method of data capture and system based on dynamic template |
CN109284463B (en) * | 2018-08-15 | 2021-02-02 | 山东鲁能软件技术有限公司 | Data collection method and system based on dynamic template |
CN109918050A (en) * | 2019-02-01 | 2019-06-21 | 上海交通大学 | A kind of software requirement description rule language and conversion method |
CN109918050B (en) * | 2019-02-01 | 2021-10-26 | 上海交通大学 | Software requirement description rule language and conversion method |
CN111124548A (en) * | 2019-12-31 | 2020-05-08 | 科大国创软件股份有限公司 | Rule analysis method and system based on YAML file |
CN111124548B (en) * | 2019-12-31 | 2023-10-27 | 科大国创软件股份有限公司 | Rule analysis method and system based on YAML file |
CN111309734A (en) * | 2020-02-20 | 2020-06-19 | 第四范式(北京)技术有限公司 | Method and system for automatically generating table data |
CN111309734B (en) * | 2020-02-20 | 2023-12-05 | 第四范式(北京)技术有限公司 | Method and system for automatically generating table data |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101427249B (en) | There is the extensible query language of the support to rich data types | |
US9092501B2 (en) | Custom entities and fields in a multi-tenant database system | |
CN107992292A (en) | A kind of method defined by schema forms progress database | |
US9613165B2 (en) | Autocomplete searching with security filtering and ranking | |
US11341171B2 (en) | Method and apparatus for implementing a set of integrated data systems | |
Yu et al. | Compressed accessibility map: Efficient access control for XML | |
US7913161B2 (en) | Computer-implemented methods and systems for electronic document inheritance | |
US10108614B2 (en) | Document handling in a web application | |
CN105849726A (en) | Generic indexing for efficiently supporting ad-hoc query over hierarchically marked-up data | |
CN101645092B (en) | Method for mapping an X500 data model onto a relational database | |
CN102646039A (en) | Software interface generating system and method based on extensible markup language (XML) Schema | |
CN104199938B (en) | Agricultural land method for sending information and system based on RSS | |
US7860903B2 (en) | Techniques for generic data extraction | |
US20140122523A1 (en) | Point-in-time query system | |
Will | The ISO 25964 data model for the structure of an information retrieval thesaurus | |
CN105468785A (en) | Computer file management method | |
US20150058363A1 (en) | Cloud-based enterprise content management system | |
JP2006524376A (en) | Generic database schema | |
Peralta | Extraction and integration of movielens and imdb data | |
EP2691874A1 (en) | Textual analysis system | |
US8073870B2 (en) | Methods for storing data | |
US20020138503A1 (en) | Method and system for mechanism for dynamic extension of attributes in a content management system | |
US20070220033A1 (en) | System and method for providing simple and compound indexes for XML files | |
Fengguang et al. | Research and implementation of heterogeneous data integration based on XML | |
KR20090107145A (en) | The integrating and searching method of alien 2-dimension table |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180504 |
|
RJ01 | Rejection of invention patent application after publication |