Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for establishing electronic certificate storage model based on sub-libraries and sub-tables

An electronic license and storage model technology, which is used in still image data retrieval, special data processing applications, still image data indexing, etc. The problem of large differences in information content can reduce the probability of locking the table, the storage structure is clear, and the bottleneck of hardware resources can be avoided.

Pending Publication Date: 2020-11-27
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

First of all, affected by the objective situation of the database, when the amount of data in a single table reaches a certain threshold, the data retrieval capability will gradually decline
Secondly, when a single record has large data, only relatively few rows can be stored in the same storage space, which will cause additional I / O overhead and reduce data access performance
Finally, different types of electronic certificates have large differences in business information content. If a single table is used to store business information, business information can only be stored as unstructured data, which is not conducive to subsequent applications.
[0006] To sum up, the single-database and single-table storage model is difficult to meet the needs of a large number of electronic certificate data aggregation, and with the increase of data volume, the ability to provide external retrieval services is significantly reduced

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
  • Method and system for establishing electronic certificate storage model based on sub-libraries and sub-tables
  • Method and system for establishing electronic certificate storage model based on sub-libraries and sub-tables
  • Method and system for establishing electronic certificate storage model based on sub-libraries and sub-tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] A method for establishing an electronic certificate storage model based on sub-database and sub-table, the specific steps of the method are as follows:

[0056] S1 disassembles the electronic certificate data and assigns it to the corresponding vertical sub-database;

[0057] S2 selects the shard key and sub-table algorithm according to the application scenario of the electronic certificate data;

[0058] S3 separately builds an index library to query non-hard key fields;

[0059] S4 adds sub-tables to migrate data;

[0060]When using the method of the present invention to establish an electronic certificate storage model, combine national standards and actual business, analyze the characteristics of the electronic certificate data, disassemble the electronic certificate data according to S1, and distribute them to different corresponding vertical sub-databases, and then based on each For some application scenarios of electronic license data, select the shard key and ...

Embodiment 2

[0104]A system for establishing an electronic certificate storage model based on sub-database and sub-table, the system specifically includes a dismantling and distribution module, a scene selection module, a field query module and a data migration module:

[0105] Disassembly and distribution module: disassemble the electronic certificate data and distribute it to the corresponding vertical sub-database;

[0106] Scenario selection module: select shard key and sub-table algorithm according to the application scenario of electronic certificate data;

[0107] Field query module: build an index library separately to query non-hard key fields;

[0108] Data migration module: add sub-tables to migrate data;

[0109] When using the system of the present invention to establish an electronic certificate storage model, in combination with national standards and actual business, analyze the characteristics of the electronic certificate data, disassemble the distribution module to disa...

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 and a system for establishing an electronic certificate storage model based on sub-libraries and sub-tables, and belongs to the field of data storage. The method comprises the following specific steps: S1, disassembling electronic certificate data, and distributing the electronic certificate data to corresponding vertical sub-libraries; S2, selecting a shard key and a table division algorithm according to the electronic certificate data application scene; S3, independently establishing an index library to inquire the non-hard key field; s4, adding sub-tables tomigrate the data. Through the electronic certificate storage model based on the sub-library and sub-table established in the invention, the electronic certificate library conforming to the national standard specification can be established, the electronic certificate system can support aggregation of a large amount of certificate data, and efficient certificate sharing service can be provided forthe outside in various business scenes.

Description

technical field [0001] The invention discloses a method and system for establishing an electronic certificate storage model based on sub-database and sub-table, and relates to the technical field of data storage. Background technique [0002] The release of 6 national standards for electronic certificates including "GB / T 36901-2018 Overall Technical Architecture of Electronic Certificates" defines the meaning of electronic certificates, the basic structure of electronic certificate system construction, and the data format standards for electronic information items. The construction of the library provides guidance and reference. [0003] In addition, "C 0126-2018 National Government Service Platform Data Exchange and Sharing Interface Standard" and other national government service platform access specifications provide a standard basis for the cross-level data exchange of electronic certificates and certificates, and provide data for cross-departmental and cross-regional el...

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): G06F16/51G06F16/53
CPCG06F16/51G06F16/53
Inventor 李双梁宁方刚陈兆亮
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products