CN111259003B - Database establishment method and device - Google Patents
Database establishment method and device Download PDFInfo
- Publication number
- CN111259003B CN111259003B CN202010016078.8A CN202010016078A CN111259003B CN 111259003 B CN111259003 B CN 111259003B CN 202010016078 A CN202010016078 A CN 202010016078A CN 111259003 B CN111259003 B CN 111259003B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- mapping
- attribute value
- ordering
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24532—Query optimisation of parallel queries
-
- 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)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a database establishment method and device, and relates to the field of databases, wherein the method comprises the following steps: acquiring a data identifier and a sorting attribute value set of data to be stored; generating sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set; and sequencing and storing the sequencing data according to a preset sequencing and storing scheme to obtain a database with a specific data sequence. It can be seen that this implementation can solve the problem of poor query effect when the data volume is large, and can also be applied to a high-concurrency data query scene.
Description
Technical Field
The present application relates to the field of database technologies, and in particular, to a method and an apparatus for establishing a database.
Background
With the rapid development of technology, more and more technologies can be implemented by a computer; as is well known, computer-implemented techniques typically require a large amount of data support, which necessitates the creation of a database. At present, the database is usually built in a sequential storage mode, so that in the process of data query, the database data needs to be reordered, and further the larger the data quantity is, the worse the query effect is; on the other hand, the number of concurrent queries supported by the current database is small, and the method cannot be applied to a high concurrent data query scene.
Disclosure of Invention
The embodiment of the application aims to provide a database building method and device, and the database built by the database building method and device can solve the problem of poor query effect when the data volume is large and can be applied to a high-concurrency data query scene.
An embodiment of the present application provides a method for establishing a database, where the method includes:
acquiring a data identifier and a sorting attribute value set of data to be stored;
generating sequencing data conforming to the data storage structure according to a preset data storage structure, the data identification and the sequencing attribute value set;
and sequencing and storing the sequencing data according to a preset sequencing and storing scheme to obtain a database with a specific data sequence.
In the implementation process, the database establishing method can obtain a large amount of data to be stored preferentially, and simultaneously obtain a data ID and a sorting attribute value set corresponding to each data to be stored, wherein the sorting attribute value set comprises a plurality of sorting attribute values, and a priority order of sequencing exists among the sorting attribute values; after the data identification and the ordering attribute value set of the data to be stored are obtained, the data ID and the ordering attribute value set are preprocessed, so that the structure obtained by preprocessing accords with a preset data storage structure, the data storage structure can adapt to a preset ordering storage scheme, the ordering storage of the data is facilitated, and a database with a specific data sequence is obtained. Therefore, by implementing the embodiment, the sorting data conforming to the data storage structure can be obtained through preprocessing the data to be stored, so that the finally established database is constructed based on the sorting data, the database can be orderly constructed through the corresponding sorting of the data in the database, the problem of poor query effect when the data volume is large can be solved in the process of using the database, and the method can be applied to a high-concurrency data query scene.
Further, the method further comprises:
generating mapping data conforming to a mapping storage structure according to a preset mapping storage structure, the data identification and the ordering attribute value set;
and storing the mapping data according to a preset mapping storage scheme to obtain a data table for inquiring the data identification and ordering attribute value set.
In the implementation process, after the database is acquired, the method can also process the data identifier and the sorting attribute value set to obtain mapping data conforming to a preset mapping storage structure, wherein the mapping data is used for representing the mapping relation between the data identifier and the sorting attribute value set except the first sorting attribute value set; after the mapping data is obtained, a corresponding mapping storage instruction is extracted from a preset mapping storage scheme, so that the mapping data can be nested into the mapping storage instruction, and the mapping storage instruction can store the mapping data into a preset data table, wherein the data table is used for inquiring the data identification and the ordering attribute value set. Therefore, by implementing the embodiment, after the database is built, the mapping relation between the data ID and the ordering data can be further built to support the data set (the data table) for inquiring the serial number of the single data, so that after the database is built, a better inquiring effect can be achieved in inquiring the single data, the using effect of the database is improved, and the using purpose of the database is enriched.
Further, the step of generating the ranking data conforming to the data storage structure according to the preset data storage structure, the data identifier and the ranking attribute value set includes:
acquiring a database number corresponding to the data identifier;
acquiring a first order attribute value included in the order attribute value set;
generating a sequencing array according to the data identification and the sequencing attribute value set;
substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure.
In the implementation process, to obtain the ordered data, the database number corresponding to the data identifier can be preferentially obtained, so that the data identifiers are stored in the same database; then, acquiring the first sorting attribute value included in the sorting attribute value set, and confirming the first sorting attribute value in the database, wherein the attribute value with the highest data sorting priority is obtained; then, generating a sorting array according to the data identification and the sorting attribute value set, wherein the sorting array does not comprise the first sorting attribute value, and as for the data identification, the sorting array is arranged at the tail end of the sorting attribute value set except the first sorting attribute value and used for representing the mapping relation between the sorting attribute value set except the first sorting attribute value and the data; finally, substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure, wherein the structural parameters are several parameters included in the data storage structure, and substitution means corresponding substitution. Therefore, by implementing the embodiment, corresponding specific data can be correspondingly acquired according to various structural parameters included in the data storage structure, so that the data storage structure can obtain effective ordering data after the specific data are filled, the acquisition of the ordering data is more accurate and effective, the ordering of the data in the database can be further improved through the ordering data of the data storage structure, the establishment of an ordered and stable database is facilitated, and the improvement of the convenience in use of subsequent inquiry is facilitated.
Further, the step of sorting and storing the sorted data according to a preset sorting and storing scheme to obtain a database with a specific data sequence includes:
invoking a database storage instruction according to a preset ordering storage scheme;
and sequencing and storing the sequencing data according to the database storage instruction to obtain a database with a specific data sequence.
In the implementation process, the method calls a database storage instruction preferentially according to a preset ordering storage scheme in the final database establishment process, wherein the database storage instruction can be a data information input instruction; after the database storage instruction is acquired, the method can embed the ordering data into the database storage instruction to obtain an instruction with ordering storage information, so that the ordering storage information (namely the ordering data) is input into the database corresponding to the database number through the instruction, and the database with the specific data sequence is established. Therefore, by implementing the implementation mode, the ordered data can be orderly stored into the database through the database storage instruction, so that the database has corresponding ordering in the establishment process, the problem of poor query effect when the data volume is large is solved conveniently, and meanwhile, the method can be applied to a high-concurrency data query scene.
Further, the step of generating mapping data conforming to the mapping storage structure according to the preset mapping storage structure, the data identifier and the ordering attribute value set includes:
acquiring a data number corresponding to the data identifier;
generating a mapping array according to the data identification and the ordering attribute value set;
substituting the data number, the data identifier and the mapping array as structural parameters into a preset mapping storage structure to obtain mapping data conforming to the mapping storage structure.
In the implementation process, the method can preferentially acquire the data number corresponding to the data identifier in the process of acquiring the mapping data, and then generates a mapping array according to the data identifier and the ordering attribute value set, wherein the mapping array comprises the ordering attribute value set except the first ordering attribute value and the data number; after the data number, the mapping array and the data identifier are obtained, the data number, the mapping array and the data identifier are embedded into a preset mapping storage structure, so that the mapping storage structure generates mapping data after combining specific data, and the mapping data also accords with the mapping storage structure. Therefore, by implementing the implementation mode, the number and the mark corresponding to the data and the mapping array corresponding to the mark can be obtained, so that the one-to-one mapping relation among the data, the mark and the mapping array is realized, and the establishment of the mapping relation is beneficial to the improvement of the query convenience and the query accuracy of the database in use.
Further, the step of storing the mapping data according to a preset mapping storage scheme to obtain a data table for querying the data identifier and the sorting attribute value set includes:
calling a data table to generate an instruction according to a preset mapping storage scheme;
and storing the mapping data according to the data table generating instruction to obtain a data table for inquiring the data identification and the ordering attribute value set.
In the implementation process, in the process of acquiring the data table for representing the data mapping relationship, the method can call a data table generation instruction according to a preset mapping storage scheme, wherein the data table generation instruction can be a data table generation instruction for generating a hash table; after the data table generating instruction is acquired, the mapping data is nested into the data table generating instruction, so that the new data table generating instruction can directly store the mapping data into the data table, and the data table can be used for querying the data identification and the ordering attribute value set. Therefore, by implementing the implementation mode, the mapping data can be stored in the data table through the data table generation instruction, so that the data table can be helpful for unidirectional query of the data after the database is built, and the problems of poor query effect when the data volume is large and high concurrent processing difficulty in the data query process can be solved.
Further, the database creation method is executed by a preset program execution script.
In the implementation process, the method is executed by using the preset program execution script, and the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
A second aspect of the embodiments of the present application provides a database creation device, where the database creation device includes:
the acquisition unit is used for acquiring a data identifier and a sorting attribute value set of the data to be stored;
the first generation unit is used for generating sequencing data conforming to the data storage structure according to a preset data storage structure, the data identification and the sequencing attribute value set;
the first storage unit is used for carrying out sequencing storage on the sequencing data according to a preset sequencing storage scheme to obtain a database with a specific data sequence.
In the implementation process, the database establishing device can acquire the data identifier and the ordering attribute value set of the data to be stored through the acquisition unit; the first generation unit can also generate sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set; and finally, sequencing and storing the sequencing data according to a preset sequencing and storing scheme through the first storage unit to obtain a database with a specific data sequence. Therefore, by implementing the embodiment, the sorting data conforming to the data storage structure can be obtained through preprocessing the data to be stored by each unit, so that the finally established database is constructed based on the sorting data, the database can be orderly constructed through the corresponding sorting of the data in the database, the problem that the query effect is poor when the data volume is large can be solved in the process of using the database, and the method can be applied to a high-concurrency data query scene.
Further, the database creation device further includes:
the second generation unit is used for generating mapping data conforming to the mapping storage structure according to a preset mapping storage structure, the data identification and the ordering attribute value set;
and the second storage unit is used for storing the mapping data according to a preset mapping storage scheme to obtain a data table for inquiring the data identification and the ordering attribute value set.
In the implementation process, after the database is built, a data set (the data table) for storing the mapping relation between the data IDs and the ordering data to support the sequence number of the single data to be queried can be further built, so that after the database is built, a good query effect can be achieved in the process of querying the single data, the use effect of the database is improved, and the use purpose of the database is enriched.
Further, the first generating unit includes:
the first acquisition subunit is used for acquiring the database number corresponding to the data identifier;
the first obtaining subunit is further configured to obtain a first ordering attribute value included in the ordering attribute value set;
A first generation subunit, configured to generate a ranking array according to the data identifier and the ranking attribute value set;
and the first generation of sub-unit is used for substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure.
In the implementation process, corresponding specific data can be correspondingly acquired according to various structural parameters included in the data storage structure, so that the data storage structure obtains effective ordering data after the specific data are filled, the acquisition of the ordering data is more accurate and effective, the ordering of the data in the database can be further improved through the ordering data of the data storage structure, the ordered and stable database establishment is facilitated, and the improvement of the convenience in use of subsequent inquiry is facilitated.
Further, the first storage unit includes:
the first calling subunit is used for calling the database storage instruction according to a preset ordering storage scheme;
and the first storage subunit is used for sequencing and storing the sequencing data according to the database storage instruction to obtain a database with a specific data sequence.
In the implementation process, the ordered data can be orderly stored into the database through the database storage instruction, so that the database has corresponding ordering in the establishment process, the problem of poor query effect when the data volume is large is solved conveniently, and meanwhile, the method can be applied to a high-concurrency data query scene.
Further, the second generating unit includes:
the second acquisition subunit is used for acquiring the data number corresponding to the data identifier;
the second generation subunit is used for generating a mapping array according to the data identification and the ordering attribute value set;
and the second substituting subunit is used for substituting the data number, the data identifier and the mapping array as structural parameters into a preset mapping storage structure to obtain mapping data conforming to the mapping storage structure.
In the implementation process, the number and the mark corresponding to the data and the mapping array corresponding to the mark can be obtained, so that the one-to-one mapping relation among the data, the mark and the mapping array is realized, and the establishment of the mapping relation is beneficial to the improvement of the query convenience and the query accuracy of the database in use.
Further, the second storage unit includes:
the second calling subunit is used for calling the data table to generate an instruction according to a preset mapping storage scheme;
and the second storage subunit is used for storing the mapping data according to the data table generation instruction to obtain a data table for inquiring the data identification and the ordering attribute value set.
In the implementation process, the mapping data can be stored in the data table through the data table generation instruction, so that the data table can be helpful for unidirectional query of the data after the database is established, and the problems of poor query effect when the data volume is large and high concurrent processing difficulty in the data query process can be solved.
Further, the database creation means executes based on a preset program execution script.
In the implementation process, the method is executed by using the preset program execution script, and the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
A third aspect of the embodiments of the present application provides an electronic device, including a memory and a processor, where the memory is configured to store a computer program, and the processor is configured to execute the computer program to cause the electronic device to perform the database creation method according to any one of the first aspect of the embodiments of the present application.
A fourth aspect of the embodiments of the present application provides a computer readable storage medium storing computer program instructions which, when read and executed by a processor, perform a database creation method according to any one of the first aspect of the embodiments of the present application.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flow chart of a database establishing method according to an embodiment of the present application;
FIG. 2 is a flowchart of another database creation method according to an embodiment of the present disclosure;
FIG. 3 is a flowchart illustrating another database creation method according to an embodiment of the present disclosure;
fig. 4 is a schematic structural diagram of a database establishing device according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of another database creating apparatus according to an embodiment of the present application
Fig. 6 is a schematic flow chart of writing data to be ordered by Lua script according to an embodiment of the present application;
fig. 7 is a schematic flow chart of a read data list according to an embodiment of the present application;
fig. 8 is a schematic flow chart of reading a single data sequence number according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance.
Example 1
Referring to fig. 1, fig. 1 is a flowchart of a database creation method according to an embodiment of the present application. The method is applied to the establishment process of the database, and particularly, when the method is applied to the establishment of the database with larger data volume, the method is used for fundamentally solving the problem of low performance of data query in the database by using sql sentences to designate a plurality of ordering conditions and the problem of less concurrent query quantity. The database establishment method comprises the following steps:
S101, acquiring a data identifier and a sorting attribute value set of data to be stored.
In this embodiment, the data to be stored may be one data or may be a plurality of data, which is not limited in this embodiment.
In this embodiment, the data to be stored may be understood as one characterizing data of a plurality of data to be stored, and when it is understood, the storage flow of each data to be stored in the plurality of data to be stored is the same.
In this embodiment, the data to be stored may be described as one data of a plurality of data types, where each data of the plurality of data types may be understood as being in the processing of the data to be stored.
In this embodiment, the data identifier is a data ID of the data to be stored, that is, an identity identifier of the data to be stored.
In this embodiment, the data ID may be X1.
In this embodiment, the set of sorting attribute values is a set of a plurality of sorting attribute values, where when the sorting attribute values are set to S1, S2 … Sn, the data to be stored will be sorted according to a plurality of attributes such as S1, S2 … Sn, that is: s1 is firstly ordered, and then S2 is ordered under the condition that S1 is the same, and Sn is the same.
S102, generating sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set.
In this embodiment, the data storage structure is preset, and the data storage structure is a modified Sets data structure conforming to Redis.
In this embodiment, the data identifier is the data ID described above.
In this embodiment, the ordering data is a data set conforming to the SORTED set data structure of Redis.
S103, sorting and storing the sorted data according to a preset sorting and storing scheme to obtain a database with a specific data sequence.
In this embodiment, the ordering storage scheme includes ordering storage instructions, and application occasions of the ordering storage instructions.
In this embodiment, since the sorting data has a sorting effect in the process of sorting storage, a specific data sequence is naturally generated in the process of storage so that the generated database has the specific data sequence.
In this embodiment, the database creation method is executed by a preset program execution script.
By implementing the implementation mode, the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
In this embodiment, the execution subject of the method may be a computing device such as a computer or a server, which is not limited in this embodiment.
In this embodiment, the execution body of the method may be an intelligent device such as an intelligent mobile phone and a tablet, which is not limited in this embodiment.
In this embodiment, in the conventional Redis-based Sorted Sets data structure, a plurality of attributes to be Sorted are assembled into a large number according to high and low bits and stored in a score value, and Sorted Sets are stored in a score size order when data is newly added. When inquiring, directly utilizing the api provided by Redis. The limitation of this scheme is that the score value of the signed Sets is kept with 64-bit floating point numbers, only allowed to be in the range of- (2-53) to + (2-53). If the number of ordering attributes is relatively large, or if the values of some attributes are also 64 bits long, it may occur that the assembled values exceed the scope of score values. A score outside this range will be expressed in terms of scientific counts and will lose accuracy resulting in a wrong ordering. It can be seen that the implementation of this embodiment described in this embodiment can avoid the above-mentioned problems, thereby improving the database usage effect.
As can be seen, implementing the database building method described in fig. 1 can preferentially obtain a large amount of data to be stored, and simultaneously obtain a data ID and a sorting attribute value set corresponding to each data to be stored, where the sorting attribute value set includes a plurality of sorting attribute values, and a priority order of sequencing exists among the plurality of sorting attribute values; after the data identification and the ordering attribute value set of the data to be stored are obtained, the data ID and the ordering attribute value set are preprocessed, so that the structure obtained by preprocessing accords with a preset data storage structure, the data storage structure can adapt to a preset ordering storage scheme, the ordering storage of the data is facilitated, and a database with a specific data sequence is obtained. Therefore, by implementing the embodiment, the sorting data conforming to the data storage structure can be obtained through preprocessing the data to be stored, so that the finally established database is constructed based on the sorting data, the database can be orderly constructed through the corresponding sorting of the data in the database, the problem of poor query effect when the data volume is large can be solved in the process of using the database, and the method can be applied to a high-concurrency data query scene.
Example 2
Referring to fig. 2, fig. 2 is a flowchart of another database creation method according to an embodiment of the present application. The flow chart of the database creation method described in fig. 2 is modified from the flow chart of the database creation method described in fig. 1. The database establishment method comprises the following steps:
s201, acquiring a data identifier and a sorting attribute value set of data to be stored.
In this embodiment, the data to be stored may be one data or may be a plurality of data, which is not limited in this embodiment.
In this embodiment, the data to be stored may be understood as one characterizing data of a plurality of data to be stored, and when it is understood, the storage flow of each data to be stored in the plurality of data to be stored is the same.
In this embodiment, the data to be stored may be described as one data of a plurality of data types, where each data of the plurality of data types may be understood as being in the processing of the data to be stored.
In this embodiment, the data identifier is a data ID of the data to be stored, that is, an identity identifier of the data to be stored.
In this embodiment, the data ID may be X1.
In this embodiment, the set of sorting attribute values is a set of a plurality of sorting attribute values, where when the sorting attribute values are set to S1, S2 … Sn, the data to be stored will be sorted according to a plurality of attributes such as S1, S2 … Sn, that is: s1 is firstly ordered, and then S2 is ordered under the condition that S1 is the same, and Sn is the same.
S202, generating sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set.
In this embodiment, the data storage structure is preset, and the data storage structure is a modified Sets data structure conforming to Redis.
In this embodiment, the data identifier is the data ID described above.
In this embodiment, the ordering data is a data set conforming to the SORTED set data structure of Redis.
S203, sorting and storing the sorted data according to a preset sorting and storing scheme to obtain a database with a specific data sequence.
In this embodiment, the ordering storage scheme includes ordering storage instructions, and application occasions of the ordering storage instructions.
In this embodiment, since the sorting data has a sorting effect in the process of sorting storage, a specific data sequence is naturally generated in the process of storage so that the generated database has the specific data sequence.
S204, generating mapping data conforming to the mapping storage structure according to the preset mapping storage structure, the data identification and the ordering attribute value set.
In this embodiment, a mapping storage structure is preset, and the mapping storage structure is a hash structure conforming to Redis.
In this embodiment, the data identifier is the data ID described above.
In this embodiment, the ordering data is a data set conforming to the Hashes data structure of the Redis.
S205, storing the mapping data according to a preset mapping storage scheme to obtain a data table for inquiring the data identification and ordering attribute value sets.
In this embodiment, the data table may be a hash table.
In this embodiment, the mapping storage scheme includes a mapping storage instruction, and an application occasion of the mapping storage instruction.
In this embodiment, the data table may be stored one data by one data in the storing process.
By implementing the embodiment, the mapping relation between the user ID and the ordering attribute value set can be stored in the Haies structure of the Redis, so that the requirement of inquiring the ordering sequence number corresponding to the specified data ID can be met.
In this embodiment, the database creation method is executed by a preset program execution script.
By implementing the implementation mode, the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
In this embodiment, the program execution script may be a lua script, where the storing logic is implemented by using the lua script, because the Redis will execute the lua script as a whole, so that other commands will not be inserted in the database establishment process, thereby ensuring the consistency of the data in the Redis.
In this embodiment, the data is already stored in the specified order after the Redis is written, and only the api of the Redis is required to be called to read the ordered data in the specified range when the query is performed.
In this embodiment, the execution subject of the method may be a computing device such as a computer or a server, which is not limited in this embodiment.
In this embodiment, the execution body of the method may be an intelligent device such as an intelligent mobile phone and a tablet, which is not limited in this embodiment.
It can be seen that, by implementing the database building method described in fig. 2, through preprocessing the data to be stored, the ordering data conforming to the data storage structure is obtained, so that the finally built database is built based on the ordering data, so that the database can complete ordered building through the corresponding ordering of the data in the database, and further the database can solve the problem of poor query effect when the data volume is large in the process of being used, and can also be applied to a high-concurrency data query scene
Example 3
Referring to fig. 3, fig. 3 is a flowchart of another database creation method according to an embodiment of the present application. The flow chart of the database creation method described in fig. 3 is modified from the flow chart of the database creation method described in fig. 2. The database establishment method comprises the following steps:
s301, acquiring a data identifier and a sorting attribute value set of data to be stored.
In this embodiment, the data to be stored may be one data or may be a plurality of data, which is not limited in this embodiment.
In this embodiment, the data to be stored may be understood as one characterizing data of a plurality of data to be stored, and when it is understood, the storage flow of each data to be stored in the plurality of data to be stored is the same.
In this embodiment, the data to be stored may be described as one data of a plurality of data types, where each data of the plurality of data types may be understood as being in the processing of the data to be stored.
In this embodiment, the data identifier is a data ID of the data to be stored, that is, an identity identifier of the data to be stored.
In this embodiment, the data ID may be X1.
In this embodiment, the set of sorting attribute values is a set of a plurality of sorting attribute values, where when the sorting attribute values are set to S1, S2 … Sn, the data to be stored will be sorted according to a plurality of attributes such as S1, S2 … Sn, that is: s1 is firstly ordered, and then S2 is ordered under the condition that S1 is the same, and Sn is the same.
S302, acquiring a database number corresponding to the data identifier.
In this embodiment, the database number refers to a ranking of data, where the ranking of data may be R1.
In this embodiment, the database number may be equal to the ranking R1 of the data obtained by adding the traversed index I1 to the database query start value N1 during the database retrieval process.
In this embodiment, the database number corresponds to R1.
S303, acquiring a first order attribute value included in the order attribute value set.
In this embodiment, the combination of the sorting attribute values includes S1, S2 … Sn, where the first sorting attribute value is S1.
In this embodiment, the first-order attribute value corresponds to S1.
S304, generating a sequencing array according to the data identification and the sequencing attribute value set.
In this example, S2 … Sn and X1 were as follows: "the partitions are spliced into a string V1 in sequence.
In this embodiment, the ordered array corresponds to V1.
S305, substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure.
In this embodiment, the preset data storage structure is a modified set data structure of dis (Remote Dictionary Server, remote dictionary service), and the modified set data structure includes three structural parameters of key score module.
In this embodiment, the data structure of the soned Sets of Redis is Sorted according to the score values, and then the dictionary sorting is performed according to the membrane values when the score values are the same. The score value is stored with 64-bit floating point numbers, only allowed to be in the range of- (2A 53) to + (2A 53). Wherein the number of members is not limited in length.
In this embodiment, the database number R1 is substituted into the key position, the first ranking attribute value S1 is substituted into the score position, and the ranking array V1 is substituted into the member position, thereby obtaining the ranking data conforming to the data storage structure.
By implementing the implementation mode, the requirements of sorting according to S1 and then sorting according to S2 … Sn can be achieved. Wherein, X1 is added in the module to fetch the data ID through the module value when inquiring.
S306, calling a database storage instruction according to a preset ordering storage scheme.
In this embodiment, the database storage instruction may be a dis Zadd command.
In this embodiment, the Redis Zadd command is used to add one or more member elements and their score values to the ordered set. If a member is already a member of the ordered set, the score value for that member is updated and the member is guaranteed to be in the correct position by reinserting the member element. The fractional value may be an integer value or a double precision floating point number. If the ordered set key does not exist, a null ordered set is created and a Zadd operation is performed. When a key exists but is not of ordered set type, an error is returned.
In this embodiment, the Redis Zadd command basic syntax is as follows:
redis 127.0.0.1:6379>ZADD KEY_NAME SCORE1 VALUE1..SCOREN VALUEN。
s307, sorting and storing the sorting data according to the database storage instruction to obtain a database with a specific data sequence.
In this embodiment, this step may be understood as a procedure to Redis that invokes the Redis Zadd command to store ordering data.
S308, acquiring a data number corresponding to the data identifier.
In this embodiment, the data number corresponds to a number corresponding to each data, and the number is generally identified by the H1 label.
S309, generating a mapping array according to the data identification and the ordering attribute value set.
In this embodiment, the mapping array has the same content as the ordering array, and is denoted by V1.
S310, substituting the data number, the data identification and the mapping array as structural parameters into a preset mapping storage structure to obtain mapping data conforming to the mapping storage structure.
In this embodiment, the mapping storage structure is a structures of Redis, where the structures of Redis include three structural parameters of key field value.
In this embodiment, the data number H1 is substituted into the key position, the mapping array V1 is substituted into the field position, and the data identifier X1 is substituted into the field position, so as to obtain the mapping data conforming to the mapping storage structure.
S311, calling a data table generation instruction according to a preset mapping storage scheme.
In this embodiment, the data table generating instruction may be a redishset command.
In this embodiment, the Redis Hset command is used to assign values to fields in the hash table. If the hash table does not exist, a new hash table is created and HSET operations are performed. If the field is already present in the hash table, the old value will be overwritten. S312, storing the mapping data according to the data table generation instruction to obtain a data table for inquiring the data identification and ordering the attribute value set.
In this embodiment, the Redis Hset command basic syntax is as follows:
redis 127.0.0.1:6379>HSET KEY_NAME FIELD VALUE。
in this embodiment, the database creation method is executed by a preset program execution script.
By implementing the implementation mode, the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
In this embodiment, the program execution script may be a lua script, where the storing logic is implemented by using the lua script, because the Redis will execute the lua script as a whole, so that other commands will not be inserted in the database establishment process, thereby ensuring the consistency of the data in the Redis.
In this embodiment, the above-described process can be understood as a process in which Lua writes data to be sorted.
In this embodiment, the data is already stored in the specified order after the Redis is written, and only the api of the Redis is required to be called to read the ordered data in the specified range when the query is performed.
For example, referring to fig. 6, fig. 6 is a schematic flow chart of Lua writing data to be sorted, wherein the flow chart in fig. 6 is the same as that described in the explanation of the embodiment, and therefore, redundant description is omitted.
Referring to fig. 7, fig. 7 is a schematic flow chart of the read data list, wherein the principle for reading the ordered data list is explained as follows: the process obtains a Sorted data list L1 from a Sorted Sets data structure of Redis according to a specified starting sequence number N1 and ending sequence number N2 through a zrevrangebyscore instruction; then, traversing L1 in sequence, intercepting the last character string data: "the character string after is stored as character string X1, X1 is the ID of the data, N1 plus index I1 of traversal is the rank R1 of the data. Thus we have queried all data IDs between the range of N1 to N2 and the ordering number of each data ID.
Referring to fig. 8, fig. 8 is a flow chart of reading a single data sequence number, wherein the principle of reading a single data sequence number is explained as follows: invoking HGET command and parameter X1 (data ID) to obtain D1 from REDIS's Hashes data structure, D1 is the same as X1 stored in the member value of the signed set structure; the recall command zrepackl command and the parameter D1 obtain the sequence number M1 of the data X1 from the soded Sets structure of REDIS; this results in a sequence number after ordering of a single piece of data.
In this embodiment, the execution subject of the method may be a computing device such as a computer or a server, which is not limited in this embodiment.
In this embodiment, the execution body of the method may be an intelligent device such as an intelligent mobile phone and a tablet, which is not limited in this embodiment.
Therefore, after the database is built, the method for building the database described in fig. 3 can further build a data set (the data table) for storing the mapping relation between the data IDs and the ordering data to support the sequence numbers of the single data to be queried, so that after the database is built, a better query effect can be achieved in the process of querying the single data, thereby being beneficial to improving the use effect of the database and enriching the use of the database; corresponding specific data can be correspondingly obtained according to various structural parameters included in the data storage structure, so that the data storage structure can obtain effective ordering data after the specific data are filled, the ordered data are more accurately and effectively obtained, the ordering data of the data storage structure can be used for further improving the ordering of the data in the database, the ordered and stable database establishment is facilitated, and the convenience in use of subsequent inquiry is improved; the ordered data can be orderly stored into the database through the database storage instruction, so that the database has corresponding ordering in the process of establishment, the problem of poor query effect when the data volume is large is solved, and meanwhile, the method can be applied to a high-concurrency data query scene; the number and the mark corresponding to the data and the mapping array corresponding to the mark can be obtained, so that a one-to-one mapping relation among the data, the mark and the mapping array is realized, and the establishment of the mapping relation is favorable for improving the query convenience and the query accuracy of the database in use; mapping data can be stored in the data table through the data table generation instruction, so that the data table can be helpful for unidirectional query of data after the establishment of a database is completed, and the problems of poor query effect when the data volume is large and high concurrent processing difficulty in the data query process can be solved; finally, the method is executed by using a preset program execution script, and the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
Example 4
Referring to fig. 4, fig. 4 is a schematic structural diagram of a database establishing device according to an embodiment of the present application. Wherein the database creation device includes:
an obtaining unit 410, configured to obtain a data identifier and a set of sorting attribute values of data to be stored;
the first generating unit 420 is configured to generate ordering data according to a preset data storage structure, a data identifier, and an ordering attribute value set;
the first storage unit 430 is configured to store the ordered data in an ordered manner according to a preset ordered storage scheme, so as to obtain a database with a specific data sequence.
In this embodiment, the explanation of the database creation device may refer to the description in embodiment 1, embodiment 2 or embodiment 3, and the description is not repeated in this embodiment.
It can be seen that implementing the database creation apparatus described in fig. 4, the data identification and the sorting attribute value set of the data to be stored can be acquired by the acquisition unit; the first generation unit can also generate sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set; and finally, sequencing and storing the sequencing data according to a preset sequencing and storing scheme through the first storage unit to obtain a database with a specific data sequence. Therefore, by implementing the embodiment, the sorting data conforming to the data storage structure can be obtained through preprocessing the data to be stored by each unit, so that the finally established database is constructed based on the sorting data, the database can be orderly constructed through the corresponding sorting of the data in the database, the problem that the query effect is poor when the data volume is large can be solved in the process of using the database, and the method can be applied to a high-concurrency data query scene.
Example 5
Referring to fig. 5, fig. 5 is a schematic structural diagram of another database creating apparatus according to an embodiment of the present application. The schematic structure of the database creation apparatus depicted in fig. 5 is modified from the schematic structure of the database creation apparatus depicted in fig. 4. Wherein, this database establishment device still includes:
a second generating unit 440, configured to generate mapping data according to the mapping storage structure, the data identifier, and the ordering attribute value set;
the second storage unit 450 is configured to store the mapping data according to a preset mapping storage scheme, and obtain a data table for querying the data identifier and ordering the attribute value set.
As an alternative embodiment, the first generating unit 420 includes:
a first obtaining subunit 421, configured to obtain a database number corresponding to the data identifier;
the first obtaining subunit 421 is further configured to obtain a first ordering attribute value included in the ordering attribute value set;
a first generation subunit 422, configured to generate a ranking array according to the data identifier and the ranking attribute value set;
the first generation entry subunit 423 is configured to substitute the database number, the first order attribute value, and the order array as structural parameters into a preset data storage structure to obtain order data that conforms to the data storage structure.
As an alternative embodiment, the first storage unit 430 includes:
a first calling subunit 431, configured to call the database storage instruction according to a preset ordering storage scheme;
the first storage subunit 432 is configured to store the ordered data according to the database storage instruction in an ordered manner, so as to obtain a database with a specific data sequence.
In the implementation process, the ordered data can be orderly stored into the database through the database storage instruction, so that the database has corresponding ordering in the establishment process, the problem of poor query effect when the data volume is large is solved conveniently, and meanwhile, the method can be applied to a high-concurrency data query scene.
As an alternative embodiment, the second generating unit 440 includes:
a second obtaining subunit 441, configured to obtain a data number corresponding to the data identifier;
a second generating subunit 442, configured to generate a mapping array according to the data identifier and the set of ordering attribute values;
the second substituting subunit 443 is configured to substitute the data number, the data identifier, and the mapping array as structural parameters into a preset mapping storage structure, so as to obtain mapping data that conforms to the mapping storage structure.
As an alternative embodiment, the second storage unit 450 includes:
a second calling subunit 451, configured to call the data table generation instruction according to a preset mapping storage scheme;
the second storage subunit 452 is configured to store the mapping data according to the data table generating instruction, and obtain a data table for querying the data identifier and ordering the attribute value set.
As an alternative embodiment, the database creation means is executed based on a preset program execution script.
In the implementation process, the method is executed by using the preset program execution script, and the method can be executed as a whole, so that the method cannot be inserted by other commands in the execution process, the consistency of data in a database can be ensured, and the stability of data storage can be ensured.
In this embodiment, the explanation of the database creation device may refer to the description in embodiment 1, embodiment 2 or embodiment 3, and the description is not repeated in this embodiment.
It can be seen that implementing the database creation apparatus described in fig. 5, the data identification and the sorting attribute value set of the data to be stored can be acquired by the acquisition unit; the first generation unit can also generate sequencing data conforming to the data storage structure according to a preset data storage structure, a data identifier and a sequencing attribute value set; and finally, sequencing and storing the sequencing data according to a preset sequencing and storing scheme through the first storage unit to obtain a database with a specific data sequence. Therefore, by implementing the embodiment, the sorting data conforming to the data storage structure can be obtained through preprocessing the data to be stored by each unit, so that the finally established database is constructed based on the sorting data, the database can be orderly constructed through the corresponding sorting of the data in the database, the problem that the query effect is poor when the data volume is large can be solved in the process of using the database, and the method can be applied to a high-concurrency data query scene.
An embodiment of the present application provides an electronic device, including a memory and a processor, where the memory is configured to store a computer program, and the processor is configured to execute the computer program to cause the electronic device to perform any one of the database creation methods of embodiment 1, embodiment 2, and embodiment 3 of the present application.
The present embodiments provide a computer readable storage medium storing computer program instructions that, when read and executed by a processor, perform the database creation method of any one of embodiments 1, 2, and 3 of the present application.
In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other manners as well. The apparatus embodiments described above are merely illustrative, for example, flow diagrams and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, the functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely exemplary embodiments of the present application and is not intended to limit the scope of the present application, and various modifications and variations may be suggested to one skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present application should be included in the protection scope of the present application. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
The foregoing is merely specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the present application, and the changes and substitutions are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Claims (11)
1. A method of database creation, the method comprising:
acquiring a data identifier and a sorting attribute value set of data to be stored;
generating sequencing data conforming to the data storage structure according to a preset data storage structure, the data identification and the sequencing attribute value set;
sequencing and storing the sequencing data according to a preset sequencing and storing scheme to obtain a database with a specific data sequence; the ordering and storing scheme comprises ordering and storing instructions, and application time and application occasions of the ordering and storing instructions;
the step of generating the ordering data conforming to the data storage structure according to the preset data storage structure, the data identifier and the ordering attribute value set includes:
acquiring a database number corresponding to the data identifier;
acquiring a first order attribute value included in the order attribute value set;
generating a sequencing array according to the data identification and the sequencing attribute value set;
substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure.
2. The database creation method according to claim 1, characterized in that the method further comprises:
generating mapping data conforming to a mapping storage structure according to a preset mapping storage structure, the data identification and the ordering attribute value set;
storing the mapping data according to a preset mapping storage scheme to obtain a data table for inquiring the data identification and the ordering attribute value set; the mapping storage scheme comprises mapping storage instructions and application occasions of the mapping storage instructions.
3. The method for creating a database according to claim 1, wherein the step of sorting and storing the sorted data according to a preset sorting and storing scheme to obtain a database having a specific data sequence comprises:
invoking a database storage instruction according to a preset ordering storage scheme;
and sequencing and storing the sequencing data according to the database storage instruction to obtain a database with a specific data sequence.
4. The database creation method according to claim 2, wherein the step of generating mapping data conforming to the mapping storage structure from the preset mapping storage structure, the data identifier, and the set of ordering attribute values includes:
Acquiring a data number corresponding to the data identifier;
generating a mapping array according to the data identification and the ordering attribute value set;
substituting the data number, the data identifier and the mapping array as structural parameters into a preset mapping storage structure to obtain mapping data conforming to the mapping storage structure.
5. The method for creating a database according to claim 2, wherein the step of storing the mapping data according to a preset mapping storage scheme to obtain a data table for querying the data identifier and the set of ordering attribute values includes:
calling a data table to generate an instruction according to a preset mapping storage scheme;
and storing the mapping data according to the data table generating instruction to obtain a data table for inquiring the data identification and the ordering attribute value set.
6. The database creation method according to claim 1, wherein the database creation method is executed by a preset program execution script.
7. A database creation apparatus, characterized in that the database creation apparatus comprises:
the acquisition unit is used for acquiring a data identifier and a sorting attribute value set of the data to be stored;
The first generation unit is used for generating sequencing data conforming to the data storage structure according to a preset data storage structure, the data identification and the sequencing attribute value set;
the first storage unit is used for carrying out sequencing storage on the sequencing data according to a preset sequencing storage scheme to obtain a database with a specific data sequence; the ordering and storing scheme comprises ordering and storing instructions, and application time and application occasions of the ordering and storing instructions;
wherein the first generation unit includes:
the first acquisition subunit is used for acquiring the database number corresponding to the data identifier;
the first obtaining subunit is further configured to obtain a first ordering attribute value included in the ordering attribute value set;
a first generation subunit, configured to generate a ranking array according to the data identifier and the ranking attribute value set;
and the first generation of sub-unit is used for substituting the database number, the first order attribute value and the order array as structural parameters into a preset data storage structure to obtain order data conforming to the data storage structure.
8. The database creation apparatus according to claim 7, wherein said database creation apparatus further comprises:
The second generation unit is used for generating mapping data conforming to the mapping storage structure according to a preset mapping storage structure, the data identification and the ordering attribute value set;
the second storage unit is used for storing the mapping data according to a preset mapping storage scheme to obtain a data table for inquiring the data identification and the ordering attribute value set; the mapping storage scheme comprises mapping storage instructions and application occasions of the mapping storage instructions.
9. The database creation apparatus according to claim 7, wherein the database creation apparatus is executed based on a preset program execution script.
10. An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the electronic device to perform the database creation method of any of claims 1 to 6.
11. A readable storage medium, characterized in that the readable storage medium has stored therein computer program instructions, which when read and executed by a processor, perform the database creation method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010016078.8A CN111259003B (en) | 2020-01-07 | 2020-01-07 | Database establishment method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010016078.8A CN111259003B (en) | 2020-01-07 | 2020-01-07 | Database establishment method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111259003A CN111259003A (en) | 2020-06-09 |
| CN111259003B true CN111259003B (en) | 2023-07-21 |
Family
ID=70950754
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010016078.8A Active CN111259003B (en) | 2020-01-07 | 2020-01-07 | Database establishment method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111259003B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113986936A (en) * | 2021-10-19 | 2022-01-28 | 北京达佳互联信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013070185A1 (en) * | 2011-11-07 | 2013-05-16 | Empire Technology Development Llc | Cache based key-value store mapping and replication |
| CN103164408B (en) * | 2011-12-09 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Information based on vertical search engine stores, querying method and device thereof |
| ES2636758T3 (en) * | 2013-08-30 | 2017-10-09 | Pilab S.A. | Procedure implemented by computer to improve query execution in standardized relational databases at level 4 and higher |
| CN110019287B (en) * | 2017-07-20 | 2021-09-14 | 华为技术有限公司 | Method and device for executing Structured Query Language (SQL) instruction |
-
2020
- 2020-01-07 CN CN202010016078.8A patent/CN111259003B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN111259003A (en) | 2020-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107247808B (en) | Distributed NewSQL database system and picture data query method | |
| US9678969B2 (en) | Metadata updating method and apparatus based on columnar storage in distributed file system, and host | |
| CN113297320B (en) | Distributed database system and data processing method | |
| CN103902698A (en) | Data storage system and data storage method | |
| CN106255962B (en) | System and method for improved data structure storage | |
| CN110019111B (en) | Data processing method, data processing device, storage medium and processor | |
| CN110134681B (en) | Data storage and query method and device, computer equipment and storage medium | |
| EP3889797A1 (en) | Database index and database query processing method, apparatus, and device | |
| CN111125229A (en) | Data blood margin generation method and device and electronic equipment | |
| CN111078205A (en) | Modular programming method and device, storage medium and electronic equipment | |
| CN113312338A (en) | Data consistency checking method, device, equipment, medium and program product | |
| CN105677805A (en) | Data storing and reading method and device using protobuf | |
| CN111259003B (en) | Database establishment method and device | |
| CN108038253B (en) | Log query processing method and device | |
| CN111125216B (en) | Method and device for importing data into Phoenix | |
| CN111290714A (en) | Data reading method and device | |
| CN111190895A (en) | Method and device for organizing columnar storage data and storage medium | |
| CN114116907A (en) | Database synchronization method and device, electronic equipment and storage medium | |
| EP3091447B1 (en) | Method for modifying root nodes and modifying apparatus | |
| CN115617773A (en) | Data migration method, device and system | |
| CN108090034B (en) | Cluster-based uniform document code coding generation method and system | |
| CN114115908A (en) | Instruction set generation method, program analysis method, device and storage medium | |
| US10198249B1 (en) | Accessing schema-free databases | |
| US10380090B1 (en) | Nested object serialization and deserialization | |
| US8849866B2 (en) | Method and computer program product for creating ordered data structure |
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 |