发明授权
- 专利标题： Slicing of relational databases
- 专利标题（中）： 切片关系数据库
-
申请号： US12103699申请日： 2008-04-15
-
公开(公告)号： US07873598B2公开(公告)日： 2011-01-18
- 发明人: Hui Shi , Kenton Gidewall , Marcelo M. De Barros , Chan Chaiyochlarb , Murali R. Krishnan , Robert Irwin Voightmann , Christina Ruth Dhanaraj
- 申请人： Hui Shi , Kenton Gidewall , Marcelo M. De Barros , Chan Chaiyochlarb , Murali R. Krishnan , Robert Irwin Voightmann , Christina Ruth Dhanaraj
- 申请人地址： US WA Redmond
- 专利权人： Microsoft Corporation
- 当前专利权人： Microsoft Corporation
- 当前专利权人地址： US WA Redmond
- 代理机构： Capitol City TechLaw
- 代理商 Richard C. Irving
- 主分类号： G06F7/00
- IPC分类号： G06F7/00 ; G06F17/00
摘要：
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.
公开/授权文献
- US20090259618A1 SLICING OF RELATIONAL DATABASES 公开/授权日：2009-10-15
信息查询
