{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T22:54:15Z","timestamp":1743029655713,"version":"3.40.3"},"publisher-location":"Cham","reference-count":38,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319629100"},{"type":"electronic","value":"9783319629117"}],"license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017]]},"DOI":"10.1007\/978-3-319-62911-7_4","type":"book-chapter","created":{"date-parts":[[2017,6,29]],"date-time":"2017-06-29T21:47:57Z","timestamp":1498772877000},"page":"65-78","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Approaching ETL Processes Specification Using a Pattern-Based Ontology"],"prefix":"10.1007","author":[{"given":"Bruno","family":"Oliveira","sequence":"first","affiliation":[]},{"given":"Orlando","family":"Belo","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2017,7,1]]},"reference":[{"key":"4_CR1","doi-asserted-by":"publisher","first-page":"199","DOI":"10.1006\/knac.1993.1008","volume":"5","author":"TR Gruber","year":"1993","unstructured":"Gruber, T.R.: A translation approach to portable ontology specifications. Knowl. Acquis. 5, 199\u2013220 (1993)","journal-title":"Knowl. Acquis."},{"key":"4_CR2","first-page":"395","volume":"206","author":"E Gamma","year":"1995","unstructured":"Gamma, E., Helm, R., Johnson, R.E., Vlissides, J.: Design patterns: elements of reusable object-oriented software. Design. 206, 395 (1995)","journal-title":"Design."},{"key":"4_CR3","volume-title":"A Pattern Language: Towns, Buildings, Construction","author":"C Alexander","year":"1977","unstructured":"Alexander, C., Ishikawa, S., Silverstein, M.: A Pattern Language: Towns, Buildings, Construction. Oxford University Press, Oxford (1977)"},{"key":"4_CR4","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/j.datak.2004.01.001","volume":"50","author":"M Weske","year":"2004","unstructured":"Weske, M., van der Aalst, W., Verbeek, H.: Advances in business process management. Data Knowl. Eng. 50, 1\u20138 (2004)","journal-title":"Data Knowl. Eng."},{"unstructured":"Oliveira, B., Belo, O.: BPMN Patterns for ETL conceptual modelling and validation. In: 20th International Symposium on Methodologies for Intelligent Systems (ISMIS 2012), Macau, 4\u20137 December 2012","key":"4_CR5"},{"key":"4_CR6","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"237","DOI":"10.1007\/978-3-642-41366-7_20","volume-title":"Model and Data Engineering","author":"B Oliveira","year":"2013","unstructured":"Oliveira, B., Santos, V., Belo, O.: Pattern-based ETL conceptual modelling. In: Cuzzocrea, A., Maabout, S. (eds.) MEDI 2013. LNCS, vol. 8216, pp. 237\u2013248. Springer, Heidelberg (2013). doi:\n                  10.1007\/978-3-642-41366-7_20"},{"doi-asserted-by":"crossref","unstructured":"Oliveira, B., Belo, O.: An ontology for describing ETL patterns behavior. In: Proceedings of 5th International Conference on Data Management Technologies and Applications (DATA 2016), Lisboa, Portugal, 24\u201326 July 2016","key":"4_CR7","DOI":"10.5220\/0005974001020109"},{"unstructured":"McGuinness, D.L., van Harmelen, F.: OWL Web Ontology Language Overview (2004)","key":"4_CR8"},{"key":"4_CR9","series-title":"Lecture Notes in Computer Science (Lecture Notes in Artificial Intelligence)","doi-asserted-by":"publisher","first-page":"597","DOI":"10.1007\/978-3-319-23485-4_60","volume-title":"Progress in Artificial Intelligence","author":"B Oliveira","year":"2015","unstructured":"Oliveira, B., Belo, O.: A domain-specific language for ETL patterns specification in data warehousing systems. In: Pereira, F., Machado, P., Costa, E., Cardoso, A. (eds.) EPIA 2015. LNCS (LNAI), vol. 9273, pp. 597\u2013602. Springer, Cham (2015). doi:\n                  10.1007\/978-3-319-23485-4_60"},{"key":"4_CR10","doi-asserted-by":"publisher","first-page":"333","DOI":"10.1017\/S089006049812406X","volume":"12","author":"DL McGuinness","year":"1998","unstructured":"McGuinness, D.L., Wright, J.R.: Conceptual modelling for configuration: a description logic-based approach. Artif. Intell. Eng. Des. Anal. Manuf. 12, 333\u2013344 (1998)","journal-title":"Artif. Intell. Eng. Des. Anal. Manuf."},{"key":"4_CR11","doi-asserted-by":"publisher","first-page":"108","DOI":"10.1016\/j.websem.2006.11.007","volume":"5","author":"J Dietrich","year":"2007","unstructured":"Dietrich, J., Elgar, C.: Towards a web of patterns. Web Semant. Sci. Serv. Agents World Wide Web 5, 108\u2013116 (2007)","journal-title":"Web Semant. Sci. Serv. Agents World Wide Web"},{"key":"4_CR12","first-page":"1","volume":"32","author":"N Noy","year":"2001","unstructured":"Noy, N., McGuinness, D.: Ontology development 101, A guide to creating your first ontology. Development. 32, 1\u201325 (2001)","journal-title":"Development."},{"key":"4_CR13","first-page":"157","volume":"2007","author":"G Antoniou","year":"2004","unstructured":"Antoniou, G., Van Harmelen, F.: OWL web ontology language. Handb. Ontol. Inf. Syst. 2007, 157\u2013160 (2004)","journal-title":"Handb. Ontol. Inf. Syst."},{"key":"4_CR14","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"520","DOI":"10.1007\/3-540-45017-3_35","volume-title":"Advanced Information Systems Engineering","author":"P Vassiliadis","year":"2003","unstructured":"Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M.: A framework for the design of ETL scenarios. In: Eder, J., Missikoff, M. (eds.) CAiSE 2003. LNCS, vol. 2681, pp. 520\u2013535. Springer, Heidelberg (2003). doi:\n                  10.1007\/3-540-45017-3_35"},{"doi-asserted-by":"crossref","unstructured":"Vassiliadis, P., Simitsis, A., Skiadopoulos, S., Conceptual modeling for ETL processes. In: Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP, DOLAP 2002, pp. 1\u201325 (2002)","key":"4_CR15","DOI":"10.1145\/583890.583893"},{"key":"4_CR16","first-page":"782","volume":"80","author":"P Vassiliadis","year":"2002","unstructured":"Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: On the logical modeling of ETL processes. Science 80, 782\u2013786 (2002)","journal-title":"Science"},{"key":"4_CR17","doi-asserted-by":"publisher","first-page":"22","DOI":"10.1016\/j.dss.2006.12.002","volume":"45","author":"A Simitsis","year":"2008","unstructured":"Simitsis, A., Vassiliadis, P.: A method for the mapping of conceptual designs to logical blueprints for ETL processes. Decis. Support Syst. 45, 22\u201340 (2008)","journal-title":"Decis. Support Syst."},{"unstructured":"Vassiliadis, P., Vagena, Z., Skiadopoulos, S., Karayannidis, N., Sellis, T.: ARKTOS: a tool for data cleaning and transformation in data warehouse environments. Bull. IEEE Comput. Soc. Tech. Comm. Data Eng. 1\u20137 (2000)","key":"4_CR18"},{"key":"4_CR19","doi-asserted-by":"publisher","first-page":"1","DOI":"10.4018\/jswis.2007100101","volume":"3","author":"D Skoutas","year":"2000","unstructured":"Skoutas, D., Simitsis, A.: Ontology-based conceptual design of ETL processes for both structured and semi-structured data. Int. J. Semant. Web Inf. Syst. 3, 1\u201324 (2000)","journal-title":"Int. J. Semant. Web Inf. Syst."},{"doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Zimanyi, E.: Defining ETL worfklows using BPMN and BPEL. In: Proceedings of the ACM Twelfth International Workshop on Data Warehousing and OLAP, DOLAP 2009, pp. 41\u201348 (2009)","key":"4_CR20","DOI":"10.1145\/1651291.1651299"},{"key":"4_CR21","first-page":"1","volume":"3","author":"SA White","year":"2005","unstructured":"White, S.A., Corp, I.B.M.: Using BPMN to model a BPEL process. Business 3, 1\u201318 (2005)","journal-title":"Business"},{"doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Zim\u00e0nyi, E., Maz\u00f3n, J.-N., Trujillo, J.: A model-driven framework for ETL process development. In: Proceedings of the ACM 14th International Workshop on Data Warehousing and OLAP, DOLAP, pp. 45\u201352 (2011)","key":"4_CR22","DOI":"10.1145\/2064676.2064685"},{"key":"4_CR23","first-page":"49","volume":"XII","author":"V K\u00f6ppen","year":"2011","unstructured":"K\u00f6ppen, V., Br\u00fcggemann, B., Berendt, B.: Designing data integration: the ETL pattern approach. Eur. J. Inform. Prof. XII, 49\u201355 (2011)","journal-title":"Eur. J. Inform. Prof."},{"key":"4_CR24","doi-asserted-by":"publisher","first-page":"725","DOI":"10.1016\/j.datak.2005.11.004","volume":"59","author":"S Luj\u00e1n-Mora","year":"2006","unstructured":"Luj\u00e1n-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59, 725\u2013769 (2006)","journal-title":"Data Knowl. Eng."},{"key":"4_CR25","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"44","DOI":"10.1007\/978-3-540-88875-8_21","volume-title":"On the Move to Meaningful Internet Systems: OTM 2008 Workshops","author":"L Mu\u00f1oz","year":"2008","unstructured":"Mu\u00f1oz, L., Maz\u00f3n, J.-N., Pardillo, J., Trujillo, J.: Modelling ETL processes of data warehouses with UML activity diagrams. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2008. LNCS, vol. 5333, pp. 44\u201353. Springer, Heidelberg (2008). doi:\n                  10.1007\/978-3-540-88875-8_21"},{"doi-asserted-by":"crossref","unstructured":"Mu\u00f1oz, L., Maz\u00f3n, J.-N., Trujillo, J.: Automatic generation of ETL processes from conceptual models. In: Proceedings of the ACM Twelfth International Workshop on Data Warehousing and OLAP, pp. 33\u201340. ACM, New York (2009)","key":"4_CR26","DOI":"10.1145\/1651291.1651298"},{"unstructured":"W3.org, Semantic Web - W3C. \n                  http:\/\/www.w3.org\/standards\/semanticweb\/","key":"4_CR27"},{"unstructured":"Motik, B., Patel-Schneider, P.F., Parsia, B., Bock, C., Fokoue, A., Haase, P., Hoekstra, R., Horrocks, I., Ruttenberg, A., Sattler, U., Smith, M.: OWL 2 Web Ontology Language - Structural Specification and Functional-Style Syntax, 2nd edn. Online, pp. 1\u2013133 (2012)","key":"4_CR28"},{"key":"4_CR29","first-page":"3","volume":"23","author":"E Rahm","year":"2000","unstructured":"Rahm, E., Do, H.: Data cleaning: Problems and current approaches. IEEE Data Eng. Bull. 23, 3\u201313 (2000)","journal-title":"IEEE Data Eng. Bull."},{"key":"4_CR30","volume-title":"The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling","author":"R Kimball","year":"2002","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, Hoboken (2002)"},{"unstructured":"Prot\u00e9g\u00e9, The Prot\u00e9g\u00e9 Ontology Editor (2011)","key":"4_CR31"},{"unstructured":"Horridge, M.: prot\u00e9g\u00e9-owl api. \n                  http:\/\/protege.stanford.edu\/plugins\/owl\/api\/","key":"4_CR32"},{"key":"4_CR33","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/978-3-642-32584-7_1","volume-title":"Data Warehousing and Knowledge Discovery","author":"Z Akkaoui","year":"2012","unstructured":"Akkaoui, Z., Maz\u00f3n, J.-N., Vaisman, A., Zim\u00e1nyi, E.: BPMN-based conceptual modeling of ETL processes. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 1\u201314. Springer, Heidelberg (2012). doi:\n                  10.1007\/978-3-642-32584-7_1"},{"unstructured":"Oliveira, B., Santos, V., Gomes, C., Marques, R., Belo, O.: Conceptual-physical bridging - from BPMN models to physical implementations on Kettle. In: CEUR Workshop Proceedings, pp. 55\u201359 (2015)","key":"4_CR34"},{"unstructured":"Oliveira, B., Belo, O., Cuzzocrea, A.: A pattern-oriented approach for supporting ETL conceptual modelling and its YAWL-based implementation. In: 3rd International Conference on Data Management Technologies and Applications, DATA 2014, pp. 408\u2013415 (2014)","key":"4_CR35"},{"unstructured":"Bouman, R., Van Dongen, J.: Pentaho\u00ae Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL\u00ae (2009)","key":"4_CR36"},{"unstructured":"Gradecki, J.D., Cole, J.: Mastering Apache Velocity - Java Open Source library (2003)","key":"4_CR37"},{"key":"4_CR38","volume-title":"Software Abstractions: Logic, Language, and Analysis","author":"D Jackson","year":"2012","unstructured":"Jackson, D.: Software Abstractions: Logic, Language, and Analysis. MIT Press, Cambridge (2012)"}],"container-title":["Communications in Computer and Information Science","Data Management Technologies and Applications"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-62911-7_4","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,20]],"date-time":"2019-05-20T23:22:05Z","timestamp":1558394525000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-62911-7_4"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"ISBN":["9783319629100","9783319629117"],"references-count":38,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-62911-7_4","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"type":"print","value":"1865-0929"},{"type":"electronic","value":"1865-0937"}],"subject":[],"published":{"date-parts":[[2017]]},"assertion":[{"value":"1 July 2017","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DATA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Conference on Data Management Technologies and Applications","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Colmar","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"France","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2016","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"24 July 2016","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"26 July 2016","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"5","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"data2016","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.dataconference.org\/?y=2016","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}