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

Multi-chart information initializing method of database

An initialization method and database technology, which is applied in the field of database multi-table information initialization, can solve the problems of many times, slow speed, and low efficiency of reading the database, and achieve the effects of short consumption time, high initialization efficiency, and reduced number of times

Inactive Publication Date: 2006-09-20
HUAWEI TECH CO LTD
View PDF0 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0022] As can be seen from the above analysis, the disadvantages of the existing database multi-table information initialization method are: when the number of rows contained in the main table is large and the number of secondary tables is large, it will take a long time to read the database and read The number of databases is large, so it takes a long time, slow speed, and low efficiency to complete the initialization of database multi-table information

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
  • Multi-chart information initializing method of database
  • Multi-chart information initializing method of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the purpose and technical solution of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and examples.

[0051] The present invention is a database multi-table information initialization method, and its basic idea is: first, read the information in each sub-table into the memory; then, read the information in the main table, and form the main table record in the memory set; then, according to the pre-established relationship between the unknown information in the main table record set and the secondary table information, the unknown information in the main table record set is used as an index, and through the association relationship, retrieve the unknown information in the memory. The sub-table information associated with information, and the known information in the main table record set and the retrieved related sub-table information are assembled into a complete r...

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 database multilist information initializing method, where the database multilist comprises primary list and secondary lists. And the method comprises the steps of: A. reading information from each secondary list into a memory; B. reading information from the primary list and generating a primary list recording set in the memory; C. according to a relation between unknown information in the primary list recording set and secondary list information, using the unknown information as index, and searching the secondary list information in the memory related with the unknown information by the relation, and putting the known information in the primary list recording set and the related secondary list information together into a complete record of database multilist information.

Description

technical field [0001] The invention relates to the field of database design, in particular to a method for initializing multi-table information in a database. Background technique [0002] In the field of database application, when the amount of information is large, the method of dividing a complete piece of information into multiple parts and storing them in different database tables is usually adopted. The above-mentioned different database tables are usually called database multiple surface. In order to facilitate the query, usually when the system starts, the database tables involved in the system are initialized, that is, by reading the database tables, various parts of the information distributed in the database tables are extracted to obtain a Complete record of information. [0003] device name Version Use Agreement Dev1 V100 SNMP Dev2 V200 MML Dev3 V100 SNMP Dev4 V200 MML ...

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
IPC IPC(8): G06F17/30
Inventor 毕洪涛莱密斯
Owner HUAWEI 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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com