Unlock instant, AI-driven research and patent intelligence for your innovation.

Database establishment method, device and terminal

A method for establishing a database and a technology for establishing a database, applied in the fields of a method for establishing a database, a device, and a terminal, can solve problems such as low efficiency of database query, achieve the effect of improving cumbersome search links and improving query efficiency

Active Publication Date: 2021-07-23
福建中金在线信息科技有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the object of the present invention is to provide a database establishment method, device and terminal to improve the technical problems of low efficiency of database query existing in the prior art

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database establishment method, device and terminal
  • Database establishment method, device and terminal
  • Database establishment method, device and terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] see figure 1 A flowchart of a method for establishing a database is shown, and the method includes the following steps:

[0030] Step S102, acquiring multiple established data sub-sheets.

[0031] Step S104, judging whether there are data sub-forms associated with each other.

[0032] Step S106, if yes, combine data sub-forms associated with each other.

[0033] In one embodiment, the data in the interrelated data sub-forms can be summarized to form a data master form.

[0034] In a specific application, the above-mentioned steps of summarizing the data in the interrelated data sub-sheets to form the general data sheet can be performed by referring to the following method: according to the interrelated data sub-sheets, the method of adding redundant columns and / or adding derived columns , summarize the data in the interrelated data sub-forms to form a total data form.

[0035] Through the operation of the above synthesis processing, because almost all the data can b...

Embodiment 2

[0062] For the database establishment method provided in Embodiment 1, the embodiment of the present invention provides a database establishment device, see figure 2 A structural block diagram of a database establishment device shown, including:

[0063] A form acquisition module 202, configured to acquire multiple established data sub-forms;

[0064] Association judging module 204, for judging whether there are data sub-forms associated with each other;

[0065] The form synthesis module 206 is configured to perform synthesis processing on the associated data sub-forms when the determination result of the association determination module is yes.

[0066] In one embodiment, the form synthesis module 206 is further configured to: summarize the data in the interrelated data sub-forms to form a data master form.

[0067] The database building module 208 is configured to use the synthesized data subforms to build a database.

[0068] In the above-mentioned device of this embod...

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 provides a method, device and terminal for establishing a database, and relates to the technical field of databases. The method includes: obtaining multiple established data sub-forms; judging whether there are interrelated data sub-forms; Data subforms are processed synthetically. The invention synthesizes the associated data sub-forms, and uses the synthesized data sub-forms to construct the database. This method can directly and quickly query the synthesized forms in the database, thereby improving the time-consuming and cumbersome search link in the database query process in the prior art according to the association relationship of each physically independent form, effectively improving the Query efficiency.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a method, device and terminal for establishing a database. Background technique [0002] When designing relational databases, different specification requirements are usually followed to design a reasonable relational database. These different specification requirements are called different paradigms. Various paradigms are incremental specifications, and the higher the paradigm, the smaller the database redundancy. . There are currently six normal forms for relational databases: first normal form (1NF), second normal form (2NF), third normal form (3NF), Bath-Kord normal form (BCNF), fourth normal form (4NF) and fifth normal form ( 5NF, also known as perfect paradigm). [0003] Although the database following the normalized design can simplify DML (data manipulation language) operations such as updates, the problems caused by the normalized design cannot be ignored, an...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/28
CPCG06F16/22G06F16/2228G06F16/284
Inventor 沈文策
Owner 福建中金在线信息科技有限公司