CN111008191B - 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
- CN111008191B CN111008191B CN201911044221.8A CN201911044221A CN111008191B CN 111008191 B CN111008191 B CN 111008191B CN 201911044221 A CN201911044221 A CN 201911044221A CN 111008191 B CN111008191 B CN 111008191B
- Authority
- CN
- China
- Prior art keywords
- field
- target
- data
- values
- value
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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
Abstract
The application discloses a completion method, a device and computer equipment for database query, 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 all default values; inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values. In the application, the values of the target fields in the mode table are all default values, after data is queried, the queried data is filled into the mode table to obtain the full data table, so that the data which can be queried in the database except the data which can be queried in the database in the full data table can be displayed as the default values, so that the data which can not be queried in the database is explicitly displayed as the default values by a user, and is not the value which can not be queried in the database, and the system fault is not caused.
Description
Technical Field
The present application relates to the field of internet of things, and in particular, to a method, an apparatus, and a computer device for supplementing a database query.
Background
In a daily industrial scene, the lack of data is a very common situation, for example, when terminal equipment stops running due to insufficient urban power supply and data generated by various parts of a company are collected, a time difference always lacks data of certain departments, usually the deleted data is not cleaned in a large condition when the data is input into a database, the database is characterized in that the data which is not input cannot be inquired, and the data which is not input cannot be displayed when an interface is displayed, so that a client can consider that a system has a problem instead of inquiring the data.
Accordingly, the prior art is subject to improvement and development.
Disclosure of Invention
The application aims to solve the technical problem of providing a database query completion method, a database query completion device and a database query completion computer device, so as to complete query data and display unobserved data as a default value.
In a first aspect, the present application provides a method for complementing 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
As a further improvement, 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 the mode table according to the configuration information includes:
obtaining a value corresponding to a common field in the mode table according to the value corresponding to the defined field;
setting the values of target fields in the mode table as 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 the obtaining, according to a value corresponding to the defined field, a value corresponding to a common field in the mode table includes:
multiplying the number of the values corresponding to the N defined fields respectively to obtain a product M;
the value corresponding to the a-th common field is M/r groups of a-th defined field, wherein r is the number of the a-th defined field values, and 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, the number of the common fields is N, and the generating a pattern table according to a preset rule and according to a value corresponding to the common field and a value of the target field in the pattern table 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 is not identical to the value of a second tuple in the two tuples;
a pattern table is generated by adding a value of a target field to each tuple.
As a further improvement technical solution, the obtaining a complement 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 complement data table according to the query data table and the mode table.
As a further improvement, the query data table includes a target query field, and the obtaining the complement data table according to the query data table and the schema table includes:
acquiring the value of each target field corresponding to the value of each target query field;
and respectively replacing the values of the target fields with the values of the target query fields to obtain a complement data table.
As a further improvement technical solution, the obtaining the 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 of the value;
traversing the pattern table to obtain each common field consistent with the value of each common query field;
the value of the target field corresponding to each common field consistent with the value of each common query field is obtained.
In a second aspect, the present application provides a completion apparatus for database queries, the apparatus comprising: the system comprises a mode table generating module and a data table complementing module;
the mode table generation 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 all default values;
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 application provides a computer device comprising a memory storing a computer program and a 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
In a fourth aspect, the present application 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
Compared with the prior art, the embodiment of the application has the following advantages:
the method provided by the embodiment of the application 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 all default values; inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values. In the application, the values of the target fields in the mode table are all default values, after data is queried, the queried data is filled into the mode table to obtain the full data table, so that the data which can be queried in the database except the data which can be queried in the database in the full data table can be displayed as the default values, so that the data which can not be queried in the database is explicitly displayed as the default values by a user, and is not the value which can not be queried in the database, and the system fault is not caused.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments described in the present application, and other drawings may be obtained according to the drawings without inventive effort to those skilled in the art.
FIG. 1 is a flow chart of a method for supplementing a database query in an embodiment of the application;
FIG. 2 is a schematic diagram of a database query completion apparatus according to an embodiment of the present application;
fig. 3 is an internal structural diagram of a computer device in an embodiment of the present application.
Detailed Description
In order to make the present application better understood by those skilled in the art, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
Referring to fig. 1, an embodiment of the present application provides a method for complementing a database query, where the method may include the steps of:
s1, 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 all default values.
In the embodiment of the application, the database is defined 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, the values in the same field have the same attribute, for example, in an address book, the field is a name, and the fields corresponding to the name have a plurality of different values (names of different people), but all the values represent the names of people and have the same attribute.
The configuration information provides various fields to be displayed, and the types of the various fields, wherein the configuration information comprises defined fields and undefined fields, and values corresponding to the defined fields and the undefined fields respectively, and specifically, the step S1 comprises:
s11, obtaining a value corresponding to a common field in the mode table according to the value corresponding to the defined field.
In the embodiment of the present application, in the database, the value corresponding to the defined field may be directly set, without detection, while the value of the undefined field may be obtained through detection, operation, etc. processes, for example, if it is required to query the GDP in three years of the plurality of administrative areas, the plurality of administrative areas may be corresponding to one defined field, three years to another defined field, and the GDP is corresponding to one undefined field, to obtain: first defined field: administrative area, second defined field: time, undefined field: GDP.
Further, the values of the defined fields may be set directly, and each field may have a plurality of values, for example, for the administrative area field in the above example, the values of the administrative area field may be set as follows: for region 1, region 2 and region 3, for the time field, the values of the time field may be set to be respectively: 2017, 2018 and 2019.
Specifically, step S11 includes:
s111, multiplying the number of the values corresponding to the N defined fields respectively to obtain a product M.
In the embodiment of the present application, the common fields of the mode table correspond to the defined fields in the configuration information, the names of the common fields correspond to the names of the defined fields, respectively, and the common fields are different from the defined fields in terms of their values, but the values of the common fields can be obtained according to the values of the defined fields. For example, for the above example, it is necessary to query GDPs within three years of a plurality of administrative areas, and the values of the first defined fields (administrative area fields) are respectively: the values of the time fields are respectively: in 2017, 2018 and 2019, the administrative area field has 3 values, the time field has 3 values, 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 M/r groups, wherein r is the number of the a-th defined field, and 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 application, for example, when a=1, in the above example, the value of the first defined field is: region 1, region 2 and region 3, m= 9,r =3, m/r=3, the value of the first normal field is: region 1, region 2, region 3, region 1, region 2, region 3. a=2, in the above example, the value of the second defined field is: in 2017, 2018 and 2019, m= 9,r =3, M/r=3, the value of the second common field is: 2017, 2018, 2019, 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.
S12, setting the values of the target fields in the mode table as default values.
In the embodiment of the present application, the target field corresponds to an undefined field, and both the undefined field and the target field are in a null structure, and the null structure describes that this field does not need to be structured in a data structure, when a program encounters a structure of a list type, the program directly obtains the list for later use, and the values of the null structure can be set to be default values, and the default values can be 0 or text information, for example, the default values are set to be: the data is not queried, and the number of the values of the target field is equal to the number of the values of each common field, namely, the number of the values of the target field is M.
S13, 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.
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 to the value of a second tuple in the two tuples.
In the embodiment of the application, the values of the N common fields are in one-to-one correspondence, each common field has N values, one value is arbitrarily selected from each common field, and for the N common fields, one value is selected from each common field at a time to be combined to obtain M tuples, and each tuple has N values. The number of the common fields is N, that is, the number of the common fields is equal to the number of the defined fields, for any two tuples of the M tuples, there is at least one difference in value between a first tuple of the two tuples and a second tuple of the two tuples, that is, any two tuples are different, for example, in the above example, the first tuple is: in region 1, 2017, the second tuple is: in region 1, 2018, the third tuple is: region 1, 2019.
S132, adding a value of a target field for each tuple to generate a mode table.
In the embodiment of the present application, the pattern table includes M tuples, N normal fields and one target field, and for the first ancestor, for example, in step S121, the first ancestor is: in the region 1 and 2017, a target field value is added to the first ancestor, and assuming that the default value is 0, the first ancestor is obtained as follows: region 1, 2017, 0. For the configuration: GDP within three years of three administrative areas, the resulting patterns are shown in Table 1:
TABLE 1
| Administrative region | Time | GDP |
| Zone 1 | 2017 | 0 |
| Zone 1 | 2018 | 0 |
| Zone 1 | 2019 | 0 |
| Zone 2 | 2017 | 0 |
| Zone 2 | 2018 | 0 |
| Zone 2 | 2019 | 0 |
| Zone 3 | 2017 | 0 |
| Zone 3 | 2018 | 0 |
| Zone 3 | 2019 | 0 |
S2, inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
In the embodiment of the application, the data in the database is queried, and the queried data may not completely match the pattern table relative to the data in the previous pattern table, i.e. the data may not be queried for partial tuples in the pattern table.
Specifically, step S21 includes:
s21, generating a query data table according to the queried data.
In the embodiment of the present application, the query data table includes a normal query field and a target query field, where each normal query field corresponds to each normal field, and each target query field corresponds to a target field, but since data in the database may not be full, a value in the target query field may not fully correspond to a value of the target field, 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 thus, each element corresponding to 2017 is not found in the query data table, and the obtained query data table is assumed to be shown in table 2.
TABLE 2
| Administrative region | Time | GDP |
| Zone 1 | 2018 | 25 |
| Zone 1 | 2019 | 27 |
| Zone 2 | 2018 | 20 |
| Zone 2 | 2019 | 24 |
| Zone 3 | 2018 | 22 |
| Zone 3 | 2019 | 29 |
S22, obtaining a complement data table according to the query data table and the mode table.
In the embodiment of the present application, the pattern table includes M tuples, that is, includes all possible situations corresponding to the configuration information, and in the pattern table, the values of the target fields of all tuples are default values, that is, the values of the target fields without data in the database are also 0.
Specifically, step S22 includes:
s221, acquiring the value of each target field corresponding to the value of each target query field;
in the embodiment of the present application, the queried data is correspondingly filled into the pattern table, and first, the values of the target fields corresponding to the values of the target query fields are obtained, specifically, step S221 includes:
s2211, for one value of the target query field, acquiring the value of each common query field in the same ancestor of the value.
In an embodiment of the present application, for example, for the value of the GDP field in table 2: 25 (i.e., for one value of the target query field), the values of the common query fields that are in the same ancestor of the same origin as 25 are obtained as: regions 1 and 2018.
S2212, traversing the mode table to obtain each common field consistent with the value of each common query field.
In the embodiment of the application, the element progenitors in the query data table are also mutually unequal, and the obtained values of the common query fields are used for obtaining the common fields consistent with the values of the common query fields, namely, for one element progenitors, the element progenitors in which the common query fields identical with the common fields of the element progenitors are positioned in the mode table are found according to the common query fields in the element progenitors. For example, in the above example, the values of the common query fields at the same ancestor of the same origin as 25 are: areas 1 and 2018, in the pattern table, find the same general fields as areas 1 and 2018, i.e., the general fields in the second row tuple in table 1.
S2213, the values of the target fields corresponding to the common fields consistent with the values of the common query fields are obtained.
In the embodiment of the application, the obtained target field value is necessarily 0, and the process is mainly to realize positioning, and the value of the target query field is correspondingly filled in the mode table.
S222, respectively replacing the values of the corresponding acquired target fields with the values of the target query fields to obtain a complement data table.
In the embodiment of the present application, the complement database has M tuples (including the tuple of which the database cannot query the data), for example, in the above example, the complement data table is obtained according to table 1 (schema table) and table 2 (query data table) as shown in table 3.
TABLE 3 Table 3
It can be seen that in the completed data table, the GDP of region 1, region 2, and region 3 at 2017 is shown as 0, i.e., the data that is not queried can also be displayed.
In the application, the values of the target fields in the mode table are all default values, after data is queried, the queried data is filled into the mode table to obtain the full data table, so that the data which can be queried in the database except the data which can be queried in the database in the full data table can be displayed as the default values, so that the data which can not be queried in the database is explicitly displayed as the default values by a user, and is not the value which can not be queried in the database, and the system fault is not caused.
Based on the above-mentioned method for supplementing the database query, the embodiment of the application also provides a device for supplementing the database query, which comprises: a pattern table generation module 100 and a data table completion module 200;
the mode table generating module 100 is configured to obtain configuration information, and generate a mode table according to the configuration information, where the mode table includes a target field, and values of the target field are all 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 the data that cannot be queried in the completion data table is a default value.
Referring to fig. 3, a computer device, which may be a terminal, is shown in an embodiment of the present application, and the internal structure is shown in fig. 3. 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 includes a non-volatile 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 the operating system and computer programs in the non-volatile storage media. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a method of complementing 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, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the block diagram of FIG. 3 is merely a partial structure associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements are applied, and that a particular computer device may include more or less components than those shown, or may combine some of the components, or have a different arrangement of components.
An embodiment of the present application provides a computer device, including a memory and a processor, where the memory stores a computer program, and the processor executes the computer program to implement 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
The embodiment of the application also provides a computer readable storage medium, on which a computer program is stored, characterized in that the computer program when executed by a processor 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
It is to be understood that the application is not limited in its application to the examples described above, but is capable of modification and variation in light of the above teachings by those skilled in the art, and that all such modifications and variations are intended to be included within the scope of the appended claims.
Claims (7)
1. A method of supplementing 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 all default values;
inquiring data, and obtaining a complement data table according to the inquired data and the mode table, wherein the data which cannot be inquired in the complement data table are all default values;
the configuration information comprises a defined field and an undefined field, and values respectively corresponding to the defined field and the undefined field, and the generating a mode table according to the configuration information comprises the following steps:
obtaining a value corresponding to a common field in the mode table according to the value corresponding to the defined field;
setting the values of target fields in the mode table as default values;
generating a mode table according to a preset rule according to a value corresponding to a common field and a value of a target field in the mode table;
the obtaining a complement data table according to the queried data and the mode table comprises the following steps:
generating a query data table according to the queried data;
obtaining a complement data table according to the query data table and the mode table;
the query data table comprises a target query field, and the obtaining the complement data table according to the query data table and the mode table comprises the following steps:
acquiring the value of each target field corresponding to the value of each target query field;
respectively replacing the values of the target fields by the values of the target query fields to obtain a complement data table;
and the target field corresponds to an undefined field, and the undefined field and the target field are in a null structure.
2. The method according to claim 1, wherein the configuration information includes N defined fields, and the obtaining the value corresponding to the normal field in the pattern table according to the value corresponding to the defined field includes:
multiplying the number of the values corresponding to the N defined fields respectively to obtain a product M;
the value corresponding to the a-th common field is M/r groups of a-th defined field, wherein r is the number of the a-th defined field values, and a, r, N and M are positive integers, and a is more than or equal to 1 and less than or equal to N.
3. The method according to claim 2, wherein the number of the common fields is N, and the generating the pattern table according to the value corresponding to the common field and the value of the target field in the pattern table and the preset rule 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 is not identical to the value of a second tuple in the two tuples;
a pattern table is generated by adding a value of a target field to each tuple.
4. The method according to claim 1, wherein the obtaining the 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 of the value;
traversing the pattern table to obtain each common field consistent with the value of each common query field;
the value of the target field corresponding to each common field consistent with the value of each common query field is obtained.
5. A completion apparatus for database queries, the apparatus comprising: the system comprises a mode table generating module and a data table complementing module;
the mode table generation 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 all default values;
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;
the configuration information comprises a defined field and an undefined field, and values respectively corresponding to the defined field and the undefined field;
the mode table generation module is specifically configured to:
obtaining a value corresponding to a common field in the mode table according to the value corresponding to the defined field;
setting the values of target fields in the mode table as default values;
generating a mode table according to a preset rule according to a value corresponding to a common field and a value of a target field in the mode table;
the data table complement module is specifically configured to:
generating a query data table according to the queried data;
obtaining a complement data table according to the query data table and the mode table;
the query data table includes a target query field;
acquiring the value of each target field corresponding to the value of each target query field;
respectively replacing the values of the target fields by the values of the target query fields to obtain a complement data table;
and the target field corresponds to an undefined field, and the undefined field and the target field are in a null structure.
6. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 4 when the computer program is executed.
7. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 4.
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 CN111008191A (en) | 2020-04-14 |
| CN111008191B true 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) |
Families Citing this family (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111008191A (en) | 2020-04-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7797341B2 (en) | Desensitizing database information | |
| AU2013335231B2 (en) | Profiling data with location information | |
| CN108733681B (en) | Information processing method and device | |
| US8990675B2 (en) | Automatic relationship detection for spreadsheet data items | |
| US6993529B1 (en) | Importing data using metadata | |
| US8195647B2 (en) | Abstract records | |
| US20130173664A1 (en) | Mapping non-relational database objects into a relational database model | |
| US10037388B2 (en) | Fast querying of social network data | |
| WO2019024496A1 (en) | Enterprise recommendation method and application server | |
| JP2009515258A (en) | System and method for storing item attributes in an electronic catalog | |
| US20120166250A1 (en) | Data visualization for time-based cohorts | |
| CN104063361A (en) | Report design method and system | |
| CN105550270A (en) | Database inquiry method and device | |
| Holme et al. | Role-similarity based functional prediction in networked systems: application to the yeast proteome | |
| US9336245B2 (en) | Systems and methods providing master data management statistics | |
| CN114185895A (en) | Data import and export method and device, electronic equipment and storage medium | |
| CN111008191B (en) | Completion method and device for database query and computer equipment | |
| US20050138001A1 (en) | Optimization for aggregate navigation for distinct count metrics | |
| US20080114752A1 (en) | Querying across disparate schemas | |
| CN115794804A (en) | Engineering internal control data visualization processing system and method based on big data technology | |
| CN110515967B (en) | Spark calculation framework-based data analysis method and electronic equipment | |
| US9323817B2 (en) | Distributed storage system with pluggable query processing | |
| US20050283460A1 (en) | Database apply-managing system, database apply-managing method and recording medium | |
| CN111652741A (en) | User preference analysis method and device and readable storage medium | |
| Wu et al. | UMine: Study on Prevalent Co-locations Mining from Uncertain Data Sets |
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 |