CN112269806A

CN112269806A - Data query method, device, equipment and computer storage medium

Info

Publication number: CN112269806A
Application number: CN202011451555.XA
Authority: CN
Inventors: 李振飞
Original assignee: Shenzhen Fangduoduo Network Technologies Co ltd
Current assignee: Shenzhen Fangduoduo Network Technologies Co ltd
Priority date: 2020-12-11
Filing date: 2020-12-11
Publication date: 2021-01-26
Anticipated expiration: 2040-12-11
Also published as: CN112269806B

Abstract

The embodiment of the invention relates to the technical field of databases, and discloses a data query method, which comprises the following steps: acquiring a data query request, wherein the data query request comprises an element to be queried, a field to be queried corresponding to the element to be queried and a target output field; determining a target data relation table according to the field to be queried and the target output field; the target data relation table comprises a corresponding relation between a field to be queried and a target output field and a combined field, and the combined field value in the combined field is obtained by converting at least one second element in the field value in the field to be queried according to a first conversion rule; converting the element to be queried according to a second conversion rule to obtain a query value; matching the query value with a combined field value in the combined field to determine a target field value; and determining the field value of the target field value in the corresponding target output field in the target data relation table for outputting. Through the mode, the embodiment of the invention realizes the high efficiency of the many-to-many relation data query.

Description

Data query method, device, equipment and computer storage medium

Technical Field

The embodiment of the invention relates to the technical field of databases, in particular to a data query method, a data query device, data query equipment and a computer storage medium.

Background

In the storage and application of a database, it often occurs that a plurality of data and a plurality of data are associated with each other, such as each element in a first list is associated with one or more elements in a second list, and at the same time each element in the second list is associated with one or more elements in the first list.

At present, when querying such many-to-many associated data, if querying whether a certain element is associated with an element in a certain row in a first list, it is generally necessary to use the element in the row in the first list as a primary key, and compare the element to be queried with the associated element of the row one by one, but the associated elements in the prior art are generally separated by separators, which results in slow data query speed and low efficiency on one hand, and is not beneficial to reverse lookup. On the other hand, each time an association relationship is added, an association data table containing multiple columns needs to be created, which results in a large storage cost of the database.

Disclosure of Invention

In view of the above problems, embodiments of the present invention provide a data query method, which is used to solve the problem existing in the prior art that the efficiency is low when many-to-many data is queried.

According to an aspect of an embodiment of the present invention, there is provided a data query method, including:

acquiring a data query request, wherein the data query request comprises an element to be queried, a field to be queried corresponding to the element to be queried and a target output field;

determining a target data relation table according to the field to be queried and the target output field; the target data relation table comprises the corresponding relation between the field to be inquired and the target output field; each field value in the target output field comprises a first element; each field value in the fields to be queried comprises at least one second element; the target data relation table also comprises a combined field, and a combined field value in the combined field is obtained by converting through a first conversion rule according to the at least one second element in the field value in the field to be queried;

converting the element to be queried according to a second conversion rule to obtain a query value; the second conversion rule corresponds to the first conversion rule;

matching according to the query value and a combined field value in the combined field, and determining the combined field value in the combined field matched with the query value as a target field value;

determining a field value of a target output field corresponding to the target field value in the target data relation table as a target output field value;

and outputting the target output field value as a query result.

In an alternative, the second element is a decimal string, and the first conversion rule includes a third conversion rule and a fourth conversion rule; the method further comprises the following steps:

respectively completing each decimal character string to a target length;

converting each of the complemented decimal character strings into sub-binary character strings according to the third conversion rule; the third conversion rule is to convert each character value in the decimal character string into a sub-binary character string;

splicing the sub binary character strings to obtain a combined binary character string;

converting the combined binary character string into a combined decimal character string according to the fourth conversion rule; the fourth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string and sum; wherein n is determined according to the sequence number of binary bits of the character value;

and respectively taking each combined decimal character string as each combined field value of the combined fields.

In an alternative mode, each character value in the decimal character string respectively corresponds to one character bit of the sub binary character string; the method further comprises:

dividing character bits contained in the sub binary character string into a first character bit and a second character bit, wherein the first character bit corresponds to each character value in the decimal character string respectively, and the second character bit does not have the character value in the decimal character string and corresponds to the character value;

and determining the character value on the first character bit as a first preset value, and determining the character value on the second character bit as a second preset value.

In an optional manner, the method further comprises:

