US 12,189,665 B2
Conversion and migration of key-value store to relational model
Onur Senturk, Amsterdam (NL)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Jul. 17, 2023, as Appl. No. 18/222,586.
Application 18/222,586 is a continuation of application No. 17/468,017, filed on Sep. 7, 2021, granted, now 11,741,134.
Prior Publication US 2023/0385308 A1, Nov. 30, 2023
Int. Cl. G06F 16/28 (2019.01); G06F 9/54 (2006.01); G06F 16/21 (2019.01); G06F 16/215 (2019.01); G06F 16/22 (2019.01); G06F 16/245 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/288 (2019.01) [G06F 9/54 (2013.01); G06F 16/212 (2019.01); G06F 16/215 (2019.01); G06F 16/221 (2019.01); G06F 16/2237 (2019.01); G06F 16/2282 (2019.01); G06F 16/245 (2019.01); G06F 16/258 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method performed by a computing device, the method comprising:
converting and migrating data from a key-value store that is a non-relational database to a relational database model, comprising:
selecting a namespace identifier that is defined in the key-value store, wherein the key-value store is a non-relational database;
querying the key-value store for a kind category defined within the namespace identifier in the key-value store and retrieving the kind category;
accessing the key-value store and retrieving data entities associated with the kind category that is defined with the namespace identifier;
traversing the data entities and identifying property names and associated property values that are found in the data entities;
generating a relational database model including a table;
assigning the namespace identifier as schema of the table and assigning the kind category as a table name of the table;
building 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
migrating data from the data entities to rows in the table in the relational database model.