Database system and inquiring method supporting to carry out rapid inquiry on data table
A query method and data table technology, applied in the field of cluster databases, can solve the problems of increased location difficulty, waste of time, manpower and material resources, and low work efficiency, and achieve the effects of improving performance, speed, and practicability
Inactive Publication Date: 2017-02-01
TIANJIN NANKAI UNIV GENERAL DATA TECH
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, the above line-by-line traversal method is only suitable for small data processing. In a data table with a large amount of data, it is very difficult to determine the position of the boundary between groups through line-by-line traversal, which not only wastes time and manpower and material resources, but also has low work efficiency. , it is impossible to meet the requirements of fast processing of big data
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0025] Such as figure 1 As shown, it is a schematic structural diagram of a database system supporting fast query of data tables in the present invention, including a data table query device 1, and the data table query device 1 is internally provided with a fast group query module 2, a large-scale group filter module 3, a mesoscale Packet filtering module 4 and precise packet location module 5. The fast packet query module 2 controls the working states of the large-scale packet filtering module 3 , the medium-scale packet filtering module 4 and the precise packet location module 5 respectively. The query work on a single data table is controlled by the data table queryer 1; the fast group query module 2 controls the large-scale group filtering module 3, the medium-scale group filtering module 4 and the precise group positioning module 5, and completes the single query. Group query operations on data tables; large-scale group filtering module 3 is used for positioning operatio...
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
Login to View More Abstract
The invention relates to a database system and an inquiring method which support to carry out rapid inquiry on a data table. The invention aims to provide a rapid inquiry database system and an inquiring method which are high in inquiry speed and are accurate to inquire. The database system comprises a data table inquiring device; a rapid grouped inquiring module, a large-scale grouped filtering module, a mesoscale grouped filtering module and an accurate grouped positioning module are arranged inside the data table inquiring device. The data table inquiring device carries out total control on the inquiry work on one single data table; the rapid grouped inquiring module completes a grouped inquiring operation on the single data table by carrying out control on each module; the large-scale grouped filtering module is used for a positioning operation on a large-scale group boundary on the single data table; the mesoscale grouped filtering module is used for a positioning operation on a mesoscale group boundary in a large-scale group range; the accurate grouped positioning module is used for a positioning operation on an accurate group boundary in a mesoscale group range.
Description
technical field [0001] The invention relates to the field of cluster databases, in particular to a database system and a query method supporting fast query of data tables. Background technique [0002] The cluster database uses multiple ordinary servers to provide high-performance database services, and is suitable for the storage, query and analysis of massive data. Group query is a data query method provided by the database, that is, to group the sorted data of a certain column in the data table, and the same values are grouped into one group. For example, group (1, 2, 2, 3, 3, 3, 4) to get 4 sets of data, namely ((1), (2, 2), (3, 3, 3), (4) ). [0003] The traditional implementation of group query is to traverse the sorted data row by row. When two adjacent row values are found to be in different groups, the boundary between groups is found, such as between 1 and 2 and between 2 and 3 in the example , Between 3 and 4. In addition, the start and end of the entire d...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2453G06F16/2282
Inventor 赵伟武新毛永康
Owner TIANJIN NANKAI UNIV GENERAL DATA TECH