Every day Internet sites collect and store lots of user data. For effective usage of that data, special tools are required. Online Analytical Processing (OLAP) tools are suggested for that purpose. Usage of these tools is related to usage of Data Warehousing tools. Therefore issues of Data Warehouse design, data transformation and transferring to data warehouses were discussed. In the present years there are new trends in business computer systems industry – WEB Data Warehouses. New characteristics of such systems were analyzed. OLAP tools usage is not possible without multidimensional data model. Main entities and operations with these entities were reviewed and mathematical definitions given. Data transformation process was proposed. This process flow shows how transformations can be used for transferring data from WEB site to multidimensional database. OLAP tools of Microsoft SQL server and Oracle database server (the most popular database management systems in Lithuania) were analyzed in experimental part of work. Data transformation and reviewing in desktop applications, WEB systems and office applications tools were compared and recommendations given.
| Identifer | oai:union.ndltd.org:LABT_ETD/oai:elaba.lt:LT-eLABa-0001:E.02~2004~D_20040924_103347-70072 |
| Date | 24 September 2004 |
| Creators | Vilimas, Marius |
| Contributors | Lenkevičius, Antanas, Matickas, Jonas Kazimieras, Targamadzė, Aleksandras, Rubliauskas, Dalius, Nemuraitė, Lina, Stulpinas, Raimundas, Butleris, Rimantas, Paradauskas, Bronius, Kiauleikis, Valentinas, Karčiauskas, Eimutis, Kaunas University of Technology |
| Publisher | Lithuanian Academic Libraries Network (LABT), Kaunas University of Technology |
| Source Sets | Lithuanian ETD submission system |
| Language | Lithuanian |
| Detected Language | English |
| Type | Master thesis |
| Format | application/pdf |
| Source | http://vddb.library.lt/obj/LT-eLABa-0001:E.02~2004~D_20040924_103347-70072 |
| Rights | Unrestricted |
Page generated in 0.0017 seconds