18171292. HYBRID TABLE SECONDARY INDEX FOR LOOKUPS, UNIQUE CHECKS, AND REFERENTIAL INTEGRITY CONSTRAINTS simplified abstract (Snowflake Inc.)

From WikiPatents
Jump to navigation Jump to search

HYBRID TABLE SECONDARY INDEX FOR LOOKUPS, UNIQUE CHECKS, AND REFERENTIAL INTEGRITY CONSTRAINTS

Organization Name

Snowflake Inc.

Inventor(s)

Nikolaos Romanos Katsipoulakis of Redwood City CA (US)

Dimitrios Tsirogiannis of Belmont CA (US)

Zhaohui Zhang of Redwood City CA (US)

HYBRID TABLE SECONDARY INDEX FOR LOOKUPS, UNIQUE CHECKS, AND REFERENTIAL INTEGRITY CONSTRAINTS - A simplified explanation of the abstract

This abstract first appeared for US patent application 18171292 titled 'HYBRID TABLE SECONDARY INDEX FOR LOOKUPS, UNIQUE CHECKS, AND REFERENTIAL INTEGRITY CONSTRAINTS

Simplified Explanation

The subject technology described in this patent application involves a system that receives information from a metadata database related to a base table. It then determines a table object associated with the base table and generates a nested object based on additional metadata. This nested object is linked to the table object.

  • The system also generates a second table object that represents a secondary index of the base table and includes information linking it to the nested object.
  • A link is established between the second table object and the base table based on the nested object.
  • The nested object and the second table object are stored in the metadata database.

Potential Applications

  • This technology can be applied in database management systems to improve indexing and organization of data.
  • It can be used in data analysis and data mining applications to enhance the efficiency of searching and retrieving information.

Problems Solved

  • The technology solves the problem of efficiently organizing and indexing large amounts of data in a database.
  • It addresses the challenge of linking and managing nested objects within a database system.

Benefits

  • Improved performance and efficiency in searching and retrieving data from a database.
  • Enhanced organization and indexing of data, leading to faster data processing.
  • Simplified management of nested objects within a database system.


Original Abstract Submitted

The subject technology receives, from a metadata database, information related to a base table. The subject technology determines a table object associated with the base table, the table object including a first set of metadata. The subject technology generates a nested object based on a second set of metadata, the second set of metadata including information linking the nested object to the table object. The subject technology generates a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object. The subject technology establishes a link between the second table object to the base table based on the nested object. The subject technology stores, in the metadata database, the nested object and the second table object.