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

Method and device for paging across multiple databases

A database and paging technology, which is applied in the field of paging methods and devices across multiple databases, and can solve problems such as poor real-time performance

Active Publication Date: 2020-11-03
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At the same time, this data merging and paging method has poor real-time performance and requires additional storage resources to store aggregated 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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for paging across multiple databases
  • Method and device for paging across multiple databases
  • Method and device for paging across multiple databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0015] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0016] figure 1 It shows an exemplary system architecture 100 to which embodiments of the multi-database paging method or the multi-database paging apparatus of the present application can be applied.

[0017] like figure 1 As shown, the system architecture 100 may include...

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 cross-multidatabase paging method and device. A specific implementation manner of the method comprises the following steps of: receiving a paging request, for contents of M databases, of a client, wherein the paging request comprises a page number N, a paging record number K and a query condition, and M, N and K are natural numbers; obtaining number records of each database, wherein each number record is a line number of the last line or records, extracted in a database corresponding to the number record, in K lines of records of a page, the page number of which is N-1; extracting K lines of records satisfying the query condition in the database corresponding to each number record from the next line of the number record; merging the K lines of records obtained in each database, and sorting the merged M*K lines or records according to a predetermined sorting condition; and taking the first K lines of records after the sorting as a paging result set, and sending response information to the client, wherein the response information comprises the paging result set. According to the method, paged displayed can be carried out on the contents of multiple databases in real time.

Description

technical field [0001] The present application relates to the technical field of computers, in particular to the technical field of database paging, and in particular to a method and device for paging across multiple databases. Background technique [0002] With the development of Internet technology, many large-scale web applications have been produced. Through these large-scale web applications embedded in browsers, users can browse various data stored in web servers. At the same time, in these large-scale web applications, data production and consumption often involve various databases. Sometimes in order to respond to the needs of users, it is necessary to combine data from different databases and display them to users. At the same time, based on performance and convenience for users to view, it is necessary to paginate the merged data. [0003] The current decision-making scheme for multi-database paging is to use a data merger to regularly extract data from multiple 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
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/25
CPCG06F16/254
Inventor 陈俊
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More