uu.seUppsala University Publications
Change search
Link to record
Permanent link

Direct link
BETA
Risch, Tore
Alternative names
Publications (10 of 146) Show all publications
Xu, C., Källström, E., Risch, T., Lindström, J., Håkansson, L. & Larsson, J. (2017). Scalable validation of industrial equipment using a functional DSMS. Journal of Intelligent Information Systems, 48(3), 553-577
Open this publication in new window or tab >>Scalable validation of industrial equipment using a functional DSMS
Show others...
2017 (English)In: Journal of Intelligent Information Systems, ISSN 0925-9902, E-ISSN 1573-7675, Vol. 48, no 3, p. 553-577Article in journal (Refereed) Published
Abstract [en]

A stream validation system called SVALI is developed in order to continuously validate correct behavior of industrial equipment. A functional data model allows the user to define meta-data, analyses, and queries about the monitored equipment in terms of types and functions. Two different approaches to validate that sensor readings in a data stream indicate correct equipment behavior are supported: with the model-and-validate approach anomalies are detected based on a physical model, while with learn-and-validate anomalies are detected by comparing streaming data with a model of normal behavior learnt during a training period. Both models are expressed on a high level using the functional data model and query language. The experiments show that parallel stream processing enables SVALI to scale very well with respect to system throughput and response time. The paper is based on a real world application for wheel loader slippage detection at Volvo Construction Equipment implemented in SVALI.

Keyword
Data stream management, Distributed stream systems, Data stream validation, Parallelization, Anomaly detection
National Category
Computer Sciences
Research subject
Computer Science with specialization in Database Technology
Identifiers
urn:nbn:se:uu:diva-292767 (URN)10.1007/s10844-016-0427-2 (DOI)000401468300004 ()
Funder
EU, FP7, Seventh Framework ProgrammeSwedish Foundation for Strategic Research , RIT08-0041
Available from: 2016-08-18 Created: 2016-05-09 Last updated: 2018-01-10Bibliographically approved
Melander, L., Orsborn, K., Risch, T. & Wedlund, D. (2017). VisDM-A Data Stream Visualization Platform. In: Candan, S Chen, L Pedersen, TB Chang, L Hua, W (Ed.), Database Systems For Advanced Applications (DASFAA 2017), Proceedings Pt II: . Paper presented at 22nd International Conference on Database Systems for Advanced Applications (DASFAA), MAR 27-30, 2017, Suzhou, PEOPLES R CHINA (pp. 677-680). SPRINGER INTERNATIONAL PUBLISHING AG
Open this publication in new window or tab >>VisDM-A Data Stream Visualization Platform
2017 (English)In: Database Systems For Advanced Applications (DASFAA 2017), Proceedings Pt II / [ed] Candan, S Chen, L Pedersen, TB Chang, L Hua, W, SPRINGER INTERNATIONAL PUBLISHING AG , 2017, p. 677-680Conference paper, Published paper (Refereed)
Abstract [en]

Visual Data stream Monitor (VisDM) is a new approach to integrate a visual programming language with a data stream management system (DSMS) to support the construction, configuration, and visualization of data stream applications through a set of building blocks, Visual Data Flow Components (VDFCs). This functionality is provided by extending the LabVIEW visual programming platform to support easy declarative specification of continuous visualizations of continuous query results. With actor-based data flows, visualization of data stream output becomes more accessible.

Place, publisher, year, edition, pages
SPRINGER INTERNATIONAL PUBLISHING AG, 2017
Series
Lecture Notes in Computer Science, ISSN 0302-9743 ; 10178
Keyword
Data stream management, Data stream visualization, Visual data flow programming
National Category
Computer Sciences
Identifiers
urn:nbn:se:uu:diva-346844 (URN)10.1007/978-3-319-55699-4_45 (DOI)000412832600045 ()978-3-319-55698-7 (ISBN)978-3-319-55699-4 (ISBN)
Conference
22nd International Conference on Database Systems for Advanced Applications (DASFAA), MAR 27-30, 2017, Suzhou, PEOPLES R CHINA
Available from: 2018-03-27 Created: 2018-03-27 Last updated: 2018-03-27Bibliographically approved
Stefanova, S. & Risch, T. (2016). Scalable long-term preservation of relational data through SPARQL queries. Semantic Web, 7(2), 117-137
Open this publication in new window or tab >>Scalable long-term preservation of relational data through SPARQL queries
2016 (English)In: Semantic Web, ISSN 1570-0844, E-ISSN 2210-4968, Vol. 7, no 2, p. 117-137Article in journal (Refereed) Published
National Category
Computer Sciences
Identifiers
urn:nbn:se:uu:diva-199570 (URN)10.3233/SW-150173 (DOI)000373208100002 ()
Projects
eSSENCE
Available from: 2016-02-12 Created: 2013-05-07 Last updated: 2018-01-11Bibliographically approved
Mahmood, K., Truong, T. & Risch, T. (2015). NoSQL approach to large scale analysis of persisted streams. In: Data Science: . Paper presented at BICOD 2015, July 6–8, Edinburgh, UK (pp. 152-156). Springer
Open this publication in new window or tab >>NoSQL approach to large scale analysis of persisted streams
2015 (English)In: Data Science, Springer, 2015, p. 152-156Conference paper, Published paper (Refereed)
Place, publisher, year, edition, pages
Springer, 2015
Series
Lecture Notes in Computer Science, ISSN 0302-9743 ; 9147
National Category
Computer Sciences
Identifiers
urn:nbn:se:uu:diva-274783 (URN)10.1007/978-3-319-20424-6_15 (DOI)000364104600015 ()978-3-319-20423-9 (ISBN)
Conference
BICOD 2015, July 6–8, Edinburgh, UK
Available from: 2015-06-11 Created: 2016-01-26 Last updated: 2018-01-10Bibliographically approved
Zhu, M., Mahmood, K. & Risch, T. (2015). Scalable queries over log database collections. In: Data Science: . Paper presented at BICOD 2015, July 6–8, Edinburgh, UK (pp. 173-185). Springer
Open this publication in new window or tab >>Scalable queries over log database collections
2015 (English)In: Data Science, Springer, 2015, p. 173-185Conference paper, Published paper (Refereed)
Place, publisher, year, edition, pages
Springer, 2015
Series
Lecture Notes in Computer Science, ISSN 0302-9743 ; 9147
National Category
Computer Sciences
Identifiers
urn:nbn:se:uu:diva-274784 (URN)10.1007/978-3-319-20424-6_17 (DOI)000364104600017 ()978-3-319-20423-9 (ISBN)
Conference
BICOD 2015, July 6–8, Edinburgh, UK
Available from: 2015-06-11 Created: 2016-01-26 Last updated: 2018-01-10Bibliographically approved
Truong, T. & Risch, T. (2015). Transparent inclusion, utilization, and validation of main memory domain indexes. In: Proc. 27th International Conference on Scientific and Statistical Database Management: . Paper presented at SSDBM 2015, June 29–July 1, San Diego, CA. New York: ACM Press
Open this publication in new window or tab >>Transparent inclusion, utilization, and validation of main memory domain indexes
2015 (English)In: Proc. 27th International Conference on Scientific and Statistical Database Management, New York: ACM Press, 2015Conference paper, Published paper (Refereed)
Abstract [en]

Main-memory database systems (MMDBs) are viable solutions for many scientific applications. Scientific and engineering data often require special indexing methods, and there is a large number of domain specific main memory indexing implementations developed. However, adding an index structure into a database system can be challenging. Mexima (Main memory External Index Manager) provides an MMDB where new main-memory index structures can be plugged-in without modifying the index implementations. This has allowed to plug into Mexima complex and highly optimized index structures implemented in C/C++ without code changes. To utilize new user defined indexes in queries transparently, Mexima automatically transforms query fragments into index operations based on index properly tables containing index meta-data. For scalable processing of complex numerical query expressions, Mexima includes an algebraic query transformation mechanism that reasons on numerical expressions to expose potential utilization of indexes. The index property tables furthermore enable validating the correctness of an index implementation by executing automatically generated test queries based on index meta-data. Experiments show that the performance penalty of using an index plugged into Mexima is low compared to using the corresponding stand-alone C/C++ implementation. Substantial performance gains are shown by the index exposing rewrite mechanisms.

Place, publisher, year, edition, pages
New York: ACM Press, 2015
Keyword
Domain Indexing; Extensible Databases; Query Processing; Automatic Testing
National Category
Computer Sciences
Research subject
Computer Science with specialization in Database Technology
Identifiers
urn:nbn:se:uu:diva-280368 (URN)10.1145/2791347.2791375 (DOI)978-1-4503-3709-0 (ISBN)
Conference
SSDBM 2015, June 29–July 1, San Diego, CA
Available from: 2015-06-29 Created: 2016-03-09 Last updated: 2018-01-10Bibliographically approved
Truong, T. & Risch, T. (2014). Scalable Numerical Queries by Algebraic Inequality Transformations. In: Database Systems for Advanced Applications, Dasfaa 2014, PT I: . Paper presented at 19th International Conference on Database Systems for Advanced Applications (DASFAA), APR 21-24, 2014, Bali, INDONESIA (pp. 95-109).
Open this publication in new window or tab >>Scalable Numerical Queries by Algebraic Inequality Transformations
2014 (English)In: Database Systems for Advanced Applications, Dasfaa 2014, PT I, 2014, p. 95-109Conference paper, Published paper (Refereed)
Abstract [en]

