公开(公告)号：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

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/25 ,  G06F16/28 ,  G06F16/93

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.