Abstract
In business intelligence, reporting is perceived by users as the most important area. Here, we present a case study of data integration for reporting within the World Health Organization (WHO).
WHO produces Communicable Disease Epidemiological Profiles for emergency affected countries. Given the nature of emergencies, the production of these reports should be timely. In order to automate the production of the reports, we have introduced a method of integrating data from multiple sources by using the RDF (Resource Description Framework) format.
The model of the data is described using an RDF ontology, making validation of the data from multiple sources possible. However, since RDF is highly technical, we have designed a graphical tool for the end user. The tool can be used to configure the data sources of a given report. After this, data for the report is generated from the sources. Finally, templates are used to generate the reports.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
RDF Primer, W3C Recommendation. Tech. rep., W3C (February 10, 2004)
RDF Vocabulary Description Language 1.0: RDF Schema. Tech. rep., W3C (2004)
RDF/XML Syntax Specification. Tech. rep., W3C (2004)
Abiteboul, S., Buneman, P., Suciu, D.: Data on the Web – from Relations to Semistructured Data and XML. Morgan Kaufmann, New York (2000)
Abiteboul, S.: Querying Semi-Structured Data. In: Proceedings of the 6th International Conference on Database Theory, pp. 1–18. Springer, London (1997)
Axson, D.A.J.: Best Practices in Planning and Management Reporting. Wiley, New York (2003)
Bass, L.: A Graphical Interface for Report Specification. In: ACM 1982 Conference, New York (1982)
Bray, T.: RDF and Metadata. xml.com (1998)
Chawathe, S., et al.: The TSIMMIS Project: Integration of Heterogeneous Information Sources. In: Proc. of the 16th Meeting of the Information Processing Society of Japan (1994)
Codd, E., Codd, S., Salley, C.: Providing OLAP to User-Analysts: An IT Mandate. Tech. rep., Hyperion (1993)
Correndo, G., Salvadores, M., Millard, I., Glaser, H., Shadbolt, N.: SPARQL Query Rewriting for Implementing Data Integration over Linked Data. In: Proceedings of the 2010 EDBT/ICDT Workshops, EDBT 2010, pp. 4:1–4:11. ACM, New York (2010)
Hull, R.: Managing Semantic Heterogeneity in Databases: a Theoretical Prospective. In: Proc. ACM Symposium on Principles of Databases (1997)
Jepsen, B.: Microsoft SQL Server 2005 Reporting Services (2005), http://download.microsoft.com/a/a1a34973-9fb6-40c4-b8bb-786a141aa559/SQL_Server_2005_Reporting_Services.ppt
Malinowski, E., Zimanyi, E.: Advanced Data Warehouse Design: from Conventional to Spatial and Temporal Applications. Springer, London (2009)
Mohania, M., Bhide, M.: New Trends in Information Integration. In: The 2nd International Conference on Ubiquitous Information Management and Communication, ICUIMC 2008, pp. 74–81. ACM, New York (2008)
Mori, M., Tanaka, T., Hirokawa, S.: A Document Authoring System for Credible Enterprise Reporting with Data Analysis from Data Warehouse. In: The 4th International Conference on Advances in Semantic Processing, Florence, Italy (2010)
Motro, A.: Superviews: Virtual Integration of Multiple Databases. IEEE Trans. Softw. Eng. 13, 785–798 (1987)
Näppilä, T., Järvelin, K., Niemi, T.: A Tool for Data Cube Construction from Structurally Heterogeneous XML Documents. J. Am. Soc. Inf. Sci. Technol. 59(3), 435–449 (2008)
Niemi, T., Niinimaki, M.: Ontologies and Summarizability in OLAP. In: Proc. SAC 2010, Sierre, Switzerland (2010)
Niemi, T., Nummenmaa, J., Thanisch, P.: Normalising OLAP Cubes for Controlling Sparsity. Data and Knowledge Engineering 46(1), 317–343 (2003)
Niemi, T., Toivonen, S., Niinimäki, M., Nummenmaa, J.: Ontologies with Semantic Web/grid in Data Integration for OLAP. International Journal on Semantic Web and Information Systems, Special Issue on Semantic Web and Data Warehousing 3(4) (2007)
Niinimäki, M., Niemi, T.: An ETL process for OLAP using RDF/OWL ontologies. In: Spaccapietra, S., Zimányi, E., Song, I.-Y. (eds.) Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 97–119. Springer, Heidelberg (2009)
Reddy, M.P., Prasad, B.E., Reddy, P.G.: A Methodology for Integration of Heterogeneous Databases. IEEE Trans. on Knowl. and Data Eng. 6, 920–933 (1994)
Seaborne, A.: RDQL - A Query Language for RDF. Tech. rep., W3C Member Submission (2004), http://www.w3c.org/Submission/RDQL/
Thanisch, P., Niemi, T., Niinimaki, M., Nummenmaa, J.: Using the Entity-Attribute-Value Model for OLAP Cube Construction. In: Grabis, J., Kirikova, M. (eds.) BIR 2011. LNBIP, vol. 90, pp. 59–72. Springer, Heidelberg (2011)
Thanisch, P., Nummenmaa, J.: On Selecting a Suitable Set of Reporting Platforms. In: Proc. Business Informatics Research BIR 2006, Kaunas, Lithuania (2006)
The World Wide Web Consortium: XSL Transformations XSLT, Version 1.0, W3C Recommendation (November 16, 1999), http://www.w3.org/TR/xslt
Witkowski, A., Bellamkonda, S., Bozkaya, T., Naimat, A., Sheng, L., Subramanian, S., Waingold, A.: Query by Excel. In: 31st Intl. Conf. of Very Large Data Bases, Trondheim, Norway, pp. 1204–1215 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Niinimaki, M., Niemi, T., Martin, S., Nummenmaa, J., Thanisch, P. (2012). Timely Report Production from WWW Data Sources. In: Niedrite, L., Strazdina, R., Wangler, B. (eds) Workshops on Business Informatics Research. BIR 2011. Lecture Notes in Business Information Processing, vol 106. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-29231-6_15
Download citation
DOI: https://doi.org/10.1007/978-3-642-29231-6_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-29230-9
Online ISBN: 978-3-642-29231-6
eBook Packages: Computer ScienceComputer Science (R0)