CN111008191A - Completion method and device for database query and computer equipment - Google Patents
Completion method and device for database query and computer equipment Download PDFInfo
- Publication number
- CN111008191A CN111008191A CN201911044221.8A CN201911044221A CN111008191A CN 111008191 A CN111008191 A CN 111008191A CN 201911044221 A CN201911044221 A CN 201911044221A CN 111008191 A CN111008191 A CN 111008191A
- Authority
- CN
- China
- Prior art keywords
- field
- values
- data
- fields
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a completion method and a completion device for database query and computer equipment, wherein the method comprises the following steps: acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values; and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values. In the invention, the values of the target fields in the mode table are all default values, and after data is inquired, the inquired data is filled in the mode table to obtain the completion data table, so that the data which can be inquired in the database in the completion data table can be displayed as the default values except the data which can be inquired in the database, so that the data which can not be inquired in the database can be clearly displayed as the default values by a user, and is the values which can not be inquired in the database and is not a system fault.
Description
Technical Field
The invention relates to the technical field of Internet of things, in particular to a completion method and device for database query and computer equipment.
Background
In a daily industrial scene, data lack is a common situation, for example, when terminal equipment stops running due to insufficient city power supply and collects data generated by each part of a company, a time difference always causes data of some departments to be lost, the lost data is usually input into a database without data cleaning under the condition that the data is frequently input, the database is characterized in that the data which is not input cannot be inquired, and the lost data cannot be displayed when an interface is displayed, so that a client can consider that the system has a problem rather than the data which is not inquired.
Accordingly, the prior art is in need of improvement and development.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a database query completion method, a database query completion device and computer equipment, so as to complete query data and display data which is not queried as a default value.
In a first aspect, the present invention provides a completion method for database query, where the method includes:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
As a further improved technical solution, the configuration information includes a defined field and an undefined field, and values corresponding to the defined field and the undefined field, respectively, and the generating a mode table according to the configuration information includes:
obtaining a value corresponding to a common field in the mode table according to a value corresponding to a defined field;
setting the values of the target fields in the mode table to be default values;
and generating a mode table according to a preset rule according to the value corresponding to the common field and the value of the target field in the mode table.
As a further improved technical solution, the configuration information includes N defined fields, and obtaining values corresponding to common fields in the mode table according to values corresponding to the defined fields includes:
multiplying the number of values corresponding to the N defined fields respectively to obtain a product M;
the value corresponding to the a-th common field is the value of the a-th defined field in the M/r group, wherein r is the number of the values of the a-th defined field, a, r, N and M are positive integers, and a is more than or equal to 1 and less than or equal to N.
As a further improved technical solution, there are N common fields, and the generating a mode table according to a preset rule according to a value corresponding to a common field in the mode table and a value of a target field includes:
the values of the N common fields are in one-to-one correspondence to obtain M tuples, wherein for any two tuples in the M tuples, the value of a first tuple in the two tuples and the value of a second tuple in the two tuples are not identical;
the value of a target field is added to each tuple to generate a pattern table.
As a further improved technical solution, the obtaining a completion data table according to the queried data and the pattern table includes:
generating a query data table according to the queried data;
and obtaining a complete data table according to the query data table and the mode table.
As a further improved technical solution, the querying a data table includes a target querying field, and the obtaining a completion data table according to the querying the data table and the mode table includes:
obtaining values of all target fields corresponding to the values of all target query fields respectively;
and replacing the values of the target fields with the values of the target query fields respectively to obtain a completion data table.
As a further improved technical solution, the obtaining values of the target fields corresponding to the values of the target query fields respectively includes:
for one value of the target query field, acquiring the value of each common query field in the same ancestor as the value;
traversing the mode table to obtain each common field consistent with the value of each common query field;
and acquiring the value of the target field corresponding to each common field consistent with the value of each common query field.
In a second aspect, the present invention provides a completion apparatus for database query, the apparatus comprising: the device comprises a mode table generation module and a data table completion module;
the mode table generating module is used for acquiring configuration information and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and the data table completion module is used for inquiring data and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
In a third aspect, the present invention provides a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
In a fourth aspect, the present invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
Compared with the prior art, the embodiment of the invention has the following advantages:
the method provided by the embodiment of the invention comprises the following steps: acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values; and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values. In the invention, the values of the target fields in the mode table are all default values, and after data is inquired, the inquired data is filled in the mode table to obtain the completion data table, so that the data which can be inquired in the database in the completion data table can be displayed as the default values except the data which can be inquired in the database, so that the data which can not be inquired in the database can be clearly displayed as the default values by a user, and is the values which can not be inquired in the database and is not a system fault.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments described in the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a completion method for database query according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a completion apparatus for database query according to an embodiment of the present invention;
fig. 3 is an internal structural diagram of a computer device in an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of the present invention provides a completion method for a database query, where the method may include the steps of:
s1, obtaining configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are all default values.
In the embodiment of the present invention, the database specifies which data is provided by fields, in the database, a row of a table is called a tuple or a record, a column of the table is called a field, values in the same field have the same attribute, for example, in the address book, a field is a name, and a field corresponding to the name has a plurality of different values (names of different people), but the values all represent names of people and have the same attribute.
The configuration information provides fields to be displayed, a type of each field, the configuration information includes a defined field and an undefined field, and values corresponding to the defined field and the undefined field, specifically, step S1 includes:
s11, obtaining the value corresponding to the common field in the mode table according to the value corresponding to the defined field.
In the embodiment of the present invention, in the database, the value corresponding to the defined field may be directly set, and does not need to be detected, and the value of the undefined field needs to be obtained through processes such as detection, operation, and the like, for example, if GDP in a plurality of administrative areas within three years needs to be queried, the plurality of administrative areas may correspond to one defined field, another defined field in three years, and the GDP corresponds to one undefined field, so as to obtain: first defined field: administrative region, second defined field: time, undefined field: GDP.
Further, the values of the defined fields may be directly set, and each field may have multiple values, for example, for the administrative area field in the above example, the values of the administrative area field may be set as: area 1, area 2 and area 3, for the time field, the values of the time field can be set as: 2017, 2018 and 2019.
Specifically, step S11 includes:
and S111, multiplying the numbers of the values corresponding to the N defined fields respectively to obtain a product M.
In the embodiment of the invention, the common field of the mode table corresponds to each defined field in the configuration information, the name of the common field corresponds to the name of each defined field respectively, and the common field is different from the defined fields in that the values of the common field and the defined fields are different, but the value of each common field can be obtained according to the value of each defined field. For example, for the above example, GDPs within three years of a plurality of administrative regions need to be queried, the values of the first defined field (administrative region field) are: region 1, region 2, and region 3, the values of the time field are: in 2017, 2018 and 2019, the value of the administrative region field is 3, the value of the time field is also 3, and the product is M-9.
S112, the value corresponding to the a-th common field is the value of the a-th defined field of the M/r group, wherein r is the number of the values of the a-th defined field, a, r, N and M are positive integers, and a is more than or equal to 1 and less than or equal to N.
In the embodiment of the present invention, for example, when a is 1, in the above example, the value of the first defined field is: region 1, region 2 and region 3, M is 9, r is 3, and M/r is 3, then the value of the first general field is: region 1, region 2, region 3, region 1, region 2, and region 3. a is 2, and in the above example, the value of the second defined field is: in 2017, 2018 and 2019, where M is 9, r is 3 and M/r is 3, the value of the second common field is: 2017, 2018, 2019. The number of the values of each common field is equal, and the number of the values of each common field is M.
And S12, setting the values of the target fields in the mode table to default values.
In the embodiment of the present invention, the target field corresponds to an undefined field, both the undefined field and the target field are empty structures, and the empty structure describes that this field does not need to be structured by a data structure, when a program encounters a list-type structure, the program directly obtains a list for later use, values of the empty structure may be set to be default values, where the default values may be 0 or text information, for example, the default values are set to: data is not inquired, and similarly, the number of values of the target field is equal to the number of values of each common field, namely the number of values of the target field is M.
And S13, generating a mode table according to the value corresponding to the common field and the value of the target field in the mode table and the preset rule.
Specifically, step S13 includes:
s131, the values of the N common fields are in one-to-one correspondence to obtain M tuples, wherein for any two tuples in the M tuples, the value of a first tuple in the two tuples is not identical with the value of a second tuple in the two tuples.
In the embodiment of the present invention, the values of N general fields are in one-to-one correspondence, each general field has N values, one value is arbitrarily selected from each general field, and for the N general fields, one value is respectively selected from each general field for combination each time to obtain M tuples, each tuple having N values. The number of the normal fields is N, that is, the number of the normal fields is equal to the number of the defined fields, and for any two tuples of the M tuples, at least one value of the number of the M tuples is different from that of the number of the M tuples in the first tuple and the number of the M tuples in the second tuple, that is, any two tuples are different, for example, in the above example, the first tuple is: in area 1, 2017, the second tuple is: in area 1, 2018, the third group is: zone 1, 2019.
S132, adding a value of a target field for each tuple to generate a pattern table.
In the embodiment of the present invention, the pattern table includes M tuples, N normal fields and one target field, and for the first tuple ancestor, for example, in step S121, the first tuple ancestor is: in area 1, 2017, add a value of the target field to the first ancestor, assuming that the default value is 0, get the first ancestor as: zone 1, 2017, 0. For configurations such as: GDP in three years in three administrative areas, the resulting pattern is shown in table 1:
TABLE 1
| Administrative region | Time of day | GDP |
| Region 1 | 2017 | 0 |
| Region 1 | 2018 | 0 |
| Region 1 | 2019 | 0 |
| Region 2 | 2017 | 0 |
| Region 2 | 2018 | 0 |
| Region 2 | 2019 | 0 |
| Region 3 | 2017 | 0 |
| Region 3 | 2018 | 0 |
| Region 3 | 2019 | 0 |
And S2, inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
In the embodiment of the present invention, the data in the database is queried, and the queried data may not completely match the pattern table with respect to the data in the pattern table in the foregoing, that is, for the partial tuples in the pattern table, the data may not be queried.
Specifically, step S21 includes:
and S21, generating a query data table according to the queried data.
In the embodiment of the present invention, the query data table includes a common query field and a target query field, where each common query field corresponds to each common field, and each target query field corresponds to a target field, but as data in the database may not be complete, a value in the target query field and a value in the target field may not completely correspond to each other, for example, in the above example, a GDP in 2017 is absent in the database, a value in the target query field does not correspond to a GDP in 2017, and further, each ancestor of elements corresponding to 2017 is absent in the query data table, and it is assumed that the obtained query data table is as shown in table 2.
TABLE 2
| Administrative region | Time of day | GDP |
| Region 1 | 2018 | 25 |
| Region 1 | 2019 | 27 |
| Region 2 | 2018 | 20 |
| Region 2 | 2019 | 24 |
| Region 3 | 2018 | 22 |
| Region 3 | 2019 | 29 |
And S22, obtaining a completion data table according to the query data table and the mode table.
In the embodiment of the present invention, the mode table includes M tuples, that is, includes all possible situations corresponding to the configuration information, and in the mode table, the values of the target fields of all the tuples are default values, that is, the value of the target field without data in the database is also 0.
Specifically, step S22 includes:
s221, obtaining values of all target fields corresponding to the values of all target query fields respectively;
in the embodiment of the present invention, the queried data is correspondingly filled into the mode table, and first, the values of the target query fields are obtained, and specifically, step S221 includes:
s2211, for a value of the target query field, obtaining the value of each common query field in the same ancestor as the value.
In an embodiment of the present invention, for example, for the values of the GDP fields in table 2: 25 (i.e., one value for the target query field), the values for each of the ordinary query fields in the same unary ancestor as 25 are obtained as: region 1 and 2018.
And S2212, traversing the mode table to obtain the common fields consistent with the values of the common query fields.
In the embodiment of the present invention, the primitive progenitors in the query data table are also different from each other, and the obtained values of the common query fields are used to obtain the common fields consistent with the values of the common query fields, that is, for one primitive progenitor, the primitive progenitor where the common query field in the schema table is the same as the common field in the primitive progenitor is found according to the common query field in the primitive progenitor. For example, in the above example, the values of the general query fields in the same ancestor as 25 are: regions 1 and 2018, in the pattern table, find the same general fields as regions 1 and 2018, i.e. the general fields in the second row tuple in table 1.
And S2213, obtaining the values of the target fields corresponding to the common fields consistent with the values of the common query fields.
In the embodiment of the present invention, the obtained value of the target field is inevitably 0, and this process is mainly to correspondingly fill the value of the target query field into the mode table in order to realize positioning.
S222, replacing the corresponding obtained values of the target fields with the values of the target query fields respectively to obtain a completion data table.
In the embodiment of the present invention, the completion database has M tuples (including the tuple that the database cannot query the data), for example, in the above example, the completion data table obtained according to table 1 (the schema table) and table 2 (the query data table) is shown in table 3.
TABLE 3
It can be seen that, in the completion data table, GDP of the area 1, the area 2, and the area 3 in 2017 is shown to be 0, that is, data which cannot be searched can also be displayed.
In the invention, the values of the target fields in the mode table are all default values, and after data is inquired, the inquired data is filled in the mode table to obtain the completion data table, so that the data which can be inquired in the database in the completion data table can be displayed as the default values except the data which can be inquired in the database, so that the data which can not be inquired in the database can be clearly displayed as the default values by a user, and is the values which can not be inquired in the database and is not a system fault.
Based on the completion method for database query, the embodiment of the invention also provides a completion device for database query, which comprises: a pattern table generating module 100 and a data table complementing module 200;
the mode table generating module 100 is configured to acquire configuration information and generate a mode table according to the configuration information, where the mode table includes target fields, and values of the target fields are default values;
the data table completion module 200 is configured to query data, and obtain a completion data table according to the queried data and the mode table, where data that cannot be queried in the completion data table are all default values.
Referring to fig. 3, a computer device, which may be a terminal, having an internal structure as shown in fig. 3 according to an embodiment of the present invention is shown. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of completion of a database query. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the illustration in fig. 3 is merely a block diagram of a portion of the structure associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
The embodiment of the invention provides computer equipment, which comprises a memory and a processor, wherein the memory stores a computer program, and the computer equipment is characterized in that the processor executes the computer program and realizes the following steps:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the following steps:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
It is to be understood that the invention is not limited to the examples described above, but that modifications and variations may be effected thereto by those of ordinary skill in the art in light of the foregoing description, and that all such modifications and variations are intended to be within the scope of the invention as defined by the appended claims.
Claims (10)
1. A completion method for a database query, the method comprising:
acquiring configuration information, and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and inquiring data, and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
2. The method of claim 1, wherein the configuration information includes a defined field and an undefined field, and values corresponding to the defined field and the undefined field respectively, and wherein generating the pattern table according to the configuration information includes:
obtaining a value corresponding to a common field in the mode table according to a value corresponding to a defined field;
setting the values of the target fields in the mode table to be default values;
and generating a mode table according to a preset rule according to the value corresponding to the common field and the value of the target field in the mode table.
3. The method of claim 2, wherein the configuration information includes N defined fields, and wherein obtaining the value corresponding to the normal field in the pattern table according to the value corresponding to the defined fields comprises:
multiplying the number of values corresponding to the N defined fields respectively to obtain a product M;
the value corresponding to the a-th common field is the value of the a-th defined field in the M/r group, wherein r is the number of the values of the a-th defined field, a, r, N and M are positive integers, and a is more than or equal to 1 and less than or equal to N.
4. The method according to claim 3, wherein there are N common fields, and the generating a pattern table according to a preset rule according to the value corresponding to the common field and the value of the target field in the pattern table comprises:
the values of the N common fields are in one-to-one correspondence to obtain M tuples, wherein for any two tuples in the M tuples, the value of a first tuple in the two tuples and the value of a second tuple in the two tuples are not identical;
the value of a target field is added to each tuple to generate a pattern table.
5. The method of claim 2, wherein obtaining a completion data table from the queried data and the pattern table comprises:
generating a query data table according to the queried data;
and obtaining a complete data table according to the query data table and the mode table.
6. The method of claim 5, wherein the query data table includes a target query field, and wherein obtaining a completion data table from the query data table and the pattern table comprises:
obtaining values of all target fields corresponding to the values of all target query fields respectively;
and replacing the values of the target fields with the values of the target query fields respectively to obtain a completion data table.
7. The method of claim 6, wherein obtaining values of target fields corresponding to the values of the target query fields respectively comprises:
for one value of the target query field, acquiring the value of each common query field in the same ancestor as the value;
traversing the mode table to obtain each common field consistent with the value of each common query field;
and acquiring the value of the target field corresponding to each common field consistent with the value of each common query field.
8. An apparatus for completion of a database query, the apparatus comprising: the device comprises a mode table generation module and a data table completion module;
the mode table generating module is used for acquiring configuration information and generating a mode table according to the configuration information, wherein the mode table comprises target fields, and the values of the target fields are default values;
and the data table completion module is used for inquiring data and obtaining a completion data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the completion data table are all default values.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911044221.8A CN111008191B (en) | 2019-10-30 | 2019-10-30 | Completion method and device for database query and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911044221.8A CN111008191B (en) | 2019-10-30 | 2019-10-30 | Completion method and device for database query and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111008191A true CN111008191A (en) | 2020-04-14 |
| CN111008191B CN111008191B (en) | 2023-08-11 |
Family
ID=70111738
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911044221.8A Active CN111008191B (en) | 2019-10-30 | 2019-10-30 | Completion method and device for database query and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111008191B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505121A (en) * | 2021-05-25 | 2021-10-15 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101046812A (en) * | 2006-06-12 | 2007-10-03 | 华为技术有限公司 | Method of data base table recording structure and detection and its device |
| CN103092916A (en) * | 2012-12-14 | 2013-05-08 | 华为技术有限公司 | Method and device for modifying data structure |
| CN110134592A (en) * | 2019-04-19 | 2019-08-16 | 平安普惠企业管理有限公司 | A kind of method and device of supplementary data field, electronic equipment |
-
2019
- 2019-10-30 CN CN201911044221.8A patent/CN111008191B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101046812A (en) * | 2006-06-12 | 2007-10-03 | 华为技术有限公司 | Method of data base table recording structure and detection and its device |
| CN103092916A (en) * | 2012-12-14 | 2013-05-08 | 华为技术有限公司 | Method and device for modifying data structure |
| CN110134592A (en) * | 2019-04-19 | 2019-08-16 | 平安普惠企业管理有限公司 | A kind of method and device of supplementary data field, electronic equipment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505121A (en) * | 2021-05-25 | 2021-10-15 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111008191B (en) | 2023-08-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020253059A1 (en) | Method and apparatus for implementing multi-stage linkage drop-down box, and computer device | |
| US20200042507A1 (en) | Information Processing Method and Apparatus | |
| CN103778135A (en) | Method for distribution storage and paging querying of real-time data | |
| CN101410838A (en) | Presenting data to a user in a three-dimensional table | |
| CN104063361A (en) | Report design method and system | |
| Holme et al. | Role-similarity based functional prediction in networked systems: application to the yeast proteome | |
| US20220374406A1 (en) | KV Database Configuration Method, Query Method, Device, and Storage Medium | |
| CN114185895A (en) | Data import and export method and device, electronic equipment and storage medium | |
| CN114637811A (en) | Data table entity relation graph generation method, device, equipment and storage medium | |
| CN111008191A (en) | Completion method and device for database query and computer equipment | |
| US8880562B2 (en) | Generating a supplemental description of an entity | |
| CN115794804A (en) | Engineering internal control data visualization processing system and method based on big data technology | |
| CN103049246B (en) | Method and system for identification continuity of array data elements | |
| CN110888901B (en) | System management method, device, computer equipment and storage medium | |
| US10972353B1 (en) | Identifying change windows for performing maintenance on a service | |
| CN111652741A (en) | User preference analysis method and device and readable storage medium | |
| US20140122419A1 (en) | Method and system to promote database cost savings | |
| CN110837606A (en) | Spatio-temporal data fusion query method, device, server and storage medium | |
| CN114253951B (en) | Data processing method, system and second server | |
| CN103902148A (en) | Information processing method and electronic devices | |
| CN103049487B (en) | For the method and system of serialization matrix data elements mark | |
| EP4092610A1 (en) | Information processing method, device, system, and computer-readable storage medium | |
| CN114020733A (en) | Target data determination method and device, computer equipment and storage medium | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN114676675A (en) | Data processing method, data processing device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |