CN116226498A - Data query method, device and equipment - Google Patents

Abstract

The embodiment of the application provides a data query method, a device and equipment. The method comprises the following steps: acquiring a query request, wherein the query request comprises at least one first service list number, at least one first query table identifier and at least one first element corresponding to each first query table; obtaining a corresponding relation between a query table and a list table, wherein the list table comprises at least one element and at least one piece of service information corresponding to each element; and determining a query result corresponding to the query request according to the query request and the corresponding relation, wherein the query result comprises the at least one first service list number and service data corresponding to each first service list number. The timeliness is guaranteed, and meanwhile, the data query efficiency is improved.

Description

Data query method, device and equipment

technical field

The embodiments of the present application relate to the field of computer technology, and in particular, to a data query method, device, and equipment.

Background technique

Staff can conduct data query through the enterprise's core business system to obtain corresponding business information.

In related technologies, data query can be performed in the following manner: a user can input element information on a query page provided by a terminal device and send it to a server. According to the element information input by the user, the server determines the business information corresponding to the element information in the business system database stored in the server and sends it to the terminal device. In the above process, when multiple users query the business information of the same business in the business system at the same time, if the element information input by each user is different, the server will simultaneously determine the corresponding business information based on the element information input by each user and sent to the user. Multiple queries at the same time at the same time may cause the server to freeze or fail, resulting in low data query efficiency.

Contents of the invention

Embodiments of the present application provide a data query method, device, and equipment to solve the problem of low data query efficiency.

In the first aspect, the embodiment of the present application provides a data query method, including:

Obtaining a query request, the query request including at least one first business order number, at least one first query table identifier, and at least one first element corresponding to each first query table;

Obtain the correspondence between the query table and the columnar table, where the columnar table includes at least one element and at least one piece of business information corresponding to each element;

According to the query request and the corresponding relationship, determine a query result corresponding to the query request, where the query result includes the at least one first business order number and business data corresponding to each first business order number.

In a possible implementation manner, determining a query result corresponding to the query request according to the query request and the correspondence relationship includes:

Determine a target columnar table corresponding to each first lookup table according to the identifier of the at least one first lookup table and the corresponding relationship;

According to the at least one first business order number and at least one first element corresponding to each of the first query tables, determine the business data corresponding to the query request in a plurality of target column tables;

The query result is generated according to the at least one first service order number and the service data corresponding to each first service order number.

In a possible implementation manner, for any target columnar table, according to the at least one first business order number and the at least one first element, determine in the target columnar table that the query request corresponds to business data, including:

In the target columnar table, determine the business information set corresponding to at least one first element;

determining the business information corresponding to the at least one first business order number in each business information set;

The business information is determined as business data corresponding to the query request.

In a possible implementation manner, for any set of business information, determining the business information corresponding to the at least one first business order number in the set of business information includes:

determining primary key information corresponding to the first query table;

The service information is determined in the service information set according to the at least one first service order number and the primary key information.

In a possible implementation manner, according to the at least one first service order number and the primary key information, determining the service information in the service information set includes:

Judging whether the quantity of the primary key information is 1;

If so, in the set of business information, determine a piece of business information corresponding to each first business order number as the business data corresponding to the query request;

If not, in the service information set, determine multiple pieces of service information corresponding to each first service order number as service data corresponding to the query request.

In a possible implementation manner, the method also includes:

Acquiring a change log of the service information in the service database, the change log including the updated first service information;

In multiple columnar tables, determine original service information corresponding to the first service information;

The original service information in the columnar table is updated to the first service information according to the change log.

In a possible implementation manner, obtaining a query request includes:

The query request sent by the terminal device is received.

In a possible implementation manner, after determining the query result corresponding to the query request according to the query request and the corresponding relationship, the method further includes:

Send the query result to the terminal device.

In the second aspect, the embodiment of the present application provides a data query device, the device includes:

A first obtaining module, configured to obtain a query request, the query request including at least one first business order number, at least one first query table identifier, and at least one first element corresponding to each first query table;

The second obtaining module is used to obtain the corresponding relationship between the query table and the columnar table, the columnar table includes at least one element and at least one piece of business information corresponding to each element;

A determining module, configured to determine a query result corresponding to the query request according to the query request and the corresponding relationship, the query result including the at least one first business order number and the corresponding information of each first business order number business data.

In a possible implementation manner, the determining module is specifically configured to:

Determine a target columnar table corresponding to each first lookup table according to the identifier of the at least one first lookup table and the corresponding relationship;

According to the at least one first business order number and at least one first element corresponding to each of the first query tables, determine the business data corresponding to the query request in a plurality of target column tables;

The query result is generated according to the at least one first service order number and the service data corresponding to each first service order number.

In a possible implementation manner, the determining module is specifically configured to:

