Object coding and operation method in database system and database server

Abstract

The invention discloses an object encoding and operation method in a database system, a database management system and a database server. According to the correlation of multiple object sample spaces in the database, a global object sample space is formed, and a global dictionary table is created in the global object sample space to provide each object with a globally unique coded value as its object identifier, and ensure that the object identifier is consistent with the object The description information of is a one-to-one mapping relationship. Encode and compress database objects based on the global dictionary table to reduce encoding overhead. Furthermore, the database query operation is performed directly using the object identifier, and the operation of the string type is optimized as an operation of the integer type, which improves the efficiency of the operation.

Description

technical field [0001] The present invention relates to the field of database technology, and more specifically, relates to an object encoding and operation method in a database system, a database management system and a database server. Background technique [0002] Modern information processing is based on the cognitive model based on object identification (ID). In this cognitive model, an object (Object) in any sample space has an identification (ID) to distinguish it from other objects in the sample space. object, and then use human language to describe this object. In this way, all objects have two basic attributes: object ID and object description information, that is, any object can be expressed as: Object=(ID, description). Information processing based on this cognitive model mainly includes: 1) Establishing object sample space. 2) Provide each object in the object sample space with a coded value to identify the unique ID of the object through manual / automatic codi...

AI Technical Summary

Problems solved by technology

[0006] It can be seen from the above that each column of the database table uses a private dictionary table during the encoding process, which increases encoding consumption and wastes disk storage space

In addition, because each column uses its own private dictionary table, the encoding information cannot be shared between multiple tables that have relationships, and the obtained encoding value (object ID) cannot be used across tables.

When you need to participate in query operations, you must first obtain the description information of all objects through the private dictionary table, and then you can perform various complex operations on these description information, which greatly reduces the performance of database execution query operations

Images