Invention Grant
- Patent Title: Automated layout of relational databases
- Patent Title (中): 关系数据库的自动布局
-
Application No.: US10426235Application Date: 2003-04-30
-
Publication No.: US07249141B2Publication Date: 2007-07-24
- Inventor: Sanjay Agrawal , Surajit Chaudhuri , Abhinandan Das , Vivek Narasayya
- Applicant: Sanjay Agrawal , Surajit Chaudhuri , Abhinandan Das , Vivek Narasayya
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Woodcock Washburn LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

Abstract:
Layout in a database system is performed using workload information. Execution information for a workload is obtained. Cumulative access and co-access information for database objects is then assembled. A cost model is developed for quantitatively capturing the value of different layouts, and a search is performed for a recommended database layout. In one embodiment, a greedy search is performed which initially attempts provide a layout that minimizes co-location of objects on storage objects, and then attempts to improve that layout via a greedy search.
Public/Granted literature
- US20040220942A1 Automated layout of relational databases Public/Granted day:2004-11-04
Information query