In the target columnar table, determine the business information set corresponding to at least one first element;

determining the business information corresponding to the at least one first business order number in each business information set;

The business information is determined as business data corresponding to the query request.

In a possible implementation manner, the determining module is specifically configured to:

determining primary key information corresponding to the first query table;

The service information is determined in the service information set according to the at least one first service order number and the primary key information.

In a possible implementation manner, the determining module is specifically configured to:

Judging whether the quantity of the primary key information is 1;

If so, in the set of business information, determine a piece of business information corresponding to each first business order number as the business data corresponding to the query request;

If not, in the service information set, determine multiple pieces of service information corresponding to each first service order number as service data corresponding to the query request.

In a possible implementation manner, the device further includes an updating module, a receiving module, and a sending module.

Among them, the update module is used for:

Acquiring a change log of the service information in the service database, the change log including the updated first service information;

In multiple columnar tables, determine original service information corresponding to the first service information;

The original service information in the columnar table is updated to the first service information according to the change log.

The receiving module is used for:

The query request sent by the terminal device is received.

The sending module is used for:

Send the query result to the terminal device.

In a third aspect, the embodiment of the present application provides a data query device, including:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can execute the method according to any one of the first aspect.

In a fourth aspect, an embodiment of the present application provides a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause the computer to execute the method described in any one of the first aspects.

In a fifth aspect, an embodiment of the present application provides a computer program product, including a computer program, and when the computer program is executed by a processor, implements the method described in any one of the first aspect.

The data query method, device, and device provided in the embodiments of the present application are provided with a data query device, and a plurality of columnar tables are stored in the data query device. When performing data query, the data query device obtains a query request, and the query request includes the first service order number, the identifier of the first query table and at least one first element. Get the correspondence between the query table and the columnar table. According to the query request and the corresponding relationship, the query result corresponding to the query request is determined. The query result includes the first business order number and business data corresponding to at least one first element. In the above process, since the business data corresponding to the first element can be obtained in the data query device according to the corresponding relationship between the query table of the business database and the columnar table, and the query request, instead of directly obtaining the first element in the business database The business information corresponding to the elements decouples the data query from the business database of the core system. In addition, business information corresponding to different first elements can be obtained simultaneously, thereby improving the efficiency of data query.

Description of drawings

FIG. 1 is a schematic diagram of an application scenario provided by an embodiment of the present application;

FIG. 2 is a schematic flow diagram of a data query method provided in an embodiment of the present application;

FIG. 3 is a schematic flow diagram of another data query method provided in the embodiment of the present application;

FIG. 4 is a schematic diagram of the relationship between the database provided by the embodiment of the present application;

FIG. 5 is a schematic diagram of the data query process provided by the embodiment of the present application;

FIG. 6 is a schematic structural diagram of a data query device provided in an embodiment of the present application;

FIG. 7 is a schematic structural diagram of another data query device provided in the embodiment of the present application;

FIG. 8 is a schematic structural diagram of a data query device provided by an embodiment of the present application.

Detailed ways

Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

It should be noted that, in this document, the term "comprising", "comprising" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article or apparatus comprising a set of elements includes not only those elements, It also includes other elements not expressly listed, or elements inherent in the process, method, article, or device. Without further limitations, an element defined by the phrase "comprising a ..." does not preclude the presence of additional identical elements in the process, method, article, or apparatus comprising that element.

For ease of understanding, the application scenario applicable to the embodiment of the present application will be described below with reference to FIG. 1 .

FIG. 1 is a schematic diagram of an application scenario provided by an embodiment of the present application. Please refer to FIG. 1 , which includes a terminal device 101 and a server 102 . The terminal device 101 may be a tablet computer, a computer, and the like. A query page is set in the terminal device 101 . A business database is set in the server 102 . Multiple pieces of business information (business information 1, business information 2, . . . , business information N) are stored in the business database. The user can input element information on the display page provided by the terminal device 101 and send it to the server 102 . According to the element information, the server 102 determines the service information corresponding to the element information in the service database of the server 102 . The server 102 sends the service information corresponding to the element information to the terminal device 101, so that the user can obtain the data query result.

In related technologies, data query can be performed in the following manner: when multiple users query the business information of the same business in the business system at the same time, the server will simultaneously determine the corresponding business information according to the element information input by each user and send the to the user. Multiple queries at the same time at the same time may cause the server corresponding to the core business system to freeze or fail, resulting in low data query efficiency.

