XBRL AND THE MULTIDIMENSIONAL DATA MODEL

Ignacio Santos, Elena Castro

2011

Abstract

Over the past ten years, there has been a significant increasing of the development of XML and Data Warehouse (DW) applications, and, in turn, more and more applications need to interact, and with different technologies. In parallel, the economic data in the last ten years have also evolved, increasingly companies and financial institutions need more information, in addition, this information must be reliable and on time. Nowadays, it is taking a significant rise for XBRL standard, based on XML. This language is mainly used in accounting reports and this consists of a set of taxonomies, which define different accounting regulations of a specific report. XBRL is becoming a global de facto standard. XBRL reports are created from various sources and are validated at source, so that, this is syntactically correct. XBRL represents business information, and it is multidimensional, and therefore the logical destination is a DW. This paper aims to analyze the data model of XBRL and its semantics, and how to map this data model to the Multidimensional Data Model (Conceptual Model) and in turn to the Logical Model, either ROLAP (Relational OLAP), MOLAP (Multidimensional OLAP), or HOLAP (Hybrid OLAP), so they can be analyzed by business users.

References

  1. Ardenne, R., December 1st, 2005. Mapping XBRL Data into and out of conventional Data Stores. 14th XBRL International Conference. http://14thconference.xbrl. org/.
  2. Ardenne, R., December 1st, 2005. Mapping XBRL Data into and out of conventional Data Stores. 14th XBRL International Conference. http://14thconference.xbrl. org/.
  3. Basel II. June, 2004. http://www.bis.orgpubl/bcbs107.htm, http://www.bis.org/publ/bcbsca.htm.
  4. Basel II. June, 2004. http://www.bis.orgpubl/bcbs107.htm, http://www.bis.org/publ/bcbsca.htm.
  5. Basel III. September, 12th, 2010.http://www.bis.org/ press/p100912.htm, http://www.basel-iii-accord.com/, http://www.oecd.org/dataoecd/42/58/45314422.pdf.
  6. Basel III. September, 12th, 2010.http://www.bis.org/ press/p100912.htm, http://www.basel-iii-accord.com/, http://www.oecd.org/dataoecd/42/58/45314422.pdf.
  7. BdE. November 28th, 2008. “Descripción Nacional de la taxonomía FINREP, Diseño Técnico. Banco de España”. File: “es-be-finrep_tecnico_pdf”. http://www.bde.es/fr/documentacion/taxonomias/esbe-finrep/6-2008/2008-11-26/es-be-finrep_tecnico.pdf.
  8. BdE. November 28th, 2008. “Descripción Nacional de la taxonomía FINREP, Diseño Técnico. Banco de España”. File: “es-be-finrep_tecnico_pdf”. http://www.bde.es/fr/documentacion/taxonomias/esbe-finrep/6-2008/2008-11-26/es-be-finrep_tecnico.pdf.
  9. BdE-FINREP, “Taxonomía Estados financieros para Entidades de Crédito”. November, 26th, 2008.” http://www.bde.es/es/fr/documentacion/es/es-befinrep/6-2008/2008-11-26/index.html”.
  10. BdE-FINREP, “Taxonomía Estados financieros para Entidades de Crédito”. November, 26th, 2008.” http://www.bde.es/es/fr/documentacion/es/es-befinrep/6-2008/2008-11-26/index.html”.
  11. Callaghan J. H., Nehmer R. and Sugumaran, V. August 4th, 2006. Modeling XBRL-based Applications with UML: Developing Balanced-Scorecard Management Appraisal Systems. AIS Electronic Library (AISel), Proceedings of 12th Americas Conference on Information Systems (AMCIS) 2006, Acapulco, México, August 4-6, 2006.
  12. Callaghan J. H., Nehmer R. and Sugumaran, V. August 4th, 2006. Modeling XBRL-based Applications with UML: Developing Balanced-Scorecard Management Appraisal Systems. AIS Electronic Library (AISel), Proceedings of 12th Americas Conference on Information Systems (AMCIS) 2006, Acapulco, México, August 4-6, 2006.
  13. Callaghan, J. H., Savage, A. and Sugumaran, V. September 11th, 2002. Augmenting XBRL Using UML: Improving Financial Analysis. The review of business information Systems, 2002, Quarter 4, volume 6, number 4. Internal title Modeling XBRL Using UML: Improving Semantics for Financial Analysis.
  14. Callaghan, J. H., Savage, A. and Sugumaran, V. September 11th, 2002. Augmenting XBRL Using UML: Improving Financial Analysis. The review of business information Systems, 2002, Quarter 4, volume 6, number 4. Internal title Modeling XBRL Using UML: Improving Semantics for Financial Analysis.
  15. Castro Galán, E. June 14st, 2004. Una aproximación a la reutilización de estructuras documentales definidas con XML, en el marco de la web semántica. Thesis PHD. Carlos III University of Madrid.
  16. Castro Galán, E. June 14st, 2004. Una aproximación a la reutilización de estructuras documentales definidas con XML, en el marco de la web semántica. Thesis PHD. Carlos III University of Madrid.
  17. Felden, C. November 18th, 2007. Multidimensional XBRL. DUV Deutscher Universitäts-Verlag. Book title: New Dimensions of Business Reporting and XBRL, pages 191-209.
  18. Felden, C. November 18th, 2007. Multidimensional XBRL. DUV Deutscher Universitäts-Verlag. Book title: New Dimensions of Business Reporting and XBRL, pages 191-209.
  19. Golfarelli, M., Rizzi, S. and Urdoljak, B. September 3rd, 2001. Data warehouse design from XML sources. Proceedings of the 4th ACM International workshop on Data, Warehousing and OLAP”, pages 40 to 47.
  20. Golfarelli, M., Rizzi, S. and Urdoljak, B. September 3rd, 2001. Data warehouse design from XML sources. Proceedings of the 4th ACM International workshop on Data, Warehousing and OLAP”, pages 40 to 47.
  21. Hernández-Ros, I. February 4th, 2009. XBRL Infoset 0.3. XBRL International Inc. Public Working Draft 04 February 2009.
  22. Hernández-Ros, I. February 4th, 2009. XBRL Infoset 0.3. XBRL International Inc. Public Working Draft 04 February 2009.
  23. Hernández-Ros, I. and Wallis, H. April 26th, 2010. XBRL Dimensions 1.0. XBRL International, http://www.xbrl. org/Specification/XDT-CR3-2006-04-26.rtf.
  24. Hernández-Ros, I. and Wallis, H. April 26th, 2010. XBRL Dimensions 1.0. XBRL International, http://www.xbrl. org/Specification/XDT-CR3-2006-04-26.rtf.
  25. Kurtev, I. and Berg, K. September 16th, 2003. Model Driven Architecture based XML Processing. Proceedings of ACM Symposium on Document Engineering. September 16th, 2003.
  26. Kurtev, I. and Berg, K. September 16th, 2003. Model Driven Architecture based XML Processing. Proceedings of ACM Symposium on Document Engineering. September 16th, 2003.
  27. Lucas-Torres Torrillas, F., Navarro Gil, S., García Pérez, G. and Román Birriales, E. March 18th, 2009. “Modelos Avanzados de Bases de Datos: Almacenes de Datos y Bases de Datos XML”. Universidad de Castilla La Mancha, Escuela Superior de Informática, Ciudad Real.
  28. Lucas-Torres Torrillas, F., Navarro Gil, S., García Pérez, G. and Román Birriales, E. March 18th, 2009. “Modelos Avanzados de Bases de Datos: Almacenes de Datos y Bases de Datos XML”. Universidad de Castilla La Mancha, Escuela Superior de Informática, Ciudad Real.
  29. Martín Quetglás, G. May, 2006. Curso de XBRL. Pearson Educación. ISBN 9788483223116.
  30. Martín Quetglás, G. May, 2006. Curso de XBRL. Pearson Educación. ISBN 9788483223116.
  31. Mazón, J., Pardillo, J. and Trujillo, J. September 1st, 2007. Applying Transformations to Model Driven Data Warehouse. Lecture Notes in Computer Sciencie, Departament of Software and Computing Systems, University of Alicante, Spain.
  32. Mazón, J., Pardillo, J. and Trujillo, J. September 1st, 2007. Applying Transformations to Model Driven Data Warehouse. Lecture Notes in Computer Sciencie, Departament of Software and Computing Systems, University of Alicante, Spain.
  33. Mazón, J., Trujillo, J., Serrano, M. and Piattini, M. November 1st, 2005. Applying MDA to the Development of Data Warehouses. DOLAP'50; Proceeding of the 8th ACM International workshop on Data Warehousing and OLAP.
  34. Mazón, J., Trujillo, J., Serrano, M. and Piattini, M. November 1st, 2005. Applying MDA to the Development of Data Warehouses. DOLAP'50; Proceeding of the 8th ACM International workshop on Data Warehousing and OLAP.
  35. Ogbuje, U. May, 2002. XML, The Model Driven Architecture and RDF. In XML Europe 2002. May 20st-23rd, 2002, Barcelona, Spain.
  36. Ogbuje, U. May, 2002. XML, The Model Driven Architecture and RDF. In XML Europe 2002. May 20st-23rd, 2002, Barcelona, Spain.
  37. Pakorný, J. February 11th, 2002. XML Data warehouse: Modelling and Querying. Proceedings of the Baltic Conference, Baltic DB&IS 2002, volume 1, pages: 267-280”. Institute of Cybernetics at Tallin Technical University.
  38. Pakorný, J. February 11th, 2002. XML Data warehouse: Modelling and Querying. Proceedings of the Baltic Conference, Baltic DB&IS 2002, volume 1, pages: 267-280”. Institute of Cybernetics at Tallin Technical University.
  39. Pardillo, J. and Trujillo, J. October 13th, 2008. Integrated Model-Driven Development of Goal-Oriented Data Warehouse and Data Marts. Lucentia Research Group, Department of Software and Computing Systems, University of Alicante. In Lecture Notes in Computer Science.
  40. Pardillo, J. and Trujillo, J. October 13th, 2008. Integrated Model-Driven Development of Goal-Oriented Data Warehouse and Data Marts. Lucentia Research Group, Department of Software and Computing Systems, University of Alicante. In Lecture Notes in Computer Science.
  41. Piechocki, M., Felden, C., and Gräning, A. March 25th, 2007. Multidimensional XBRL Reporting. Proceedings of the Fifteenth European Conference on Information Systems.
  42. Piechocki, M., Felden, C., and Gräning, A. March 25th, 2007. Multidimensional XBRL Reporting. Proceedings of the Fifteenth European Conference on Information Systems.
  43. Schmehl, K. and Ochocki, B. November 19th, 2009. Data Model and Matrix Schemas. http://www.eurofiling. info. XI European Banking Supervisor XBRL Workshop, 16th November 2009, Vienna.
  44. Schmehl, K. and Ochocki, B. November 19th, 2009. Data Model and Matrix Schemas. http://www.eurofiling. info. XI European Banking Supervisor XBRL Workshop, 16th November 2009, Vienna.
  45. Snijders, P.. February 11th, 2005. XBRL and Complex Data Mapping. Madrid, Conference for Software Developers.
  46. Snijders, P.. February 11th, 2005. XBRL and Complex Data Mapping. Madrid, Conference for Software Developers.
  47. XBRL International, December, 14th, 2001. Extensible Business Reporting Language (XBRL) 2.0 Specification. http://www.xbrl.org/tr/2001/xbrl-2001- 12-14.doc.
  48. XBRL International, December, 14th, 2001. Extensible Business Reporting Language (XBRL) 2.0 Specification. http://www.xbrl.org/tr/2001/xbrl-2001- 12-14.doc.
