Towards a Semantic Extract-Transform-Load (ETL) framework for big data integration

Proceedings - 2014 IEEE International Congress on Big Data, BigData Congress 2014

Volumn , Issue , 2014, Pages 522-529

  Bansal, Srividya K ^a  

^a ARIZONA STATE UNIVERSITY   (United States)

Author keywords

Big data; Data integration; Ontology; Semantic technolgies

Indexed keywords

BIG DATA; DATA MINING; DECISION MAKING; LARGE DATASET; ONTOLOGY; QUERY LANGUAGES; QUERY PROCESSING; SEMANTIC WEB; SEMANTICS;

EXTRACT TRANSFORM LOADS; GRAPH DATA MODELS; RESOURCE DESCRIPTION FRAMEWORK; SEMANTIC DATA MODEL; SEMANTIC QUERY LANGUAGE; SEMANTIC TECHNOLOGIES; SOFTWARE TECHNIQUES; UNSTRUCTURED TEXTS;

DATA INTEGRATION;

EID: 84923917788     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/BigData.Congress.2014.82     Document Type: Conference Paper

References (33)

1. E. Kandogan, M. Roth, C. Kieliszewski, F. Ozcan, B. Schloss, and M.-T. Schmidt, " Data for All: A Systems Approach to Accelerate the Path from Data to Insight," in 2013 IEEE International Congress on Big Data (BigData Congress), 2013, pp. 427-428.
2. C. Bizer, P. Boncz, M. L. Brodie, and O. Erling, "The Meaningful Use of Big Data: Four Perspectives-Four Challenges, " SIGMOD Rec., vol. 40, no. 4, pp. 56-60, Jan. 2012.
3. A. Azzini,P. Ceravolo Consistent Process Mining over Big Data Triple Stores 2013 IEEE International Congress on Big Data (BigData Congress) 2013, 54-61.
4. C. Bizer, T. Heath, and T. Berners-Lee, "Linked datathe story so far, " International journal on semantic web and information systems, vol. 5, no. 3, pp. 1-22, 2009.
5. F. Lecue, S. Kotoulas, and P. Mac Aonghusa, " Capturing the Pulse of Cities: Opportunity and Research Challenges for Robust Stream Data Reasoning," in Workshops at the Twenty-Sixth AAAI Conference on Artificial Intelligence, 2012.
6. P. Hayes and B. McBride, "Resource description framework (RDF), " 2004. [Online]. Available: http://www.w3.org/TR/rdf-mt/. [Accessed: 28-Feb-2014].
7. "SPARQL Query Language for RDF. " [Online]. Available: http://www.w3.org/TR/rdf-sparql-query/. [Accessed: 28-Feb-2014].
8. P. Vassiliadis, A. Simitsis, and E. Baikousi, "A Taxonomy of ETL Activities, " in Pr oceedings of the ACM Twelfth International Workshop on Data Warehousing and OLAP, New York, NY, USA, 2009, pp. 25-32.
9. P. Vassiliadis, A. Simitsis, P. Georgantas, M. Terrovitis, and S. Skiadopoulos, " A generic and customizable framework for the design of ETL scenarios," Information Systems, vol. 30, no. 7, pp. 492-525, Nov. 2005.
10. S. Lujá n-Mora, P. Vassiliadis, and J. Trujillo, " Data mapping diagrams for data warehouse design with UML," in Conceptual Modeling-ER 2004, Springer, 2004, pp. 191-204.
11. J. Trujillo and S. Luján-Mora, "A UML based approach for modeling ETL processes in data warehouses, " in Conceptual Modeling-ER 2003, Springer, 2003, pp. 307-320.
12. A. Simitsis, K. Wilkinson, M. Castellanos, and U. Dayal, " QoX-driven ETL design: reducing the cost of ETL consulting engagements," in Proceedings of the 2009 ACM SIGMOD International Conference on Management of data, 2009, pp. 953-960.
13. A. Karagiannis, P.Vassiliadis, and A. Simitsis, " Macro-level Scheduling of ETL Workflows," Submitted for publication, 2009.
14. D. Skoutas and A. Simitsis, "Ontology-Based Conceptual Design of ETL Processes for Both Struc tured and Semi-Structured Data:," International Journal on Semantic Web and Information Systems, vol. 3, no. 4, pp. 1-24, 34 2007.
15. S. Bergamaschi, F. Guerra, M. Orsini, C. Sartori, and M. Vincini, " A semantic approach to ETL technologies," Data & Knowledge Engineering, vol. 70, no. 8, pp. 717-731, Aug. 2011.
16. S. K. Bista, S. Nepal, and C. Paris, "Data Abstraction and V isualisation in Next Step: Experiences from a Government Services Delivery Trial," in 2013 IEEE International Congress on Big Data (BigData Congress), 2013, pp. 263-270.
17. Y. Guo, X. Shang, J. Li , and Z. Li, " Revealing the Causes of Dynamic Change in Protein-Protein Interaction Network," in 2013 IEEE International Congress on Big Data (BigData Congress), 2013, pp. 189-194.
18. E. Olmezogu llari and I. Ari, "Online Association Rule Mining over Fast Data, " in 2013 IEEE International Congress on Big Data (BigData Congress), 2013, pp. 110-117.
19. M. U. Nisar, A. Fard, and J. A. Miller, "Techniques for Graph Analytics on Big Data, " in Big Data (BigData Congress), 2013 IEEE International Congress on, 2013, pp. 255-262.
20. Y.-W. Cheah, R. Canon, B. Plale, and L. Ramakrishnan, "Milieu: Lightweight and Configurable Big Data Provenance for Science, " in Big Data (BigData Congress), 2013 IEEE International Congress on, 2013, pp. 46-53.
21. H. T. Lin and V. Honavar, "Learning Classifiers from Chains of Multiple Interlinked RDF Data Stores, " in Big Data (BigData Congress), 2013 IEEE International Congress on, 2013, pp. 94-101.
22. " IBM InfoSphere Platform-big data, information integration, data warehousing, master data management, lifecycle management and data security." [Online]. Available: http://www-01.ibm.com/software/data/infosphere/. [Accessed: 28-Feb-2014].
23. "Warehouse Builder 11gR2: Home Page on OTN. " [Online]. Available: http://www.oracle.com/technetwork/developertools/warehouse/overview/introduction/index.html. [Accessed: 28-Feb-2014].
24. "Integration Services | Microsoft SQL Server 2012. " [Online]. Available: http://www.microsoft.com/enus/sqlserver/solutions-technologies/enterpriseinformation-management/integration-services.aspx. [Accessed: 28-Feb-2014].
25. Enter prise Data Integration-Informatica." [Online] Available http://www.informatica.com/us/products/dataintegration/enterprise/. [Accessed: 28-Feb-2014].
26. "Talend Open Studio | Talend. " [Online]. Available: http ://www.talend.com/products/talend-open-studio. [Accessed: 28-Feb-2014].
27. "Data Integration | Pentaho Business Analytics Platform. " [Online]. Available: http://www.pentaho.com/product/data-integration. [Accessed: 28-Feb-2014].
28. N. Shadbolt, W. Hall, and T. Berners-Lee, "The semantic web revisited, " Intelligent Systems, IEEE, vol. 21, no. 3, pp. 96-101, 2006.
29. G. Antoniou and F. Van Harmelen, A semantic web primer. The MIT Press, 2004.
30. "OWL-Semantic Web Standards. " [Online]. Available: http://www.w3.org/2001/sw/wiki/OWL. [Accessed: 23-Jan-2014].
31. "Protégé Ontology Editor." [Online]. Available: http://protege.stanford.edu/. [Accessed: 28-Feb-2014].
32. "Oxygen XML Editor. " [Online]. Available: http://www.oxygenxml.com/. [Accessed: 28-Feb-2014].
33. "Apache Jena-Home. " [Online]. Available: https://jena.apache.org/. [Accessed: 28-Feb-2014].