In the embodiment of the present application, a data query device is provided, and multiple columnar tables are stored in the data query device. When performing data query, the data query device obtains a query request, and the query request includes the first service order number, the identifier of the first query table and at least one first element. Get the correspondence between the query table and the columnar table. According to the query request and the corresponding relationship, the query result corresponding to the query request is determined. The query result includes the first business order number and business data corresponding to at least one first element. In the above process, since the business data corresponding to the first element can be obtained in the data query device according to the corresponding relationship between the query table of the business database and the columnar table, and the query request, instead of directly obtaining the first element in the business database The business information corresponding to the elements decouples the data query from the business database of the core system. In addition, business information corresponding to different first elements can be obtained in real time, thereby improving the efficiency of data query.

In the following, the method shown in this application will be described through specific examples. It should be noted that the following embodiments may exist independently or be combined with each other, and the same or similar content will not be repeatedly described in different embodiments.

FIG. 2 is a schematic flowchart of a data query method provided by an embodiment of the present application. See Figure 2, the method can include:

S201. Obtain a query request.

The executor of this embodiment of the present application may be a data query device, or may be a data query device installed in the data query device. The data query device can be implemented by software, or by a combination of software and hardware. The data query device may be a server.

The query request includes that the query request includes at least one first service order number, at least one identifier of the first query table, and at least one first element corresponding to each first query table.

The acquisition query request may include two situations.

Case 1. The user can input a query request on the query page provided by the terminal device and send the query request to the data query device. The user may input multiple first elements corresponding to the same business order number, or may input the same first element corresponding to multiple business order numbers.

Case 2. Other business systems send a data query request to the data query device by inputting a business order number and at least one first element through an interface call.

The query table is a query table stored in the business database, and the query table includes multiple pieces of business information. The business database is set in the server corresponding to the core system, and multiple query tables are stored in the business database.

For example, assume that the user queries the insurance start time and insurance end time of insurance A. The query request that the user can input on the query page provided by the terminal device can be specifically shown in Table 1:

Table 1

First business order number PADC2023A14023751F ID of the first lookup table PRPCM first element Insurance start time, insurance end time

S202. Obtain the corresponding relationship between the query table and the columnar table.

The columnar table includes at least one element and at least one piece of business information corresponding to each element.

The name of each column of the columnar table can be in the form of query table-query table element name. The primary key information in the columnar table can be a business order number. A column-style table of business information corresponding to an element is determined as an empty column-style table. If the columnar table is an empty columnar table, the business data corresponding to the query request obtained through data query is empty.

The structural relationship of each business information in the columnar database is different from the structural relationship of each business information in the business system database. The corresponding relationship between the query table and the columnar table, and multiple columnar tables can be stored in the columnar database in advance, and the columnar database is set in the data query device. The columnar database can be HBase, Vertica and other databases.

For example, the columnar table corresponding to the basic policy information of insurance company A can be shown in Table 2:

Table 2

Business order number Policyholder insurance start time insurance termination time PADC2023A14023751F User A 2023.01.01 2025.01.01 PADC2023B24502152C User B 2023.05.01 2025.12.31

The quantity of business information in the columnar table corresponding to the query table can be determined according to the primary key information corresponding to the query table.

For example, the corresponding relationship between the query table and the columnar table can be specifically shown in Table 3:

table 3

ID of the lookup table ID of the columnar table primary key information PRPCM hbaseTable-A0201 Business order number PRPCIN hbaseTable-A0110 Business order number, serial number

According to Table 3, it can be determined that the primary key information corresponding to the query table PRPCM is the business order number, and then the corresponding relationship between the query table PRPCM and the columnar table hbaseTable-A0201 is determined to be one-to-one, that is, the query table PRPCM corresponds to the columnar table hbaseTable-A0110 1 piece of business information. The correspondence between the query table and the columnar table can be expressed as PRPCM:1:hbaseTable-A0201. According to Table 3, it can be determined that the primary key information corresponding to the query table PRPCIN is the business order number and serial number, and then it is determined that the corresponding relationship between the query table PRPCIN and the columnar table hbaseTable-A0110 is a pair of M, and M is an integer greater than or equal to 1. That is, the query table PRPCIN corresponds to M pieces of business information in the columnar table hbaseTable-A0110. The correspondence between the query table and the columnar table can be expressed as PRPCM:M:hbaseTable-A0201.

S203. Determine a query result corresponding to the query request according to the query request and the corresponding relationship.

The query result includes at least one first business order number and business data corresponding to each first business order number.

The query result corresponding to the query request can be determined in the following manner: according to the identification and corresponding relationship of at least one first query table, determine the target columnar table corresponding to each first query table; The at least one first element corresponding to a query table determines the service data corresponding to the query request in multiple target columnar tables; generates a query result according to the first service order number and the business data.

For example, according to the query request shown in Table 1 above, it is determined that the first query table is PRPCM. According to the correspondence between the lookup table and the columnar table shown in Table 3 above, it is determined that the columnar table corresponding to the first lookup table PRPCM is hbaseTable-A0201. The column table hbaseTable-A0201 can be specifically shown in Table 4:

Table 4

Business order number Policyholder insurance start time insurance termination time PADC2021S12450101T User C 2021.01.01 2024.01.01 PADC2022A0124501T User D 2022.01.01 2022.12.31 PADC2023B24502152C User B 2023.05.01 2025.12.31 PADC2023A14023751F User A 2023.01.01 2025.01.01

According to the above Table 3, it can be determined that the query request corresponds to one piece of business information in the columnar table hbaseTable-A0110. According to the first business order number shown in Table 1 and the columnar table shown in Table 4, it can be determined that the business data corresponding to the query request is the insurance start time 2023.01.01 and the insurance end time 2025.01.01. Therefore, the query result includes the first business order number PADC2023A14023751F, the insurance start time 2023.01.01, and the insurance termination time 2025.01.01.

The data query method provided in the embodiment of this application obtains a query request. Obtain the correspondence between the query table and the columnar table. According to the query request and the corresponding relationship, the query result corresponding to the query request is determined. In the above process, since the business data corresponding to the first element can be obtained in the data query device according to the corresponding relationship between the query table of the business database and the columnar table, and the query request, instead of directly obtaining the first element in the business database The business information corresponding to the elements enables data query to be decoupled from the business database of the core system while ensuring timeliness. At the same time, the function of the interface is maximized through the parameterization of element information, which improves the efficiency of data query.

On the basis of any one of the above embodiments, the detailed process of data query will be described below with reference to FIG. 3 .

FIG. 3 is a schematic flowchart of another data query method provided by the embodiment of the present application. See Figure 3, the method includes:

S301. Obtain a query request.

When obtaining a query request, if there are multiple query tables in the query condition, the identifier of the first query table can be determined in the form of the query table name + the first element, so as to quickly determine the first query table corresponding to each first element of the query request. lookup table.

For example, the first element of the query request includes the insurance start time, the insurance end time, and the insured. It can be determined that the insurance start time and insurance termination time belong to the lookup table PRPCM, and the insured belongs to the lookup table PRPCIN. The identifier of the first lookup table can be determined in the form of lookup table name+first element. That is, the first lookup table identifier corresponding to the query request may include PRPCM (insurance start time, insurance end time) and PRPCIN (insured).

The identification of the first query table is determined by the method of the query table name + the first element, which can avoid the process of the server traversing the query table to determine the first element during data query, and improve the efficiency of data query.

S302. Obtain the corresponding relationship between the query table and the columnar table.

The corresponding relationship between the query table and the columnar table can be set in advance and stored in the preset storage space of the data query device.

S303. Determine a target columnar table corresponding to each first lookup table according to the identifier and the corresponding relationship of at least one first lookup table.

The identifier of the target columnar table corresponding to the first lookup table may be determined in the corresponding relationship according to the identifier of the first lookup table. According to the identifier of the target columnar table, the corresponding target columnar table is determined in the columnar database.

For example, the corresponding relationship between the query table and the columnar table can be specifically shown in Table 5:

table 5

ID of the lookup table ID of the columnar table PRPCM hbaseTable-A0201 PRPCIN hbaseTable-A0110 PRPCA hbaseTable-B0001 PRPCF hbaseTable-C0002

Assume that the identifier of the first lookup table is determined to be PRPCIN according to the lookup request. According to the corresponding relationship shown in Table 5, it is determined that the identifier of the column-type table corresponding to the identifier PRPCIN of the first lookup table is hbaseTable-A0110. Therefore, determine the columnar table corresponding to hbaseTable-A0110 as the target columnar table in the columnar database.

S304. For any target columnar table, determine a business information set corresponding to at least one first element in the target columnar table.

For example, the target columnar table corresponding to hbaseTable-A0110 determined according to the above example can be shown in Table 6:

Table 6

Assume that the first element is the insured and the ID number. Then it can be determined that the business information set corresponding to the first element is the column corresponding to the insured in Table 6, and the column corresponding to the certificate number in Table 6.

S305. For any set of business information, determine primary key information corresponding to the first lookup table.

The primary key information corresponding to the query table may be stored in a preset storage space of the data query device.

The primary key information is the information that associates all business information to generate a query table.

For example, for insurance company A, multiple policy basic information tables can be associated according to the insurance policy number to generate a policy information query table. The primary key information corresponding to the policy information query table is the policy number.

Primary key information can include serial numbers. Sequence numbers are used to indicate dynamic columns in columnar databases.

For example, if the serial numbers of two insureds corresponding to a business order number are 1 and 2, the corresponding positions in the columnar table HbaseTableA are listed as $1 and $2.

The dynamic column is to be compatible with the one-to-many business information of the business order number. An element with a dynamic column will have multiple pieces of business information under one business order number. For example, under one business order number, there will be multiple business information corresponding to elements such as the ID number of the insured and the name of the insured.

