Artículo
Vaisman, A.A.; Izquierdo, A.; Ktenas, M. "A web-based architecture for temporal OLAP" (2008) International Journal of Web Engineering and Technology. 4(4):465-494
Estamos trabajando para incorporar este artículo al repositorio
Consulte la política de Acceso Abierto del editor
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, none 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. In the second part of the paper, we present TOLAP-QL, an SQL-like temporal query language. We describe the syntax and semantics of the language, a sequel of its logic-based predecessor, TOLAP. We study query optimisation in temporal OLAP, and introduce a technique based on materialisation of historical views. Last, but not least, we present a system implementation, and a real-world case study, that shows that our proposal achieves good query performance for OLAP queries over large historical databases in a web environment. Copyright © 2008 Inderscience Enterprises Ltd.
Registro:
| Documento: | Artículo |
| Título: | A web-based architecture for temporal OLAP |
| Autor: | Vaisman, A.A.; Izquierdo, A.; Ktenas, M. |
| Filiación: | Facultad de Ciencias Exactas y Naturales, Universidad de Buenos Aires, C/ Ciudad Universitaria Pabellon I, 1428, Buenos Aires, Argentina Universidad de Chile University of Buenos Aires Buenos Aires |
| Palabras clave: | Dimension updates; Temporal databases; Temporal OLAP; TOLAP; Web services; Administrative data processing; Computer programming languages; Data processing; Data structures; Data warehouses; Database systems; Information management; Information services; Information theory; Internet; Linguistics; Markup languages; Metadata; Warehouses; Web services; World Wide Web; XML; Application servers; Case studies; Data warehouse structure; Dimension updates; Historical databases; Historical information; Multidimensional databases; OLAP queries; OLAP systems; Query optimisation; Query performances; Real-world; System implementation; Temporal Data; Temporal databases; Temporal OLAP; Temporal queries; Three-tier architecture; TOLAP; Versioning; Web environment; Web-based architecture; XML documents; XML metadata; Query languages |
| Año: | 2008 |
| Volumen: | 4 |
| Número: | 4 |
| Página de inicio: | 465 |
| Página de fin: | 494 |
| DOI: | http://dx.doi.org/10.1504/IJWET.2008.019944 |
| Título revista: | International Journal of Web Engineering and Technology |
| Título revista abreviado: | Int. J. Web Eng. Technol. |
| ISSN: | 14761289 |
| Registro: | https://bibliotecadigital.exactas.uba.ar/collection/paper/document/paper_14761289_v4_n4_p465_Vaisman |
Referencias:
- Bebel, B., Eder, J., Koncilia, C., Morzy, T., Wrembel, R., Creation and management of versions in multiversion data warehouse (2004) Proceedings of SAC, pp. 717-723. , Nicosia, Cyprus, pp
- Binh, N.T., Tjoa, A.M., Mangisengi, O., Meta Cube-X: An XML metadata foundation for interoperability search among web data warehouses (2001) Proceedings of DMDW, , Interlaken, Switzerland
- Bliujute, R., Saltenis, S., Slivinskas, G., Jensen, G., Systematic change management in dimensional data warehousing (1998), Technical Report TR-23, Time Center, Computer Science Department, University of Arizona; Cabibbo, L., Torlone, R., A logical approach to multidimensional database's (1998) Proceedings of the 6th International Conference on Extending Database Technology, pp. 253-269. , Valencia, Spain, pp
- Eder, J., Koncilia, C., Morzy, T., The COMET Metamodel for temporal data warehouses (2002) Proceedings of CAiSE, pp. 83-99. , Toronto, Canada, pp
- Harinarayan, V., Rajaraman, A., Ullman, J., Implementing data cubes efficiently (1996) Proceedings of the 15th ACM-SIGMOD Conference, pp. 205-216. , Montreal, Canada, pp
- Hummer, W., Bauer, A., Harde, G., XCube: XML for data warehouses (2003) Proceedings of DOLAP, pp. 33-40. , New Orleans, Los Angeles, pp
- Hurtado, C., Mendelzon, A.O., Vaisman, A., Maintaining data cubes under dimension updates (1999) Proceedings of 1999 Int. Conference on Data Engineering (IEEE/ICDE'99), pp. 346-355. , Sydney, Australia, pp
- Kimball, R., (1996) The Data Warehouse Toolkit, , New York, NY: J. Wiley and Sons Inc
- Le Hors, A., Le Hegaret, P., Wood, L., Nicol, G., Robie, J., Champion, M., Byrne, S., DOM Level 3 Core Specification (2004) W3C Recommendation, , version 1.0, 7 April
- Lehner, W., Modeling large OLAP scenarios (1998) Proceedings of the 6th International Conference on Extending Database Technology, pp. 153-157. , Valencia, Spain, pp
- Levy, A., Mendelzon, A.O., Sagiv, Y., Srivastava, D., Answering queries using views (1995) Proceedings of the 14th ACM-SIGMOD Symposium on Principles of Database Systems, pp. 95-104. , San Jose, California, pp
- Marian, A., Abiteboul, S., Cobena, G., Mignet, Change-centric management of versions in an XML warehouse (2001) Proceedings of the 27th Int. Conf. on Very Large Databases, pp. 581-590. , Rome, Italy, pp
- Mendelzon, A.O., Vaisman, A., Temporal queries in OLAP (2000) Proceedings of the 26th Int. Conf. on Very Large Databases, pp. 242-253. , Cairo, Egypt, pp
- Mendelzon, A.O., Vaisman, A., Time in multidimensional databases (2003) Multidimensional Databases: Problems and Solutions, , Hershey, PA: Idea Group
- Mitra, N, Ed, 2003 SOAP Version 1.2 Part 0: Primer, W3C Recommendation 24 June; Mumick, I., Quass, D., Mumick, B., Maintenance of data cubes and summary tables in a warehouse (1997) Proceedings of the 16th ACM - SIGMOD Conference, pp. 100-111. , Tucson, Arizona, pp
- Niemi, T., Niinimäki, M., Nummenmaa, J., Thanisch, P., Applying grid technologies to XML based OLAP cube construction (2003) Proceedings of DMDW, , Berlin, Germany
- Pedersen, T.B., Jensen, C., Multidimensional data modeling for complex data (1999) Proceedings of 1999 Int. Conference on Data Engineering (IEEE/ICDE'99), pp. 336-345. , Sydney, Australia, pp
- Snodgrass, R., (1995) The TSQL2 Temporal Query Language, , Boston, MA: Kluwer Academic Publishers
- Thompson, H.S., Sperberg-McQueen, C.M., Mendelsohn, N., Beech, D., Maloney, M., XML Schema 1.1 Part 1: Structures (2006) W3C Working Draft, , 30 March
- 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) Proceedings of DaWaK, pp. 89-98. , Prague, Czech Republic, pp
Citas:
---------- APA ----------
Vaisman, A.A., Izquierdo, A. & Ktenas, M. (2008) . A web-based architecture for temporal OLAP. International Journal of Web Engineering and Technology, 4(4), 465-494.http://dx.doi.org/10.1504/IJWET.2008.019944
---------- CHICAGO ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M. "A web-based architecture for temporal OLAP" . International Journal of Web Engineering and Technology 4, no. 4 (2008) : 465-494.http://dx.doi.org/10.1504/IJWET.2008.019944
---------- MLA ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M. "A web-based architecture for temporal OLAP" . International Journal of Web Engineering and Technology, vol. 4, no. 4, 2008, pp. 465-494.http://dx.doi.org/10.1504/IJWET.2008.019944
---------- VANCOUVER ----------
Vaisman, A.A., Izquierdo, A., Ktenas, M. A web-based architecture for temporal OLAP. Int. J. Web Eng. Technol. 2008;4(4):465-494.http://dx.doi.org/10.1504/IJWET.2008.019944
