ConceptMix - Self-Service Analytical Data Integration based on the Concept-Oriented Model

Alexandr Savinov

2014

Abstract

Data integration as well as other data wrangling tasks account for a great deal of the difficulties in data analysis and frequently constitute the most tedious part of the overall analysis process. We describe a new system, ConceptMix, which radically simplifies analytical data integration for a broad range of non-IT users who do not possess deep knowledge in mathematics or statistics. ConceptMix relies on a novel unified data model, called the concept-oriented model (COM), which provides formal background for its functionality.

References

  1. Abelló, A., Darmont, J., Etcheverry, L., Golfarelli, M., Mazón, J.-N., Naumann, F., Pedersen, T.B., Rizzi, S., Trujillo, J., Vassiliadis, P., Vossen, G., 2013. Fusion Cubes: Towards Self-Service Business Intelligence. IJDWM 9(2), 66-88.
  2. Atzeni, P., Jensen, C.S., Orsi, G., Ram, S., Tanca, L., Torlone, R., 2013. The relational model is dead, SQL is dead, and I don't feel so good myself. ACM SIGMOD Record, 42(2), 64-68.
  3. Chaudhuri, S., Dayal, U., Narasayya, V., 2011. An overview of Business Intelligence technology. Communications of the ACM, 54(8), 88-98.
  4. Gonzalez, H., Halevy, A., Jensen, C., Langen, A., Madhavan, J., Shapley, R., Shen, W., 2010. Google Fusion Tables: Data Management, Integration and Collaboration in the Cloud. Proc. ACM Symposium on Cloud Computing (SOCC 2010), 175-180.
  5. Hanrahan, P., 2012. Analytic database technologies for a new kind of user: the data enthusiast. Proc. SIGMOD 2012, 577-578.
  6. Idreos, S., Liarou, E., 2013. dbTouch: Analytics at your Fingertips. Proc. 6th Biennial Conference on Innovative Data Systems Research (CIDR'13).
  7. Kandel, S., Paepcke, A., Hellerstein, J., Heer, J., 2011. Wrangler: Interactive Visual Specification of Data Transformation Scripts. Proc. ACM Human Factors in Computing Systems (CHI), 3363-3372.
  8. Löser, A., Hueske, F., Markl, V., 2008. Situational business intelligence. Proc. Business Intelligence for the Real-Time Enterprise (BIRTE), 1-11.
  9. Morton, K., Bunker, R., Mackinlay, J., Morton, R., Stolte, C., 2012. Dynamic Workload-Driven Data Integration in Tableau. Proc. SIGMOD 2012, 807-816.
  10. Morton, K., Balazinska, M., Grossman, D., Mackinlay, J., 2014. Support the Data Enthusiast: Challenges for Next-Generation Data-Analysis Systems. Proc. VLDB Endowment 7(6), 453-456.
  11. Russo, M., Ferrari, A., Webb, C., 2012. Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model. Microsoft Press.
  12. Savinov, A., 2014a. Concept-oriented query language. In J. Wang (Ed.), Encyclopedia of Business Analytics and Optimization. IGI Global, 512-522.
  13. Savinov, A., 2014b. Concept-oriented model. In J. Wang (Ed.), Encyclopedia of Business Analytics and Optimization. IGI Global, 502-511.
  14. Savinov, A., 2012a. References and arrow notation instead of join operation in query languages. Computer Science Journal of Moldova (CSJM), 20(3), 313-333.
  15. Savinov, A., 2012b. Inference in hierarchical multidimensional space. In Proc. International Conference on Data Technologies and Applications (DATA 2012), 70-76.
  16. Savinov, A., 2012c. Concept-oriented model: Classes, hierarchies and references revisited. Journal of Emerging Trends in Computing and Information Sciences, 3(4), 456-470.
  17. Savinov, A., 2011a. Concept-oriented model: Extending objects with identity, hierarchies and semantics. Computer Science Journal of Moldova (CSJM), 19(3), 254-287.
  18. Savinov, A., 2011b. Concept-oriented query language for data modeling and analysis. In L. Yan & Z. Ma (Eds), Advanced database query systems: Techniques, applications and technologies. IGI Global, 85-101.
  19. Savinov, A., 2006. Query by constraint propagation in the concept-oriented data model. Computer Science Journal of Moldova (CSJM), 14(2), 219-238.
  20. Thiele, M., Lehner, W., 2012. Real-Time BI and Situational Analysis. In M.E. Zorrilla, J.-N. Mazón, Ó. Ferrández, I. Garrigós, F. Daniel, & J. Trujillo (Eds.), Business Intelligence Applications and the Web: Models, Systems and Technologies. IGI Global, 285-309.
  21. Viégas, F.B., Wattenberg, M., Ham, F. van, Kriss, J., McKeon, M., 2007. Many eyes: A site for visualization at internet scale. IEEE TVCG, 13(6), 1121-1128.
Download


Paper Citation


in Harvard Style

Savinov A. (2014). ConceptMix - Self-Service Analytical Data Integration based on the Concept-Oriented Model . In Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: DATA, ISBN 978-989-758-035-2, pages 78-84. DOI: 10.5220/0005103700780084


in Bibtex Style

@conference{data14,
author={Alexandr Savinov},
title={ConceptMix - Self-Service Analytical Data Integration based on the Concept-Oriented Model},
booktitle={Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: DATA,},
year={2014},
pages={78-84},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005103700780084},
isbn={978-989-758-035-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of 3rd International Conference on Data Management Technologies and Applications - Volume 1: DATA,
TI - ConceptMix - Self-Service Analytical Data Integration based on the Concept-Oriented Model
SN - 978-989-758-035-2
AU - Savinov A.
PY - 2014
SP - 78
EP - 84
DO - 10.5220/0005103700780084