determining the character bit order of the character value corresponding to each sub-binary character string in the decimal character string;

and splicing the sub binary character strings according to the character bit sequence to obtain the combined binary character string.

In an optional manner, the method further comprises:

performing an and operation on the query value and a first combined field value in the combined field, wherein the first combined field value is any one of the combined field values;

and acquiring an operation result, and taking a first combined field corresponding to the operation result which is the same as the query value as the target field value.

In an optional manner, the method further comprises:

acquiring a data updating request, wherein the data updating request comprises an element to be updated, a field to be updated corresponding to the element to be updated and an updated element;

converting the element to be updated according to a seventh conversion rule to obtain a field value to be updated, wherein the seventh conversion rule corresponds to the first conversion rule;

respectively matching the field value to be updated with each field value in the combined field, and determining the matched field value in the combined field as a first field value;

determining a field value of a field to be updated corresponding to the first field value in the target data relation table as a second field value;

updating the second field value according to the updated element;

converting according to the updated second field value and the seventh conversion rule to obtain a third field value;

and updating the first field value according to the third field value.

In an optional manner, the second conversion rule includes a fifth conversion rule and a sixth conversion rule, and the method further includes:

converting the decimal value to be queried into a sub-binary character string to be queried according to the fifth conversion rule; the fifth conversion rule is to convert each character value in the decimal value to be queried into a sub binary character string to be queried;

splicing all the sub-binary character strings to be queried to obtain a combined binary character string to be queried;

converting the combined binary character string to be queried into a combined decimal character string to be queried according to the sixth conversion rule; the sixth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string to be queried and sum the values; wherein n is determined according to the sequence number of binary bits of the character value;

and taking the combined decimal character string to be queried as the query value.

According to another aspect of the embodiments of the present invention, there is provided a data query apparatus including:

the device comprises an acquisition module, a query module and a query module, wherein the acquisition module is used for acquiring a data query request which comprises an element to be queried, a field to be queried corresponding to the element to be queried and a target output field;

the first determining module is used for determining a target data relation table according to the field to be queried and the target output field; the target data relation table comprises the corresponding relation between the field to be inquired and the target output field; each field value in the target output field comprises a first element; each field value in the fields to be queried comprises at least one second element; the target data relation table also comprises a combined field, and a combined field value in the combined field is obtained by converting through a first conversion rule according to the at least one second element in the field value in the field to be queried;

the conversion module is used for converting the element to be queried according to a second conversion rule to obtain a query value; the second conversion rule corresponds to the first conversion rule;

the matching module is used for matching according to the query value and the combined field value in the combined field and determining the combined field value in the combined field matched with the query value as a target field value;

a second determining module, configured to determine a field value of the target output field corresponding to the target field value in the target data relationship table, as a target output field value;

and the output module is used for outputting the target output field value as a query result.

According to another aspect of the embodiments of the present invention, there is provided a data query apparatus including: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction causes the processor to execute the operation of the data query method in any one of the previous embodiments.

According to a further aspect of the embodiments of the present invention, there is provided a computer-readable storage medium having at least one executable instruction stored therein, the executable instruction causing a data query device to perform the operations of the data query method according to any one of the preceding claims.

The embodiment of the invention obtains a data query request, wherein the data query request comprises an element to be queried, a field to be queried corresponding to the element to be queried and a target output field;

determining a target data relation table according to the field to be queried and the target output field; the target data relation table comprises a corresponding relation between a field to be queried and a target output field, wherein each field value in the target output field comprises a first element, and each field value in the field to be queried comprises at least one second element; meanwhile, the target data relation table also comprises a combined field, and the combined field value in the combined field is obtained by converting through a first conversion rule according to at least one second element in the field value in the field to be inquired; and converting the element to be queried according to a second conversion rule to obtain a query value, wherein the second conversion rule corresponds to the first conversion rule. And matching according to the query value and the combined field value in the combined field, and determining the combined field value in the combined field matched with the query value as a target field value. Finally, determining the field value of the target field value in the corresponding target output field in the target data relation table as the target output field value; and outputting the target output field value as a query result.

The invention can determine the combined field value corresponding to the associated element according to the first conversion rule, convert the element to be queried according to the second conversion rule corresponding to the first conversion rule to obtain the query value, and match the query value with each combined field value once, thereby realizing the purpose of quickly querying the associated data in many-to-many data, solving the problem of low efficiency of comparing the elements associated with the main key element one by one when querying the associated elements in the prior art and improving the efficiency of querying the data.

