Browse Prior Art Database

Data Recovery depending on the index segment

IP.com Disclosure Number: IPCOM000241553D
Publication Date: 2015-May-11
Document File: 3 page(s) / 61K

Publishing Venue

The IP.com Prior Art Database

Abstract

It is common that our data table is broken, we could not avoid recover the data repeatedly. Usually we might need to back up the data by period. But if the recovery is long ago, we might lose data by some accidence. When we insert record into database, database should update index also. The indexes also contain the information of columns. We would like to introduce a new method to recovery the data. There is also the information segment in the index. The database system would calculate the cost for the recovery to choose the minimum index set to recovery. If the indexes are chosen to be used as candidate indexes, the system would read the index keys to combine them together to get semi records. We might still miss some of the values in the records, but we could recovery the most column as best.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 3

Data Recovery depending on the index segment

It is common that our data table is broken, we could not avoid recover the data repeatedly. Usually we might need to back up the data by period. But if the recovery is long ago, we might lose data by some accidence. When we insert record into database, database should update index also. It would cost a long time when there are too many index on the table, especially meeting index split. We need a method to reduce the time on index update. database uses indexes not only to enforce uniqueness on column values, but also to cluster data, to partition tables, and to provide efficient access paths to data for queries. Understanding the structure of database indexes can be important for achieving the best performance for your system. An index is an ordered set of pointers to the data in a database table. The index is stored separately from the table. Each index is based on the values of data in one or more columns of a table. After you create an index, database maintains the index, but you can perform necessary maintenance such as reorganizing it or recovering the index. Indexes take up physical storage in index spaces. Each index occupies its own index space. The main purposes of indexes are: v To improve performance. The indexes also contain the information of columns.

We would like to introduce a new method to recovery the data. There is also the information segment in the index. The database system would calculate the cost for the recovery to choose the minimum index set to recovery. If the indexes are chosen to be used as candidate indexes, the system would read the index keys to combine them toget...