US Patent Application 18222586. CONVERSION AND MIGRATION OF KEY-VALUE STORE TO RELATIONAL MODEL simplified abstract

From WikiPatents
Jump to navigation Jump to search

CONVERSION AND MIGRATION OF KEY-VALUE STORE TO RELATIONAL MODEL

Organization Name

Oracle International Corporation

Inventor(s)

Onur Senturk of Amsterdam (NL)

CONVERSION AND MIGRATION OF KEY-VALUE STORE TO RELATIONAL MODEL - A simplified explanation of the abstract

This abstract first appeared for US patent application 18222586 titled 'CONVERSION AND MIGRATION OF KEY-VALUE STORE TO RELATIONAL MODEL

Simplified Explanation

The abstract describes a method for migrating key-value data to a relational database. Here are the key points:

  • The method retrieves a namespace from a key-value store and queries the store for a kind category associated with the namespace.
  • Data entities associated with the kind category are retrieved from the key-value store.
  • Property names and their associated values are identified in the data entities.
  • A relational database model is generated, with the namespace identifier assigned as the schema of a table and the kind category assigned as the table name.
  • The table is built in the relational database model, with columns defined for each different property name identified from the data entities.
  • Data from the data entities is migrated to rows in the table in the relational database model.


Original Abstract Submitted

Systems, methods, and other embodiments associated with migrating key-value data to a relational database. A method comprises retrieving a namespace from a key-value store and querying the key-value store for a kind category associated with the namespace. The key-value store is accessed and data entities are retrieved that are associated with the kind category that is defined with the namespace identifier. Property names and associated property values are identified in the data entities. The method generates a relational database model including a table; assigns the namespace identifier as schema of the table and assigns the kind category as a table name; builds the table in the relational database model by defining a plurality of columns, wherein a column is defined for each different property name identified from the data entities; and migrates data from the data entities to rows in the table in the relational database model.