Invention Grant
- Patent Title: Slicing of relational databases
- Patent Title (中): 切片关系数据库
-
Application No.: US12103699Application Date: 2008-04-15
-
Publication No.: US07873598B2Publication Date: 2011-01-18
- Inventor: Hui Shi , Kenton Gidewall , Marcelo M. De Barros , Chan Chaiyochlarb , Murali R. Krishnan , Robert Irwin Voightmann , Christina Ruth Dhanaraj
- Applicant: Hui Shi , Kenton Gidewall , Marcelo M. De Barros , Chan Chaiyochlarb , Murali R. Krishnan , Robert Irwin Voightmann , Christina Ruth Dhanaraj
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Capitol City TechLaw
- Agent Richard C. Irving
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00
Abstract:
A method and a processing device may be provided for creating a shadow database, having a size being approximately a desired percentage of a size of a relational database. Referential integrity of tables of the relational database may be preserved in the created shadow database. A representation of a connected graph may be created, based on a schema description of the relational database, and may be used to find driving tables and related tables of the relational database. Portions of driving tables of the relational database may be copied to corresponding tables of the shadow database and rows of tables of the relational database, related to the copied portions of the driving tables, may be copied to corresponding tables of the shadow database in a number of iterations until the size of the shadow database is approximately the desired percentage of the size of the relational database.
Public/Granted literature
- US20090259618A1 SLICING OF RELATIONAL DATABASES Public/Granted day:2009-10-15
Information query
