Method and device for storing data

Abstract

The invention discloses a method and device for storing data. The method includes the steps that the same column attributes of at least two data objects to be stored into a KeyValue-type distributed database are determined; the formats of row identification of all the data objects of the at least two data objects in the KeyValue-type distributed database are determined, wherein the formats of the row identification comprise the same column attributes and data object identification, and the positions of the data object identification of different data objects in the formats of the row identification are the same and located behind the same column attributes; the values of the row identification of all data records of each data object are determined; the values of the row identification of the data records and the data records are stored in the KeyValue-type distributed database, and the values of the row identification of the data records serve as the prime indexes of the data records in the KeyValue-type distributed database. According to the method and device for storing data, the data inquiring efficiency can be improved.

Description

technical field [0001] The present invention relates to the field of information technology, and more particularly, to a method and apparatus for storing data. Background technique [0002] As a distributed column storage database, the KeyValue type distributed database has high scalability and robustness, and has been widely used in more and more systems. The user table of the KeyValue type distributed database is usually designed to store the data format is relatively simple, the relationship is simple but may be massive data, for example: used to store web page address information, used to store call record information, used to store Internet record information ,and many more. It can provide fast query based on the row key (RowKey) of the data record, regardless of the size of the data volume. It can dynamically expand physical nodes when the current storage space usage reaches a certain threshold. [0003] In an existing database application of an enterprise, many use...

AI Technical Summary

Problems solved by technology

The distributed database of KeyValue type based on sparse matrix is ​​suitable for storing large data tables. If these tables are imported into the distributed database of KeyValue type as they are, there will be too many small tables. would increase the complexity of management

That is to say, when data in traditional applications is migrated to a distributed database of the KeyValue type, in order to complete the association query between user tables and user tables, different tables need to be queried, and continuous data positioning leads to inefficiency.

Images