The foregoing description is only an overview of the technical solutions of the embodiments of the present invention, and the embodiments of the present invention can be implemented according to the content of the description in order to make the technical means of the embodiments of the present invention more clearly understood, and the detailed description of the present invention is provided below in order to make the foregoing and other objects, features, and advantages of the embodiments of the present invention more clearly understandable.

Drawings

The drawings are only for purposes of illustrating embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

FIG. 1 is a flow chart of a data query method according to an embodiment of the present invention;

FIG. 2 is a schematic structural diagram of a data query device according to an embodiment of the present invention;

fig. 3 shows a schematic structural diagram of a data query device according to an embodiment of the present invention.

Detailed Description

Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be embodied in various forms and should not be limited to the embodiments set forth herein.

Fig. 1 shows a flowchart of a data query method provided by an embodiment of the present invention, where the method is executed by a data query device. The specific device may include a computer processing device such as a mobile phone and a notebook computer. As shown in fig. 1, the method comprises the steps of:

step 101: the method comprises the steps of obtaining a data query request, wherein the data query request comprises an element to be queried, a field to be queried corresponding to the element to be queried and a target output field.

For example, the element to be queried is 123, the field to be queried is a student ID, the target output field is a course ID, each student ID corresponds to a student name, and each course ID corresponds to a course name. Meaning that the course ID associated with the student having student ID 123 is queried. The correspondence between the student ID and the course ID can refer to table 1. Where the course IDs "1, 3" indicate that the student ID "120" corresponds to the courses whose course IDs are "1" and "3", respectively, "," is a separator between different course IDs.

TABLE 1

Student ID	Course ID
		120	1，3
123	1，2
		126	3

In one embodiment of the invention, the numeric association elements are stored according to the relationship between the fields. The numeric association element means that the elements on the respective fields are numbers, i.e., as shown in table 1 above. For the non-digital associated elements, a unique digital element may be assigned to the non-digital element in each field in advance, and then the digital elements corresponding to each field are stored in association according to the relationship between the non-digital elements, for example, the corresponding relationship between the course ID and the course name and the corresponding relationship between the student ID and the student name are stored first, and the table 2 and the table 3 are referred to respectively.

TABLE 2

Course ID	Course name
		1	Data structure
2	Principle of computer composition
		3	Cryptography

TABLE 3

Student ID	Student name
		120	Zhang three
123	Li four
		126	Wangwu tea

Step 102: determining a target data relation table according to the field to be queried and the target output field; the target data relation table comprises the corresponding relation between the field to be inquired and the target output field; each field value in the target output field comprises a first element; each field value in the fields to be queried comprises at least one second element; the target data relation table also comprises a combined field, and the combined field value in the combined field is obtained by converting through a first conversion rule according to the at least one second element in the field value in the field to be queried.

In one embodiment of the present invention, the target data relationship table may refer to table 4.

TABLE 4

Course ID	Student ID	Combined field
			1	120，123	2101257
2	123	2101256
			3	120，126	2101313

The beneficial effect of storing many-to-many data relationships in the manner shown in table 4 is that: for the association relationship between 100 courses and 1000 students, the storage method in the prior art is to take the students and the courses as the main keys respectively, and establish two data relationship tables with different main keys for storage. In this manner of the prior art, the maximum number of rows of data that needs to be stored is 100 x 1000. After the method of the invention is adopted to generate the target data table, only 100 rows are needed for storing the data relation, therefore, the data query method of the invention greatly saves the cost of data storage while improving the data query speed.

First, the second element is a decimal character string, and the first conversion rule includes a third conversion rule and a fourth conversion rule. Before determining a target data relation table according to the field to be queried and the target output field, the method also comprises steps 1021-1025:

step 1021: and respectively completing each decimal character string to a target length.

For example, the second element included in the field to be queried may be 123, 14, 331, 1058. In the embodiment of the present invention, when the field to be queried is queried, each character in each field value in the field to be queried is queried separately, for example, in the case of the field 123 to be queried, first, whether a second element with a unit position of 3 exists in each field value in the field to be queried is searched, then, whether an element with a unit position of 2 exists in the searched second element with a unit position of 3 is further searched, and finally, a second element with a unit position of 1 is searched in the searched second element, and other higher digits are similar to each other.

