CN111460240A - Page turning data query method and device under cross-region multi-activity micro-service architecture - Google Patents

Page turning data query method and device under cross-region multi-activity micro-service architecture Download PDF

Info

Publication number
CN111460240A
CN111460240A CN202010285082.4A CN202010285082A CN111460240A CN 111460240 A CN111460240 A CN 111460240A CN 202010285082 A CN202010285082 A CN 202010285082A CN 111460240 A CN111460240 A CN 111460240A
Authority
CN
China
Prior art keywords
target
data
database
data set
page turning
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.)
Granted
Application number
CN202010285082.4A
Other languages
Chinese (zh)
Other versions
CN111460240B (en
Inventor
柳春晖
陈佳鹏
秦旭果
邹帮山
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jilin Yillion Bank Co ltd
Original Assignee
Jilin Yillion Bank Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jilin Yillion Bank Co ltd filed Critical Jilin Yillion Bank Co ltd
Priority to CN202010285082.4A priority Critical patent/CN111460240B/en
Publication of CN111460240A publication Critical patent/CN111460240A/en
Application granted granted Critical
Publication of CN111460240B publication Critical patent/CN111460240B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/90335Query processing
    • G06F16/90348Query processing by searching ordered data, e.g. alpha-numerically ordered data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1448Management of the data involved in backup or backup restore
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/9038Presentation of query results
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method and a device for inquiring page-turning data under a cross-region multi-activity micro-service architecture, wherein in the method, corresponding data are stored in databases of different regions in advance according to client attributes, and the method comprises the following steps: receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request; querying the target database to obtain each data set associated with the current customer; sequencing the data sets according to a preset identifier to obtain a target data set; and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display. In the query method, the corresponding data is stored in the databases in different regions, the types of the data are not limited, and the obtained target data set is displayed in a paging mode, so that poor sorting performance caused by large data volume is avoided.

Description

Page turning data query method and device under cross-region multi-activity micro-service architecture
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for inquiring page-turning data under a cross-region multi-activity micro-service architecture.
Background
The bank system implements remote multi-activity and micro-service architecture, can realize service system decoupling and service level expansion, and ensures high concurrency and high availability of the service system. The existing client data are all uniformly stored in a database, and users in different regions all initiate query requests according to the database.
At present, the cross-library paging solution under the micro-service architecture in the industry is mainly 1) a global view method 2) a secondary query method, and although the first solution is accurate in data, the reordering performance is poor when the data volume is large; and in the second scheme, the efficiency is improved by adopting a secondary query algorithm on the premise of not losing the accuracy, but the second scheme is only suitable for the traditional relational database sub-database and sub-table scheme and has high restriction by depending on the MySql database.
Disclosure of Invention
In view of the above, the present invention provides a method and an apparatus for querying page-turning data under a cross-region multi-active micro-service architecture, so as to solve the problems that in the existing query process, only a relational database can be used for a database storing data to implement database and table splitting, the restriction is large, and the sorting performance is poor when the data size is large. The specific scheme is as follows:
a method for inquiring page-turning data under a cross-region multi-activity micro-service architecture stores corresponding data in databases of different regions according to client attributes in advance, and comprises the following steps:
receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request;
querying the target database to obtain each data set associated with the current customer;
sequencing the data sets according to a preset identifier to obtain a target data set;
and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display.
Optionally, the method stores data corresponding to the customer attribute in each database of different regions in advance according to the customer attribute, and further includes:
and aiming at any one database, backing up the rest databases in each database in the region to which the database belongs.
Optionally, in the foregoing method, selecting a target database from the databases according to the search request includes:
acquiring a retrieval keyword in the retrieval request;
and traversing each database, and searching the target database according to the search key words.
Optionally, in the method, the sorting the data sets according to a preset identifier to obtain a target data set includes:
traversing each data set to obtain a preset identification of each data in each data set;
sequencing the preset sequencing rule of each preset identifier to obtain target sequencing;
and arranging the data according to the target sequence to obtain the target data set.
Optionally, the method may further include, after the target data set is intercepted according to a preset number of page turning pieces, feeding the intercepted target data set back to a front-end service system for display:
selecting the service element of the current position of the recorded data as a page turning condition identifier;
and storing the minimum position service element and the maximum position service element in the current page according to the page turning condition identifier.
A page-turning data query device under a cross-region multi-activity micro-service architecture stores corresponding data in databases of different regions according to client attributes in advance, and comprises the following steps:
the selection module is used for receiving a retrieval request of a target client and selecting a target database from each database according to the retrieval request;
the query module is used for querying in the target database to obtain each data set associated with the current customer;
the sorting module is used for sorting the data sets according to preset identifications to obtain target data sets;
and the intercepting and displaying module is used for intercepting the target data set according to the preset number of page turning pieces and feeding the intercepted target data set back to the front-end service system for displaying.
Optionally, the apparatus described above, where the querying apparatus stores data corresponding to the client attribute in each database of different regions in advance according to the client attribute, further includes:
and the backup module is used for backing up the rest databases in each database in the region where any database belongs.
The above apparatus, optionally, the selecting module includes:
a keyword obtaining unit, configured to obtain a search keyword in the search request;
and the searching unit is used for traversing each database and searching the target database according to the retrieval key words.
The above apparatus, optionally, the sorting module includes:
the identification acquisition unit is used for traversing each data set and acquiring a preset identification of each data in each data set;
the first sequencing unit is used for sequencing the sequencing rule preset by each preset identifier to obtain target sequencing;
and the second sorting unit is used for sorting the data according to the target sorting to obtain the target data set.
The above apparatus, optionally, the intercepting and displaying module further includes:
the selecting unit is used for selecting the service element of the current position of the recorded data as a page turning condition identifier;
and the storage unit is used for storing the minimum position service element and the maximum position service element in the current page according to the page turning condition identifier.
Compared with the prior art, the invention has the following advantages:
the invention discloses a method and a device for inquiring page-turning data under a cross-region multi-activity micro-service architecture, wherein in the method, corresponding data are stored in databases of different regions in advance according to client attributes, and the method comprises the following steps: receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request; querying the target database to obtain each data set associated with the current customer; sequencing the data sets according to a preset identifier to obtain a target data set; and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display. In the query method, the corresponding data is stored in the databases in different regions, the types of the data are not limited, and the obtained target data set is displayed in a paging mode, so that poor sorting performance caused by large data volume is avoided.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flowchart of a method for querying page-turning data under a cross-region multi-active micro-service architecture according to an embodiment of the present application
Fig. 2 is an architecture diagram of a page-turning data query method under a cross-region multi-active micro service architecture disclosed in the embodiment of the present application;
fig. 3 is a block diagram illustrating a structure of a page-turning data query device under a cross-region multi-active micro service architecture according to an embodiment of the present disclosure.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
The invention discloses a method and a device for inquiring page-turning data under a cross-region multi-activity micro-service architecture, which are applied to the processes of data synchronization, paging inquiry and the like of cross-region inquiry report service, in the prior art, a bank stores client data in a single database in a single-database storage mode, namely all data are stored in one database, aiming at the inquiry process of the single database, in the prior art, 1) a global visual field method 2) a secondary inquiry method is mainly adopted to realize inquiry, and the research finds that although the data is accurate, the reordering performance is poor when the data size is large; and in the second scheme, the efficiency is improved by adopting a secondary query algorithm on the premise of not losing the accuracy, but the second scheme is only suitable for the traditional relational database sub-database and sub-table scheme and has high restriction by depending on the MySql database. Therefore, the invention provides a method for querying page-turning data under a cross-region multi-activity micro-service architecture, which stores corresponding data in databases of different regions according to client attributes in advance, and preferably allocates an identifier to each database, wherein the identifier can be user information, a time period for storing data and the like. Further, for any one database, backup is performed on the rest databases in the region to which the client belongs, where the client attribute refers to the region to which the client belongs when business transaction occurs with the bank, for example, business transaction occurs with the bank in the region a, the region B, and the region C for the current user, so that the corresponding data is stored in the database of the corresponding region, and the region a is backed up with the data of the region B and the region C, the region B is backed up with the data of the region a and the region C, and the region C is backed up with the data of the region a and the region B.
The execution flow of the query method is shown in fig. 1, and includes the steps of:
s101, receiving a retrieval request of a target client, and selecting a target database from each database according to the retrieval request;
in the embodiment of the invention, when a user inputs a retrieval request for a client through a terminal, a retrieval request is generated, the retrieval request can be a transfer record query of the client or a transaction detail query aiming at a certain time period, and the like, the retrieval request is usually a segment of characters, when the retrieval request is received, the retrieval request is analyzed to obtain the retrieval request in the retrieval request, the retrieval request is subjected to word segmentation to obtain retrieval keywords, the retrieval keywords can comprise user information, time information or region information and the like, all databases are traversed, at least one database with the same identification as the retrieval keywords is searched according to the retrieval keywords and is used as a target database, and the target databases are multiple.
S102, inquiring in the target database to obtain each data set associated with the current customer;
in the embodiment of the invention, the target databases are taken as two databases for explanation, the target databases are inquired according to the retrieval keywords to obtain a first data set and a second data set which have an association relationship with the current user, wherein the first data set is taken as an example for explanation of the determining process, the retrieval keywords are assumed as a client A, a time period B and a transfer record, firstly, the data set corresponding to the client A is determined in the target databases, and the data except the time period B in the data and the data of the non-transfer record are removed to obtain the first data set.
S103, sequencing the data sets according to preset identifications to obtain target data sets;
in the embodiment of the present invention, data in the first data set and data in the second data set are sorted according to a preset sequence, but the first data set and the first data set need to be integrated, so that the data need to be sorted again.
And S104, intercepting the target data set according to the preset number of page turning pieces, and feeding back the intercepted target data set to a front-end service system for display.
In the embodiment of the invention, the target data set needs to be displayed on a front-end system in a paging display mode, the number of page turning pieces is preset, and the target data set is intercepted in sequence according to the number of the page turning pieces and then fed back to the front-end system for display.
Further, in the process of displaying by the front-end system, the service element of the current position of the recorded data is selected as a page turning condition identifier, wherein the page turning condition identifier may be a service number, a timestamp, a sub-sequence number, a sequence number, or the like. And storing the minimum position service element and the maximum position service element in the current page according to the page turning condition identifier. For example: if the page turning condition is the sequence number, the minimum sequence number and the maximum sequence number in the current page need to be stored.
The invention discloses a method for inquiring page-turning data under a cross-region multi-activity micro-service architecture, wherein in the method, corresponding data is stored in databases of different regions in advance according to customer attributes, and the method comprises the following steps: receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request; querying the target database to obtain each data set associated with the current customer; sequencing the data sets according to a preset identifier to obtain a target data set; and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display. In the query method, the corresponding data is stored in the databases in different regions, the types of the data are not limited, and the obtained target data set is displayed in a paging mode, so that poor sorting performance caused by large data volume is avoided.
In the embodiment of the present invention, the above query method is used for illustration, and the query method adopts a scheme combining an application platform and a database operation, and packages the data into atomic services such as data inspection, local data query, data query in different places, data result set ordering, and the like, so as to complete service arrangement of query-in-order, provide a cross-library paging API service interface, and issue the service interface to a distributed service registry in my row for a front-end service system to call, form a middle platform in the cross-library paging technology, and form an overall architecture diagram as shown in fig. 2,
the method comprises the following steps that 1, a front-end business system sends data to a combined service platform, the combined service platform is a basic platform based on an SOA architecture system and is arranged between the front-end business system and a core system, atomic services of the core system are arranged and assembled, a reusable combined flow with business meaning is assembled, and the combined flow is provided for a channel system to be called in a coarse-grained service mode.
(1) The front-end service system can select the service elements of the current position of the recorded data according to the service characteristics for page turning condition identification, such as service numbers, timestamps, sequence numbers and the like, wherein the service elements are generally sorted according to ascending sequence of time sequence, and unique integer numbers are ensured, so that the accuracy and the safety of the query result can be ensured.
(2) And each page saves the service element value of the current minimum position and the service element value of the current maximum position according to the returned query record and the page turning identification.
(3) And when the current page is m pages, the data information of the nth page needs to be pulled, the front end needs to send the page turning identification field of the m pages (the maximum timestamp and the sequence number existing in the current page), the current page number m and the page number n of the target query.
2, the front-end service system calls core system services, firstly, the services are routed to a combined service platform for service splitting processing, the combined service platform performs service arrangement and assembly according to service logic, calls local and allopatric data query services, and queries local Tidb (Tidb1 and Tidb2) database clusters according to query service parameters;
(1) and the background acquires fields such as page turning identification, destination page number and the like sent from the front end, and the number of the inquired pieces is calculated by multiplying (destination inquiry page number n-current page number m) by the number of the displayed pieces of each page.
(2) And calling a combined service platform to perform cross-library combined data query.
(3) The method comprises the steps that for example, the account accounting detail of an account A is inquired, a front-end service system sends the account A, service information elements such as a time period and the like through the Internet or a client, a combined service platform acquires field and page turning identification information, data inquiry services of different regions are respectively called to inquire a local Tidb (Tidb1 and Tidb2) core database to acquire data, the database stores the account accounting detail, accounting entry and the like, after inquiry is completed, data inquiry results of the different regions are combined into a new L ist, the inquiry result set needs to be stored in a local memory of a server, data reordering in the memory is needed in follow-up operation, therefore, page turning intervals need to be controlled within a certain range to prevent the server from being down due to overlarge data, for example, the current page is page 1, 100 items of detail data are displayed on each page, if page 50 is inquired, 100 items of data sets of the inquiry services of the different regions need to be respectively inquired and stored in the memory, and potential performance hazards are caused, and therefore, the page turning interval system can set parameters to ensure that the page turning interval is within a certain.
3, the data service returns the query result set to the BIP system, and the BIP system sorts the query result set according to uniqueness factors such as time stamps, service numbers, service serial numbers and the like;
in the embodiment of the invention, the combined service platform calls the data sorting service to reorder the searched combined data result set L ist, and the service can form uniqueness constraint field sorting for key ordered uniqueness fields such as time stamps, sequence numbers and the like, for example, sorting according to the ascending order of the service numbers and the time stamps.
And 4, after finishing sequencing, the BIP system intercepts and returns the target query data to the front-end service system according to the number of page turning pieces.
After finishing sorting, calculating a result data set required to be returned according to the number of the data required to be returned in each page, intercepting the query data result set from L ist, simultaneously returning fields such as time stamps, sequence numbers and the like in the initial position and the end position of the data query result set to the front end, and displaying the fields to a client through the front end.
Preferably, related data of a core system related to reports and details can be periodically extracted according to the reserved port, and historical data of different regions are stored by using the HDFS, so that historical transactions can be inquired through an external system connected with the reserved port, and the pressure of online transactions on a core database is reduced.
In the embodiment of the invention, a plurality of industry mainstream open-source technology frameworks are adopted in the query method, for example, a distributed database Tidb which can be elastically expanded and supports online O L TP and O L AP is adopted in the database, the open-source distributed service framework Dubbo is selected by calling a combined service platform, an external system performs extraction and analysis by adopting technologies such as Sqoop and Spark, and the paging query and synchronization problems of bank transaction data among different data centers are realized by redesigning an application layer and a data layer and performing service packaging.
Based on the above method for querying page-turning data under a cross-region multi-active micro-service architecture, an embodiment of the present invention provides a device for querying page-turning data under a cross-region multi-active micro-service architecture, where the querying device stores data corresponding to the querying device in each database of different regions according to a client attribute in advance, and a structural block diagram of the querying device is shown in fig. 3, and includes:
the system comprises a selecting module 201, a query module 202, a sorting module 203 and an intercepting and presenting module 204.
Wherein,
the selecting module 201 is configured to receive a retrieval request for a target client, and select a target database from the databases according to the retrieval request;
the query module 202 is configured to query the target database to obtain each data set associated with the current customer;
the sorting module 203 is configured to sort the data sets according to a preset identifier to obtain a target data set;
the intercepting and displaying module 204 is configured to intercept the target data set according to a preset number of page turning pieces, and feed the intercepted target data set back to the front-end service system for displaying.
The invention discloses a page turning data query device under a cross-region multi-activity micro service architecture, in the method, corresponding data is stored in databases of different regions in advance according to client attributes, and the method comprises the following steps: receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request; querying the target database to obtain each data set associated with the current customer; sequencing the data sets according to a preset identifier to obtain a target data set; and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display. In the query device, the corresponding data is stored in the databases in different regions, the types of the data are not limited, and the obtained target data set is displayed in a paging mode, so that poor sorting performance caused by large data volume is avoided.
In the embodiment of the present invention, the querying device stores the corresponding data in each database of different regions according to the client attribute in advance, and further includes: a backup module 205.
Wherein,
the backup module 205 is configured to backup, for any one database, the remaining databases in each database in the region to which the database belongs.
In the embodiment of the present invention, the selecting module 201 includes:
a keyword acquisition unit 206 and a search unit 207.
Wherein,
the keyword obtaining unit 206, configured to obtain a search keyword in the search request;
the search unit 207 is configured to traverse the databases, search the target database according to the search keyword,
in this embodiment of the present invention, the sorting module 203 includes:
an identity acquisition unit 208, a first ordering unit 209 and a second ordering unit 210.
The identifier obtaining unit 208 is configured to traverse the data sets, and obtain a preset identifier of each data in the data sets;
the first sorting unit 209 is configured to sort the sorting rules preset by each preset identifier to obtain a target sorting;
the second sorting unit 210 is configured to sort the data according to the target sorting to obtain the target data set.
In the embodiment of the present invention, the intercepting and displaying module further includes:
a selecting unit 211 and a saving unit 212.
Wherein,
the selecting unit 211 is configured to select a service element of the current position of the recorded data as a page turning condition identifier;
the saving unit 212 is configured to save the minimum location service element and the maximum location service element in the current page according to the page turning condition identifier.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. For the device-like embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functions of the units may be implemented in the same software and/or hardware or in a plurality of software and/or hardware when implementing the invention.
From the above description of the embodiments, it is clear to those skilled in the art that the present invention can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the embodiments or some parts of the embodiments.
The invention provides a method and a device for inquiring page-turning data under a cross-region multi-activity micro-service architecture. The detailed description is given, and the principle and the embodiment of the present invention are explained by applying specific examples, and the above description of the embodiments is only used to help understanding the method and the core idea of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.

