ABSTRACT
Existing data stores of enterprises are full of connected data and users are increasingly finding value in performing graph querying, analytics and visualization on this data. This process involves a labor-intensive ETL pipeline, where users write scripts to extract graphs from data stored in legacy stores, often an RDBMS, and import these graphs into a graph-specific software. We demonstrate GraphWrangler, a system that allows users to connect to an RDBMS and within a few clicks extract graphs out of their tabular data, visualize and explore these graphs, and automatically generate scripts for their ETL pipelines. GraphWrangler adopts the predictive interaction framework and internally uses a data transformation language that is a limited subset of SQL. Our demonstration video can be found here: https://youtu.be/k92Qk6vuIsU
- M. Bostock, V. Ogievetsky, and J. Heer. D3: Data-driven Documents. TVCG, 17(12), 2011.Google Scholar
- J. Heer, J. M. Hellerstein, and S. Kandel. Predictive Interaction for Data Transformation. In CIDR, 2015.Google Scholar
- Imdb datasets. https://www.imdb.com/interfaces/.Google Scholar
- interact.js. http://interactjs.io/.Google Scholar
- S. Kandel, A. Paepcke, J. Hellerstein, and J. Heer. Wrangler: Interactive Visual Specification of Data Transformation Scripts. In CHI, 2011. Google ScholarDigital Library
- C. Kankanamge, S. Sahu, A. Mhedbhi, J. Chen, and S. Salihoglu. Graphflow: An Active Graph Database. In SIGMOD, 2017. Google ScholarDigital Library
- S. Sahu, A. Mhedhbi, S. Salihoglu, J. Lin, and M. T. Özsu. The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing: Extended Survey. https://cs.uwaterloo.ca/ ssalihog/papers/graph-survey-extended.pdf, 2019.Google Scholar
- P. Zhao, X. Li, D. Xin, and J. Han. Graph Cube: On Warehousing and OLAP Multidimensional Networks. In SIGMOD, 2011. Google ScholarDigital Library
Index Terms
- GraphWrangler: An Interactive Graph View on Relational Data
Recommendations
The transformation graph Gxyz when xyz=-++
The transformation graph G^-^+^+ of G is the graph with vertex set V(G)@?E(G) in which the vertex x and y are joined by an edge if one of the following conditions holds: (i) x,y@?V(G), and x and y are not adjacent in G, (ii) x,y@?E(G), and x and y are ...
RDB2RDF: completed transformation from relational database into RDF ontology
ICUIMC '14: Proceedings of the 8th International Conference on Ubiquitous Information Management and CommunicationOne of the most advantages of the Semantic Web is to augment the data with a well-defined meaning and linking between data by using the RDF ontology language. Today most of data are stored in relational databases. In order to reuse and infer this data ...
Wrangler: interactive visual specification of data transformation scripts
CHI '11: Proceedings of the SIGCHI Conference on Human Factors in Computing SystemsThough data analysis tools continue to improve, analysts still expend an inordinate amount of time and effort manipulating data and assessing data quality issues. Such "data wrangling" regularly involves reformatting data values or layout, correcting ...
Comments