Therefore, it is necessary to unify the number of characters included in the second element. Step 1021 further comprises: step 10211: and respectively acquiring the length of each decimal character string, and determining the length of the decimal character string with the maximum length as the target length.

In connection with the example of step 1021, the target length is 4 word bits corresponding to 1058.

Step 10212: and completing the vacant positions of the decimal character strings with the length smaller than the target length according to a third preset value.

In one embodiment of the present invention, the third preset value is 0, i.e. high-order zero padding is performed for the second elements with lengths less than the target length, such as 123, 14 and 331, which are padded with 0123, 0014 and 0331, respectively.

Step 1022: converting each of the complemented decimal character strings into sub-binary character strings according to the third conversion rule; the third conversion rule is to convert each character value in the decimal character string into a sub-binary character string.

In connection with the foregoing example, for the complemented decimal strings 0123, 0014, 0331 and 1058, bit-corresponding binary strings are first determined according to the character values 3, 4, 1 and 8 contained in the bits. And by analogy, sequentially determining binary character strings corresponding to each character value in ten digits, thousand digits and hundred digits as corresponding sub-binary character strings.

Step 1022 also includes: step 10221: dividing character bits contained in the sub binary character string into a first character bit and a second character bit, wherein the first character bit corresponds to each character value in the decimal character string respectively, and the second character bit does not have the character value in the decimal character string and corresponds to the character value.

Considering that a decimal string may include 0 to 9 decimal character values, each decimal character value corresponds to a predetermined character bit in a sub-binary string, such as 0 in the decimal string corresponding to the last digit of the sub-binary string, 1 in the decimal string corresponding to the second last digit of the sub-binary string, 9 in the decimal string corresponding to the highest digit of the sub-binary string, etc., where each sub-binary string corresponds to one.

Step 10222: and determining the character value on the first character bit as a first preset value, and determining the character value on the second character bit as a second preset value.

In one embodiment of the present invention, the first preset value is set to 1 and the second preset value is set to 0. For each decimal string 0123, 0014, 0331 and 1058, the character values in its bits are 3, 4, 1 and 8, respectively, and the character values 3, 4, 1 and 8 correspond to the 4 th, 5 th, 2 nd and 9 th bits from right to left of the sub-binary string, in turn. The character value of a bit thus corresponds to a sub-binary string of 0100011010. By analogy, the decimal character values of the decimal character strings 0123, 0014, 0331, and 1058 in the kilobits, the hundreds, and the tens correspond to the sub-binary character strings 0000000011, 0000001011, and 0000101110.

Step 1023: and splicing the sub binary character strings to obtain a combined binary character string.

And splicing the sub binary character strings according to the sequence of the corresponding character values, namely, the sub binary character strings corresponding to the character values from the corresponding units, tens, hundreds to the highest unit in the decimal character string are spliced from right to left.

Step 1023 further includes step 10231-step 10232:

step 10231: determining the character bit order of the character value corresponding to each sub binary character string in the decimal character string.

For example, the sub-binary string 0100011010 corresponds to character values of 3, 4, 1, 8 in the digits of the decimal strings 0123, 0014, 0331, and 1058, and the sub-binary string 0000101110 corresponds to character values of 2, 1, 3, 5 in the tens of the decimal strings 0123, 0014, 0331, and 1058. And in the decimal system, the order of the character digits is unit digit, ten digits, thousand digits and the like from low to high.

Step 10232: and splicing the sub binary character strings according to the character bit sequence to obtain the combined binary character string.

And splicing the sub binary character strings according to the corresponding character bit sequence, namely, the sub binary character string corresponding to the highest bit corresponding to the character value in the decimal character string from the corresponding bit, ten bit and hundred bit from right to left is spliced.

For example, the combined binary string composed of the sub-binary strings in the previous step 10222 is 11000000101100001011100100011010.

Step 1024: converting the combined binary character string into a combined decimal character string according to the fourth conversion rule; the fourth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string and sum; wherein the n is determined according to the sequence number of the binary bit of the character value.

For example, when the combined binary string is 1010, the corresponding combined decimal string is 1 × 2 (3 rd power of 2) +1 × 2 (1 st power of 2), resulting in 10. The combined binary string 11000000101100001011100100011010 in the previous step 10222 is converted to a combined decimal string 3232807194 according to a fourth conversion rule.

