 |
eLABa objektas: "Daugiaatribučių duomenų struktūrų sukūrimas ir jų alternatyvų įvertinimas", 2004,D:20040524:145330-43698 |
|
visi dokumentai ... |
Rubliauskas, Dalius - Magistro baigiamojo darbo vertinimo komisijos narys
Bareiša, Eduardas - Magistro baigiamojo darbo vertinimo komisijos narys
Stulpinas, Raimundas - Magistro baigiamojo darbo vertinimo komisijos pirmininkas
Jusas, Vacius - Magistro baigiamojo darbo vadovas
Štuikys, Vytautas - Magistro baigiamojo darbo vertinimo komisijos narys
Lenkevicius, Antanas - Magistro baigiamojo darbo recenzentas
Butleris, Rimantas - Magistro baigiamojo darbo vertinimo komisijos narys
Targamadzė, Aleksandras - Magistro baigiamojo darbo vertinimo komisijos narys
Kazanavičius, Egidijus - Magistro baigiamojo darbo vertinimo komisijos narys
Kauno technologijos universitetas - Mokslinį laipsnį teikianti institucija
Data structures with many attributes and the evaluation of the alternatives
This paper is a research of problem which was faced during development of clinical information system. This is a scope, where one clinical test can by characterised by several hundreds of attributes. Thus the focus is on the design and performance of database tables with 200-300 columns. |
To perform the research the Oracle Database Management System was chosen. There is the main factors, influencing performance, such as principles of data storage on disk, query processing also the main facilities to improve performance observed. |
Based on the basic principles of relational database design some alternatives to tables with many attributes were created. It is normalized and denormalized structures. |
There is performed the experiment to see how the speed of most used queries depends on data structure. Also there is done the analysis of complexity and usability of these queries. |
Raktažodžiai: reliacinė duomenų bazė, užklausos vykdymas, normalizavimas, užklausos greičio priklausomybės, užklausų panaudojamumas, denormalizavimas, daugiaatributė lentelė |