Invention Grant
- Patent Title: Schema agnostic migration of delineated data between relational databases
-
Application No.: US16914060Application Date: 2020-06-26
-
Publication No.: US11232084B2Publication Date: 2022-01-25
- Inventor: Igor Taranov
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Agency: Watson Patents, PLC
- Agent Vladan M. Vasiljevic
- Main IPC: G06F16/30
- IPC: G06F16/30 ; G06F7/00 ; G06F16/21 ; G06F16/22

Abstract:
Initially, a database schema is parsed and a table tree structure is created delineating the relationships between data that are identified in the schema. In addition to accommodating relationships between main tables of data, the table tree structure also accommodates possible side tables of data, and possible circular references between tables, should such be encountered when parsing the schema. Subsequently, a migration mechanism consumes the generated table tree structure and iteratively migrates data in accordance therewith. Individual layers of the table tree structure are migrated consecutively with referenced layers being migrated prior to referencing layers. Circular links are accommodated through temporary null values, and side tables are accommodated during migration of the referencing main table. The iterative process provides completeness and fault tolerance/failure recovery.
Public/Granted literature
- US20210406229A1 Schema Agnostic Migration Of Delineated Data Between Relational Databases Public/Granted day:2021-12-30
Information query