In one embodiment of the present invention, if there is an overflow of the combined decimal string, the sub-binary strings may be pieced together in blocks, i.e., characters in at least one decimal digit of each second element are determined to correspond to a combined field value, such as the first combined binary string 1011100100011010 in digits and tens, and the second combined binary string 110000001011 in hundreds and thousands, respectively. Splitting the combined field into a first combined field and a second combined field for characterizing a combined field value of the second element in units and tens and hundreds and thousands, respectively. During query, the element to be queried is also split into a plurality of binary character strings according to the decimal digits, and query is respectively carried out under the combined field value of the corresponding character digit according to the combined field value corresponding to each decimal digit.

Step 1025: and respectively taking each combined decimal character string as each combined field value of the combined fields.

Step 103: converting the element to be queried according to a second conversion rule to obtain a query value; the second conversion rule corresponds to the first conversion rule.

Firstly, the element to be queried is a decimal value to be queried, and similar to the method for determining each combined field value in the combined field in the previous step, the corresponding element to be queried also determines a corresponding combined binary character string to be queried according to each decimal character value of the decimal value to be queried, and then the combined binary character strings to be queried are spliced to obtain a query value.

The second conversion rule corresponds to the first conversion rule, and the second conversion rule comprises a fifth conversion rule and a sixth conversion rule. Wherein the fifth conversion rule and the calculation principle are similar to the third conversion rule in step 102. Namely, the fifth conversion rule is to convert each digit character value in the decimal value to be queried into a sub-binary character string to be queried. The calculation principle of the sixth conversion rule is similar to the fourth conversion rule in step 102.

Step 103 further comprises: step 1031: converting the decimal value to be queried into a sub-binary character string to be queried according to the fifth conversion rule; and the fifth conversion rule is to convert each character value in the decimal value to be queried into a sub binary character string to be queried.

In an embodiment of the present invention, the element to be queried needs to be supplemented to the target bit number first, for example, 123 is supplemented as 0123 according to the supplementing method in steps 10211-10212. And then, converting the character values 0, 1, 2 and 3 contained in the completed 0123 into corresponding sub-binary character strings to be queried, 0000000001, 0000000010, 0000000100 and 0000001000, respectively, according to a fifth conversion rule.

Step 1032: and splicing the sub binary character strings to be queried to obtain a combined binary character string to be queried.

The four to-be-queried sub-binary character strings are spliced 1000000001000000001000000001000 to serve as the to-be-queried sub-binary character strings, and the splicing mode is the same as that in step 102, and is not described again.

Step 1033: converting the combined binary character string to be queried into a combined decimal character string to be queried according to the sixth conversion rule; the sixth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string to be queried and sum the values; wherein the n is determined according to the sequence number of the binary bit of the character value.

The combined binary string 1000000001000000001000000001000 to be examined is converted into a corresponding decimal value string 1075843080 according to a sixth conversion rule.

Step 1034: and taking the combined decimal character string to be queried as the query value.

The combined decimal string 1075843080 to be queried is taken as the query value.

Step 104: and matching according to the query value and the combined field value in the combined field, and determining the combined field value in the combined field matched with the query value as a target field value.

To inquire whether a certain character value exists in a certain bit of each combined field value, and operation is required.

Step 104 further comprises: step 1041: and the query value and a first combined field value in the combined field, wherein the first combined field value is any one of the combined field values.

Step 1042: and acquiring an operation result, and taking a first combined field corresponding to the operation result which is the same as the query value as the target field value.

For example, the result of the AND operation of the query value 1075843080 with the combined field value 3232807194 in the combined field is 1075843080, and thus the target field value is 3232807194. As shown in the foregoing step 1024, the second elements included in the combination field value 3232807194 are 123, 14, 331, and 1058, which include the element 123 to be queried, indicating that the query result is correct.

Step 105: and determining a field value of a target output field corresponding to the target field value in the target data relation table as a target output field value.

That is, after the target field value is found, the field value under the target output field in the same row as the target field value in the target data relationship table is found and output, so that the target element associated with the element to be queried is output.

Step 106: and outputting the target output field value as a query result.

The field to be queried is a student ID, the target output field is a course ID, each student ID corresponds to a student name, and each course ID corresponds to a course name. Meaning that the student with ID 123 is queried for the course ID associated with it. The final query result is the course ID corresponding to the student with student ID 123. In an alternative embodiment, information corresponding to the target output field value, such as a course name corresponding to the course ID, may be further obtained and output together.

In an alternative embodiment, the corresponding data in the target data table is also updated as the association relationship between the data changes, so that steps 1071-1076 are also included.

