{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T15:23:10Z","timestamp":1781104990606,"version":"3.54.1"},"reference-count":46,"publisher":"IGI Global Scientific Publishing","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2012,1,1]]},"abstract":"<p>Current commercial and academic OLAP tools do not process XML data that contains XLink. Aiming at overcoming this issue, this paper proposes an analytical system composed by LMDQL, an analytical query language. Also, the XLDM metamodel is given to model cubes of XML documents with XLink and to deal with syntactic, semantic and structural heterogeneities commonly found in XML documents. As current W3C query languages for navigating in XML documents do not support XLink, XLPath is discussed in this article to provide features for the LMDQL query processing. A prototype system enabling the analytical processing of XML documents that use XLink is also detailed. This prototype includes a driver, named sql2xquery, which performs the mapping of SQL queries into XQuery. To validate the proposed system, a case study and its performance evaluation are presented to analyze the impact of analytical processing over XML\/XLink documents.<\/p>","DOI":"10.4018\/jdwm.2012010103","type":"journal-article","created":{"date-parts":[[2012,1,13]],"date-time":"2012-01-13T10:26:08Z","timestamp":1326450368000},"page":"52-92","source":"Crossref","is-referenced-by-count":1,"title":["Analytical Processing Over XML and XLink"],"prefix":"10.4018","volume":"8","author":[{"given":"Paulo","family":"Caetano da Silva","sequence":"first","affiliation":[{"name":"Salvador University and Federal University of Pernambuco, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Val\u00e9ria Ces\u00e1rio","family":"Times","sequence":"additional","affiliation":[{"name":"Federal University of Pernambuco, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ricardo Rodrigues","family":"Ciferri","sequence":"additional","affiliation":[{"name":"Federal University of S\u00e3o Carlos, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Cristina Dutra de Aguiar","family":"Ciferri","sequence":"additional","affiliation":[{"name":"University of S\u00e3o Paulo, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"jdwm.2012010103-0","doi-asserted-by":"crossref","unstructured":"Barcel\u00f3, P., & Libkin, L. (2005). Temporal logics over unranked trees. In Proceedings of the 20th Annual Symposium on Logic in Computer Science.","DOI":"10.1109\/LICS.2005.51"},{"key":"jdwm.2012010103-1","unstructured":"Berglund, A., Boag, S., Chamberlin, D., Fern\u00e1ndez, M. F., Kay, M., Robie, J., & Sim\u00e9on, J. (Eds.). (2007). XPath - XML path language. Retrieved from http:\/\/www.w3c.org\/tr\/xpath20\/"},{"key":"jdwm.2012010103-2","doi-asserted-by":"crossref","unstructured":"Beyer, K., Chamberlin, D., Colby, L., Ozcan, F., Pirahesh, H., & Xu, Y. (2005). Extending XQuery for analytics. In Proceedings of the ACM SIGMOD International Conference on Management of Data.","DOI":"10.1145\/1066157.1066215"},{"key":"jdwm.2012010103-3","unstructured":"Boag, S., Chamberlin, D., Fern\u00e1ndez, M. F., Florescu, D., Robie, J., & Sim\u00e9on, J. (Eds.). (2007). XQuery 1.0: An xml query language. Retrieved from http:\/\/www.w3.org\/TR\/xquery"},{"issue":"2","key":"jdwm.2012010103-4","doi-asserted-by":"crossref","DOI":"10.1145\/1083784.1083790","article-title":"Analytical processing of XML documents: Opportunities and challenges.","volume":"34","author":"R. R.Bordawekar","year":"2005","journal-title":"SIGMOD Record"},{"key":"jdwm.2012010103-5","doi-asserted-by":"crossref","unstructured":"Boussaid, O., Messaoud, R. B., Choquet, R., & Anthoard, S. (2006). X-warehousing: An XML-based approach for warehousing complex data. In Proceedings of the 10th East European Conference on Advances in Databases and Information Systems (LNCS 4152, pp. 39-54).","DOI":"10.1007\/11827252_6"},{"key":"jdwm.2012010103-6","author":"E. F.Brigham","year":"2007","journal-title":"Financial management: Theory and practice"},{"key":"jdwm.2012010103-7","doi-asserted-by":"publisher","DOI":"10.1145\/248603.248616"},{"key":"jdwm.2012010103-8","author":"A.Damondaran","year":"2007","journal-title":"Avalia\u00e7\u00e3o de empresas"},{"key":"jdwm.2012010103-9","unstructured":"DeRose, S., Maler, E., & Orchard, D. (Eds.). (2001). XLink - XML linking language. Retrieved from http:\/\/www.w3.org\/TR\/xlink"},{"key":"jdwm.2012010103-10","unstructured":"Deutsch, A., Fernandez, M., Florescu, D., Levy, A., & Suciu, D. (1998). XML-QL: A query language for XML. Retrieved from http:\/\/www.w3.org\/TR\/NOTE-xml-ql\/"},{"key":"jdwm.2012010103-11","unstructured":"Eurofiling. (2005). COREP XBRL Project. Retrieved from http:\/\/www.eurofiling.info\/index.html"},{"key":"jdwm.2012010103-12","doi-asserted-by":"crossref","unstructured":"Gottlob, G., Koch, C., & Pichler, R. (2003). XPath query evaluation: Improving time and space efficiency. In Proceedings of the 19th International Conference on Data Engineering (pp. 379-390).","DOI":"10.1109\/ICDE.2003.1260807"},{"key":"jdwm.2012010103-13","unstructured":"Grosso, P., Maler, E., Marsh, J., & Walsh, N. (2003). XPointer framework. Retrieved from http:\/\/www.w3.org\/TR\/xptr-framework\/"},{"key":"jdwm.2012010103-14","author":"E. A.Helfert","year":"1997","journal-title":"Techniques of financial analysis: A practical guide to measuring business performance"},{"key":"jdwm.2012010103-15","unstructured":"Hern\u00e1ndez-Ros, I., & Wallis, H. (2006). XBRL dimensions. Retrieved from http:\/\/www.xbrl.org\/Specification\/XDT-REC-2006-09-18.htm"},{"key":"jdwm.2012010103-16","doi-asserted-by":"crossref","unstructured":"H\u00fcmmer, W., Bauer, A., & Harde, G. (2003). XCube \u2013 XML for data warehouses. In Proceedings of the 6th ACM International Workshop on Data Warehousing and OLAP (pp. 33-40).","DOI":"10.1145\/956060.956067"},{"key":"jdwm.2012010103-17","unstructured":"IBM. (2010). DB2 Express C. Retrieved from http:\/\/www-01.ibm.com\/software\/data\/db2\/express\/"},{"key":"jdwm.2012010103-18","doi-asserted-by":"crossref","unstructured":"Jian, F. M., Pei, J., & Fu, A. W. (2007). IX-Cubes: Iceberg cubes for data warehousing and OLAP on XML data. In Proceedings of the Sixteenth ACM Conference on Information and Knowledge Management (pp. 905-908).","DOI":"10.1145\/1321440.1321572"},{"key":"jdwm.2012010103-19","author":"R.Kimball","year":"2002","journal-title":"The DataWarehouse toolkit"},{"key":"jdwm.2012010103-20","doi-asserted-by":"publisher","DOI":"10.2168\/LMCS-2(3:2)2006"},{"key":"jdwm.2012010103-21","doi-asserted-by":"crossref","unstructured":"Libkin, L., & Neven, F. (2003). Logical definability and query languages over unranked trees. In Proceedings of the 18th IEEE Annual Symposium on Logic in Computer Science, Ottawa, ON, Canada (pp. 178-187).","DOI":"10.1109\/LICS.2003.1210057"},{"key":"jdwm.2012010103-22","author":"D. C.Matarazzo","year":"2003","journal-title":"An\u00e1lise financeira de balan\u00e7os"},{"key":"jdwm.2012010103-23","unstructured":"MSDN. (2008). MDX function reference. Retrieved from http:\/\/msdn.microsoft.com\/en-us\/library\/ms145970.aspx"},{"key":"jdwm.2012010103-24","doi-asserted-by":"publisher","DOI":"10.1002\/asi.20756"},{"key":"jdwm.2012010103-25","unstructured":"Oracle. (2010). Oracle Berkeley DB XML. Retrieved from http:\/\/www.oracle.com\/technology\/documentation\/berkeley-db\/xml\/index.html"},{"key":"jdwm.2012010103-26","doi-asserted-by":"crossref","unstructured":"Park, B. K., Han, H., & Song, I. Y. (2005) XML-OLAP: A multidimensional analysis framework for XML warehouses. In A. M. Tjoa & J. Trujillo (Eds.), Proceedings of the 7th International Conference in Data Warehousing and Knowledge Discovery (LNCS 3589, pp. 32-42).","DOI":"10.1007\/11546849_4"},{"key":"jdwm.2012010103-27","unstructured":"Pentaho. (2008). Mondrian project. Retrieved from http:\/\/mondrian.pentaho.com\/"},{"key":"jdwm.2012010103-28","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2009.12.002"},{"key":"jdwm.2012010103-29","unstructured":"Robie, J. (1999). XQL (XML Query Language). Retrieved from http:\/\/www.ibiblio.org\/xql\/xql-proposal.html"},{"key":"jdwm.2012010103-30","doi-asserted-by":"crossref","unstructured":"Silva, P. C., Aquino, I. J. S., & Times, V. C. (2008). A query language for navigation over links. In Proceedings of the 14th Brazilian Multimedia Systems and Web Symposium (pp. 9-12).","DOI":"10.1145\/1809980.1809984"},{"key":"jdwm.2012010103-31","unstructured":"Silva, P. C., Santos, M. M., Cruz, M. S. H., & Santos, A. A. (2010). XBRL taxonomy for indexes of financial analysis. In Proceedings of the 7th CONTECSI International Conference on Information Systems and Technology Management, S\u00e3o Paulo, Brazil."},{"key":"jdwm.2012010103-32","unstructured":"Silva, P. C., Santos, M. M., & Times, V. C. (2010). XLPATH: XML linking path language. In Proceedings of the IADIS WWW\/Internet International Conference, Timisoara, Romania."},{"key":"jdwm.2012010103-33","unstructured":"Silva, P. C., & Times, V. C. (2009a). XPath+: A tool for linked XML documents navigation. In Z. Bellahs\u00e8ne, E. Hunt, M. Rys, & R. Unland (Eds.), Proceedings of the Sixth International XML Database Symposium, Lyon, France (LNCS 5679, pp. 67-74)."},{"key":"jdwm.2012010103-34","doi-asserted-by":"crossref","unstructured":"Silva, P. C., & Times, V. C. (2009b). LMDQL: link-based and multidimensional query language. In Proceedings of the ACM Twelfth International Workshop on Data Warehousing and OLAP.","DOI":"10.1145\/1651291.1651307"},{"key":"jdwm.2012010103-35","unstructured":"Sourceforge. (2010). eXist Open Source Native XML database. Retrieved from http:\/\/exist.sourceforge.net\/"},{"key":"jdwm.2012010103-36","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2010.07.055"},{"key":"jdwm.2012010103-37","doi-asserted-by":"publisher","DOI":"10.1108\/17440080580000084"},{"key":"jdwm.2012010103-38","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2005.12.015"},{"key":"jdwm.2012010103-39","doi-asserted-by":"crossref","unstructured":"Taniar, D., Rusu, L. I., & Rahayu, J. W. (2004). On building XML data warehouses. In L. I. Rusu, W. Rahayu, & D. Taniar (Eds.), Proceedings of the 5th International Conference on Intelligent Data Engineering and Automated Learning (LNCS 3177, pp. 293-299).","DOI":"10.1007\/978-3-540-28651-6_43"},{"key":"jdwm.2012010103-40","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2005040102"},{"key":"jdwm.2012010103-41","doi-asserted-by":"publisher","DOI":"10.1007\/s10619-009-7034-y"},{"key":"jdwm.2012010103-42","unstructured":"Thompson, H. S., Beech, D., Maloney, M., & Mendelsohn, N. (Eds.). (2004). XML schema. Retrieved from http:\/\/www.w3.org\/TR\/xmlschema-1"},{"key":"jdwm.2012010103-43","doi-asserted-by":"publisher","DOI":"10.3923\/itj.2007.697.703"},{"key":"jdwm.2012010103-44","doi-asserted-by":"crossref","unstructured":"Wiwatwattana, N., Jagadish, H., Lakshmanan, L., & Srivastava, D. (2007). X^3: A cube operator for xml OLAP. In Proceedings of the 23rd International Conference on Data Engineering (pp. 916-925).","DOI":"10.1109\/ICDE.2007.367937"},{"key":"jdwm.2012010103-45","unstructured":"XBRL International. (2006). XBRL consortium. Retrieved from http:\/\/www.xbrl.org"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=61424","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,6,13]],"date-time":"2023-06-13T10:39:15Z","timestamp":1686652755000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2012010103"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2012,1,1]]},"references-count":46,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2012,1]]}},"URL":"https:\/\/doi.org\/10.4018\/jdwm.2012010103","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2012,1,1]]}}}