[General principles of database storage operations with emphasis on OLAP reports].
In article general principles and features of data warehouse were presented in particular of OLAP reports. The data warehouse was built using Oracle tools. The repository was filled with death records from Central Office of Statistics. Various features adequate for epidemiological analyses have been discussed and illustrated like pivoting and rotating dimension, drilling on hierarchical data, reduction of dimensions. The possibility of specific for epidemiology indicators creation was shown. The need of implementation of data warehouses and OLAP reports in Polish healthcare was discussed. In comparison with traditional manner of analysis and presentation epidemiological facts OLAP reports give new perspectives.
Borkowski
Włodzimierz
W
Zakład Informatyki, Centrum Medycznego Kształcenia Podyplomowego w Warszawie. wborkow@cmkp.edu.pl
Mielniczuk
Hanna
H
D019985:Benchmarking / Q000379:methods; D003628:Database Management Systems / Q000592:standards*; D003644:Death Certificates; D020000:Decision Support Systems, Clinical / Q000592:standards; D003660:Decision Support Systems, Management / Q000592:standards*; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods; D016347:Medical Records Systems, Computerized / Q000592:standards*; D011044:Poland