Claims (10)

1. A method for inquiring page-turning data under a cross-region multi-activity micro-service architecture is characterized in that corresponding data is stored in databases of different regions in advance according to customer attributes, and the method comprises the following steps:
receiving a retrieval request for a target client, and selecting a target database from each database according to the retrieval request;
querying the target database to obtain each data set associated with the current customer;
sequencing the data sets according to a preset identifier to obtain a target data set;
and intercepting the target data set according to a preset number of page turning pieces, and feeding the intercepted target data set back to a front-end service system for display.
2. The method according to claim 1, wherein the corresponding data is stored in each database of different regions according to the client attribute in advance, further comprising:
and aiming at any one database, backing up the rest databases in each database in the region to which the database belongs.
3. The method of claim 1, wherein selecting a target database from the databases based on the search request comprises:
acquiring a retrieval keyword in the retrieval request;
and traversing each database, and searching the target database according to the search key words.
4. The method of claim 1, wherein sorting the data sets according to a preset identifier to obtain a target data set comprises:
traversing each data set to obtain a preset identification of each data in each data set;
sequencing the preset sequencing rule of each preset identifier to obtain target sequencing;
and arranging the data according to the target sequence to obtain the target data set.
5. The method of claim 1, wherein the target data set is intercepted according to a preset number of page turning pieces and then fed back to a front-end service system for display, further comprising:
selecting the service element of the current position of the recorded data as a page turning condition identifier;
and storing the minimum position service element and the maximum position service element in the current page according to the page turning condition identifier.
6. A page turning data query device under a cross-region multi-activity micro service architecture is characterized in that corresponding data are stored in databases of different regions in advance according to customer attributes, and the page turning data query device comprises:
the selection module is used for receiving a retrieval request of a target client and selecting a target database from each database according to the retrieval request;
the query module is used for querying in the target database to obtain each data set associated with the current customer;
the sorting module is used for sorting the data sets according to preset identifications to obtain target data sets;
and the intercepting and displaying module is used for intercepting the target data set according to the preset number of page turning pieces and feeding the intercepted target data set back to the front-end service system for displaying.
7. The apparatus according to claim 6, wherein the querying device stores the corresponding data in each database of different regions according to the client attribute in advance, further comprising:
and the backup module is used for backing up the rest databases in each database in the region where any database belongs.
8. The apparatus of claim 6, wherein the selecting module comprises:
a keyword obtaining unit, configured to obtain a search keyword in the search request;
and the searching unit is used for traversing each database and searching the target database according to the retrieval key words.
9. The apparatus of claim 6, wherein the ordering module comprises:
the identification acquisition unit is used for traversing each data set and acquiring a preset identification of each data in each data set;
the first sequencing unit is used for sequencing the sequencing rule preset by each preset identifier to obtain target sequencing;
and the second sorting unit is used for sorting the data according to the target sorting to obtain the target data set.
10. The apparatus of claim 9, wherein the intercepting presentation module further comprises:
the selecting unit is used for selecting the service element of the current position of the recorded data as a page turning condition identifier;
and the storage unit is used for storing the minimum position service element and the maximum position service element in the current page according to the page turning condition identifier.
CN202010285082.4A 2020-04-13 2020-04-13 Cross-region multi-activity micro-service architecture page turning data query method and device Active CN111460240B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010285082.4A CN111460240B (en) 2020-04-13 2020-04-13 Cross-region multi-activity micro-service architecture page turning data query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010285082.4A CN111460240B (en) 2020-04-13 2020-04-13 Cross-region multi-activity micro-service architecture page turning data query method and device