Step 1071: the method comprises the steps of obtaining a data updating request, wherein the data updating request comprises an element to be updated, a field to be updated corresponding to the element to be updated and an updated element.

For example, the element to be updated is also a decimal value to be updated, such as 123, the field to be updated is the student ID, and the element after update is 124.

Step 1072: and converting the element to be updated according to a seventh conversion rule to obtain a field value to be updated.

According to the foregoing steps, the process of converting the element to be updated into the field value to be updated is similar to the process of converting the element to be queried into the value to be queried in the steps, that is, first, three character values 1, 2, and 3 included in 123 are converted into corresponding binary character strings to be updated, 0000000010, 00000000100, and 0000001000, respectively. And then the three sub-binary character strings to be updated are spliced according to the sequence to obtain a combined binary character string to be updated 10000000001000000001000. Then, a decimal character string 4198408 corresponding to the combined binary character string 10000000001000000001000 to be updated is determined, and 4198408 is taken as a field value to be updated.

Step 1073: and matching according to the field value to be updated and the field value in the combined field, and determining the matched field value in the combined field as a first field value.

And step 104 is referred to in the matching process according to the field value to be updated and the field value in the combined field. And if the data is not matched, returning preset prompt information to the sender of the updated data.

Step 1074: and determining a field value of the field to be updated corresponding to the first field value in the target data relation table as a second field value.

The field to be updated is the student ID, and the second field value is 123, 14, 331, and 1058.

Step 1075: and updating the second field value according to the updated element.

The process of updating the second field value may be to replace a second element in the second field value, which matches the element to be updated, with an updated element, that is, the second field value is 123, 14, 331 and 1058 before the update and 124, 14, 331 and 105 after the update.

Step 1076: and calculating according to the updated second field value and the conversion rule to obtain a third field value, and updating the first field value according to the third field value.

The updating of the first field value is performed by replacing the first field value with a third field value.

Fig. 2 is a schematic structural diagram illustrating a data query apparatus according to an embodiment of the present invention. As shown in fig. 2, the apparatus 200 includes: an acquisition module 201, a first determination module 202, a conversion module 203, a matching module 204, a second determination module 205, and an output module 206, wherein,

an obtaining module 201, configured to obtain a data query request, where the data query request includes an element to be queried, a field to be queried corresponding to the element to be queried, and a target output field;

a first determining module 202, configured to determine a target data relationship table according to the field to be queried and the target output field; the target data relation table comprises the corresponding relation between the field to be inquired and the target output field; each field value in the target output field comprises a first element; each field value in the fields to be queried comprises at least one second element; the target data relation table also comprises a combined field, and a combined field value in the combined field is obtained by converting through a first conversion rule according to the at least one second element in the field value in the field to be queried;

the conversion module 203 is configured to convert the element to be queried according to a second conversion rule to obtain a query value; the second conversion rule corresponds to the first conversion rule;

a matching module 204, configured to match the query value with a combined field value in the combined field, and determine the combined field value in the combined field with which the query value matches as a target field value;

a second determining module 205, configured to determine a field value of the target output field corresponding to the target field value in the target data relationship table as a target output field value;

an output module 206, configured to output the target output field value as a query result.

In an alternative, the second element is a decimal string, and the first conversion rule includes a third conversion rule and a fourth conversion rule; the first determining module 202 is further configured to:

respectively completing each decimal character string to a target length; converting each of the complemented decimal character strings into sub-binary character strings according to the third conversion rule; the third conversion rule is to convert each character value in the decimal character string into a sub-binary character string;

splicing the sub binary character strings to obtain a combined binary character string; converting the combined binary character string into a combined decimal character string according to the fourth conversion rule; the fourth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string and sum; wherein n is determined according to the sequence number of binary bits of the character value;

In an alternative mode, each character value in the decimal character string respectively corresponds to one character bit of the sub binary character string; the first determining module 202 is further configured to:

dividing character bits contained in the sub binary character string into a first character bit and a second character bit, wherein the first character bit corresponds to each character value in the decimal character string respectively, and the second character bit does not have the character value in the decimal character string and corresponds to the character value; and determining the character value on the first character bit as a first preset value, and determining the character value on the second character bit as a second preset value.

In an optional manner, the first determining module 202 is further configured to:

determining the character bit order of the character value corresponding to each sub-binary character string in the decimal character string; and splicing the sub binary character strings according to the character bit sequence to obtain the combined binary character string.

