Home| Contact Us| New Journals| Browse Journals| Journal Prices| For Authors|

Print ISSN: 0976-3503
Online ISSN:
0976-2930


  About JET
  DLINE Portal Home
Home
Aims & Scope
Editorial Board
Current Issue
Next Issue
Previous Issue
Sample Issue
Upcoming Conferences
Self-archiving policy
Alert Services
Be a Reviewer
Publisher
Paper Submission
Subscription
Contact us
 
  How To Order
  Order Online
Price Information
Request for Complimentary
Print Copy
 
  For Authors
  Guidelines for Contributors
Online Submission
Call for Papers
Author Rights
 
 
RELATED JOURNALS
Journal of Digital Information Management (JDIM)
International Journal of Computational Linguistics Research (IJCL)
International Journal of Web Application (IJWA)

 

 
Journal of E-Technology

Visualization-based Machine Learning Model for Relational Databases
Dihia Lanasri, Carlos Ordonez, Ladjel Bellatreche, Selma Khouri
ESI, Algiers, Algeria., University of Houston, USA., LIAS/ISAE-ENSMA, Poitiers, France
Abstract: Transforming several relational tables into a data set to be used as input to a Machine Learning (ML) model is a complex task since the data scientist has to derive many intermediate tables, queries and views in a disorganized manner. This process creates many SQL queries to facilitate the exploration task of the data scientist. Because the provenance of the intermediate results is not reflected, similar SQL queries tend to be written multiple times causing repeated manual work. In this paper, we propose a tool “ER4ML” assisting data scientists in modeling and visualizing the transformations applied to the relational database before obtaining a dataset feeding the ML models. ER4ML is a diagram flow based on a conceptual view of the database schema and transformations based on powerful extensions of ER diagram in UML notations. In addition, ER4ML tracks data provenance, improving query and data set reuse.
Keywords: ER Diagram, Provenance, Data Transformation, Query, Machine Learning Visualization-based Machine Learning Model for Relational Databases
DOI:https://doi.org/10.6025/jet/2020/11/2/49-53
Full_Text   PDF 155 KB   Download:   14  times
References:

[1] Boyd, M., McBrien, P. (2005). Comparing and transforming between data models via an intermediate hypergraph data model. In: JoDS IV, p 69–109. Springer.

[2] El Akkaoui, Z., Maz´on, J. N., Vaisman, A., Zim´anyi, E. (2012). Bpmn-based conceptual modeling of etl processes. In: DaWaK. p 1–14. Springer.

[3] Oliveira, B., Belo, O. (2013). Using reo on etl conceptual modelling: a first approach. In: DOLAP. p 55–60. ACM.

[4] Ordonez, C. (2011). Data set preprocessing and transformation in a database system. Intelligent Data Analysis (IDA) 15(4).

[5] Ordonez, C., Bellatreche, L. (2019). Enhancing ER diagrams to view data transformations computed with queries. In: DOLAP.

[6] Poulovassilis, A., McBrien, P. (1998). A general formal framework for schema transformation. DKE 28(1), 47–71.

[7] Shi, Z., Moorthy, S., Zimmermann, A. (2013). Predicting ncaab match outcomes using ml techniques-some results and lessons learned. In: ECML/PKDD.

[8] Zubcoff, J., Trujillo, J. (2006). Conceptual modeling for classification mining in data warehouses. In: DaWaK. p 566–575. Springer.


Home | Aim & Scope | Editorial Board | Author Guidelines | Publisher | Subscription | Previous Issue | Contact Us |Upcoming Conferences|Sample Issues|Library Recommendation Form|

 

Copyright 2011 dline.info