we are developing the DSMS SCSQ (SuperComputer Stream Query processor) based on the main memory D... more we are developing the DSMS SCSQ (SuperComputer Stream Query processor) based on the main memory DBMS Amos II. Amos II is a functional DBMS where data and information are represented as typed functions. In SCSQ database queries over streams are expressed in the functional query language SCSQL, a language similar to the object oriented parts of SQL:99 but extended with parallel stream query facilities. In this paper we investigate what existing functionality in SCSQ and Amos II can be utilized to support CQL, a continuous query language developed by the Stanford STREAM project. SCSQL is extended with functionality required to support CQL. The extended functional stream query language is called FCQL. To implement FCQL, SCSQ is extended with new operators that adhere to the semantics of CQL. FCQL is a functional continuous query language with the same expressive power as CQL. Furthermore, we show how CQL queries can be translated to FCQL in a systematic way and by doing so give a template for an automatic CQL-to-FCQL translator. We also evaluate the completeness of FCQL by translating to FCQL the queries of the linear road DSMS benchmark as it was expressed in CQL by the Stanford STREAM project.
There are several query languages developed for data stream management systems (DSMS), CQL (Stanf... more There are several query languages developed for data stream management systems (DSMS), CQL (Stanford), StreamSQL (StreamBase), WaveScript (MIT), SCSQL (Uppsala University), etc. This thesis is the research phase of a two-phase project where the final goal is to provide CQL support to the Super Computer Stream Query processor (SCSQ); a DSMS developed by the Uppsala DataBase Laboratory. In this paper, the main properties of CQL, the extent to which they are implemented by the Stanford STREAM project and the expressibility of the Linear Road (LR) benchmark using CQL is investigated. An overview and comparison of SQL, CQL, StreamSQL and WaveScript is also given.
we are developing the DSMS SCSQ (SuperComputer Stream Query processor) based on the main memory D... more we are developing the DSMS SCSQ (SuperComputer Stream Query processor) based on the main memory DBMS Amos II. Amos II is a functional DBMS where data and information are represented as typed functions. In SCSQ database queries over streams are expressed in the functional query language SCSQL, a language similar to the object oriented parts of SQL:99 but extended with parallel stream query facilities. In this paper we investigate what existing functionality in SCSQ and Amos II can be utilized to support CQL, a continuous query language developed by the Stanford STREAM project. SCSQL is extended with functionality required to support CQL. The extended functional stream query language is called FCQL. To implement FCQL, SCSQ is extended with new operators that adhere to the semantics of CQL. FCQL is a functional continuous query language with the same expressive power as CQL. Furthermore, we show how CQL queries can be translated to FCQL in a systematic way and by doing so give a template for an automatic CQL-to-FCQL translator. We also evaluate the completeness of FCQL by translating to FCQL the queries of the linear road DSMS benchmark as it was expressed in CQL by the Stanford STREAM project.
There are several query languages developed for data stream management systems (DSMS), CQL (Stanf... more There are several query languages developed for data stream management systems (DSMS), CQL (Stanford), StreamSQL (StreamBase), WaveScript (MIT), SCSQL (Uppsala University), etc. This thesis is the research phase of a two-phase project where the final goal is to provide CQL support to the Super Computer Stream Query processor (SCSQ); a DSMS developed by the Uppsala DataBase Laboratory. In this paper, the main properties of CQL, the extent to which they are implemented by the Stanford STREAM project and the expressibility of the Linear Road (LR) benchmark using CQL is investigated. An overview and comparison of SQL, CQL, StreamSQL and WaveScript is also given.
Uploads
Papers by Robert Kajic