CN112035524B - List data query method, device, computer equipment and readable storage medium - Google Patents
List data query method, device, computer equipment and readable storage medium Download PDFInfo
- Publication number
- CN112035524B CN112035524B CN202010909835.4A CN202010909835A CN112035524B CN 112035524 B CN112035524 B CN 112035524B CN 202010909835 A CN202010909835 A CN 202010909835A CN 112035524 B CN112035524 B CN 112035524B
- Authority
- CN
- China
- Prior art keywords
- data
- query
- display
- query request
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000003860 storage Methods 0.000 title claims abstract description 16
- 238000005096 rolling process Methods 0.000 claims abstract description 16
- 238000004590 computer program Methods 0.000 claims description 9
- 230000004044 response Effects 0.000 claims description 4
- 238000012216 screening Methods 0.000 claims description 2
- 230000009286 beneficial effect Effects 0.000 abstract description 4
- 230000002349 favourable effect Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Abstract
The embodiment of the invention provides a list data query method, a device, computer equipment and a readable storage medium, wherein the method comprises the following steps: receiving a first query request, and recording the query time of the first query request, wherein the first query request is a query request for requesting to display the first page of data; loading first page data from the list data for display; receiving a non-first query request; and loading the data generated before the query time from the data list for display. The scheme fundamentally avoids the problem of data repetition with the prior loaded data when the data is loaded based on the non-first query request, is favorable for avoiding the problem of data repetition of list data query, supports a paging display mode and a rolling loading display mode, and does not cause the problem of data repetition in the paging display mode and the rolling loading display mode; is beneficial to reducing the occupation of the memory.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for querying list data, a computer device, and a readable storage medium.
Background
The general page display list data are all data requested by each page in batches for display, and when a plurality of persons have authority to operate the data to be displayed, the problem that the data which are newly requested and the data which are requested and returned before are repeated can occur. In the case that a web page can be presented using paging, although this approach does not avoid the problem of duplication of newly requested data with previously requested data, the data seen by the user on the page or the same page is not duplicated; however, under the condition that the screen of the mobile phone terminal is smaller, the paging mode cannot be used for solving the problem, the mobile phone terminal display list data generally adopts a rolling loading mode, and at the moment, the problem of data repetition of the data displayed by the mobile phone terminal occurs.
In addition, in the prior art, all data is cached in the memory when the data is queried for the first time, and the data is read from the cache when the data is loaded, but the mode occupies excessive memory when the transaction amount is large.
Disclosure of Invention
The embodiment of the invention provides a list data query method, which aims to solve the technical problem that data repetition or memory occupation exists in the prior art. The method comprises the following steps:
Receiving a first query request, and recording the query time of the first query request, wherein the first query request is a query request for requesting to display the first page of data;
loading first page data from the list data for display;
receiving a non-first query request;
And loading the data generated before the query time from the data list for display.
The embodiment of the invention also provides a list data query device, which is used for solving the technical problem that the prior art has repeated data or occupies memory. The device comprises:
The inquiry request receiving module is used for receiving a first inquiry request and recording the inquiry time of the first inquiry request, wherein the first inquiry request is an inquiry request for requesting to display the first page of data;
The data display module is also used for loading the first page data from the list data for display;
the query request receiving module is also used for receiving a non-first query request;
the data display module is used for displaying the data generated before the query time is loaded from the data list.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the random list data query method when executing the computer program so as to solve the technical problems of data repetition or memory occupation in the prior art.
The embodiment of the invention also provides a computer readable storage medium which stores a computer program for executing any list data query method, so as to solve the technical problem that the prior art has repeated data or occupies memory.
In the embodiment of the invention, the first query request and the non-first query request are distinguished, the first query request is the query request for requesting to display the first page of data when the list data is queried, the first page of data is loaded from the list data based on the first query request, the query time of the first query request is recorded, and then when the non-first query request is received, the data generated before the query time is loaded from the data list, thereby realizing that the data generated from the query time to the current loading data moment is excluded from the query range, namely that the data generated from the query time to the current loading data moment does not influence the data loading and the data displaying based on the non-first query request, and the data loading based on the non-first query request or the data loading generated before the query time is carried out, thereby fundamentally avoiding the problem that the data loading based on the non-first query request is repeated with the previously loaded data, and being favorable for avoiding the problem that the data of the list data query is repeated; in addition, the method supports a paging display mode and a rolling loading display mode, and the problem of data repetition cannot occur in the paging display mode and the rolling loading display mode; in addition, the data does not need to be cached in the memory, which is beneficial to reducing the occupation of the memory.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate and together with the description serve to explain the application. In the drawings:
FIG. 1 is a flowchart of a list data query method provided in an embodiment of the present invention;
FIG. 2 is a block diagram of a computer device according to an embodiment of the present invention;
Fig. 3 is a block diagram of a list data query apparatus according to an embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the following embodiments and the accompanying drawings, in order to make the objects, technical solutions and advantages of the present invention more apparent. The exemplary embodiments of the present invention and the descriptions thereof are used herein to explain the present invention, but are not intended to limit the invention.
In an embodiment of the present invention, a method for querying list data is provided, as shown in fig. 1, where the method includes:
step 102: receiving a first query request, and recording the query time of the first query request, wherein the first query request is a query request for requesting to display the first page of data;
step 104: loading first page data from the list data for display;
Step 106: receiving a non-first query request;
step 108: and loading the data generated before the query time from the data list for display.
As can be seen from the flow shown in fig. 1, in the embodiment of the present invention, a first query request and a non-first query request are provided, where the first query request is a query request for requesting to display first page data when querying list data, the first page data is loaded from the list data based on the first query request and displayed, and the query time of the first query request is recorded, and further when receiving the non-first query request, the data generated before the query time is loaded from the data list is displayed, so that the data generated from the query time to the time when the data is loaded at present is excluded from the query range at this time, that is, the data generated from the query time to the time when the data is loaded at present does not affect the data loading and the data displaying based on the non-first query request, and the data loading based on the non-first query request is also loaded from the data generated before the query time, thereby fundamentally avoiding the problem that the data loading based on the non-first query request is repeated with the previously loaded data, and being favorable for avoiding the problem that the data of the list data query is repeated; in addition, the method supports a paging display mode and a rolling loading display mode, and the problem of data repetition cannot occur in the paging display mode and the rolling loading display mode; in addition, the data does not need to be cached in the memory, which is beneficial to reducing the occupation of the memory and avoiding the consumption of extra resources.
In particular, when the list data query is implemented, the batch request data is generally requested for multiple times to be displayed, the data which is not requested for multiple times is displayed in a one-page mode, and each page displays the preset number of data, so that the request can be judged to be used for requesting to display which page of data according to the received query request, if the query request is the request for displaying the first page of data, the query request is considered to be the first query request, and the query request which is not used for requesting to display the first page of data is not the first query request.
In particular, when the list data is stored in the database, the list data stored in the database may change at any time as the data is continuously generated, for example, the list data is newly added, so as to facilitate distinguishing between the data generated before the query time and the data generated after the query time.
In particular, in order to further avoid data duplication during data loading, in this embodiment, the data generated before the query time is loaded from the data list is shown by:
After receiving the non-first query request, screening data with the generation time after the query time from a data list, and displaying the data according to the loading response of the non-first query request in the rest data, namely, excluding newly generated data from the query time to the current loading time within the data loading range, so that the newly generated data cannot influence the data loading and the data displaying based on the non-first query request or the data loading of the non-first query request based on the unchanged data before the query time, and the problem of data repetition between the data loading of different requests is fundamentally avoided.
For example, 20 pieces of data in the current list data are ordered according to the sequence from the last to the first in the generation time, for example, after the first query request, the first 5 pieces of data (i.e. the 1 st to the 5 th pieces of data) are loaded for display, at this time, one piece of data is newly generated, and in the first piece, when the non-first query request is received again, if the 5 pieces of data (i.e. the current 6 th to the 10 th pieces of data) are reloaded according to the prior art for display, but the current 6 th piece of data is actually the 5 th piece of data before the first query time, thus the 5 th piece of data before the first query time is repeatedly loaded, the problem of data repetition occurs, and if the loading mode according to the application screens the data after the query time from the data list, that is, after the newly generated piece of data is screened, the remaining data is not newly generated, the sequence of data which is generated before the first query time is not changed, and the problem of data ordering is not changed when the remaining data is sequentially loaded again (i.e. the 5 th piece of data before the first query time is displayed, the 6 th to the data is repeatedly generated, and the problem is fundamentally solved.
In specific implementation, the list data query method can display data in a paging display or rolling loading mode, namely can support paging display and rolling loading mode display, and the problem of data repetition can not occur. The list data query method based on a set of processing logic can realize that when multi-user operable list data query is realized, both page jump query and rolling loading query are supported, and data is not repeated when the rolling loading query is performed.
In this embodiment, a computer device is provided, as shown in fig. 2, including a memory 202, a processor 204, and a computer program stored on the memory and executable on the processor, where the processor implements any of the list data query methods described above when executing the computer program.
In particular, the computer device may be a computer terminal, a server or similar computing means.
In the present embodiment, there is provided a computer-readable storage medium storing a computer program for executing any of the list data querying methods described above.
In particular, computer-readable storage media, including both permanent and non-permanent, removable and non-removable media, may be used to implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer-readable storage media include, but are not limited to, phase-change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable storage media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
Based on the same inventive concept, the embodiment of the invention also provides a list data query device, as described in the following embodiment. Because the principle of solving the problem of the list data query device is similar to that of the list data query method, the implementation of the list data query device can refer to the implementation of the list data query method, and the repetition is omitted. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 3 is a block diagram of a list data query apparatus according to an embodiment of the present invention, as shown in fig. 3, the apparatus includes:
the query request receiving module 302 is configured to receive a first query request, and record a query time of the first query request, where the first query request is a query request for requesting to display data of a first page;
the data display module 304 is further configured to load the first page data from the list data for display;
the query request receiving module is also used for receiving a non-first query request;
the data display module is used for displaying the data generated before the query time is loaded from the data list.
In one embodiment, the data in the list data is ordered by production time.
In one embodiment, the data display module is specifically configured to screen the data with the generation time after the query time from the data list, and display the data with the remaining data according to the non-first query request loading response.
In one embodiment, further comprising:
the data display module is also used for displaying data in a paging display or rolling loading mode.
The embodiment of the invention realizes the following technical effects: the method includes the steps that a first query request and a non-first query request are distinguished, the first query request is a query request for requesting to display first page data when list data is queried, the first page data is loaded from the list data based on the first query request for display, the query time of the first query request is recorded, then when the non-first query request is received, data generated before the query time is loaded from a data list for display, the data generated from the query time to the current loading data moment is excluded from the query range of the time, namely the data generated from the query time to the current loading data moment does not influence the data loading and the data displaying based on the non-first query request, the data loading based on the non-first query request is carried out from the unchanged data generated before the query time, the problem that the data loading based on the non-first query request is repeated with the data loaded before is fundamentally avoided, and the problem that the data of the list data query is repeated is avoided; in addition, the method supports a paging display mode and a rolling loading display mode, and the problem of data repetition cannot occur in the paging display mode and the rolling loading display mode; in addition, the data does not need to be cached in the memory, which is beneficial to reducing the occupation of the memory.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the invention described above may be implemented in a general purpose computing device, they may be concentrated on a single computing device, or distributed across a network of computing devices, they may alternatively be implemented in program code executable by computing devices, so that they may be stored in a storage device for execution by computing devices, and in some cases, the steps shown or described may be performed in a different order than what is shown or described, or they may be separately fabricated into individual integrated circuit modules, or a plurality of modules or steps in them may be fabricated into a single integrated circuit module. Thus, embodiments of the invention are not limited to any specific combination of hardware and software.
The above description is only of the preferred embodiments of the present invention and is not intended to limit the present invention, and various modifications and variations can be made to the embodiments of the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (8)
1. A method for querying list data, comprising:
Receiving a first query request, and recording the query time of the first query request, wherein the first query request is a query request for requesting to display the first page of data;
loading first page data from the list data for display;
receiving a non-first query request; wherein, the query request not used for requesting to display the first page of data is a non-first query request;
Loading data generated before the query time from the list data for display;
wherein, the data generated before the query time is loaded from the list data is displayed, and the method comprises the following steps:
Screening the data with the generation time after the query time from the list data, and displaying the data with the residual data according to the data of the non-first query request loading response; the non-first query request load is a load from unchanged data generated prior to the query time.
2. The list data query method of claim 1 wherein the data in the list data is ordered by time of generation.
3. The list data query method of any one of claims 1 to 2, further comprising:
the data is displayed in a paging display or rolling loading mode.
4. A list data query apparatus, comprising:
The inquiry request receiving module is used for receiving a first inquiry request and recording the inquiry time of the first inquiry request, wherein the first inquiry request is an inquiry request for requesting to display the first page of data;
The data display module is also used for loading the first page data from the list data for display;
The query request receiving module is also used for receiving a non-first query request; wherein, the query request not used for requesting to display the first page of data is a non-first query request;
The data display module is used for displaying the data generated before the query time is loaded from the list data;
the data display module is specifically configured to screen the list data for data with the generation time after the query time, and display the remaining data according to the data of the non-first query request loading response; the non-first query request load is a load from unchanged data generated prior to the query time.
5. The list data query device of claim 4 wherein the data in the list data is ordered by time of generation.
6. The list data query apparatus of any one of claims 4 to 5, further comprising:
the data display module is also used for displaying data in a paging display or rolling loading mode.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the list data query method of any of claims 1 to 3 when the computer program is executed by the processor.
8. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program that performs the list data query method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010909835.4A CN112035524B (en) | 2020-09-02 | 2020-09-02 | List data query method, device, computer equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010909835.4A CN112035524B (en) | 2020-09-02 | 2020-09-02 | List data query method, device, computer equipment and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112035524A CN112035524A (en) | 2020-12-04 |
| CN112035524B true CN112035524B (en) | 2024-04-19 |
Family
ID=73591190
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010909835.4A Active CN112035524B (en) | 2020-09-02 | 2020-09-02 | List data query method, device, computer equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112035524B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112699147A (en) * | 2020-12-31 | 2021-04-23 | 京东数字科技控股股份有限公司 | Paging query method, device, equipment and storage medium |
| CN113868315A (en) * | 2021-09-28 | 2021-12-31 | 深圳云之家网络有限公司 | Data rolling loading method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678701A (en) * | 2013-12-31 | 2014-03-26 | 福建四创软件有限公司 | Disaster prevention and reduction information processing system and method based on WebService |
| CN103778135A (en) * | 2012-10-18 | 2014-05-07 | 厦门雅迅网络股份有限公司 | Method for distribution storage and paging querying of real-time data |
| CN103942196A (en) * | 2013-01-17 | 2014-07-23 | 腾讯科技（深圳）有限公司 | Method, device and system for data inquiry |
| CN109657176A (en) * | 2018-10-16 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Web vector graphic state identification method, device, equipment and readable storage medium storing program for executing |
| CN110825603A (en) * | 2019-11-01 | 2020-02-21 | 北京博睿宏远数据科技股份有限公司 | Page first loading time determining method and device, electronic equipment and storage medium |
| CN110866045A (en) * | 2019-10-25 | 2020-03-06 | 广西英腾教育科技股份有限公司 | Data concurrency statistical method, system, medium and equipment |
| CN110888925A (en) * | 2019-10-11 | 2020-03-17 | 广州大气候农业科技有限公司 | Data loading and distributing method and device and storage medium |
| CN111414534A (en) * | 2019-01-07 | 2020-07-14 | 阿里巴巴集团控股有限公司 | Information processing method, device, equipment and storage medium |
-
2020
- 2020-09-02 CN CN202010909835.4A patent/CN112035524B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103778135A (en) * | 2012-10-18 | 2014-05-07 | 厦门雅迅网络股份有限公司 | Method for distribution storage and paging querying of real-time data |
| CN103942196A (en) * | 2013-01-17 | 2014-07-23 | 腾讯科技（深圳）有限公司 | Method, device and system for data inquiry |
| CN103678701A (en) * | 2013-12-31 | 2014-03-26 | 福建四创软件有限公司 | Disaster prevention and reduction information processing system and method based on WebService |
| CN109657176A (en) * | 2018-10-16 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Web vector graphic state identification method, device, equipment and readable storage medium storing program for executing |
| CN111414534A (en) * | 2019-01-07 | 2020-07-14 | 阿里巴巴集团控股有限公司 | Information processing method, device, equipment and storage medium |
| CN110888925A (en) * | 2019-10-11 | 2020-03-17 | 广州大气候农业科技有限公司 | Data loading and distributing method and device and storage medium |
| CN110866045A (en) * | 2019-10-25 | 2020-03-06 | 广西英腾教育科技股份有限公司 | Data concurrency statistical method, system, medium and equipment |
| CN110825603A (en) * | 2019-11-01 | 2020-02-21 | 北京博睿宏远数据科技股份有限公司 | Page first loading time determining method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112035524A (en) | 2020-12-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11734271B2 (en) | Data query method, apparatus and device | |
| US20160142369A1 (en) | Service addressing in distributed environment | |
| CN112035524B (en) | List data query method, device, computer equipment and readable storage medium | |
| CN110032598B (en) | Method and device for updating field and electronic equipment | |
| CN105205014A (en) | Data storage method and device | |
| CN105205157A (en) | Page loading method, device and system | |
| CN110557445A (en) | Access request routing method and device, storage medium and electronic equipment | |
| CN108200196B (en) | Data storage and query method and system based on distributed architecture | |
| CN105631035A (en) | Data storage method and device | |
| CN106202082B (en) | Method and device for assembling basic data cache | |
| CN110175306A (en) | A kind of processing method and processing device of advertising information | |
| CN104657435A (en) | Storage management method for application data and network management system | |
| CN105843559A (en) | Read-write optimization method and system of disk cache system | |
| JP6779307B2 (en) | Method and device for page display | |
| CN111865687B (en) | Service data updating method and device | |
| CN111367948B (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN115426375A (en) | Data processing method and data processing system | |
| US11086849B2 (en) | Methods and systems for reading data based on plurality of blockchain networks | |
| CN109656805B (en) | Method and device for generating code link for business analysis and business server | |
| CN113723991B (en) | Marketing article influence analysis processing method and device | |
| CN116126546B (en) | Performance optimization method and device, electronic equipment and medium | |
| CN113553193B (en) | Mirror image data auditing and distributing processing method and system | |
| CN112258300B (en) | Auditing method and device for order generation | |
| CN112052223A (en) | File uploading method and device, computer equipment and readable storage medium | |
| CN107436918A (en) | Database implementation method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |