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

Method and device for storing and inquiring data

A data storage device and data storage technology, applied in the field of data processing, can solve problems such as large queries and increased code complexity, and achieve the effect of improving query efficiency

Inactive Publication Date: 2010-02-24
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] In summary, this method will result in a large number of queries and greatly increase the complexity of the code

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 device for storing and inquiring data
  • Method and device for storing and inquiring data
  • Method and device for storing and inquiring data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention.

[0055] The present invention can be applied to a system or software implemented based on a database. The database is organized according to a certain data model and stores data collections in secondary storage. This kind of data collection has the following characteristics: it is not repeated as much as possible, and serves multiple applications of a specific organization in an optimal way. Its data structure is independent of the application program that uses it. Unified software for management and control.

[0056] In the prior art, for data with a tree-like storage structure, the lower-level organization is usually used to record the storage method of the upper-level organization ID. In this way, when a certain level node has N-level upper-level nodes or M-level lower-level...

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 device for storing and inquiring data. The method for storing data is applied to a database provided with a tree-shaped storing structure and comprises the following steps: acquiring path information expressing a storing relation of an upper grade and a lower grade of nodes in all grades in the tree-shaped storing structure in the database; distributing the path information to the nodes in all grades and storing, wherein the path information comprises the ID information of the nodes at a grade and the ID information of all nodes in the upper grade of thenodes. By distributing the path information for expressing the storing relation of the upper grade and the lower grade to an organization in each grade, all upper grades or all lower grades of an organization can be directly inquired at one step by the path information distributed to the organization in the grade, thereby greatly improving the inquiring efficiency of data in the database of the tree-shaped storing structure.

Description

technical field [0001] The present invention relates to the technical field of data processing, and more specifically, to a data storage and query method and device. Background technique [0002] The database is a warehouse that organizes, stores and manages data according to the data structure, so that the computer can be used to realize the automatic management of production data. Therefore, the database has been widely used in the production management of various departments in various enterprises. [0003] At present, when using a database for data storage, for data with a tree-like storage structure, the storage method of recording the ID (Identity, identity number) of the upper-level organization is usually used by the lower-level organization, specifically: assign IDs to each level of organization ID, which is in one-to-one correspondence with the corresponding organization. E.g, figure 1 It is a common tree-shaped organization chart in production management. "Group...

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 KINGDEE SOFTWARE(CHINA) 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