On universal database design

被引:0
作者
Eessaar, Erki [1 ]
Soobik, Marek [1 ]
机构
[1] Tallinn Univ Technol, Dept Informat, Tallinn, Estonia
来源
DATABASES AND INFORMATION SYSTEMS | 2008年
关键词
database design; data management; universal design; SQL;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Requirements to software systems, including databases, often change. It is tempting to design a database according to very abstracts concepts. The generic design, which is called "universal database design", allows us to record all possible facts in terms of object types, objects, attributes, attribute values, and relationships. This kind of design arguably simplifies the recording of new kinds of facts. However, the flexibility comes with a price. Existing studies point mostly to the performance problems and complexity of queries. We found twelve different problems with this kind of design. In this paper, we present the analysis of the advantages and disadvantages of the use of the universal design.
引用
收藏
页码:349 / 360
页数:12
相关论文
共 26 条
[1]   Generic Design of Web-Based Clinical Databases [J].
Anhoj, Jacob .
JOURNAL OF MEDICAL INTERNET RESEARCH, 2003, 5 (04)
[2]  
Baskerville R, 2001, INT FED INFO PROC, V66, P49
[3]  
BEDNAREK D, 2005, P 9 E EUR C ADV DAT, P178
[4]  
Bernstein PA, 1997, PROCEEDINGS OF THE TWENTY-THIRD INTERNATIONAL CONFERENCE ON VERY LARGE DATABASES, P3
[5]   Exploring performance issues for a clinical database organized using an entity-attribute-value representation [J].
Chen, RS ;
Nadkarni, P ;
Marenco, L ;
Levin, F ;
Erdos, J ;
Miller, PL .
JOURNAL OF THE AMERICAN MEDICAL INFORMATICS ASSOCIATION, 2000, 7 (05) :475-487
[6]  
Date C.J., 2003, Introduction to database systems, Veigth
[7]  
DEHAAN L, 2007, APLLIED MATH DATABAS
[8]  
Do HH, 2004, LECT NOTES COMPUT SC, V2992, P811
[9]  
EESSAAR E, 2006, THESIS TALLINN U TEC
[10]  
Fowler M., 1997, ANAL PATTERNS REUSAB