In an optional manner, the matching module 204 is further configured to:

performing an and operation on the query value and a first combined field value in the combined field, wherein the first combined field value is any one of the combined field values; and acquiring an operation result, and taking a first combined field corresponding to the operation result which is the same as the query value as the target field value.

In an optional manner, the obtaining module 201 is further configured to:

converting the element to be updated according to a seventh conversion rule to obtain a field value to be updated, wherein the seventh conversion rule corresponds to the first conversion rule; respectively matching the field value to be updated with each field value in the combined field, and determining the matched field value in the combined field as a first field value; determining a field value of a field to be updated corresponding to the first field value in the target data relation table as a second field value; updating the second field value according to the updated element; converting according to the updated second field value and the seventh conversion rule to obtain a third field value; and updating the first field value according to the third field value.

In an alternative manner, the second conversion rule includes a fifth conversion rule and a sixth conversion rule, the element to be queried is a decimal value to be queried, and the conversion module 203 is further configured to:

converting the combined binary character string to be queried into a combined decimal character string to be queried according to the sixth conversion rule; the sixth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string to be queried and sum the values; wherein n is determined according to the sequence number of binary bits of the character value; and taking the combined decimal character string to be queried as the query value.

The implementation process of the data query device of the present invention is the same as that of the data query method in any of the foregoing embodiments, and is not described again. The data query device can determine the combined field value corresponding to the associated element according to the first conversion rule, convert the element to be queried according to the second conversion rule corresponding to the first conversion rule to obtain the query value, and match the query value with each combined field value once, so that the problem that the efficiency of comparing the elements associated with the main key element one by one is low when the associated elements are queried in the prior art is solved, and the efficiency of data query is improved.

Fig. 3 is a schematic structural diagram of a data query device according to an embodiment of the present invention, and the specific embodiment of the present invention does not limit the specific implementation of the data query device.

As shown in fig. 3, the data query apparatus may include: a processor (processor)302, a communication Interface 304, a memory 306, and a communication bus 308.

Wherein: the processor 302, communication interface 304, and memory 306 communicate with each other via a communication bus 308. A communication interface 304 for communicating with network elements of other devices, such as clients or other servers. The processor 302 is configured to execute the program 310, and may specifically perform the relevant steps in the data query method embodiments described above.

In particular, program 310 may include program code comprising computer-executable instructions.

The processor 302 may be a central processing unit CPU, or an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits configured to implement an embodiment of the present invention. The data inquiry device comprises one or more processors which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.

And a memory 306 for storing a program 310. Memory 306 may comprise high-speed RAM memory and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.

Specifically, program 310 may be invoked by processor 302 to cause data querying device to perform the following operations:

and outputting the target output field value as a query result.

In an alternative manner, the program 310 may be further specifically invoked by the processor 302 to cause the data query device to perform the following operations:

respectively completing each decimal character string to a target length;

splicing the sub binary character strings to obtain a combined binary character string; converting the combined binary character string into a combined decimal character string according to the fourth conversion rule; the fourth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string and sum; wherein n is determined according to the sequence number of binary bits of the character value; and respectively taking each combined decimal character string as each combined field value of the combined fields.

In an alternative manner, the program 310 may be further specifically invoked by the processor 302 to cause the data query device to perform the following operations: performing an and operation on the query value and a first combined field value in the combined field, wherein the first combined field value is any one of the combined field values; and acquiring an operation result, and taking a first combined field corresponding to the operation result which is the same as the query value as the target field value.

acquiring a data updating request, wherein the data updating request comprises an element to be updated, a field to be updated corresponding to the element to be updated and an updated element; converting the element to be updated according to a seventh conversion rule to obtain a field value to be updated, wherein the seventh conversion rule corresponds to the first conversion rule; respectively matching the field value to be updated with each field value in the combined field, and determining the matched field value in the combined field as a first field value; determining a field value of a field to be updated corresponding to the first field value in the target data relation table as a second field value; updating the second field value according to the updated element; converting according to the updated second field value and the seventh conversion rule to obtain a third field value; and updating the first field value according to the third field value.

converting the decimal value to be queried into a sub-binary character string to be queried according to the fifth conversion rule; the fifth conversion rule is to convert each character value in the decimal value to be queried into a sub binary character string to be queried; splicing all the sub-binary character strings to be queried to obtain a combined binary character string to be queried; converting the combined binary character string to be queried into a combined decimal character string to be queried according to the sixth conversion rule; the sixth conversion rule is to calculate the value of the power of 2 n of each character value in the combined binary string to be queried and sum the values; wherein n is determined according to the sequence number of binary bits of the character value; and taking the combined decimal character string to be queried as the query value.