S306. Determine whether the quantity of primary key information is 1.

If yes, execute S307.

If not, execute S308.

S307. Determine a piece of business information corresponding to each first business order number as business data corresponding to the query request.

For example, assuming that the identifier of the first lookup table is determined to be PRPCM according to the query request, and the primary key information corresponding to the lookup table PRPCM is determined to be the service order number. According to the identification PRPCM of the first lookup table and the corresponding relationship shown in Table 5 above, it is determined that the target columnar table corresponding to the first lookup table PRPCM is hbaseTable-A0201. Then in the target columnar table hbaseTable-A0201, determine the business information set corresponding to the first element as the column corresponding to the policyholder. In the service information set, a piece of service information user A corresponding to the first service order number PADC2023A14023751F is determined as the service data corresponding to the query request.

After S307, execute S309.

S308. In the business information set, determine multiple pieces of business information corresponding to each first business order number as business data corresponding to the query request.

For example, assuming that the first element is the insured and the certificate number, according to the target column table hbaseTable-A0110 shown in Table 6 above, it can be determined that the business information set corresponding to the first element is the column corresponding to the insured in Table 6 , and the column corresponding to the document number in Table 6. In the business information set, two pieces of business information corresponding to the first business order number PADC2022A0124501T are determined as the business data corresponding to the query request. The specific business data can be shown in Table 7:

Table 7

Insured ID number User F 60212403548596705 User B 21306460844561098

S309. Generate a query result according to at least one first business order number and business data corresponding to each first business order number.

For example, according to the first business order number PADC2022A0124501T and the business data shown in Table 7 above, the generated query results can be specifically shown in Table 8:

Table 8

S310. Send the query result to the terminal device.

The query result can be sent to the terminal device in the form of business order number-query table-business information. The terminal device can analyze and process the query result in the form of service order number-query table-service information according to a preset method, so as to obtain the service information corresponding to the query request. Wherein, if the query table is a sub-table in the query table, the query result may be business order number-query table-sub-table-business information.

If the number of business information is 1, the business information of the query result is a piece of data; if the number of business information is not 1, the business information of the query result is a set of data.

The query result can be analyzed and processed in the following manner: obtain the structural information corresponding to the first element; analyze and process the query result according to the first element and the structural information to obtain at least one piece of business information corresponding to the first element.

Structural information is used to indicate the relationship between features and lookup tables. The elements and the structure information corresponding to the elements may be stored in a preset storage space of the terminal device.

The elements corresponding to the query request can be input in a preset way and generate structural information. During the data query process, the structural information, the analysis method of the structural information, and the counter-parameter method corresponding to the query results are all determined according to the query table structure in the core business system. Therefore, it is possible to realize one-time development configuration and multiple sharing.

For example, after receiving the query result shown in Table 8 above, the terminal device acquires the structural information of the insured and the certificate number. The structural information can be specifically shown in Table 9:

Table 9

Insured ID number PRPCIN-column PRPCIN-column

According to the first element and the structural information shown in Table 9, the query result is analyzed and processed to obtain at least one piece of business information corresponding to the first element. The specific business information can be shown in Table 10:

Table 10

The terminal device analyzes and processes the query result according to the first element and the structural information. So that the data query according to the query request can accurately return the query result.

The data query method provided in the embodiment of this application obtains a query request. Obtain the correspondence between the query table and the columnar table. According to the identifier and the corresponding relationship of the first lookup table, the target columnar table corresponding to the first lookup table is determined. In the target columnar table, the business information set corresponding to at least one first element is determined. Determine primary key information corresponding to the first query table. The business information is determined in the business information set according to the first business order number and the primary key information. According to the first service order number and the service data, a query result is generated and sent to the terminal device. In the above process, since the business data corresponding to the first element can be obtained in the data query device according to the corresponding relationship between the query table of the business database and the columnar table, and the query request, instead of directly obtaining the first element in the business database The business information corresponding to the elements enables data query to be decoupled from the business database of the core system while ensuring timeliness. At the same time, the function of the interface is maximized through the parameterization of element information, which improves the efficiency of data query.

On the basis of any one of the above embodiments, the relationship between the columnar database and the service database will be described below with reference to FIG. 4 .

FIG. 4 is a schematic diagram of the relationship between the databases provided by the embodiment of the present application. Please refer to FIG. 4 , which includes a business database 401 , a message middleware 402 and a columnar database 403 . The business database 401 is set in the core business system, and the message middleware 402 and the columnar database 403 are set in the data query device. Multiple query tables (query table 1, query table 2, . . . , query table M) are stored in the business database 401, and each query table is multiple pieces of business information associated according to primary key information. Data corresponding to multiple topics are stored in the message middleware 402 . Each topic corresponds to a query table in the service database 401 . A plurality of columnar tables (columnary table 1, columnary table 2, ..., columnary table K) are stored in the columnar database 403, and each columnar table has a corresponding relationship with at least one query table in the business database 401 .

