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

Table-by-table and page-by-page query method and system for database

A paging query and database technology, applied in the field of database table and paging query, can solve problems such as consuming database resources

Active Publication Date: 2014-10-29
数贸科技(北京)有限公司
View PDF8 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to solve the above problems, the present invention provides a method and system for solving database table-by-table and page-by-page queries, so as to solve the problem of serious consumption of database resources during table-by-table and page-by-page queries, so as to alleviate the pressure on the database system

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
  • Table-by-table and page-by-page query method and system for database
  • Table-by-table and page-by-page query method and system for database
  • Table-by-table and page-by-page query method and system for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0042] The first aspect of the present invention provides a method for database table-by-table and page-by-page query, by calculating N tables that meet the query conditions and querying the N tables to obtain records that meet the conditions, such as Figure 4 As shown, it specifically includes the following steps:

[0043] S1. Query the number of records satisfying the conditions in each table;

[0044] S2. According to the request page and the number of records of the request page, locate the table where the request page is located and the location of the records in the table;

[0045] S3. Query the database according to the location of the table and the record to obtain the corresponding record;

[0046] S4. Establishing and...

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 relates to a table-by-table and page-by-page query method and system for a database. An application layer can send a query request to a data access layer, the data access layer can calculate out N tables meeting the query conditions and respectively query the record numbers, meeting the conditions, of the tables, then the position of the table where a request page is arranged and the positions of records in the table can be located according to the request page and the record number of the request page, the database can be queried to obtain corresponding records according to the position of the table and the positions of the records in the table, and finally results are returned to the application layer. Before accessing the database and processing the results, the data access layer can access a cache area to read or store corresponding data. By means of layer-by-layer and page-by-page query, the effective utilization of resources in the database is improved, and the burden of a database system is relieved.

Description

technical field [0001] The invention relates to a method and system for querying a database by table and page. Background technique [0002] With the development of information technology and the market, especially after the 1990s, data management is no longer just about storing and managing data, but has transformed into a variety of data management methods required by users. At the same time, the information in the database The amount is increasing, and people often need to search and query various information in the database according to their own needs. When the amount of data is too large, various problems may occur during the query, such as exhaustion of server resources, processing timeout due to excessive data transmission, etc., which will eventually cause the query to fail to complete, and the structure obtained by the query Often a lot, even massive amounts of data. If they are all displayed together, it is often impossible for people to find the information the...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/2455
Inventor 薛继东
Owner 数贸科技(北京)有限公司
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