CN112162904B - Order change process integration method, extraction method, integration device and extraction device - Google Patents
Order change process integration method, extraction method, integration device and extraction device Download PDFInfo
- Publication number
- CN112162904B CN112162904B CN202011026446.3A CN202011026446A CN112162904B CN 112162904 B CN112162904 B CN 112162904B CN 202011026446 A CN202011026446 A CN 202011026446A CN 112162904 B CN112162904 B CN 112162904B
- Authority
- CN
- China
- Prior art keywords
- binlog
- data
- order
- open source
- data table
- 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
- 238000000034 method Methods 0.000 title claims abstract description 68
- 238000000605 extraction Methods 0.000 title claims abstract description 24
- 230000010354 integration Effects 0.000 title claims abstract description 23
- 238000005192 partition Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 6
- 238000012163 sequencing technique Methods 0.000 claims 1
- 230000000694 effects Effects 0.000 abstract description 2
- 239000000284 extract Substances 0.000 abstract description 2
- 230000009286 beneficial effect Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 2
- 238000013075 data extraction Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 230000004807 localization Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- 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/2228—Indexing structures
- G06F16/2255—Hash tables
-
- 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
-
- 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/248—Presentation of query results
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to the field of computers, in particular to an order change process integration method, an extraction method, an integration device and an extraction device, wherein the integration method comprises the steps of adding binlog logs in various databases into a queue; consuming the binlog in the queue; storing the consumed binlog in a distributed open source database. Adding all the binlog logs into a queue, consuming the binlog by the queue, and storing the binlog into a distributed open source database, so that the binlog generated by all the databases are all located in the same distributed open source database, and integrating the binlog is realized. The related personnel do not need to switch among a plurality of systems and do not need to filter redundant logs. And related personnel can conveniently inquire, extract or call the binlog. The application has the effect of improving the efficiency of order problem positioning.
Description
Technical Field
The present application relates to the field of computers, and in particular, to an order change process integrating method, an order change process extracting method, an integrating device, and an extracting device.
Background
As business systems become more complex, a business process needs to involve multiple intersystem calls to complete. And the increase in business complexity also increases the chance of order problems. When an order has a problem, the problem of the order needs to be positioned, and then the source of the problem can be known.
In the related art, order problem localization is typically achieved by logging many redundant logs in advance in the business system. In the order problem positioning process, switching is performed among all systems, redundant logs are filtered, and useful logs are obtained.
Aiming at the related technology, the inventor considers that developers need to switch and search related logs in a plurality of systems, redundant logs are more, steps are complicated, the process is complex, and the order problem positioning efficiency is reduced.
Disclosure of Invention
In order to improve order problem positioning efficiency, the application provides an order change process integration method, an extraction method, an integration device and an extraction device.
In a first aspect, the present application provides an order change process integration method, which adopts the following technical scheme:
An order change process integration method comprises the steps of adding binlog logs in various databases into a queue; consuming the binlog in the queue; storing the consumed binlog in a distributed open source database.
By adopting the technical scheme, when an order has a problem, a corresponding binlog log is generated in a database related to the order, and the change process of the order is recorded in the binlog. And collecting all the generated binlog logs into a queue, and consuming the binlog logs in the queue to enable the binlog logs to be added into a distributed open source database. When related personnel need to locate a certain order problem, as the binlog logs of all order change processes are located in the distributed open source database, the related personnel can query in the distributed open source database. And (3) searching the relevant binlog log without switching among a plurality of systems. The redundant logs are not required to be filtered, the operation is simple, the convenience and the rapidness are realized, and the order problem positioning efficiency is improved.
Preferably, the distributed open source database comprises a plurality of data tables, each data table corresponds to one database, and each data table is provided with a corresponding data table name; each data table comprises a plurality of partitions, and each partition is provided with a corresponding partition number; the binlog is stored in a corresponding one of the partitions in a corresponding one of the data tables.
By adopting the technical scheme, a plurality of partitions are preset in the data table, so that more uniform data distribution is facilitated. The hot spot data is avoided, and the I/O consumption generated during automatic partitioning is reduced, so that the overall performance of the distributed open source database is improved.
Preferably, the partition number calculates a hash value according to the order number in the binlog log, and then the hash value is obtained and generated.
By adopting the technical scheme, since the order number is fixed, the partition number is also fixed. When a binlog is added to a certain data table, the relevant binlog of different order numbers are assigned to different partitions. The binlog log quantity in each partition is relatively uniform, which is beneficial to improving the performance of the distributed open source database, thereby being beneficial to improving the query speed and the extraction speed of data and improving the order problem positioning efficiency.
Preferably, a RowKey of the distributed open source database is formed according to the data table name, the partition number and the order number; adding an update type as a column name of the data table in a character string form according to the offset in the queue; converting rowData of the binlog into json character strings as values stored in the distributed open source database; and storing rowData of the converted binlog into the corresponding data table.
By adopting the technical scheme, rowKey of the distributed open source database and column names of the data table are generated according to rules, so that data in the distributed open source database can be conveniently searched and extracted in the later period, and the order problem positioning efficiency can be improved.
In a second aspect, the present application provides a method for extracting an order change process, which adopts the following technical scheme,
An order change process extraction method comprises the steps of obtaining a query request, extracting corresponding binlog log data from a distributed open source database according to the query request, and returning the extracted binlog data to a query interface.
By adopting the technical scheme, after receiving the query request, the corresponding binlog log data is extracted from the distributed open source database according to the query request. Because the binlog log data are all located in the distributed open source database, related personnel do not need to switch the system and also need to filter redundant logs. The method is simple to operate, convenient and quick, and is beneficial to improving the efficiency of order problem positioning.
Preferably, the query request includes order number information, database information and data table information, and when the data table information is empty, all binlog log data corresponding to the order number information and the database information are extracted from the distributed open source database according to the order number information and the database information, and the binlog data are ordered according to the generation time of the binlog data.
By adopting the technical scheme, when the binlog logs are integrated, the binlog logs are distributed into the corresponding partitions according to the order numbers. When the method is used for extracting, the corresponding binlog log data is queried and extracted according to the order number, so that the method is accurate and quick and is not easy to generate errors. The extracted binlog log data are ordered according to time, so that query personnel can view and understand the binlog data, and the efficiency of order problem positioning can be improved.
Preferably, when the binlog log data is extracted, the corresponding RowKey set is generated according to the RowKey rule when the binlog log data is generated, and the binlog log data is queried in the distributed open source database.
By adopting the technical scheme, when the method is used for extracting, the RowKey generation rule used for inquiring the binlog log data is the same as that used when the binlog is integrated, so that the binlog log data is extracted more accurately and rapidly, and the order problem positioning efficiency is improved.
Preferably, when sorting according to the generation time of the binlog log data, if the generation time of the binlog data is the same, the binlog data is arranged according to the priority of the corresponding data table.
By adopting the technical scheme, the time is the same, and the corresponding binlog log data are ordered according to the priority of the data table in the database. Binlog log data is not easy to confuse, lose and make mistakes. The method is convenient for inquiry personnel to check and understand, and is helpful for improving the efficiency of order problem positioning.
In a third aspect, the present application provides an order changing process integrating apparatus, which adopts the following technical scheme,
An order change process integration device comprises a first memory and a first processor, wherein the first memory is stored with a computer program which can be loaded by the first processor and execute the order change process integration method.
In a fourth aspect, the present application provides an order changing process extracting apparatus, which adopts the following technical scheme,
An order change process extraction device comprises a second memory and a second processor, wherein a computer program capable of being loaded by the second processor and executing the order change process extraction method is stored in the second memory.
In summary, the present application includes at least one of the following beneficial technical effects:
1. Adding all binlog logs into a queue, consuming the binlog by the queue, storing the binlog into a distributed open source database, and enabling the binlog generated by all databases to be positioned in the same distributed open source database, so that the integration of the binlog is realized, the query, extraction or calling of the binlog by related personnel is facilitated, and the efficiency of order problem positioning is improved;
2. The query personnel inputs the query request, extracts the corresponding binlog log data from the distributed open source database according to the query request, does not need to switch among a plurality of systems, does not need to filter redundant logs, and is beneficial to improving the order problem positioning efficiency.
Drawings
FIG. 1 is a flow diagram of an order change process integration method;
FIG. 2 is a flow diagram of an order change process extraction method.
Detailed Description
The application is described in further detail below with reference to fig. 1-2.
Binlog log: is a binary log of MySQL database for recording the SQL statement information of the user's operation on the database. When the database is changed, the database generates a binlog log, and records the change data.
When a problem occurs in an order, the change process of the order in the database can be traced back by querying the binlog log related to the order. Helping to find the cause of the problem with the order. Because each order is provided with a corresponding order number, the binlog logs of the data changes in different databases can be collected according to the order numbers, and the change process of the query order in the databases in the whole life cycle is realized.
The embodiment of the application discloses an order change process integration method. Referring to fig. 1, the order change process integration method includes S1, obtaining a binlog log: and adding the binlog logs corresponding to the data tables in the databases into the queues. S2, queue consumption: a consumer is started to consume the binlog in the queue. S3, log storage: storing the consumed binlog in a distributed open source database.
In this embodiment, the queue selects MQ (Message Queue) a message queue. MQ (Message Queue) message queues are one type of data structure that is "first in first out" in the underlying data structure. The method is generally used for solving the problems of application decoupling, asynchronous message and flow peak clipping and the like, and realizing a high-performance, high-availability, scalable and final consistency architecture.
In this embodiment, the distributed open source database selects the HBASE database. The HBASE is a distributed and column-oriented open source database, the data model of the HBASE is a sparse, multidimensional and ordered mapping table, and the index of the table is a row key, a column group, a column qualifier and a timestamp, so that simple operations of insertion, inquiry, deletion and clearing can be performed.
The distributed open source database comprises a plurality of data tables, each data table corresponds to one database, and each data table is provided with a corresponding data table name. The data table names are set according to the corresponding databases. Each data table comprises a plurality of subareas, and each subarea is respectively provided with a corresponding subarea number. And calculating a hash value according to the order number in the binlog log, and then taking the remainder to generate the partition number. It should be appreciated that the order number of each order is a fixed string. The generation of the order number is regular and can be circulated, for example, the order number is composed of ten digits, and the mantissa of the order number is circulated back and forth by 0-9. When the number of the partitions is set, the partitions are set according to the generation rule of the order numbers. And if the mantissa of the order number is 0-9 and the cycle is repeated, setting 10 partitions. The partition numbers calculated by taking the remainder through the hash value correspond to mantissas of the order numbers, namely ten partition numbers are respectively 0-9. When the end number of the order is 5, then the binlog log associated with the order is stored in the partition with the partition number of 5. In this way, the binlog log stored in each partition is regularly circulated, so that later inquiry and extraction are facilitated. And the data in each partition is relatively balanced, which is helpful for improving the performance of the distributed open source database.
And splicing the partition number, the data table name and the order number through '|' to obtain the RowKey required by storing the RowKey into the distributed open source database. RowKey can be understood as an identification that facilitates knowing where the binlog should exist. The update type is added in the form of a string as the column name of the data table according to the offset in the queue. The Offset is automatically generated data with an identification function in the queue, and the binlog logs added to the queue are added with a corresponding Offset, so that the Offset corresponding to each binlog is unique. The update type is carried by the binlog, and when the database is changed to generate the binlog, the change type data is stored in the corresponding binlog according to the type of the change of the database. The offset and the update type are used as column names of the data table, so that the column names in the data table are not easy to repeat, and the phenomenon of data coverage is avoided.
Converting rowData of the binlog into json character strings as values stored in the distributed open source database; and storing rowData of the converted binlog logs into the corresponding data table to integrate the binlog logs.
The implementation principle of the order change process integration method in the embodiment of the application is as follows: the method comprises the steps of knowing which partition of a distributed open source database is required to store a binlog corresponding to an order according to the order number of the order. And then the corresponding RowKey is known according to the data in the binlog, a column is established in the corresponding data table, and the offset and the update type are used as column names of the data table. Then converting rowData of the binlog into json character strings as values stored in the distributed open source database, so that the binlog data are stored in the distributed open source database, and later searching and calling are facilitated. Because the binlog logs generated by all databases are located in the distributed open source databases, related personnel do not need to switch among a plurality of databases for searching the binlog logs, and redundant logs do not need to be filtered, so that the order problem positioning efficiency is improved.
The embodiment of the application also discloses an order change process extraction method. Referring to fig. 2, the order change process extraction method includes L1, request acquisition: a query request is obtained. The query request includes order number information, database information, and data table information. That is, when a inquirer inquires about a relevant binlog of an order, the order number of the order, the name of the database to be inquired, and the name of a certain data table in the database need to be input. The order number is order number information, the database name is database information, and the data table name is data table information. In addition, the data sheet information may not be filled in. When the data table information is not filled in, the data table information in the acquired query request is empty.
L2, data extraction: and extracting corresponding binlog log data from the distributed open source database according to the query request. Because the query request comprises order number information, database information and data table information, when the binlog log data in the distributed open source database is extracted, a corresponding RowKey set is generated according to a RowKey rule when the binlog log data is generated, and the corresponding binlog data is queried in the distributed open source database according to the RowKey set. The RowKey rule when generating binlog log data is that partition numbers, data table names and order numbers are spliced by '|'. The partition number can be obtained through the order number in the query request, and the data table name can be obtained according to the database information in the query request.
And when the data table information is empty, extracting all binlog log data corresponding to the order number information and the database information from the distributed open source database according to the order number information and the database information.
The extracted binlog log data are ordered according to the generation time of each binlog log data, and when the generation time of a plurality of binlog log data is the same, the extracted binlog data are arranged according to the priority of the corresponding data table.
L3, data return: and returning the extracted binlog log data to the query interface.
The implementation principle of the order change process extraction method in the embodiment of the application is as follows: after the query request is acquired, a RowKey set is generated according to order number information, database information and data table information in the query request, and corresponding binlog log data is extracted from the distributed open source database according to the RowKey and the order number. And then the extracted data is returned to the query interface for the query personnel to check. The inquirer does not need to switch among a plurality of databases, which is beneficial to improving the efficiency of order problem positioning.
The embodiment of the application also discloses an order change process integrating device. The order change process integration device comprises a first memory and a first processor, wherein the first memory is stored with a computer program which can be loaded by the first processor and execute the order change process integration method.
The embodiment of the application also discloses an order change process extraction device. The order change process extraction device comprises a second memory and a second processor, wherein the second memory is stored with a computer program which can be loaded by the second processor and execute the order change process extraction method.
The above embodiments are not intended to limit the scope of the present application, so: all equivalent changes in structure, shape and principle of the application should be covered in the scope of protection of the application.
Claims (4)
1. An order change process integration method, comprising:
Adding the binlog logs in each database to a queue;
Consuming the binlog in the queue;
Storing the consumed binlog into a distributed open source database; the distributed open source database comprises a plurality of data tables, each data table corresponds to one database, and each data table is provided with a corresponding data table name; each data table comprises a plurality of partitions, and each partition is provided with a corresponding partition number; the partition number calculates a hash value according to the order number in the binlog log and then generates the remainder;
The step of storing the consumed binlog in the distributed open source database specifically comprises: forming a RowKey of the distributed open source database according to the data table name, the partition number and the order number; adding an update type as a column name of the data table in a character string form according to the offset in the queue; converting rowData of the binlog into json character strings as values stored in the distributed open source database; and storing rowData of the converted binlog into the corresponding data table.
2. An order change process extraction method, comprising:
acquiring a query request; the inquiry request comprises order number information, database information and data table information;
extracting corresponding binlog log data from a distributed open source database according to the query request; when the data table information is empty, extracting all binlog log data corresponding to the order number information and the database information from the distributed open source database according to the order number information and the database information, and sequencing according to the generation time of the binlog log data;
The step of extracting the corresponding binlog log data specifically includes: generating a corresponding RowKey set according to a RowKey rule when the binlog log data is generated, and inquiring the binlog data in the distributed open source database;
After the step of sorting according to the generation time of the binlog log data, if the generation time of a plurality of pieces of the binlog data is the same, sorting according to the priority of the corresponding data table;
and returning the extracted binlog log data to a query interface.
3. An order change process integration device is characterized in that: comprising a first memory and a first processor, said first memory having stored thereon a computer program capable of being loaded by said first processor and executing an order change process integration method as claimed in claim 1.
4. An order change process extraction device is characterized in that: comprising a second memory and a second processor, said second memory having stored thereon a computer program capable of being loaded by said second processor and executing an order change procedure extraction method as claimed in claim 2.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011026446.3A CN112162904B (en) | 2020-09-25 | 2020-09-25 | Order change process integration method, extraction method, integration device and extraction device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011026446.3A CN112162904B (en) | 2020-09-25 | 2020-09-25 | Order change process integration method, extraction method, integration device and extraction device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN112162904A CN112162904A (en) | 2021-01-01 |
CN112162904B true CN112162904B (en) | 2024-06-18 |
Family
ID=73864308
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011026446.3A Active CN112162904B (en) | 2020-09-25 | 2020-09-25 | Order change process integration method, extraction method, integration device and extraction device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112162904B (en) |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
CN109753531A (en) * | 2018-12-26 | 2019-05-14 | 深圳市麦谷科技有限公司 | A kind of big data statistical method, system, computer equipment and storage medium |
Family Cites Families (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20150310044A1 (en) * | 2014-02-03 | 2015-10-29 | Codefutures Corporation | Database device and processing of data in a database |
CN107038162B (en) * | 2016-02-03 | 2021-03-02 | 北京嘀嘀无限科技发展有限公司 | Real-time data query method and system based on database log |
CN107818431B (en) * | 2016-09-14 | 2021-05-25 | 北京京东尚科信息技术有限公司 | Method and system for providing order track data |
CN107958010B (en) * | 2016-10-18 | 2020-09-01 | 北京京东尚科信息技术有限公司 | Method and system for online data migration |
KR101904786B1 (en) * | 2017-03-06 | 2018-10-08 | 주식회사 데이터스트림즈 | Apparatus and method for replicating changed data in a source database management system to a target database management system in real time |
CN107943841B (en) * | 2017-10-30 | 2022-01-11 | 深圳前海微众银行股份有限公司 | Streaming data processing method, system and computer readable storage medium |
CN108769172A (en) * | 2018-05-21 | 2018-11-06 | 杭州有赞科技有限公司 | A kind of method of data synchronization and system |
US20200233699A1 (en) * | 2019-01-23 | 2020-07-23 | Servicenow, Inc. | Platform-based change management |
CN110555028A (en) * | 2019-08-22 | 2019-12-10 | 上海数禾信息科技有限公司 | data display method and device |
CN110597914A (en) * | 2019-09-18 | 2019-12-20 | 北京思维造物信息科技股份有限公司 | Data transmission system, method, device and equipment |
CN110807067B (en) * | 2019-09-29 | 2023-12-22 | 北京淇瑀信息科技有限公司 | Data synchronization method, device and equipment for relational database and data warehouse |
CN111008246B (en) * | 2019-11-26 | 2024-04-19 | 中盈优创资讯科技有限公司 | Database log synchronization method, device, computer equipment and readable storage medium |
CN111026813A (en) * | 2019-12-18 | 2020-04-17 | 紫光云(南京)数字技术有限公司 | High-availability quasi-real-time data synchronization method based on MySQL |
-
2020
- 2020-09-25 CN CN202011026446.3A patent/CN112162904B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
CN109753531A (en) * | 2018-12-26 | 2019-05-14 | 深圳市麦谷科技有限公司 | A kind of big data statistical method, system, computer equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN112162904A (en) | 2021-01-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110321344B (en) | Information query method and device for associated data, computer equipment and storage medium | |
CN102722531B (en) | Query method based on regional bitmap indexes in cloud environment | |
CN105975617A (en) | Multi-partition-table inquiring and processing method and device | |
JP2022534215A (en) | Hybrid indexing method, system and program | |
US8108411B2 (en) | Methods and systems for merging data sets | |
CN111324610A (en) | Data synchronization method and device | |
US20180129708A1 (en) | Query processing management in a database management system | |
CN110245134B (en) | Increment synchronization method applied to search service | |
CN114911830A (en) | Index caching method, device, equipment and storage medium based on time sequence database | |
CN111506621A (en) | Data statistical method and device | |
CN113918605A (en) | Data query method, device, equipment and computer storage medium | |
CN112580319A (en) | Data processing method, device, equipment and computer readable storage medium | |
Camacho-Rodríguez et al. | Building large XML stores in the Amazon cloud | |
Huang et al. | R-HBase: A multi-dimensional indexing framework for cloud computing environment | |
CN111400301B (en) | Data query method, device and equipment | |
CN108874873B (en) | Data query method, device, storage medium and processor | |
CN113553341A (en) | Multidimensional data analysis method, multidimensional data analysis device, multidimensional data analysis equipment and computer readable storage medium | |
CN112162904B (en) | Order change process integration method, extraction method, integration device and extraction device | |
CN111125045B (en) | Lightweight ETL processing platform | |
JP5464017B2 (en) | Distributed memory database system, database server, data processing method and program thereof | |
CN105786990B (en) | The method and device of database data storage and quick search | |
CN107291938A (en) | Order Query System and method | |
CN111666302A (en) | User ranking query method, device, equipment and storage medium | |
CN113468166A (en) | Metadata processing method and device, storage medium and server | |
CN111522918A (en) | Data aggregation method and device, electronic equipment and computer readable storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |