A dynamically expandable relational database and a design method thereof

A design method and relational technology, applied in the field of data processing, can solve the problems of relational databases that lack dynamic scalability of fields, and achieve the effect of improving flexibility and concurrency and enhancing data security

Active Publication Date: 2018-12-11
CHONGQING INST OF GREEN & INTELLIGENT TECH CHINESE ACADEMY OF SCI
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the shortcomings of the prior art described above, the purpose of the present invention is to provide a dynamically scalable relational database and its design method, which is used to solve the problem of the lack of field dynamic scalability in relational databases 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
  • A dynamically expandable relational database and a design method thereof
  • A dynamically expandable relational database and a design method thereof
  • A dynamically expandable relational database and a design method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The implementation of the present application will be described by specific specific examples below, and those skilled in the art can easily understand other advantages and effects of the present application from the content disclosed in this specification.

[0031] In the following description, reference is made to the accompanying drawings, which illustrate several embodiments of the application. It is to be understood that other embodiments may be utilized, and that mechanical, structural, electrical, and operational changes may be made without departing from the spirit and scope of the present disclosure. The following detailed description should not be considered as limiting, And the scope of the embodiments of the present application is defined only by the claims of the issued patent. The terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the application. Spatially relative terms such as "upper", "lowe...

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 design method of a dynamically expandable relational database, comprising: S1, establishing a data table management table, a field mapping relation table and a fixed data table structure of an entity data table, wherein the data table management table stores virtual table information and the association relationship among the virtual table, the field relationship mapping table and the entity data table; S2, when the virtual table is detect to be created, correspondingly inserting a record of the virtual table in the data table management table, and generating a field mapping relation table and an entity data table corresponding to the virtual table; S3, when field information is created in that virtual table, correspondingly adding field information in the field map relation table; S4, forming a mapping relation between the fixed field of the entity data table and the field information in the virtual table, and storing the mapping relation in the field mappingrelation table. Through the mapping mechanism of virtual field, the flexibility and concurrency of the data table structure modification are improved, the data security is enhanced when the data tablestructure is modified, and thus the database has the advantage of scalability.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a dynamically expandable relational database and a design method thereof. Background technique [0002] In a relational database, the structure of the data table is fixed, and the creator of the data table needs to know the fields of the data, as well as the attributes and restrictions of each field in advance. This feature does not cause any inconvenience to developers. Due to the variety of application scenarios, users often need to define the data structure by themselves. The traditional database method is to open certain database interfaces for users to create data tables by themselves. However, on the one hand, this method provides users with the right to modify the database structure, which makes the database have certain security risks; In addition, a large number of data tables with different structures are stored in the database, which also puts great pressure o...

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): G06F17/30
Inventor 张学睿张帆何盼
Owner CHONGQING INST OF GREEN & INTELLIGENT TECH CHINESE ACADEMY OF SCI
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