Abstract:
Commercial OLAP systems usually consider OLAP dimensions as static entities. In practice, dimension updates are often necessary in order to adapt the multidimensional database to changing requirements. Query languages are then needed to retrieve historical information from a data warehouse. Although many proposals addressing temporal OLAP exist, no one supports full operation over the World Wide Web. After introducing a temporal data model supporting historical dimensions and fact table versioning, we present a three-tier architecture based on Web services, SOAP and XML, allowing efficient querying over the Web. In this architecture, XML metadata is stored at the application server in the form of XML documents containing the data warehouse structure. This allows addressing most of the requests (navigation through time, updates, and queries) without accessing the data warehouse. We present our implementation, and also discuss query processing issues, like answering historical queries using materialized views. © 2006 IEEE.
Registro:
| Documento: |
Conferencia
|
| Título: | Web-enabled temporal OLAP |
| Autor: | Vaisman, A.A.; Izquierdo, A.; Ktenas, M. |
| Ciudad: | Cholula |
| Filiación: | Universidad de Chile, Blanco Encalada 2120, Santiago, Chile
Universidad de Buenos, Aires Ciudad Universitaria, PI Bs.As, Argentina
|
| Palabras clave: | Data warehousing; OLAP; Temporal databases; Temporal OLAP; Data structures; Data warehouses; Query processing; Software engineering; XML; OLAP; Temporal databases; Temporal OLAP; Web services |
| Año: | 2006
|
| Página de inicio: | 220
|
| Página de fin: | 229
|
| DOI: |
http://dx.doi.org/10.1109/LA-WEB.2006.37 |
| Título revista: | LA-Web 06: 4th Latin American Web Congress
|
| Título revista abreviado: | Proc. LA-Web Fourth Laten Am. Web Congr.
|
| Registro: | https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_07695269_v_n_p220_Vaisman |
Referencias:
- Bebei, B., Eder, J., Koncilia, C., Morzy, T., Wrembel, R., Creation and management of versions in multiversion data warehouse (2004) SAC, pp. 717-723
- Binh, N., Tjoa, A., Mangisengi, O., Meta cube-x: An XML metadata foundation for interoperability search among web data warehouses (2001) DMDW
- Bliujute, R., Saltenis, S., Slivinskas, G., Jensen, G., Systematic change management in dimensional data warehousing (1998) Time Center Technical Report, , TR-23
- Bray, T., Paoli, J., Sperberg-McQueen, C., Maler, E., Yergeau, F., XML 1.0 third edition ; Cabibbo, L., Torlone, R., A logical approach to multidimensional databases (1998) EDBT'98: 6th International Conference on Extending Database Technology, pp. 253-269. , Valencia, Spain
- Eder, J., Koncilia, C., Morzy, T., The comet metamodel for temporal data warehouses (2002) CAiSE, pp. 83-99
- eSOAP http://www.embedding.net/eSOAP; Hurtado, C., Mendelzon, A., Vaisman, A., Maintaining data cubes under dimension updates (1999) Proceedings of IEEE/ICDE'99
- Kimball, R., (1996) The Data Warehouse Toolkit, , J.Wiley and Sons, Inc
- Lehner, W., Modeling large OLAP scenarios (1998) Proceedings of the 1998 International Conference on Extending Database Technology, , Valencia, Spain
- Le Hors, A., Le Hegaret, P., Wood, L., Nicol, G., Robie, J., Champion, M., Byrne, S., DOM level 3 core specification W3C Recommendation, 7 April 2004, , version 1.0
- Marian, A., Abiteboul, S., Cobena, G., Mignet, L., Change-centric management of versions in an XML warehouse (2001) Proceedings of the 27th VLDB Conference, pp. 581-590. , Rome, Italy
- Mendelzon, A., Vaisman, A., Temporal queries in OLAP (2000) Proceedings of the 26th VLDB Conference, , Cairo, Egypt
- Mendelzon, A., Vaisman, A., Time in multidimensional databases (2003) Multidimensional Databases, pp. 166-199
- N. E. Mitra. SOAP version 1.2 part 0: Primer. W3C Recommendation 24 June 2003; Mumick, I., Quass, D., Mumick, B., Maintenance of data cubes and summary tables in a warehouse (1997) Proceedings of the ACM - SIGMOD Conference, , Tucson, Arizona
- Niemi, T., Niinimäki, M., Nummenmaa, J., Thanisch, P., Applying grid technologies to xml based olap cube construction (2003) DMDW
- Pedersen, T., Jensen, C., Multidimensional data modeling for complex data (1999) Proceedings of IEEE/ICDE'99
- Snodgrass, R., (1995) The TSQL2 Temporal Query Language, , Kluwer Academic Publishers
- Thompson, H., Sperberg-McQueen, C., Mendelsohn, D., Beech, N., Maloney, M., XML schema 1.1 part 1: Structures W3C Working Draft, 30 March, 2006
- Tomcat Apache, , http://tomcat.apache.org, home
- Vaisman, A., (2001) Updates, view maintenance and time management in multidimensional databases, , http://www.cs.toronto.edu/avaisman/ publications, Phd Thesis
- Vrdoljak, B., Banek, M., Rizzi, S., Designing web warehouses from XML schemas (2003) InDaWaK, pp. 89-98
- XML for Analysis Specification, , http://xmla.org/ download.asp?id=2
- XML for Analysis, , http://xmla.org
- http://www-rocq.inria.fr/verso/research/xyleme, Xyleme ProjectA4 - SMCC - Sociedad Mexicana de Ciencia de la Computacion; CIRIA - Interactive Center of Inf. and Learn. Resources (UDLA); ICT - Lab. of Interactive and Cooperative Technol. (UDLA)
Citas:
---------- APA ----------
Vaisman, A.A., Izquierdo, A. & Ktenas, M.
(2006)
. Web-enabled temporal OLAP. LA-Web 06: 4th Latin American Web Congress, 220-229.
http://dx.doi.org/10.1109/LA-WEB.2006.37---------- CHICAGO ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M.
"Web-enabled temporal OLAP"
. LA-Web 06: 4th Latin American Web Congress
(2006) : 220-229.
http://dx.doi.org/10.1109/LA-WEB.2006.37---------- MLA ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M.
"Web-enabled temporal OLAP"
. LA-Web 06: 4th Latin American Web Congress, 2006, pp. 220-229.
http://dx.doi.org/10.1109/LA-WEB.2006.37---------- VANCOUVER ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M. Web-enabled temporal OLAP. Proc. LA-Web Fourth Laten Am. Web Congr. 2006:220-229.
http://dx.doi.org/10.1109/LA-WEB.2006.37