The implementation process of the data query device of the present invention is the same as that of the data query method in any of the foregoing embodiments, and is not described again. The data query equipment can determine the combined field value corresponding to the associated element according to the first conversion rule, convert the element to be queried according to the second conversion rule corresponding to the first conversion rule to obtain the query value, and match the query value with each combined field value once, so that the problem that the efficiency of comparing the elements associated with the main key element one by one is low when the associated elements are queried in the prior art is solved, and the efficiency of data query is improved.

An embodiment of the present invention provides a computer-readable storage medium, where the storage medium stores at least one executable instruction, and when the executable instruction is executed on a data query device, the data query device executes a data query method in any method embodiment described above.

The executable instructions may be specifically configured to cause the data querying device to perform the following operations:

and outputting the target output field value as a query result.

In an alternative, the second element is a decimal string, and the first conversion rule includes a third conversion rule and a fourth conversion rule; the executable instructions cause the data querying device to:

respectively completing each decimal character string to a target length;

In an alternative mode, each character value in the decimal character string respectively corresponds to one character bit of the sub binary character string; the executable instructions cause the data querying device to perform operations further comprising:

In an alternative form, the executable instructions cause the data querying device to:

updating the second field value according to the updated element;

and updating the first field value according to the third field value.

In an alternative manner, the second conversion rule includes a fifth conversion rule and a sixth conversion rule, the element to be queried is a decimal value to be queried, and the executable instructions cause the data query device to perform the following operations:

The implementation process of the computer readable medium of the present invention is the same as that of the data query method in any of the foregoing embodiments, and is not described again. The computer readable medium can determine the combined field value corresponding to the associated element according to the first conversion rule, convert the element to be queried according to the second conversion rule corresponding to the first conversion rule to obtain the query value, and match the query value with each combined field value once, so that the problem that the efficiency of comparing the elements associated with the main key element one by one is low when the associated elements are queried in the prior art is solved, and the efficiency of data query is improved.

The embodiment of the invention provides a data query device, which is used for executing the data query method.

Embodiments of the present invention provide a computer program, where the computer program can be called by a processor to enable a data query device to execute a data query method in any of the above method embodiments.

Embodiments of the present invention provide a computer program product, which includes a computer program stored on a computer-readable storage medium, where the computer program includes program instructions, and when the program instructions are run on a computer, the computer is caused to execute the data query method in any of the above method embodiments.

The algorithms or displays presented herein are not inherently related to any particular computer, virtual system, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system will be apparent from the description above. In addition, embodiments of the present invention are not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.

In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the embodiments of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the invention and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim.

Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names. The steps in the above embodiments should not be construed as limiting the order of execution unless specified otherwise.

Claims

1. A method for data query, the method comprising:

and outputting the target output field value as a query result.

2. The method of claim 1, wherein the second element is a decimal string, and wherein the first conversion rule comprises a third conversion rule and a fourth conversion rule; before determining a target data relation table according to the field to be queried and the target output field, the method further includes:

respectively completing each decimal character string to a target length;

3. The method of claim 2, wherein each character value in the decimal character string corresponds to a character bit of the sub-binary character string; the converting each of the complemented decimal character strings into sub-binary character strings according to the third conversion rule, further comprising:

4. The method of claim 2, wherein the concatenating the sub-binary strings to obtain a combined binary string further comprises:

5. The method of claim 1, wherein the determining a field value in the combined field that the query value matches as a target field value according to the matching of the query value and the field value in the combined field, further comprises:

6. The method of claim 1, further comprising:

updating the second field value according to the updated element;

and updating the first field value according to the third field value.

7. The method according to claim 1, wherein the second conversion rule includes a fifth conversion rule and a sixth conversion rule, the element to be queried is a decimal value to be queried, and the converting the element to be queried according to the second conversion rule to obtain a query value further includes:

8. A data query apparatus, characterized in that the apparatus comprises:

9. A data query device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is configured to store at least one executable instruction that causes the processor to perform the operations of the data query method of any one of claims 1-7.

10. A computer-readable storage medium having stored therein at least one executable instruction that, when executed on a data querying device, causes the data querying device to perform operations of the data querying method as recited in any one of claims 1-7.