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

Database processing and data query method and equipment

A processing method and processing equipment technology, applied in the direction of electrical digital data processing, special data processing applications, database models, etc., can solve problems such as the reduction of database data processing efficiency, achieve the effects of shortening query time, ensuring efficiency, and improving performance

Active Publication Date: 2018-12-07
ADVANCED NEW TECH CO LTD
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In view of this, the embodiment of the present application provides a database processing and data query method and equipment, which are used to solve the problem of reduced data processing efficiency of the database 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 processing and data query method and equipment
  • Database processing and data query method and equipment
  • Database processing and data query method and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] In order to achieve the purpose of this application, the embodiment of this application provides a database processing method, data query method and equipment. For business data stored in sub-databases and sub-tables, it can be determined that the first data item is used as the split unit to obtain the first A data warehouse table; and according to the second data item contained in the first data warehouse table, the first data warehouse table is converted into a second data warehouse table with the second data item as a split unit, and the The business data stored in the second data warehouse table is the same as the business data stored in the first data warehouse table. In this way, the second data warehouse table can be guaranteed to be obtained in a short time, that is to say, no matter which data item is queried for the corresponding business data, the technical solution provided by the embodiment of the present application can not only ensure the integrity of the ...

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 processing and data query method and equipment. The method comprises the steps that for service data stored in different warehouses and tables, a first data warehouse table with a first data item determined as a split unit can be obtained; and according to the judgment that the first data warehouse table contains a second data item, the first data warehouse tableis converted into a second data warehouse table with the second data item being a split unit, wherein the service data stored in the second data warehouse table is the same as the service data storedin the first data warehouse table. In this way, it can be guaranteed that the second data warehouse table is obtained in a short time, that is, by the adoption of the technical scheme in the embodiment, when the service data corresponding to any data item is queried, the integrity of the service data can be guaranteed, data processing efficiency also can be guaranteed, therefore, query time is shortened, and the performance of a whole system is improved.

Description

technical field [0001] The present application relates to the field of computer technology and distributed storage, in particular to a database processing and data query method and equipment. Background technique [0002] With the development of e-commerce technology, a large amount of business data is generated through the Internet. Faced with the large amount of business data generated, it is proposed to store these business data in a relational database by sub-database and sub-table. [0003] The so-called sub-database sub-table refers to splitting the received business data based on a certain data attribute of the business data, and storing the split business data in different data tables. The tables have the same table structure, but different table names. [0004] For example: the business data can be split according to the data attribute of user ID, and the business data including user ID 1 is stored in data table 1; the business data including user ID 2 is stored i...

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
CPCG06F16/2282G06F16/24553G06F16/283
Inventor 孙超
Owner ADVANCED NEW TECH CO LTD