To enable historical analyses of logged data streams by SQL queries, the Stream Log Analysis System (SLAS) bulk loads data streams derived from sensor readings into a relational database system. SQL queries over such log data often involve numerical conditions containing inequalities, e. g. to find suspected deviations from normal behavior based on some function over measured sensor values. However, such queries are often slow to execute, because the query optimizer is unable to utilize ordered indexed attributes inside numerical conditions. In order to speed up the queries they need to be reformulated to utilize available indexes. In SLAS the query transformation algorithm AQIT (Algebraic Query Inequality Transformation) automatically transforms SQL queries involving a class of algebraic inequalities into more scalable SQL queries utilizing ordered indexes. The experimental results show that the queries execute substantially faster by a commercial DBMS when AQIT has been applied to preprocess them.

Series
Lecture Notes in Computer Science, ISSN 0302-9743 ; 8421
National Category
Computer and Information Sciences
Identifiers
urn:nbn:se:uu:diva-236268 (URN)000342909200007 ()978-3-319-05810-8; 978-3-319-05809-2 (ISBN)
Conference
19th International Conference on Database Systems for Advanced Applications (DASFAA), APR 21-24, 2014, Bali, INDONESIA
Available from: 2014-11-18 Created: 2014-11-17 Last updated: 2018-01-11
Andrejev, A., He, X. & Risch, T. (2014). Scientific data as RDF with arrays: Tight integration of SciSPARQL queries into MATLAB. In: Proc. ISWC 2014 Posters & Demonstrations Track: . Paper presented at 13th International Semantic Web Conference (ISWC 2014) (pp. 221-224). RWTH Aachen University
Open this publication in new window or tab >>Scientific data as RDF with arrays: Tight integration of SciSPARQL queries into MATLAB
2014 (English)In: Proc. ISWC 2014 Posters & Demonstrations Track, RWTH Aachen University , 2014, p. 221-224Conference paper, Poster (with or without abstract) (Refereed)
Abstract [en]

We present an integrated solution for storing and querying scientific data and metadata, using MATLAB envi ronment as client front-end and our prototype DBMS on the server. We use RDF for experiment metadata, and numeric arrays for the rest. Our extension of SPARQL supports array operations and extensibility with foreign functions.

Place, publisher, year, edition, pages
RWTH Aachen University, 2014
Series
CEUR Workshop Proceedings, ISSN 1613-0073 ; 1272
National Category
Computer Sciences
Research subject
Computer Science with specialization in Database Technology
Identifiers
urn:nbn:se:uu:diva-236208 (URN)
Conference
13th International Semantic Web Conference (ISWC 2014)
Projects
SSPIeSSENCE
Funder
eSSENCE - An eScience Collaboration
Available from: 2014-10-21 Created: 2014-11-14 Last updated: 2018-01-11Bibliographically approved
Badiozamany, S., Melander, L., Truong, T., Xu, C. & Risch, T. (2013). Grand challenge: Implementation by frequently emitting parallel windows and user-defined aggregate functions. In: Proc. 7th ACM International Conference on Distributed Event-Based Systems: . Paper presented at DEBS 2013 (pp. 325-330). New York: ACM Press
Open this publication in new window or tab >>Grand challenge: Implementation by frequently emitting parallel windows and user-defined aggregate functions
Show others...
2013 (English)In: Proc. 7th ACM International Conference on Distributed Event-Based Systems, New York: ACM Press, 2013, p. 325-330Conference paper, Published paper (Refereed)
Place, publisher, year, edition, pages
New York: ACM Press, 2013
National Category
Computer Sciences
Identifiers
urn:nbn:se:uu:diva-211954 (URN)10.1145/2488222.2488284 (DOI)978-1-4503-1758-0 (ISBN)
External cooperation:
Conference
DEBS 2013
Available from: 2013-06-29 Created: 2013-12-03 Last updated: 2018-01-11Bibliographically approved
Xu, C., Wedlund, D., Helgoson, M. & Risch, T. (2013). Model-based validation of streaming data. In: Proc. 7th ACM International Conference on Distributed Event-Based Systems: . Paper presented at DEBS 2013, June 29–July 3, Arlington, TX (pp. 107-113). New York: ACM Press
Open this publication in new window or tab >>Model-based validation of streaming data
2013 (English)In: Proc. 7th ACM International Conference on Distributed Event-Based Systems, New York: ACM Press, 2013, p. 107-113Conference paper, Published paper (Refereed)
Place, publisher, year, edition, pages
New York: ACM Press, 2013
National Category
Computer Sciences
Research subject
Computer Science with specialization in Database Technology
Identifiers
urn:nbn:se:uu:diva-212049 (URN)10.1145/2488222.2488275 (DOI)978-1-4503-1758-0 (ISBN)
Conference
DEBS 2013, June 29–July 3, Arlington, TX
Projects
eSSENCE
Available from: 2013-07-03 Created: 2013-12-04 Last updated: 2018-01-11Bibliographically approved
Organisations

Search in DiVA

Show all publications