Title
SFL: a structured dataflow language based on SQL and FP
Abstract
SFL (pronounced as Sea-Flow) is an analytics system that supports a declarative language that extends SQL for specifying the dataflow of data-intensive analytics. The extended SQL language is motivated by providing a top-level representation of the converged platform for analytics and data management. Due to fast data access and reduced data transfer, such convergence has become the key to speed up and scale up data intensive BI applications. A SFL query is constructed from conventional queries in terms of Function Forms (FFs). While a conventional SQL query represents a dataflow tree, a SFL query represents a more general dataflow graph. We support SFL query execution by tightly integrating it with the evaluation of its component queries to minimize the overhead of data retrieval, copying, moving and buffering, which actually turns a query engine to a generalized dataflow engine. The experimental results based on a prototype built by extending the PostgreSQL engine are discussed.
Year
DOI
Venue
2010
10.1007/978-3-642-15364-8_25
DEXA
Keywords
Field
DocType
data intensive bi application,sfl query execution,structured dataflow language,query engine,data retrieval,fast data access,conventional sql query,component query,data management,conventional query,sfl query,functional form,data transfer,data access
Data mining,Programming language,Computer science,Data retrieval,Theoretical computer science,Dataflow,Declarative programming,Analytics,SQL,Query by Example,Data access,Data management,Database
Conference
ISBN
Citations 
PageRank 
3-642-15363-1
1
0.36
References 
Authors
4
2
Name
Order
Citations
PageRank
Qiming Chen12010233.16
Meichun Hsu23437778.34