CN113360495B - A recovery method, device, equipment and readable medium for database query interruption - Google Patents
A recovery method, device, equipment and readable medium for database query interruption Download PDFInfo
- Publication number
- CN113360495B CN113360495B CN202110422047.7A CN202110422047A CN113360495B CN 113360495 B CN113360495 B CN 113360495B CN 202110422047 A CN202110422047 A CN 202110422047A CN 113360495 B CN113360495 B CN 113360495B
- Authority
- CN
- China
- Prior art keywords
- address information
- query
- data
- sequence number
- statement
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/2455—Query execution
- G06F16/24568—Data stream processing; Continuous queries
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明公开了一种数据库查询中断的恢复方法,包括以下步骤:解析查询语句以获得待查询表和若干待查询数据,基于待查询表的索引获取若干待查询数据对应的地址信息;创建序号‑地址信息参照表,并将地址信息顺序写入序号‑地址信息参照表中;创建序号‑数据临时表,执行查询语句并将查询结果顺序写入序号‑数据临时表中;以及响应于执行查询语句出现异常中断,读取序号‑数据临时表的末位序号,并将末位序号在序号‑地址信息参照表中对应的地址信息作为断点继续执行查询语句。本发明还公开了一种数据库查询中断的恢复装置、计算机设备和可读存储介质。本发明解决了数据库大数据量表查询过程中发生中断如何快速恢复的问题。
The invention discloses a recovery method for database query interruption, comprising the following steps: parsing the query statement to obtain a table to be queried and a plurality of data to be queried, and obtaining address information corresponding to the data to be queried based on an index of the table to be queried; creating a serial number- Address information reference table, and address information is sequentially written in serial number-address information reference table; Create serial number-data temporary table, execute query statement and sequentially write query result in serial number-data temporary table; and execute query statement in response When an abnormal interruption occurs, read the last serial number of the serial number-data temporary table, and use the address information corresponding to the last serial number in the serial number-address information reference table as a breakpoint to continue executing the query statement. The invention also discloses a recovery device for database query interruption, computer equipment and readable storage medium. The invention solves the problem of how to recover quickly when an interruption occurs in the query process of the large data volume table of the database.
Description
技术领域technical field
本发明涉及数据库技术领域,尤其涉及一种数据库查询中断的恢复方法、装置、设备及可读介质。The invention relates to the technical field of databases, in particular to a recovery method, device, equipment and readable medium for database query interruption.
背景技术Background technique
数据库日常使用过程中,经常会用到查询,搜寻表的每一条记录的过程,直到所有符合给定条件的记录返回为止,即“查询xx from tablexx where条件语句”等,执行该SQL(Structured Query Language,结构化查询语言)语句的时候,如果遇到数据库中大数据量表,表更新不频繁,但数据量特别大,执行速度会很慢,耗费时间长,这时候如果出现异常情况导致语句中断,再次进行查询操作需要重新从头开始,前功尽弃。In the daily use of the database, queries are often used to search for each record in the table until all records that meet the given conditions are returned, that is, "query xx from tablexx where conditional statement", etc., execute the SQL (Structured Query Language, structured query language) statement, if you encounter a large data volume table in the database, the table is not updated frequently, but the data volume is particularly large, the execution speed will be very slow, and it will take a long time. If an abnormal situation occurs at this time, the statement will If it is interrupted, the query operation needs to be restarted from the beginning again, and all previous efforts will be wasted.
现有技术通过并行查询提高查询速度,但是对于查询中断的情况还需要重新执行查询。In the prior art, the query speed is improved through parallel query, but the query needs to be re-executed when the query is interrupted.
发明内容Contents of the invention
有鉴于此,本发明实施例的目的在于提出一种数据库查询中断的恢复方法、装置、设备及可读介质,通过顺序记录查询数据的索引,在遇到异常中断时,确定断点并从断点处继续查询,前期查询结果不会丢失,从而减少了整个查询耗费的时间,提高了查询效率,同时保证了查询结果的一致性,解决了数据库大数据量表查询过程中发生中断如何快速恢复的问题。In view of this, the purpose of the embodiment of the present invention is to propose a recovery method, device, device and readable medium for database query interruption, by sequentially recording the index of the query data, when encountering an abnormal interruption, determine the breakpoint and start from the interruption. Continue to query at the point, the previous query results will not be lost, thereby reducing the time spent on the entire query, improving query efficiency, while ensuring the consistency of query results, and solving the problem of how to quickly recover from interruptions in the query process of large data volume tables in the database The problem.
基于上述目的,本发明实施例的一方面提供了一种数据库查询中断的恢复方法,包括以下步骤:解析查询语句以获得待查询表和若干待查询数据,基于待查询表的索引获取若干待查询数据对应的地址信息;创建序号-地址信息参照表,并将地址信息顺序写入序号-地址信息参照表中;创建序号-数据临时表,执行查询语句并将查询结果顺序写入序号-数据临时表中;以及响应于执行查询语句出现异常中断,读取序号-数据临时表的末位序号,并将末位序号在序号-地址信息参照表中对应的地址信息作为断点继续执行查询语句。Based on the above purpose, an aspect of the embodiment of the present invention provides a recovery method for database query interruption, including the following steps: parsing the query statement to obtain a table to be queried and a number of data to be queried, and obtaining a number of data to be queried based on the index of the table to be queried The address information corresponding to the data; create a serial number-address information reference table, and write the address information into the serial number-address information reference table in sequence; create a serial number-data temporary table, execute the query statement and write the query results sequentially into the serial number-data temporary In the table; and in response to an abnormal interruption in the execution of the query statement, read the last serial number of the serial number-data temporary table, and use the address information corresponding to the last serial number in the serial number-address information reference table as a breakpoint to continue executing the query statement.
在一些实施方式中,还包括:判断异常中断期间待查询表中数据是否被修改;若是异常中断期间待查询表中数据被修改,进一步判断被修改数据的地址信息是否为已查询地址;若是被修改数据的地址信息为已查询地址,基于被修改数据的地址信息修改序号-数据临时表中对应的查询结果。In some embodiments, it also includes: judging whether the data in the table to be queried during the abnormal interruption is modified; if the data in the table to be queried during the abnormal interruption is modified, further judging whether the address information of the modified data is the queried address; The address information of the modified data is the queried address, and the corresponding query result in the serial number-data temporary table is modified based on the address information of the modified data.
在一些实施方式中,还包括:若是异常中断期间待查询表中数据未被修改,合并序号-数据临时表中的查询结果并输出。In some implementations, it also includes: if the data in the table to be queried has not been modified during the abnormal interruption, merging and outputting the query results in the serial number-data temporary table.
在一些实施方式中,还包括:若是被修改数据的地址信息不为已查询地址,合并序号-数据临时表中的查询结果并输出。In some implementations, it also includes: if the address information of the modified data is not the queried address, merging and outputting the query results in the serial number-data temporary table.
在一些实施方式中,还包括:创建状态表,并将状态表的状态值设置为0;响应于异常中断期间待查询表中数据被修改,将状态值增加1;判断异常中断期间待查询表中数据是否被修改包括:判断状态表是否为0;若是异常中断期间待查询表中数据未被修改,合并序号-数据临时表中的查询结果并输出包括:若是状态表为0,合并序号-数据临时表中的查询结果并输出。In some embodiments, it also includes: creating a state table, and setting the state value of the state table to 0; in response to the data in the table to be queried during the abnormal interruption is modified, increasing the state value by 1; judging the table to be queried during the abnormal interruption Whether the data in the data has been modified includes: judging whether the status table is 0; if the data in the table to be queried during the abnormal interruption period has not been modified, merge the query results in the serial number-data temporary table and output includes: if the status table is 0, merge the serial number- The query results in the data temporary table and output.
在一些实施方式中,还包括:创建状态表,并将状态表的状态值设置为0;响应于异常中断期间待查询表中数据被修改,将状态值增加1,并将修改语句记录到状态表中;判断异常中断期间待查询表中数据是否被修改包括:判断状态表是否为0;若是异常中断期间待查询表中数据被修改,进一步判断被修改数据的地址信息是否为已查询地址包括:若是状态表不为0,进一步判断状态表中修改语句的地址信息是否大于断点的地址信息;若是被修改数据的地址信息不为已查询地址,合并序号-数据临时表中的查询结果并输出包括:若是状态表中修改语句的地址信息大于断点的地址信息,合并序号-数据临时表中的查询结果并输出;若是被修改数据的地址信息为已查询地址,基于被修改数据的地址信息修改序号-数据临时表中对应的查询结果包括:若是状态表中修改语句的地址信息不大于断点的地址信息,基于状态表中修改语句的地址修改序号-数据临时表中对应的查询结果,并初始化状态表。In some implementations, it also includes: creating a state table, and setting the state value of the state table to 0; in response to the data being modified in the table to be queried during the abnormal interruption, increasing the state value by 1, and recording the modification statement to the state In the table; judging whether the data in the table to be queried during abnormal interruption is modified includes: judging whether the status table is 0; if the data in the table to be queried during abnormal interruption is modified, further judging whether the address information of the modified data is the queried address includes : If the state table is not 0, further judge whether the address information of the modification statement in the state table is greater than the address information of the breakpoint; if the address information of the modified data is not the queried address, merge the query results in the serial number-data temporary table and The output includes: if the address information of the modified statement in the state table is greater than the address information of the breakpoint, merge the query results in the serial number-data temporary table and output; if the address information of the modified data is the queried address, based on the address of the modified data The corresponding query results in the information modification sequence number-data temporary table include: if the address information of the modification statement in the state table is not greater than the address information of the breakpoint, based on the address modification sequence number of the modification statement in the state table-the corresponding query results in the data temporary table , and initialize the state table.
在一些实施方式中,执行查询语句并将查询结果顺序写入序号-数据临时表中包括:执行查询语句,实时获取内存中查询结果并将查询结果写入序号-数据临时表;将序号-数据临时表固化保存到磁盘中。In some embodiments, executing the query statement and sequentially writing the query result into the sequence number-data temporary table includes: executing the query statement, obtaining the query result in the memory in real time and writing the query result into the sequence number-data temporary table; Temporary tables are solidified and saved to disk.
本发明实施例的另一方面,还提供了一种数据库查询中断的恢复装置,包括:第一模块,配置用于解析查询语句以获得待查询表和若干待查询数据,基于待查询表的索引获取若干待查询数据对应的地址信息;第二模块,配置用于创建序号-地址信息参照表,并将地址信息顺序写入序号-地址信息参照表中;第三模块,配置用于创建序号-数据临时表,执行查询语句并将查询结果顺序写入序号-数据临时表中;以及第四模块,配置用于响应于执行查询语句出现异常中断,读取序号-数据临时表的末位序号,并将末位序号在序号-地址信息参照表中对应的地址信息作为断点继续执行查询语句。Another aspect of the embodiments of the present invention also provides a recovery device for database query interruption, including: a first module configured to parse the query statement to obtain the table to be queried and a number of data to be queried, based on the index of the table to be queried Obtain the address information corresponding to several data to be queried; the second module is configured to create a serial number-address information reference table, and write the address information into the serial number-address information reference table in sequence; the third module is configured to create a serial number-address information reference table; The data temporary table executes the query statement and sequentially writes the query results into the serial number-data temporary table; and the fourth module is configured to respond to an abnormal interruption in the execution of the query statement, read the serial number-the last serial number of the data temporary table, The address information corresponding to the last serial number in the serial number-address information reference table is used as a breakpoint to continue executing the query statement.
本发明实施例的再一方面,还提供了一种计算机设备,包括:至少一个处理器;以及存储器,存储器存储有可在处理器上运行的计算机指令,指令由处理器执行时实现上述方法的步骤。In another aspect of the embodiments of the present invention, there is also provided a computer device, including: at least one processor; and a memory, the memory stores computer instructions that can be run on the processor, and when the instructions are executed by the processor, the above method is implemented. step.
本发明实施例的再一方面,还提供了一种计算机可读存储介质,计算机可读存储介质存储有被处理器执行时实现如上方法步骤的计算机程序。In yet another aspect of the embodiments of the present invention, a computer-readable storage medium is also provided, and the computer-readable storage medium stores a computer program for implementing the above method steps when executed by a processor.
本发明具有以下有益技术效果:通过顺序记录查询数据的索引,在遇到异常中断时,确定断点并从断点处继续查询,前期查询结果不会丢失,从而减少了整个查询耗费的时间,提高了查询效率,同时保证了查询结果的一致性,解决了数据库大数据量表查询过程中发生中断如何快速恢复的问题。The present invention has the following beneficial technical effects: by sequentially recording the index of the query data, when an abnormal interruption is encountered, the breakpoint is determined and the query is continued from the breakpoint, the previous query results will not be lost, thereby reducing the time spent on the entire query, It improves the query efficiency, ensures the consistency of query results, and solves the problem of how to quickly recover from interruptions in the query process of large data volume tables in the database.
附图说明Description of drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的实施例。In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention, and those skilled in the art can obtain other embodiments according to these drawings without any creative effort.
图1为本发明提供的数据库查询中断的恢复方法的实施例的示意图;Fig. 1 is the schematic diagram of the embodiment of the recovery method that the database query interruption provided by the present invention;
图2为本发明提供的数据库查询中断的恢复装置的实施例的示意图;Fig. 2 is the schematic diagram of the embodiment of the recovery device that the database query interruption provided by the present invention;
图3为本发明提供的计算机设备的实施例的示意图;FIG. 3 is a schematic diagram of an embodiment of a computer device provided by the present invention;
图4为本发明提供的计算机可读存储介质的实施例的示意图。FIG. 4 is a schematic diagram of an embodiment of a computer-readable storage medium provided by the present invention.
具体实施方式Detailed ways
为使本发明的目的、技术方案和优点更加清楚明白,以下结合具体实施例,并参照附图,对本发明实施例进一步详细说明。In order to make the object, technical solution and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.
需要说明的是,本发明实施例中所有使用“第一”和“第二”的表述均是为了区分两个相同名称非相同的实体或者非相同的参量,可见“第一”“第二”仅为了表述的方便,不应理解为对本发明实施例的限定,后续实施例对此不再一一说明。It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are to distinguish two entities with the same name but different parameters or parameters that are not the same, see "first" and "second" It is only for the convenience of expression, and should not be construed as a limitation on the embodiments of the present invention, which will not be described one by one in the subsequent embodiments.
基于上述目的,本发明实施例的第一个方面,提出了数据库查询中断的恢复方法的实施例。图1示出的是本发明提供的数据库查询中断的恢复方法的实施例的示意图。如图1所示,本发明实施例包括如下步骤:Based on the above purpose, the first aspect of the embodiments of the present invention proposes an embodiment of a recovery method for database query interruption. FIG. 1 is a schematic diagram of an embodiment of a recovery method for database query interruption provided by the present invention. As shown in Figure 1, the embodiment of the present invention includes the following steps:
S01、解析查询语句以获得待查询表和若干待查询数据,基于待查询表的索引获取若干待查询数据对应的地址信息;S01. Parse the query statement to obtain a table to be queried and some data to be queried, and obtain address information corresponding to some data to be queried based on an index of the table to be queried;
S02、创建序号-地址信息参照表,并将地址信息顺序写入序号-地址信息参照表中;S02. Create a serial number-address information reference table, and write the address information into the serial number-address information reference table in sequence;
S03、创建序号-数据临时表,执行查询语句并将查询结果顺序写入序号-数据临时表中;以及S03. Create a serial number-data temporary table, execute the query statement and sequentially write the query results into the serial number-data temporary table; and
S04、响应于执行查询语句出现异常中断,读取序号-数据临时表的末位序号,并将末位序号在序号-地址信息参照表中对应的地址信息作为断点继续执行查询语句。S04. In response to an abnormal interruption in the execution of the query statement, read the last serial number of the serial number-data temporary table, and use the address information corresponding to the last serial number in the serial number-address information reference table as a breakpoint to continue executing the query statement.
在本实施例中,以K-DB数据库为例,K-DB数据库是一种类似于oracle数据库的关系型数据库。解决的技术问题是数据库大数据量表查询过程中发生中断如何恢复,利用了表查询是通过索引将数据按照实际物理地址信息顺序输出的特性,查询指的是搜寻表的每一条记录的过程,直到所有符合给定条件的记录返回为止,索引是一种单独的、物理的对数据库表中一列或多列的值进行排序的一种存储结构,它是某个表中一列或若干列值的集合和相应的指向表中物理标识这些值的数据页的逻辑指针清单,提供指向存储在表的指定列中的数据值的指针。本发明技术方案能使用户执行长时间查询操作遇到异常导致中断时,从断点处继续进行完成剩余查询而不是从头开始再次查询,节约了时间,提高了查询效率,对于K-DB数据库的发展推广有一定意义。In this embodiment, the K-DB database is taken as an example, and the K-DB database is a relational database similar to an oracle database. The technical problem to be solved is how to recover from interruptions in the query process of large data volume tables in the database. The feature of table query is to output data according to the order of actual physical address information through indexes. Query refers to the process of searching for each record in the table. An index is a separate, physical storage structure that sorts the values of one or more columns in a database table until all records that meet a given condition are returned. A collection and corresponding list of logical pointers to data pages in the table that physically identify those values, providing pointers to data values stored in specified columns of the table. The technical scheme of the present invention enables the user to continue to complete the remaining query from the breakpoint when the user encounters an abnormality in performing a long-term query operation instead of re-querying from the beginning, which saves time and improves query efficiency. For the K-DB database Development and promotion have a certain meaning.
在本实施例中,执行查询语句,解析查询语句,将所要查询数据的索引部分,按顺序记录写入到参照表中,进行查询时,查询结果被读到内存中,同时将该部分结果顺序写入磁盘临时表中进行固化,查询语句异常中断后,读取临时表最末一行数据信息,并与参照表数据信息对比,将其作为重新查询的起点,即查询语句从断点处开始查询,这样前期查询的结果不会丢失,减少了整个查询耗费的时间,提高了效率。In this embodiment, the query statement is executed, the query statement is parsed, and the index part of the data to be queried is recorded into the reference table in order. When querying, the query result is read into the memory, and the part of the result is sequentially Write to the disk temporary table for curing. After the query statement is interrupted abnormally, read the last row of data information in the temporary table, compare it with the data information of the reference table, and use it as the starting point for re-query, that is, the query statement starts querying from the breakpoint , so that the results of the previous query will not be lost, reducing the time spent on the entire query and improving efficiency.
在本实施例中,首先对查询语句进行解析,以查询数据a、c、e时发生中断为例,待查询表如表1所示,待查询表的索引如表2所示,其中,rowid为数据库的表中的每一行数据都有一个唯一的标识符,该值表明了该行在数据库中的物理具体位置。In this embodiment, firstly, the query statement is parsed, and an interruption occurs when querying data a, c, and e as an example, the table to be queried is shown in Table 1, and the index of the table to be queried is shown in Table 2, wherein rowid Each row of data in a database table has a unique identifier, which indicates the physical location of the row in the database.
表1待查询表Table 1 to be queried
表2待查询表索引Table 2 Index of the table to be queried
从待查询表的索引中找到待查询数据的地址信息,并按照顺序生成序号-地址信息参照表,如表3所示。Find the address information of the data to be queried from the index of the table to be queried, and generate a serial number-address information reference table in sequence, as shown in Table 3.
表3序号-地址信息参照表Table 3 Serial Number - Address Information Reference Table
执行查询语句,磁盘中表数据按顺序读取到内存中,将内存中该部分数据按顺序写入到磁盘临时表中,即将该部分数据持久化,写到磁盘保存,序号-数据临时表中如表4所示。Execute the query statement, read the table data in the disk into the memory in order, and write this part of the data in the memory to the temporary disk table in order, that is, persist this part of the data and write it to the disk for storage, serial number - data temporary table As shown in Table 4.
表4序号-数据临时表Table 4 Serial Number - Data Temporary Table
查询语句发生异常中断,重新进行查询查询,读取临时表最后一行数据,根据序号-数据临时表最后一行查找序号为2,查询参照表找到序号2对应的断点的地址信息rowid3,并从rowid3继续执行查询语句,也可以以断点下一个数据为起点查找剩余部分数据。The query statement is abnormally interrupted, re-query, read the last row of data in the temporary table, find the serial number 2 according to the serial number - the last row of the data temporary table, query the reference table to find the address information rowid3 of the breakpoint corresponding to the serial number 2, and read rowid3 from rowid3 Continue to execute the query statement, or search for the rest of the data starting from the data next to the breakpoint.
在本发明的一些实施例中,还包括:判断异常中断期间待查询表中数据是否被修改;若是异常中断期间待查询表中数据被修改,进一步判断被修改数据的地址信息是否为已查询地址;若是被修改数据的地址信息为已查询地址,基于被修改数据的地址信息修改序号-数据临时表中对应的查询结果。In some embodiments of the present invention, it also includes: judging whether the data in the table to be queried during the abnormal interruption is modified; if the data in the table to be queried during the abnormal interruption is modified, further judging whether the address information of the modified data is the queried address ; If the address information of the modified data is the queried address, modify the corresponding query result in the serial number-data temporary table based on the address information of the modified data.
在本实施例中,针对断点恢复查询之前,已获数据发生变化的情况,该机制也提出相应解决办法:记录表状态,如若发生变化,将其标记并通过查找记录找到变化部分,修改相应数据记录后合并查询结果。In this embodiment, the mechanism also proposes a corresponding solution for the situation that the obtained data changes before the breakpoint resumes the query: if the state of the record table changes, mark it and find the changed part by searching the record, and modify the corresponding Merge query results after data logging.
在本发明的一些实施例中,还包括:若是异常中断期间待查询表中数据未被修改,合并序号-数据临时表中的查询结果并输出。In some embodiments of the present invention, it also includes: if the data in the table to be queried has not been modified during the abnormal interruption, merging and outputting the query results in the serial number-data temporary table.
在本发明的一些实施例中,还包括:若是被修改数据的地址信息不为已查询地址,合并序号-数据临时表中的查询结果并输出。In some embodiments of the present invention, it also includes: if the address information of the modified data is not the queried address, merging and outputting the query results in the serial number-data temporary table.
在本发明的一些实施例中,还包括:创建状态表,并将状态表的状态值设置为0;响应于异常中断期间待查询表中数据被修改,将状态值增加1;判断异常中断期间待查询表中数据是否被修改包括:判断状态表是否为0;若是异常中断期间待查询表中数据未被修改,合并序号-数据临时表中的查询结果并输出包括:若是状态表为0,合并序号-数据临时表中的查询结果并输出。In some embodiments of the present invention, it also includes: creating a state table, and setting the state value of the state table to 0; in response to the data being modified in the table to be queried during the abnormal interruption, increasing the state value by 1; judging during the abnormal interruption Whether the data in the table to be queried has been modified includes: judging whether the status table is 0; if the data in the table to be queried has not been modified during the abnormal interruption, merge the query results in the serial number-data temporary table and output includes: if the status table is 0, Combine the query results in the serial number-data temporary table and output.
在本实施例中,创建状态表,记录表的状态值和相关修改语句。应用端进行查询表查询操作,同时将该表状态值置为0,查询中断后,再次恢复查询之前,中间每发生一次表修改的操作,包括增删改,就将状态值+1,同时将该修改语句一并记录到状态表中,状态表如表5所示。In this embodiment, a state table is created, and state values of the table and related modification statements are recorded. The application side performs the query table query operation, and sets the state value of the table to 0 at the same time. After the query is interrupted and before the query is resumed again, every time a table modification operation occurs in the middle, including adding, deleting, and modifying, the state value will be +1, and the The modification statement is also recorded in the state table, and the state table is shown in Table 5.
表5状态表Table 5 state table
在本实施例中,查询语句会对表加共享锁,在查询中断期间,查询原表版本状态值,是否为0,若为0,说明中断期间该表没有发生过修改操作,即数据保持不变,不需要对临时表进行处理,查询语句完成后得出的结果加上临时表的数据就是当前表的所有数据,最后释放共享锁即可。In this embodiment, the query statement will add a shared lock to the table. During the query interruption period, query the original table version status value, whether it is 0, if it is 0, it means that the table has not been modified during the interruption period, that is, the data remains unchanged. There is no need to process the temporary table, the result obtained after the query statement is completed plus the data of the temporary table is all the data of the current table, and finally the shared lock can be released.
在本发明的一些实施例中,还包括:创建状态表,并将状态表的状态值设置为0;响应于异常中断期间待查询表中数据被修改,将状态值增加1,并将修改语句记录到状态表中;判断异常中断期间待查询表中数据是否被修改包括:判断状态表是否为0;若是异常中断期间待查询表中数据被修改,进一步判断被修改数据的地址信息是否为已查询地址包括:若是状态表不为0,进一步判断状态表中修改语句的地址信息是否大于断点的地址信息;若是被修改数据的地址信息不为已查询地址,合并序号-数据临时表中的查询结果并输出包括:若是状态表中修改语句的地址信息大于断点的地址信息,合并序号-数据临时表中的查询结果并输出;若是被修改数据的地址信息为已查询地址,基于被修改数据的地址信息修改序号-数据临时表中对应的查询结果包括:若是状态表中修改语句的地址信息不大于断点的地址信息,基于状态表中修改语句的地址修改序号-数据临时表中对应的查询结果,并初始化状态表。In some embodiments of the present invention, it also includes: creating a state table, and setting the state value of the state table to 0; in response to the data being modified in the table to be queried during the abnormal interruption, increasing the state value by 1, and modifying the statement Recorded in the status table; judging whether the data in the table to be queried during the abnormal interruption period is modified includes: judging whether the status table is 0; if the data in the table to be queried during the abnormal interruption period is modified, further judging whether the address information of the modified data is already The query address includes: if the state table is not 0, further judge whether the address information of the modification statement in the state table is greater than the address information of the breakpoint; if the address information of the modified data is not the queried address, merge the sequence number - The query result and output include: if the address information of the modification statement in the state table is greater than the address information of the breakpoint, merge the query result in the serial number-data temporary table and output; if the address information of the modified data is the queried address, based on the modified The corresponding query results in the data address information modification sequence number-data temporary table include: if the address information of the modification statement in the state table is not greater than the address information of the breakpoint, based on the address modification sequence number of the modification statement in the state table-correspondence in the data temporary table The query results and initialize the state table.
在本实施例中,查询语句会对表加共享锁,在查询中断期间,查询原表版本状态值,是否为0,若不为0,说明表数据发生了变化,查询语句完成后,继续保持共享锁,从状态表中寻找与该表相关的数据修改语句,找到发生变化的数据,记录该部分数据的rowid,以rowid A、rowid B、rowid C为例,对比临时表最后一行,查找rowid值,以rowidM为例。若存在C大于M,说明M之后的数据发生了变化,临时表存放的数据不变,不需要处理;若存在A、B小于M,则说明临时表存放的数据已发生变化,这时候需要调用状态表里面相关rowid A、B行的语句修改临时表数据,比如,update临时表set列=新值where rowid=A。临时表数据修改完成后释放共享锁,并将原表状态重置为0,查询语句完成后得出的结果加上临时表的数据就是当前表的所有数据,完成查询查询全过程。In this embodiment, the query statement will add a shared lock to the table. During the query interruption period, check whether the original table version status value is 0. If it is not 0, it means that the table data has changed. After the query statement is completed, continue to keep Shared lock, find the data modification statement related to the table from the state table, find the changed data, record the rowid of this part of the data, take rowid A, rowid B, and rowid C as examples, compare the last row of the temporary table, and find the rowid Value, take rowidM as an example. If there is C greater than M, it means that the data after M has changed, the data stored in the temporary table remains unchanged, and no processing is required; if A and B are smaller than M, it means that the data stored in the temporary table has changed, and you need to call Statements related to rowid A and row B in the state table modify the temporary table data, for example, update temporary table set column=new value where rowid=A. After the modification of the temporary table data is completed, the shared lock is released, and the state of the original table is reset to 0. After the query statement is completed, the result plus the data of the temporary table is all the data of the current table, and the whole query process is completed.
在本发明的一些实施例中,执行查询语句并将查询结果顺序写入序号-数据临时表中包括:执行查询语句,实时获取内存中查询结果并将查询结果写入序号-数据临时表;将序号-数据临时表固化保存到磁盘中。In some embodiments of the present invention, executing the query statement and writing the query result into the sequence number-data temporary table includes: executing the query statement, obtaining the query result in the memory in real time and writing the query result into the sequence number-data temporary table; Sequence number - the data temporary table is solidified and saved to the disk.
需要特别指出的是,上述数据库查询中断的恢复方法的各个实施例中的各个步骤均可以相互交叉、替换、增加、删减,因此,这些合理的排列组合变换之于数据库查询中断的恢复方法也应当属于本发明的保护范围,并且不应将本发明的保护范围局限在实施例之上。It should be pointed out that the various steps in the various embodiments of the above-mentioned recovery method for database query interruption can be mutually interleaved, replaced, increased, and deleted. It should belong to the protection scope of the present invention, and should not limit the protection scope of the present invention to the embodiment.
基于上述目的,本发明实施例的第二个方面,提出了一种数据库查询中断的恢复装置。图2示出的是本发明提供的数据库查询中断的恢复装置的实施例的示意图。如图2所示,本发明实施例包括如下模块:第一模块S11,配置用于解析查询语句以获得待查询表和若干待查询数据,基于待查询表的索引获取若干待查询数据对应的地址信息;第二模块S12,配置用于创建序号-地址信息参照表,并将地址信息顺序写入序号-地址信息参照表中;第三模块S13,配置用于创建序号-数据临时表,执行查询语句并将查询结果顺序写入序号-数据临时表中;以及第四模块S14,配置用于响应于执行查询语句出现异常中断,读取序号-数据临时表的末位序号,并将末位序号在序号-地址信息参照表中对应的地址信息作为断点继续执行查询语句。Based on the above purpose, a second aspect of the embodiments of the present invention provides a recovery device for interrupted database query. FIG. 2 is a schematic diagram of an embodiment of a recovery device for interrupted database query provided by the present invention. As shown in Figure 2, the embodiment of the present invention includes the following modules: a first module S11, which is configured to parse the query statement to obtain the table to be queried and some data to be queried, and obtain the addresses corresponding to the data to be queried based on the index of the table to be queried information; the second module S12 is configured to create a serial number-address information reference table, and write the address information into the serial number-address information reference table in sequence; the third module S13 is configured to create a serial number-data temporary table and perform a query statement and write the query results in the serial number-data temporary table in sequence; and the fourth module S14 is configured to respond to an abnormal interruption in the execution of the query statement, read the last serial number of the serial number-data temporary table, and write the last serial number The corresponding address information in the sequence number-address information reference table is used as a breakpoint to continue executing the query statement.
基于上述目的,本发明实施例的第三个方面,提出了一种计算机设备。图3示出的是本发明提供的计算机设备的实施例的示意图。如图3所示,本发明实施例包括如下装置:至少一个处理器S21;以及存储器S22,存储器S22存储有可在处理器上运行的计算机指令S23,指令由处理器执行时实现以上方法的步骤。Based on the above purpose, a third aspect of the embodiments of the present invention provides a computer device. FIG. 3 shows a schematic diagram of an embodiment of a computer device provided by the present invention. As shown in Figure 3, the embodiment of the present invention includes the following devices: at least one processor S21; and a memory S22, the memory S22 stores computer instructions S23 that can run on the processor, and the steps of the above method are realized when the instructions are executed by the processor .
本发明还提供了一种计算机可读存储介质。图4示出的是本发明提供的计算机可读存储介质的实施例的示意图。如图4所示,计算机可读存储介质存储S31有被处理器执行时执行如上方法的计算机程序S32。The present invention also provides a computer-readable storage medium. FIG. 4 is a schematic diagram of an embodiment of a computer-readable storage medium provided by the present invention. As shown in FIG. 4 , the computer-readable storage medium stores S31 a computer program S32 for performing the above method when executed by a processor.
最后需要说明的是,本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,可以通过计算机程序来指令相关硬件来完成,数据库查询中断的恢复方法的程序可存储于一计算机可读取存储介质中,该程序在执行时,可包括如上述各方法的实施例的流程。其中,程序的存储介质可为磁碟、光盘、只读存储记忆体(ROM)或随机存储记忆体(RAM)等。上述计算机程序的实施例,可以达到与之对应的前述任意方法实施例相同或者相类似的效果。Finally, it should be noted that those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented through computer programs to instruct related hardware to complete, and the program of the recovery method for database query interruption can be stored in a computer When the program is read from the storage medium, when executed, it may include the procedures of the embodiments of the above-mentioned methods. Wherein, the storage medium of the program may be a magnetic disk, an optical disk, a read-only memory (ROM) or a random access memory (RAM), and the like. The foregoing computer program embodiments can achieve the same or similar effects as any of the foregoing method embodiments corresponding thereto.
此外,根据本发明实施例公开的方法还可以被实现为由处理器执行的计算机程序,该计算机程序可以存储在计算机可读存储介质中。在该计算机程序被处理器执行时,执行本发明实施例公开的方法中限定的上述功能。In addition, the method disclosed according to the embodiments of the present invention can also be implemented as a computer program executed by a processor, and the computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the above functions defined in the methods disclosed in the embodiments of the present invention are executed.
此外,上述方法步骤以及系统单元也可以利用控制器以及用于存储使得控制器实现上述步骤或单元功能的计算机程序的计算机可读存储介质实现。In addition, the above-mentioned method steps and system units can also be realized by using a controller and a computer-readable storage medium for storing a computer program for enabling the controller to realize the functions of the above-mentioned steps or units.
本领域技术人员还将明白的是,结合这里的公开所描述的各种示例性逻辑块、模块、电路和算法步骤可以被实现为电子硬件、计算机软件或两者的组合。为了清楚地说明硬件和软件的这种可互换性,已经就各种示意性组件、方块、模块、电路和步骤的功能对其进行了一般性的描述。这种功能是被实现为软件还是被实现为硬件取决于具体应用以及施加给整个系统的设计约束。本领域技术人员可以针对每种具体应用以各种方式来实现的功能,但是这种实现决定不应被解释为导致脱离本发明实施例公开的范围。Those of skill would also appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the disclosure herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described generally in terms of their functionality. Whether such functionality is implemented as software or as hardware depends upon the particular application and design constraints imposed on the overall system. Those skilled in the art may implement the functions in various ways for each specific application, but such implementation decisions should not be interpreted as causing a departure from the scope disclosed in the embodiments of the present invention.
在一个或多个示例性设计中,功能可以在硬件、软件、固件或其任意组合中实现。如果在软件中实现,则可以将功能作为一个或多个指令或代码存储在计算机可读介质上或通过计算机可读介质来传送。计算机可读介质包括计算机存储介质和通信介质,该通信介质包括有助于将计算机程序从一个位置传送到另一个位置的任何介质。存储介质可以是能够被通用或专用计算机访问的任何可用介质。作为例子而非限制性的,该计算机可读介质可以包括RAM、ROM、EEPROM、CD-ROM或其它光盘存储设备、磁盘存储设备或其它磁性存储设备,或者是可以用于携带或存储形式为指令或数据结构的所需程序代码并且能够被通用或专用计算机或者通用或专用处理器访问的任何其它介质。此外,任何连接都可以适当地称为计算机可读介质。例如,如果使用同轴线缆、光纤线缆、双绞线、数字用户线路(DSL)或诸如红外线、无线电和微波的无线技术来从网站、服务器或其它远程源发送软件,则上述同轴线缆、光纤线缆、双绞线、DSL或诸如红外线、无线电和微波的无线技术均包括在介质的定义。如这里所使用的,磁盘和光盘包括压缩盘(CD)、激光盘、光盘、数字多功能盘(DVD)、软盘、蓝光盘,其中磁盘通常磁性地再现数据,而光盘利用激光光学地再现数据。上述内容的组合也应当包括在计算机可读介质的范围内。In one or more exemplary designs, functions may be implemented in hardware, software, firmware, or any combination thereof. If implemented in software, the functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. Storage media may be any available media that can be accessed by a general purpose or special purpose computer. By way of example and not limitation, the computer readable medium may include RAM, ROM, EEPROM, CD-ROM or other optical disk storage device, magnetic disk storage device or other magnetic storage device, or may be used to carry or store instructions in Any other medium that can be accessed by a general purpose or special purpose computer or a general purpose or special purpose processor, and the required program code or data structure. Also, any connection is properly termed a computer-readable medium. For example, if the software is transmitted from a website, server, or other remote source using coaxial cable, fiber optic cable, twisted pair, digital subscriber line (DSL), or wireless technologies such as infrared, radio, and microwave, then the coaxial cable Cable, fiber optic cable, twisted pair, DSL, or wireless technologies such as infrared, radio, and microwave are included in the definition of media. Disk and disc, as used herein, includes compact disc (CD), laser disc, optical disc, digital versatile disc (DVD), floppy disk, blu-ray disc where disks usually reproduce data magnetically, while discs reproduce data optically with lasers . Combinations of the above should also be included within the scope of computer-readable media.
以上是本发明公开的示例性实施例,但是应当注意,在不背离权利要求限定的本发明实施例公开的范围的前提下,可以进行多种改变和修改。根据这里描述的公开实施例的方法权利要求的功能、步骤和/或动作不需以任何特定顺序执行。此外,尽管本发明实施例公开的元素可以以个体形式描述或要求,但除非明确限制为单数,也可以理解为多个。The above are the exemplary embodiments disclosed in the present invention, but it should be noted that various changes and modifications can be made without departing from the scope of the disclosed embodiments of the present invention defined in the claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. In addition, although the elements disclosed in the embodiments of the present invention may be described or required in an individual form, they may also be understood as a plurality unless explicitly limited to a singular number.
应当理解的是,在本文中使用的,除非上下文清楚地支持例外情况,单数形式“一个”旨在也包括复数形式。还应当理解的是,在本文中使用的“和/或”是指包括一个或者一个以上相关联地列出的项目的任意和所有可能组合。It should be understood that as used herein, the singular form "a" and "an" are intended to include the plural forms as well, unless the context clearly supports an exception. It should also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items.
上述本发明实施例公开实施例序号仅仅为了描述,不代表实施例的优劣。The serial numbers of the embodiments disclosed in the above-mentioned embodiments of the present invention are only for description, and do not represent the advantages and disadvantages of the embodiments.
本领域普通技术人员可以理解实现上述实施例的全部或部分步骤可以通过硬件来完成,也可以通过程序来指令相关的硬件完成,程序可以存储于一种计算机可读存储介质中,上述提到的存储介质可以是只读存储器,磁盘或光盘等。Those of ordinary skill in the art can understand that all or part of the steps for implementing the above-mentioned embodiments can be completed by hardware, or can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium. The above-mentioned The storage medium may be a read-only memory, a magnetic disk or an optical disk, and the like.
所属领域的普通技术人员应当理解:以上任何实施例的讨论仅为示例性的,并非旨在暗示本发明实施例公开的范围(包括权利要求)被限于这些例子;在本发明实施例的思路下,以上实施例或者不同实施例中的技术特征之间也可以进行组合,并存在如上的本发明实施例的不同方面的许多其它变化,为了简明它们没有在细节中提供。因此,凡在本发明实施例的精神和原则之内,所做的任何省略、修改、等同替换、改进等,均应包含在本发明实施例的保护范围之内。Those of ordinary skill in the art should understand that: the discussion of any of the above embodiments is exemplary only, and is not intended to imply that the scope (including claims) disclosed by the embodiments of the present invention is limited to these examples; under the idea of the embodiments of the present invention , the technical features in the above embodiments or different embodiments can also be combined, and there are many other changes in different aspects of the above embodiments of the present invention, which are not provided in details for the sake of brevity. Therefore, within the spirit and principle of the embodiments of the present invention, any omissions, modifications, equivalent replacements, improvements, etc., shall be included in the protection scope of the embodiments of the present invention.
Claims (6)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110422047.7A CN113360495B (en) | 2021-04-20 | 2021-04-20 | A recovery method, device, equipment and readable medium for database query interruption |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110422047.7A CN113360495B (en) | 2021-04-20 | 2021-04-20 | A recovery method, device, equipment and readable medium for database query interruption |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113360495A CN113360495A (en) | 2021-09-07 |
| CN113360495B true CN113360495B (en) | 2023-02-24 |
Family
ID=77525252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110422047.7A Active CN113360495B (en) | 2021-04-20 | 2021-04-20 | A recovery method, device, equipment and readable medium for database query interruption |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113360495B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114048218A (en) * | 2021-11-06 | 2022-02-15 | 北京天融信网络安全技术有限公司 | Data query method, terminal and storage medium |
| CN114443652B (en) * | 2022-01-07 | 2024-01-19 | 苏州浪潮智能科技有限公司 | Breakpoint SQL operation method, system and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101078999A (en) * | 2006-05-26 | 2007-11-28 | 任永坚 | Method and system for accomplishing data backup and recovery |
| CN103970834A (en) * | 2014-04-02 | 2014-08-06 | 浙江大学 | Recovery method for incremental data synchronization fault in isomerous database synchronizing system |
| CN108280148A (en) * | 2018-01-02 | 2018-07-13 | 中国民生银行股份有限公司 | A kind of data migration method and data migration server |
| CN109408588A (en) * | 2018-09-07 | 2019-03-01 | 武汉达梦数据库有限公司 | A kind of method of breakpoint transmission when database synchronization initialization loading |
| CN110633300A (en) * | 2019-08-23 | 2019-12-31 | 苏州浪潮智能科技有限公司 | Breakpoint continuous operation method and device for nested query |
| CN110765204A (en) * | 2019-09-30 | 2020-02-07 | 武汉达梦数据库有限公司 | Method and device for processing incremental synchronous abnormal interrupt condition |
| CN111338853A (en) * | 2020-03-16 | 2020-06-26 | 南京云信达科技有限公司 | Data real-time storage system and method based on Linux |
| CN111737295A (en) * | 2020-06-11 | 2020-10-02 | 上海达梦数据库有限公司 | Database cursor query method, device, equipment and storage medium |
| CN112612827A (en) * | 2020-12-25 | 2021-04-06 | 平安国际智慧城市科技股份有限公司 | Database paging query method and device, computer equipment and storage medium |
-
2021
- 2021-04-20 CN CN202110422047.7A patent/CN113360495B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101078999A (en) * | 2006-05-26 | 2007-11-28 | 任永坚 | Method and system for accomplishing data backup and recovery |
| CN103970834A (en) * | 2014-04-02 | 2014-08-06 | 浙江大学 | Recovery method for incremental data synchronization fault in isomerous database synchronizing system |
| CN108280148A (en) * | 2018-01-02 | 2018-07-13 | 中国民生银行股份有限公司 | A kind of data migration method and data migration server |
| CN109408588A (en) * | 2018-09-07 | 2019-03-01 | 武汉达梦数据库有限公司 | A kind of method of breakpoint transmission when database synchronization initialization loading |
| CN110633300A (en) * | 2019-08-23 | 2019-12-31 | 苏州浪潮智能科技有限公司 | Breakpoint continuous operation method and device for nested query |
| CN110765204A (en) * | 2019-09-30 | 2020-02-07 | 武汉达梦数据库有限公司 | Method and device for processing incremental synchronous abnormal interrupt condition |
| CN111338853A (en) * | 2020-03-16 | 2020-06-26 | 南京云信达科技有限公司 | Data real-time storage system and method based on Linux |
| CN111737295A (en) * | 2020-06-11 | 2020-10-02 | 上海达梦数据库有限公司 | Database cursor query method, device, equipment and storage medium |
| CN112612827A (en) * | 2020-12-25 | 2021-04-06 | 平安国际智慧城市科技股份有限公司 | Database paging query method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113360495A (en) | 2021-09-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9619492B2 (en) | Data migration | |
| US8938430B2 (en) | Intelligent data archiving | |
| US10776345B2 (en) | Efficiently updating a secondary index associated with a log-structured merge-tree database | |
| WO2020211236A1 (en) | Read-write conflict resolution method and apparatus employing b+ tree and storage medium | |
| CN113360495B (en) | A recovery method, device, equipment and readable medium for database query interruption | |
| JP6432893B1 (en) | Database processing apparatus, group map file production method and program | |
| CN106874329A (en) | The implementation method and device of database table index | |
| JP6752547B2 (en) | Database management method and database management system | |
| JP6450865B2 (en) | Aggregate large amounts of time data from many overlapping sources | |
| CN114461648A (en) | Data storage method and system based on LSM-Tree | |
| CN114816247B (en) | A method and device for acquiring logical data | |
| US20070239794A1 (en) | Method and system for updating logical information in databases | |
| CN116610636A (en) | Data processing method and device of file system, electronic equipment and storage medium | |
| CN109063186A (en) | A kind of General query method and relevant apparatus | |
| RU2389066C2 (en) | Multidimensional database and method of managing multidimensional database | |
| CN111459949B (en) | Data processing method, device and equipment for database and index updating method | |
| CN116126620A (en) | Database log processing method, database change query method and related device | |
| CN110147355A (en) | Method of data synchronization, device and server | |
| CN113535714A (en) | Data storage method, reading method and computer equipment | |
| CN114218277A (en) | Efficient query method and device for relational database | |
| CN108874820B (en) | System file searching method | |
| CN115934825B (en) | Data access method, system, electronic device and storage medium based on elastic search | |
| US20170192674A1 (en) | Facilitating reverse reading of sequentially stored, variable-length data | |
| CN111444195B (en) | Method, device and equipment for clearing indexes in block chain type account book | |
| CN112100150B (en) | Data reading method and system |
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 |