The business information in the columnar database 403 and the business database 401 can be synchronized in real time through the message middleware 402 according to the way of monitoring logs. When the business information in the business database 401 is updated, the corresponding business information in the columnar database 403 can be updated in the following way: Obtain a change log of the business information in the business database 401, and the change log includes the updated first business information. The original service information corresponding to the first service information is determined in multiple columnar tables of the columnar database 403 through the message middleware 402 . The columnar database 403 updates the original service information in the columnar table to the first service information according to the change log.

In the business information update process provided by the embodiment of the present application, the change log of the business information is obtained in the business database, and the change log includes the updated first business information; in multiple columnar tables, the original business corresponding to the first business information is determined information; according to the change log, the original service information in the columnar table is updated to the first service information. In the above process, the data query device and the core business system can be decoupled through the message middleware, so that the data query process and other business processes of the core business system can be carried out independently, improving the efficiency of data query.

On the basis of any one of the above-mentioned embodiments, the process of data query will be illustrated below with reference to FIG. 5 .

FIG. 5 is a schematic diagram of the data query process provided by the embodiment of the present application. Please refer to FIG. 5 , which includes a terminal device 501 , a data query device 502 and a server 503 . The terminal device 501 may be a tablet computer, a computer, etc., and a query page is set in the terminal device 501 . The data query device 502 may be a server, and the data query device 502 is provided with a columnar database and message middleware. A plurality of columnar tables (columnary table 1, columnary table 2, . . . , columnar table K) are stored in the columnar database. The corresponding relationship between the query table and the columnar table is stored in the data query device 502 . The server 503 is provided with a service database, and multiple lookup tables (lookup table 1, lookup table 2, . . . , lookup table M) are stored in the service database. The data query device 502 can synchronize the business information in the server 503 through the message middleware.

The user inputs a query request through the query page provided by the terminal device 501 and sends the query request to the data query device 502 . The specific query request can be shown in Table 11:

Table 11

The data query device 502 receives the query request sent by the terminal device 501, and determines the target columnar table corresponding to the first query table PRPCM (insurance start time, insurance end time) as hbaseTable-A0201 according to the identification and corresponding relationship of the first query table , determine the target columnar table corresponding to the first query table PRPCIN (insured person) as hbaseTable-A0110. The target column table hbaseTable-A0201 can be specifically shown in Table 12:

Table 12

The target column table hbaseTable-A0110 can be specifically shown in Table 13:

Table 13

In the target column-type table hbaseTable-A0201 shown in Table 12, the data query device 502 determines that the business information set 1 corresponding to the first element is the column corresponding to the insurance start time and the column corresponding to the insurance termination time in Table 12. In the target column-type table hbaseTable-A0110 shown in Table 13, the data query device 502 determines that the business information set 2 corresponding to the first element is the column corresponding to the insured in Table 13.

The data query device 502 determines that the primary key information corresponding to the first lookup table PRPCM is the service order number, and determines that the primary key information corresponding to the first lookup table PRPCIN is the service order number and the serial number. The number of primary key information corresponding to the first query table PRPCM is 1, and the data query device 502 determines a piece of business information corresponding to the first business order number PADC2023D54012751C in the business information set 1 as the business data corresponding to the query request. The business data determined in the business information set 1 can be specifically shown in Table 14:

Table 14

insurance start time insurance termination time 2023.05.01 2025.12.31

The number of primary key information corresponding to the first query table PRPCIN is 2, and the data query device 502 determines multiple pieces of business information corresponding to the first business order number PADC2023D54012751C in the business information set 2 as the business data corresponding to the query request. The business data determined in the business information set 2 can be specifically shown in Table 15:

Table 15

Generate query results based on the first business order number PADC2023D54012751C and the business data shown in Table 14 and Table 15. The query results can be specifically shown in Table 16:

Table 16

The data query device 502 sends the query results shown in Table 16 to the terminal device 501 . The terminal device 501 may analyze and process the query result to obtain the service information corresponding to the query request.

The data query method provided in the embodiment of this application obtains a query request. Obtain the correspondence between the query table and the columnar table. According to the identifier and the corresponding relationship of the first lookup table, the target columnar table corresponding to the first lookup table is determined. In the target columnar table, the business information set corresponding to at least one first element is determined. Determine primary key information corresponding to the first query table. The business information is determined in the business information set according to the first business order number and the primary key information. According to the first service order number and the service data, a query result is generated and sent to the terminal device. In the above process, since the business data corresponding to the first element can be obtained in the data query device according to the corresponding relationship between the query table of the business database and the columnar table, and the query request, instead of directly obtaining the first element in the business database The business information corresponding to the elements enables data query to be decoupled from the business database of the core system while ensuring timeliness. At the same time, the function of the interface is maximized through the parameterization of element information, which improves the efficiency of data query.

