Method and system for splitting and querying database relational tables

A relational table and database technology, applied in the database field, can solve the problems of low query efficiency and achieve the effect of short query time, simple query method and high efficiency

Active Publication Date: 2016-04-06
ALIBABA GRP HLDG LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0020] This application provides a method and system for splitting and querying database relational tables to solve the problem of low query efficiency of traditional database relational table horizontal splitting methods

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 splitting and querying database relational tables
  • Method and system for splitting and querying database relational tables
  • Method and system for splitting and querying database relational tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0089] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0090] The application provides a method and system for splitting and querying database relational tables to solve the problem of low query efficiency in the traditional horizontal splitting method for database relational tables.

[0091] refer to Figure 4 , a flow chart of a method for splitting a database relational table described in the embodiment of the present application is given.

[0092] Step 101, according to the fields in the database relationship table, select n fields as split fields, select each split field as a coordinate axis, select the calculation result of the split field value as the coordinate value of the corresponding coordinate axis, and establish n dimensions Coordinate system,...

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 splitting and inquiring method and system of a database relational table, which solves the problem that the horizontal splitting method for a conventional database relational table is lower in inquiring efficiency. The method comprises the steps of: selecting the splitting fields as a coordinate axis according to n splitting fields in the database relational table, the calculating results of the splitting fields are coordinate values to establish a n-dimensional coordinate system; determining branch warehouses corresponding to the coordinate system; placing a row of records in the relational database in corresponding branch warehouses; and searching for corresponding branch warehouses according to the splitting fields and the calculating results of the splitting fields during inquiry. For the splitting fields provided in the inquiring condition, not all splitting fields are provided, and the branch warehouses corresponding to the calculating results of the splitting fields provided without inquiring all branch warehouses. Therefore, the inquiring method is simple, short in inquiring time, and higher in efficiency.

Description

technical field [0001] The application relates to database technology, in particular to a method and system for splitting and querying database relational tables. Background technique [0002] A database is a warehouse that organizes, stores and manages data according to the data structure. Among them, a database system composed of relational data structures is called a relational database system. [0003] Almost all data operations in relational databases are based on one or more relational tables, and data management is realized through operations such as classification, merging, connection, or selection of these relational tables. [0004] In relational databases, as the amount of data in relational tables increases, it is difficult for a single database to support data storage and search. Therefore, horizontal splitting of tables is introduced, and table records are stored in various sub-databases according to certain rules. The records stored in the library have no in...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 邱硕
Owner ALIBABA GRP HLDG LTD
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