Collaborative Agents Supported Automatic Physical Database Design Based on Description Logics Reasoning

Author

Hu, Tian-lei ; Chen, Gang ; Hong, Yin-Jie ; Zhang, Xiao-Long ; Dong, Jin-xiang

Author_Institution

Coll. of Comput. Sci. & Technol., Zhejiang Univ., Hangzhou

fYear

2006

fDate

3-5 May 2006

Firstpage

1

Lastpage

6

Abstract

Physical database design is a key phase in devising and deploying a database system to improve overall system performance, and automatic physical database design becomes an important value-added feature in a database system to decrease the TCO (total cost of ownership). A GAPDD (general automatic physical database design) framework, with two phases, the workload mining phase and the design advising phase, is provided to support automatic physical database design for relational database systems. Three collaborative agents, the workload mining agent (WMA), the feature generation agent (FGA), and the optimal search agent (OSA) work together in GAPDD. The feature generation procedure in FGA is further studied, and a reasoner based on description logics (DL) is offered to reason useful features. An index advisor for OSCAR relational engine is prototyped, and experiment results show its feasibility and efficiency

Keywords

data mining; groupware; inference mechanisms; relational databases; software agents; OSCAR relational engine; collaborative agent supported GAPDD; description logics reasoning; design advising phase; feature generation agent; general automatic physical database design; index advisor; optimal search agent; relational database systems; workload mining agent; Automatic logic units; Collaboration; Collaborative work; Costs; Database systems; Engines; Logic design; Relational databases; Spatial databases; System performance; Automatic Physical Database Design; Collaborative Agent; Description Logics;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Supported Cooperative Work in Design, 2006. CSCWD '06. 10th International Conference on

Conference_Location

Nanjing

Print_ISBN

1-4244-0164-X

Electronic_ISBN

1-4244-0165-8

Type

conf

DOI

10.1109/CSCWD.2006.253132

Filename

4019168