FIG. 6 is a schematic structural diagram of a data query device provided by an embodiment of the present application. Referring to Fig. 6, the data query device 10 may include:

The first acquiring module 11 is configured to acquire a query request, the query request including at least one first business order number, at least one first query table identifier and at least one first element corresponding to each first query table;

The second obtaining module 12 is used to obtain the correspondence between the query table and the columnar table, the columnar table includes at least one element and at least one piece of business information corresponding to each element;

A determining module 13, configured to determine a query result corresponding to the query request according to the query request and the corresponding relationship, the query result including the at least one first business order number and the correspondence between each first business order number business data.

The data query device provided in the embodiment of the present application can implement the technical solutions shown in the above method embodiments, and its implementation principles and beneficial effects are similar, and will not be repeated here.

In a possible implementation manner, the determining module 13 is specifically configured to:

Determine a target columnar table corresponding to each first lookup table according to the identifier of the at least one first lookup table and the corresponding relationship;

According to the at least one first business order number and at least one first element corresponding to each of the first query tables, determine the business data corresponding to the query request in a plurality of target list tables;

The query result is generated according to the at least one first service order number and the service data corresponding to each first service order number.

In a possible implementation manner, the determining module 13 is specifically configured to:

In the target columnar table, determine the business information set corresponding to at least one first element;

determining the business information corresponding to the at least one first business order number in each business information set;

The business information is determined as business data corresponding to the query request.

In a possible implementation manner, the determining module 13 is specifically configured to:

determining primary key information corresponding to the first query table;

The service information is determined in the service information set according to the at least one first service order number and the primary key information.

In a possible implementation manner, the determining module 13 is specifically configured to:

Judging whether the quantity of the primary key information is 1;

If so, in the set of business information, determine a piece of business information corresponding to each first business order number as the business data corresponding to the query request;

If not, in the service information set, determine multiple pieces of service information corresponding to each first service order number as service data corresponding to the query request.

The data query device provided in the embodiment of the present application can implement the technical solutions shown in the above method embodiments, and its implementation principles and beneficial effects are similar, and will not be repeated here.

FIG. 7 is a schematic structural diagram of another data query device provided by an embodiment of the present application. On the basis of the embodiment shown in FIG. 6 , referring to FIG. 7 , the data query device 10 further includes an updating module 14 , a receiving module 15 and a sending module 16 .

Among them, the update module 14 is used for:

Acquiring a change log of the service information in the service database, the change log including the updated first service information;

In multiple columnar tables, determine original service information corresponding to the first service information;

The original service information in the columnar table is updated to the first service information according to the change log.

The receiving module 15 is used for:

The query request sent by the terminal device is received.

Sending module 16 is used for:

Send the query result to the terminal device.

The data query device provided in the embodiment of the present application can implement the technical solutions shown in the above method embodiments, and its implementation principles and beneficial effects are similar, and will not be repeated here.

FIG. 8 is a schematic structural diagram of a data query device provided by an embodiment of the present application. Referring to FIG. 8 , the data query device 20 may include: a memory 21 and a processor 22 . Exemplarily, the memory 21 and the processor 22 are connected to each other through a bus 23 .

The memory 21 is used to store program instructions;

The processor 22 is configured to execute the program instructions stored in the memory, so as to make the data query device 20 execute the methods shown in the above method embodiments.

The data query device provided by the embodiment of the present application can implement the technical solutions shown in the above method embodiments, and its implementation principles and beneficial effects are similar, and will not be repeated here.

An embodiment of the present application provides a computer-readable storage medium, where computer-executable instructions are stored in the computer-readable storage medium, and the computer-executable instructions are used to implement the foregoing method when executed by a processor.

The embodiment of the present application may further provide a computer program product, including a computer program, and when the computer program is executed by a processor, the foregoing method may be implemented.

All or part of the steps for implementing the above method embodiments can be completed by program instructions and related hardware. The aforementioned program can be stored in a readable memory. When the program is executed, it executes the steps comprising the above-mentioned method embodiments; and the aforementioned memory (storage medium) includes: read-only memory (English: read-only memory, abbreviated: ROM), random access memory (English: Random Access Memory, abbreviation: RAM), flash memory, hard disk, solid state disk, magnetic tape (English: magnetic tape), floppy disk (English: floppy disk), optical disc (English: optical disc) and any combination thereof.

Embodiments of the present application are described with reference to flowcharts and/or block diagrams of methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each procedure and/or block in the flowchart and/or block diagram, and a combination of procedures and/or blocks in the flowchart and/or block diagram can be realized by computer program instructions. These computer program instructions may be provided to a general purpose computer, special purpose computer, embedded processor, or processing unit of other programmable data processing equipment to produce a machine such that the instructions executed by the processing unit of the computer or other programmable data processing equipment produce a An apparatus for realizing the functions specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing apparatus to operate in a specific manner, such that the instructions stored in the computer-readable memory produce an article of manufacture comprising instruction means, the instructions The device realizes the function specified in one or more procedures of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions can also be loaded onto a computer or other programmable data processing device, causing a series of operational steps to be performed on the computer or other programmable device to produce a computer-implemented process, thereby The instructions provide steps for implementing the functions specified in the flow chart or blocks of the flowchart and/or the block or blocks of the block diagrams.

Apparently, those skilled in the art can make various changes and modifications to the embodiments of the present application without departing from the spirit and scope of the present application. In this way, if the modifications and variations of the embodiments of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application is also intended to include these modifications and variations.

In this application, the term "include" and its variants may mean non-limiting inclusion; the term "or" and its variants may mean "and/or". The terms "first", "second", etc. in this application are used to distinguish similar objects, and not necessarily used to describe a specific order or sequence. In the present application, "plurality" means two or more. "And/or" describes the association relationship of associated objects, indicating that there may be three types of relationships, for example, A and/or B may indicate: A exists alone, A and B exist simultaneously, and B exists independently. The character "/" generally indicates that the contextual objects are an "or" relationship.

Claims (12)

1. A data query method, characterized in that, comprising: Obtaining a query request, the query request including at least one first business order number, at least one first query table identifier, and at least one first element corresponding to each first query table; Obtain the correspondence between the query table and the columnar table, where the columnar table includes at least one element and at least one piece of business information corresponding to each element; According to the query request and the corresponding relationship, determine a query result corresponding to the query request, where the query result includes the at least one first business order number and business data corresponding to each first business order number. 2. The method according to claim 1, wherein, according to the query request and the corresponding relationship, determining the query result corresponding to the query request comprises: Determine a target columnar table corresponding to each first lookup table according to the identifier of the at least one first lookup table and the corresponding relationship; According to the at least one first business order number and at least one first element corresponding to each of the first query tables, determine the business data corresponding to the query request in a plurality of target column tables; The query result is generated according to the at least one first service order number and the service data corresponding to each first service order number. 3. The method according to claim 2, characterized in that, for any target list, according to the at least one first business order number and the at least one first element, in the target list Determining the business data corresponding to the query request includes: In the target columnar table, determine the business information set corresponding to at least one first element; determining the business information corresponding to the at least one first business order number in each business information set; The business information is determined as business data corresponding to the query request. 4. The method according to claim 3, wherein, for any set of business information, determining the business information corresponding to the at least one first business order number in the set of business information includes: determining primary key information corresponding to the first query table; The service information is determined in the service information set according to the at least one first service order number and the primary key information. 5. The method according to claim 4, wherein, according to the at least one first business order number and the primary key information, determining the business information in the business information set includes: Judging whether the quantity of the primary key information is 1; If so, in the set of business information, determine a piece of business information corresponding to each first business order number as the business data corresponding to the query request; If not, in the service information set, determine multiple pieces of service information corresponding to each first service order number as service data corresponding to the query request. 6. The method according to any one of claims 1-5, wherein the method further comprises: Acquiring a change log of the service information in the service database, the change log including the updated first service information; In multiple columnar tables, determine original service information corresponding to the first service information; The original service information in the columnar table is updated to the first service information according to the change log. 7. The method according to any one of claims 1-6, wherein obtaining the query request comprises: The query request sent by the terminal device is received. 8. The method according to any one of claims 1-7, characterized in that, after determining the query result corresponding to the query request according to the query request and the corresponding relationship, further comprising: Send the query result to the terminal device. 9. A data query device, characterized in that the device comprises: A first obtaining module, configured to obtain a query request, the query request including at least one first business order number, at least one first query table identifier, and at least one first element corresponding to each first query table; The second obtaining module is used to obtain the corresponding relationship between the query table and the columnar table, the columnar table includes at least one business order number and at least one piece of business information corresponding to each business order number; A determining module, configured to determine a query result corresponding to the query request according to the query request and the corresponding relationship, the query result including the at least one first business order number and the corresponding information of each first business order number business data. 10. A data query device, characterized in that, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, the instructions are executed by the at least one processor, so that the at least one processor can perform any one of claims 1 to 8 Methods. 11. A non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause a computer to execute the method according to any one of claims 1-8. 12. A computer program product, comprising a computer program, characterized in that, when the computer program is executed by a processor, the method according to any one of claims 1 to 8 is implemented.

Images