Download


Paper Citation


in Harvard Style

Santos I. and Castro E. (2011). XBRL AND THE MULTIDIMENSIONAL DATA MODEL . In Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8425-51-5, pages 161-164. DOI: 10.5220/0003399001610164


in Harvard Style

Santos I. and Castro E. (2011). XBRL AND THE MULTIDIMENSIONAL DATA MODEL . In Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST, ISBN 978-989-8425-51-5, pages 161-164. DOI: 10.5220/0003399001610164


in Bibtex Style

@conference{webist11,
author={Ignacio Santos and Elena Castro},
title={XBRL AND THE MULTIDIMENSIONAL DATA MODEL},
booktitle={Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2011},
pages={161-164},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003399001610164},
isbn={978-989-8425-51-5},
}


in Bibtex Style

@conference{webist11,
author={Ignacio Santos and Elena Castro},
title={XBRL AND THE MULTIDIMENSIONAL DATA MODEL},
booktitle={Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,},
year={2011},
pages={161-164},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003399001610164},
isbn={978-989-8425-51-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - XBRL AND THE MULTIDIMENSIONAL DATA MODEL
SN - 978-989-8425-51-5
AU - Santos I.
AU - Castro E.
PY - 2011
SP - 161
EP - 164
DO - 10.5220/0003399001610164


in EndNote Style

TY - CONF
JO - Proceedings of the 7th International Conference on Web Information Systems and Technologies - Volume 1: WEBIST,
TI - XBRL AND THE MULTIDIMENSIONAL DATA MODEL
SN - 978-989-8425-51-5
AU - Santos I.
AU - Castro E.
PY - 2011
SP - 161
EP - 164
DO - 10.5220/0003399001610164