-
公开(公告)号:US20250147936A1
公开(公告)日:2025-05-08
申请号:US18420708
申请日:2024-01-23
Applicant: Oracle International Corporation
Inventor: Shashank Gugnani , Ajit Mylavarapu , Sukhada Pendse , Tirthankar Lahiri , Shadab Ahmed , Sanju Gowda , Beda C. Hammerschmidt , Zhen Hua Liu
Abstract: Techniques for automatically migrating documents from a document database to a relational database are provided. In one technique, it is determined whether a set of documents, from a document database system, can be stored in a relational database system. If so, one or more entities to be normalized are identified based on a hierarchical structure of the set of documents. One or more scripts are generated based on the identified one or more entities. In a related technique, a set of documents from a document database system is stored. It is validated that the set of documents can be converted to one or more duality views. Data of the set of documents is normalized for storing in a relational database system. A script is generated that, when executed, generates the one or more duality views.
-
公开(公告)号:US12287777B2
公开(公告)日:2025-04-29
申请号:US17966730
申请日:2022-10-14
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Juan R. Loaiza , Sundeep Abraham , Shubha Bose , Hui Joe Chang , Shashank Gugnani , Beda Christoph Hammerschmidt , Tirthankar Lahiri , Ying Lu , Douglas James McMahon , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Ananth Raghavan
IPC: G06F16/00 , G06F16/23 , G06F16/2455
Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.
-
公开(公告)号:US12298946B2
公开(公告)日:2025-05-13
申请号:US17966736
申请日:2022-10-14
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Juan R. Loaiza , Sundeep Abraham , Shubha Bose , Hui Joe Chang , Shashank Gugnani , Beda Christoph Hammerschmidt , Tirthankar Lahiri , Ying Lu , Douglas James McMahon , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Ananth Raghavan
IPC: G06F16/20 , G06F16/21 , G06F16/2453 , G06F16/84
Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.
-
-