Publications (2)

Publication Number Publication Date
CN111460240A true CN111460240A (en) 2020-07-28
CN111460240B CN111460240B (en) 2023-08-15

Family

ID=71680251

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010285082.4A Active CN111460240B (en) 2020-04-13 2020-04-13 Cross-region multi-activity micro-service architecture page turning data query method and device

Country Status (1)

Country Link
CN (1) CN111460240B (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112148710A (en) * 2020-09-21 2020-12-29 珠海市卓轩科技有限公司 Micro-service database dividing method, system and medium
CN113282617A (en) * 2021-05-31 2021-08-20 北京中祥英科技有限公司 Data query method and business system page turning method
CN114238730A (en) * 2021-12-21 2022-03-25 中国建设银行股份有限公司 Method and apparatus for data retrieval
CN115481187A (en) * 2022-09-28 2022-12-16 北京亚控科技发展有限公司 Data reading and writing method and device and storage medium

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100153409A1 (en) * 2008-12-12 2010-06-17 Joshi Mahesh V Computer-Implemented Systems And Methods For Providing Paginated Search Results From A Database
CN106649435A (en) * 2016-09-07 2017-05-10 努比亚技术有限公司 Data query device and method of querying data
CN107103032A (en) * 2017-03-21 2017-08-29 中国科学院计算机网络信息中心 The global mass data paging query method sorted is avoided under a kind of distributed environment
CN107315753A (en) * 2016-04-27 2017-11-03 北京京东尚科信息技术有限公司 Across the paging method and device of multiple database
CN107918642A (en) * 2017-10-26 2018-04-17 深圳市金立通信设备有限公司 Data query method, server and computer-readable recording medium
CN109684528A (en) * 2018-12-04 2019-04-26 深圳店匠科技有限公司 Inter-library paging query method, system and storage medium
CN110555034A (en) * 2018-03-28 2019-12-10 武汉斗鱼网络科技有限公司 Data query paging method, device, server and medium

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100153409A1 (en) * 2008-12-12 2010-06-17 Joshi Mahesh V Computer-Implemented Systems And Methods For Providing Paginated Search Results From A Database
CN107315753A (en) * 2016-04-27 2017-11-03 北京京东尚科信息技术有限公司 Across the paging method and device of multiple database
CN106649435A (en) * 2016-09-07 2017-05-10 努比亚技术有限公司 Data query device and method of querying data
CN107103032A (en) * 2017-03-21 2017-08-29 中国科学院计算机网络信息中心 The global mass data paging query method sorted is avoided under a kind of distributed environment
CN107918642A (en) * 2017-10-26 2018-04-17 深圳市金立通信设备有限公司 Data query method, server and computer-readable recording medium
CN110555034A (en) * 2018-03-28 2019-12-10 武汉斗鱼网络科技有限公司 Data query paging method, device, server and medium
CN109684528A (en) * 2018-12-04 2019-04-26 深圳店匠科技有限公司 Inter-library paging query method, system and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
走在小路: "《数据库-跨库分页的几种常见方案》" *
赵久利: "《一类分布数据查询及分页定位的设计与实现》" *

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112148710A (en) * 2020-09-21 2020-12-29 珠海市卓轩科技有限公司 Micro-service database dividing method, system and medium
CN112148710B (en) * 2020-09-21 2023-11-14 珠海市卓轩科技有限公司 Micro-service library separation method, system and medium
CN113282617A (en) * 2021-05-31 2021-08-20 北京中祥英科技有限公司 Data query method and business system page turning method
CN114238730A (en) * 2021-12-21 2022-03-25 中国建设银行股份有限公司 Method and apparatus for data retrieval
CN115481187A (en) * 2022-09-28 2022-12-16 北京亚控科技发展有限公司 Data reading and writing method and device and storage medium
CN115481187B (en) * 2022-09-28 2023-11-21 北京亚控科技发展有限公司 Data reading and writing method, device and storage medium

Also Published As

Publication number Publication date
CN111460240B (en) 2023-08-15

Similar Documents

Publication Publication Date Title
CN111460240A (en) Page turning data query method and device under cross-region multi-activity micro-service architecture
JP4634685B2 (en) Data linking system and method using tokens
US6721760B1 (en) Method and apparatus for searching multi-dimensional database and storage medium stored search program of multi-dimensional database
EP2702510B1 (en) Joining tables in a mapreduce procedure
WO2021068549A1 (en) Data processing method, platform and system
CN109325078A (en) Data blood margin determination method and device based on structural data
US9251212B2 (en) Profiling in a massive parallel processing environment
CA3176450A1 (en) Method and apparatus for implementing incremental data consistency
CN107451208B (en) Data searching method and device
US11216516B2 (en) Method and system for scalable search using microservice and cloud based search with records indexes
CN105468720A (en) Method for integrating distributed data processing systems, corresponding systems and data processing method
US8943042B2 (en) Analyzing and representing interpersonal relations
CN112269816B (en) Government affair appointment correlation retrieval method
CN111339171B (en) Data query method, device and equipment
Huang et al. Mining frequent and top-k high utility time interval-based events with duration patterns
AU2011247915B2 (en) Enhancing an inquiry for a search of a database
CN105843956A (en) Paging query method and system
CN105760380A (en) Database query method, device and system
US20090327339A1 (en) Partition templates for multidimensional databases
US7725433B1 (en) Data navigation system and method employing data transformation lineage model
CN109189810B (en) Query method, query device, electronic equipment and computer-readable storage medium
CN109492006B (en) Mass data processing method and device based on Oracle
CN111563112A (en) Data search and display system based on cross-border trade big data
US11048728B2 (en) Dependent object analysis
US20120109875A1 (en) Organization of data mart using clustered key

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
GR01 Patent grant