{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,12]],"date-time":"2025-10-12T02:31:42Z","timestamp":1760236302024,"version":"build-2065373602"},"reference-count":61,"publisher":"MDPI AG","issue":"11","license":[{"start":{"date-parts":[[2021,11,9]],"date-time":"2021-11-09T00:00:00Z","timestamp":1636416000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information"],"abstract":"<jats:p>Many organizations must produce many reports for various reasons. Although this activity could appear simple to carry out, this fact is not at all true: indeed, generating reports requires the collection of possibly large and heterogeneous data sets. Furthermore, different professional figures are involved in the process, possibly with different skills (database technicians, domain experts, employees): the lack of common knowledge and of a unifying framework significantly obstructs the effective and efficient definition and continuous generation of reports. This paper presents a novel framework named RADAR, which is the acronym for \u201cResilient Application for Dependable Aided Reporting\u201d: the framework has been devised to be a \u201dbridge\u201d between data and employees in charge of generating reports. Specifically, it builds a common knowledge base in which database administrators and domain experts describe their knowledge about the application domain and the gathered data; this knowledge can be browsed by employees to find out the relevant data to aggregate and insert into reports, while designing report layouts; the framework assists the overall process from data definition to report generation. The paper presents the application scenario and the vision by means of a running example, defines the data model and presents the architecture of the framework.<\/jats:p>","DOI":"10.3390\/info12110463","type":"journal-article","created":{"date-parts":[[2021,11,9]],"date-time":"2021-11-09T21:39:07Z","timestamp":1636493947000},"page":"463","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["RADAR: Resilient Application for Dependable Aided Reporting"],"prefix":"10.3390","volume":"12","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-9066-1229","authenticated-orcid":false,"given":"Antonia","family":"Azzini","sequence":"first","affiliation":[{"name":"Consortium for the Technology Transfer C2T, 20122 Milan, Italy"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1899-0180","authenticated-orcid":false,"given":"Nicola","family":"Cortesi","sequence":"additional","affiliation":[{"name":"Consortium for the Technology Transfer C2T, 20122 Milan, Italy"},{"name":"Department of Management Engineering, Information and Production Engineering, University of Bergamo, 24129 Bergamo, Italy"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9228-560X","authenticated-orcid":false,"given":"Giuseppe","family":"Psaila","sequence":"additional","affiliation":[{"name":"Department of Management Engineering, Information and Production Engineering, University of Bergamo, 24129 Bergamo, Italy"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2021,11,9]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1145\/2407740.2407741","article-title":"Business intelligence and analytics: Research directions","volume":"3","author":"Lim","year":"2013","journal-title":"Acm Trans. Manag. Inf. Syst."},{"key":"ref_2","doi-asserted-by":"crossref","unstructured":"Golfarelli, M., Rizzi, S., and Cella, I. (2004, January 12\u201313). Beyond data warehousing: What\u2019s next in business intelligence?. Proceedings of the 7th ACM International Workshop on Data Warehousing and OLAP, Washington, DC, USA.","DOI":"10.1145\/1031763.1031765"},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"79","DOI":"10.1145\/1047671.1047673","article-title":"A comparison of data warehousing methodologies","volume":"48","author":"Sen","year":"2005","journal-title":"Commun. ACM"},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Azzini, A., Cortesi, N., Topalovic, A., and Psaila, G. (2019, January 7\u20139). Radar, a framework for automated reporting. Proceedings of the 16th International Conference on Applied Computing 2019, Cagliari, Italy.","DOI":"10.33965\/ac2019_201912L007"},{"key":"ref_5","doi-asserted-by":"crossref","first-page":"314","DOI":"10.1147\/rd.24.0314","article-title":"A business intelligence system","volume":"2","author":"Luhn","year":"1958","journal-title":"IBM J. Res. Dev."},{"key":"ref_6","doi-asserted-by":"crossref","first-page":"29","DOI":"10.1109\/MITP.2003.1254966","article-title":"From unstructured data to actionable intelligence","volume":"5","author":"Rao","year":"2003","journal-title":"IT Prof."},{"key":"ref_7","first-page":"1","article-title":"Business intelligence","volume":"1","author":"Elena","year":"2011","journal-title":"J. Knowl. Manag. Econ. Inf. Technol."},{"key":"ref_8","first-page":"36","article-title":"Enabling technology for knowledge sharing","volume":"12","author":"Neches","year":"1991","journal-title":"AI Mag."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"199","DOI":"10.1006\/knac.1993.1008","article-title":"A translation approach to portable ontology specifications","volume":"5","author":"Gruber","year":"1993","journal-title":"Knowl. Acquis."},{"key":"ref_10","unstructured":"Swartout, B., Patil, R., Knight, K., and Russ, T. (1996, January 9\u201311). Toward distributed use of large-scale ontology. Proceedings of the Tenth Workshop on Knowledge Acquisition for Knowledge-Based Systems, Banff, AB, Canada."},{"key":"ref_11","unstructured":"\u015eim\u015fek, U., K\u00e4rle, E., Holzknecht, O., and Fensel, D. (2017, January 27\u201329). Domain specific semantic validation of schema. org annotations. Proceedings of the International Andrei Ershov Memorial Conference on Perspectives of System Informatics, Moscow, Russia."},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"359","DOI":"10.1016\/j.pmcj.2011.02.002","article-title":"A top-level ontology for smart environments","volume":"7","author":"Ye","year":"2011","journal-title":"Pervasive Mob. Comput."},{"key":"ref_13","first-page":"28","article-title":"The semantic web","volume":"284","author":"Hendler","year":"2001","journal-title":"Sci. Am."},{"key":"ref_14","doi-asserted-by":"crossref","unstructured":"Bontcheva, K., and Wilks, Y. (2004, January 23\u201325). Automatic Report Generation from Ontologies: The MIAKT Approach. Proceedings of the International Conference on Application of Natural Language to Information Systems, Salford, UK.","DOI":"10.1007\/978-3-540-27779-8_28"},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"1138","DOI":"10.1016\/j.datak.2010.07.007","article-title":"A framework for multidimensional design of data warehouses from ontologies","volume":"69","author":"Romero","year":"2010","journal-title":"Data Knowl. Eng."},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Nebot, V., Berlanga, R., P\u00e9rez, J.M., Aramburu, M.J., and Pedersen, T.B. (2009). Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses, Springer.","DOI":"10.1007\/978-3-642-03098-7_1"},{"key":"ref_17","unstructured":"Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Poggi, A., and Rosati, R. (2007, January 17\u201320). Ontology-based Database Access. Proceedings of the Fifteenth Italian Symposium on Advanced Database Systems SEBD, Torre Canne di Fasano, Italy."},{"key":"ref_18","doi-asserted-by":"crossref","unstructured":"Xiao, G., Calvanese, D., Kontchakov, R., Lembo, D., Poggi, A., Rosati, R., and Zakharyaschev, M. (2018). Ontology-Based Data Access: A survey, IJCAI Organization.","DOI":"10.24963\/ijcai.2018\/777"},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"201","DOI":"10.1162\/dint_a_00011","article-title":"Virtual Knowledge Graphs: An Overview of Systems and Use Cases","volume":"1","author":"Xiao","year":"2019","journal-title":"Data Intell."},{"key":"ref_20","doi-asserted-by":"crossref","unstructured":"Poggi, A., Lembo, D., Calvanese, D., Giacomo, G.D., Lenzerini, M., and Rosati, R. (2008). Linking Data to Ontologies, Springer.","DOI":"10.1007\/978-3-540-77688-8_5"},{"key":"ref_21","first-page":"7","article-title":"Linked data: Un nuovo alfabeto del web semantico","volume":"30","author":"Guerrini","year":"2012","journal-title":"Bibl. Oggi Mens. Inf. Aggiorn. Dibatt."},{"key":"ref_22","first-page":"41","article-title":"JSON-LD 1.0","volume":"16","author":"Sporny","year":"2014","journal-title":"W3C Recomm."},{"key":"ref_23","first-page":"127","article-title":"JSON-LD 1.0: A JSON-based serialization for linked data","volume":"16","author":"Sporny","year":"2014","journal-title":"W3C Recomm."},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Pan, J.Z. (2009). Resource Description Framework, Springer.","DOI":"10.1007\/978-3-540-92673-3_3"},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"575","DOI":"10.1002\/asi.24144","article-title":"Distributed Data and Ontologies: An Integrated Semantic Web Architecture Enabling More Efficient Data Management","volume":"70","author":"Browne","year":"2019","journal-title":"J. Assoc. Inf. Sci. Technol."},{"key":"ref_26","unstructured":"Petrova, G., Tuzovsky, A., and Aksenova, N. (2016). Application of the Financial Industry Business Ontology (FIBO) for development of a financial organization. Conference Series of Journal of Physics, Proceedings of the International Conference on Information Technologies in Business and Industry, Bali, Indonesia, 30\u201331 January 2016, IOP Publishing."},{"key":"ref_27","doi-asserted-by":"crossref","unstructured":"Bergvall-K\u00e5reborn, B., and Nielsen, P.A. (2014). A Mechanism-Based Explanation of the Institutionalization of Semantic Technologies in the Financial Industry. Creating Value for All Through IT, Springer.","DOI":"10.1007\/978-3-662-43459-8"},{"key":"ref_28","unstructured":"(2021, January 15). Financial Industry Business Ontology. Available online: http:\/\/www.fibo.org\/schema."},{"key":"ref_29","unstructured":"(2020, November 15). The Schema.org Ontology. Available online: http:\/\/schema.org\/."},{"key":"ref_30","doi-asserted-by":"crossref","first-page":"44","DOI":"10.1145\/2844544","article-title":"Schema.org: Evolution of structured data on the web","volume":"59","author":"Guha","year":"2016","journal-title":"Commun. ACM"},{"key":"ref_31","doi-asserted-by":"crossref","unstructured":"K\u00e4rle, E., Fensel, A., Toma, I., and Fensel, D. (2016). Why are there more hotels in tyrol than in austria? Analyzing schema. org usage in the hotel domain. Information and Communication Technologies in Tourism 2016, Springer.","DOI":"10.1007\/978-3-319-28231-2_8"},{"key":"ref_32","doi-asserted-by":"crossref","first-page":"85","DOI":"10.1016\/j.tree.2011.11.016","article-title":"Ecoinformatics: Supporting ecology as a data-intensive science","volume":"27","author":"Michener","year":"2012","journal-title":"Trends Ecol. Evol."},{"key":"ref_33","doi-asserted-by":"crossref","first-page":"279","DOI":"10.1016\/j.ecoinf.2007.05.004","article-title":"An ontology for describing and synthesizing ecological observation data","volume":"2","author":"Madin","year":"2007","journal-title":"Ecol. Inform."},{"key":"ref_34","doi-asserted-by":"crossref","first-page":"159","DOI":"10.1016\/j.tree.2007.11.007","article-title":"Advancing ecological research with ontologies","volume":"23","author":"Madin","year":"2008","journal-title":"Trends Ecol. Evol."},{"key":"ref_35","unstructured":"(2020, October 10). Science Environment for Ecological Knowledge. Available online: http:\/\/seek.ecoinformatics.org\/."},{"key":"ref_36","unstructured":"Foundry, O. (2020, October 10). Environment Ontology ENVO. Available online: http:\/\/www.obofoundry.org\/ontology\/envo.html."},{"key":"ref_37","doi-asserted-by":"crossref","first-page":"57","DOI":"10.1186\/s13326-016-0097-6","article-title":"The environment ontology in 2016: Bridging domains with increased scope, semantic density, and interoperation","volume":"7","author":"Buttigieg","year":"2016","journal-title":"J. Biomed. Semant."},{"key":"ref_38","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1016\/j.websem.2017.05.005","article-title":"Ontology based data access in Statoil","volume":"44","author":"Kharlamov","year":"2017","journal-title":"J. Web Semant."},{"key":"ref_39","first-page":"1","article-title":"Ontology-based data integration in multi-disciplinary engineering environments: A review","volume":"4","author":"Ekaputra","year":"2017","journal-title":"Open J. Inf. Syst."},{"key":"ref_40","doi-asserted-by":"crossref","unstructured":"Mate, S., K\u00f6pcke, F., Toddenroth, D., Martin, M., Prokosch, H.U., B\u00fcrkle, T., and Ganslandt, T. (2015). Ontology-based data integration between clinical and research systems. PLoS ONE, 10.","DOI":"10.1371\/journal.pone.0116656"},{"key":"ref_41","unstructured":"Nadareishvili, I., Mitra, R., McLarty, M., and Amundsen, M. (2016). Microservice Architecture: Aligning Principles, Practices, and Culture, O\u2019Reilly Media Inc."},{"key":"ref_42","unstructured":"Newman, S. (2015). Building Microservices, O\u2019Reilly Media Inc."},{"key":"ref_43","unstructured":"Bauer, C., and King, G. (2005). Hibernate in Action, Manning."},{"key":"ref_44","unstructured":"Date, C. (2003). Introduction To Database Systems, Addison-Wesley. [8th ed.]."},{"key":"ref_45","unstructured":"Elmasri, R., and Navathe, S.B. (2011). Database Systems, Pearson Education."},{"key":"ref_46","first-page":"8","article-title":"Relational Algebra Teaching Support Tool","volume":"2","year":"2017","journal-title":"J. Inf. Syst. Eng. Manag."},{"key":"ref_47","doi-asserted-by":"crossref","unstructured":"Zaniolo, C. (1994). A unified semantics for active and deductive databases. Rules in Database Systems, Springer.","DOI":"10.1007\/978-1-4471-3225-7_16"},{"key":"ref_48","unstructured":"(2021, January 15). OMG Available Specification, Meta Object Facility (MOF) 2.0 Core Specification, 2006. Available online: https:\/\/www.omg.org\/spec\/MOF\/2.0\/PDF."},{"key":"ref_49","doi-asserted-by":"crossref","unstructured":"Poernomo, I. (2006, January 23\u201327). The Meta-Object Facility typed. Proceedings of the 2006 ACM Symposium on Applied Computing, Dijon, France.","DOI":"10.1145\/1141277.1141710"},{"key":"ref_50","doi-asserted-by":"crossref","first-page":"15","DOI":"10.1002\/bult.105","article-title":"An introduction to the Resource Description Framework","volume":"25","author":"Miller","year":"1998","journal-title":"Bull. Am. Soc. Inf. Sci. Technol."},{"key":"ref_51","doi-asserted-by":"crossref","first-page":"6","DOI":"10.1145\/507533.507536","article-title":"Resource Description Framework: Metadata and its applications","volume":"3","author":"Candan","year":"2001","journal-title":"ACM Sigkdd Explor. Newsl."},{"key":"ref_52","unstructured":"Heflin, J. (2007). An Introduction to the OWL Web Ontology Language, National Science Foundation (NSF)."},{"key":"ref_53","first-page":"2004","article-title":"OWL web ontology language overview","volume":"10","author":"McGuinness","year":"2004","journal-title":"W3C Recomm."},{"key":"ref_54","doi-asserted-by":"crossref","unstructured":"Meier, A., and Kaufmann, M. (2019). SQL & NoSQL Databases, Springer.","DOI":"10.1007\/978-3-658-24549-8"},{"key":"ref_55","doi-asserted-by":"crossref","unstructured":"Ihrig, C.J. (2013). Javascript object notation. Pro Node.js for Developers, Springer.","DOI":"10.1007\/978-1-4302-5861-2"},{"key":"ref_56","doi-asserted-by":"crossref","first-page":"361","DOI":"10.1016\/0022-0000(86)90058-9","article-title":"Non first normal form relations: An algebra allowing data restructuring","volume":"33","author":"Abiteboul","year":"1986","journal-title":"J. Comput. Syst. Sci."},{"key":"ref_57","doi-asserted-by":"crossref","unstructured":"Papakonstantinou, Y. (July, January 26). Semistructured Models, Queries and Algebras in the Big Data Era: Tutorial Summary. Proceedings of the 2016 International Conference on Management of Data, San Francisco, CA, USA.","DOI":"10.1145\/2882903.2912573"},{"key":"ref_58","doi-asserted-by":"crossref","first-page":"257","DOI":"10.1080\/10095020.2017.1374703","article-title":"A cross-analysis framework for multi-source volunteered, crowdsourced, and authoritative geographic information: The case study of volunteered personal traces analysis against transport network data","volume":"21","author":"Bordogna","year":"2018","journal-title":"Geo-Spat. Inf. Sci."},{"key":"ref_59","doi-asserted-by":"crossref","unstructured":"Marrara, S., Pelucchi, M., and Psaila, G. (2019). Blind Queries Applied to JSON Document Stores. Information, 10.","DOI":"10.3390\/info10100291"},{"key":"ref_60","doi-asserted-by":"crossref","unstructured":"Psaila, G., and Fosci, P. (2021). J-CO: A Platform-Independent Framework for Managing Geo-Referenced JSON Data Sets. Electronics, 10.","DOI":"10.3390\/electronics10050621"},{"key":"ref_61","doi-asserted-by":"crossref","unstructured":"Fosci, P., and Psaila, G. (2021). Towards Flexible Retrieval, Integration and Analysis of JSON Data Sets through Fuzzy Sets: A Case Study. Information, 12.","DOI":"10.3390\/info12070258"}],"container-title":["Information"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2078-2489\/12\/11\/463\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T07:28:18Z","timestamp":1760167698000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2078-2489\/12\/11\/463"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,11,9]]},"references-count":61,"journal-issue":{"issue":"11","published-online":{"date-parts":[[2021,11]]}},"alternative-id":["info12110463"],"URL":"https:\/\/doi.org\/10.3390\/info12110463","relation":{},"ISSN":["2078-2489"],"issn-type":[{"type":"electronic","value":"2078-2489"}],"subject":[],"published":{"date-parts":[[2021,11,9]]}}}