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

Direct link
BETA
Risch, Tore
Alternative names
Publications (10 of 145) 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, 553-577 p.Article 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
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, 117-137 p.Article 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, 152-156 p.Conference 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, 173-185 p.Conference 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, 95-109 p.Conference 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, 221-224 p.Conference 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, 325-330 p.Conference 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, 107-113 p.Conference 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
Stefanova, S. & Risch, T. (2013). Scalable reconstruction of RDF-archived relational databases. In: Proc. 5th International Workshop on Semantic Web Information Management: . Paper presented at 5th International Workshop on Semantic Web Information Management (SWIM 2013), June 23, New York (pp. 5:1-4). New York: ACM Press.
Open this publication in new window or tab >>Scalable reconstruction of RDF-archived relational databases
2013 (English)In: Proc. 5th International Workshop on Semantic Web Information Management, New York: ACM Press, 2013, 5:1-4 p.Conference 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-199571 (URN)10.1145/2484712.2484717 (DOI)978-1-4503-2194-5 (ISBN)
Conference
5th International Workshop on Semantic Web Information Management (SWIM 2013), June 23, New York
Projects
eSSENCE
Funder
eSSENCE - An eScience Collaboration
Available from: 2013-06-23 Created: 2013-05-07 Last updated: 2018-01-11Bibliographically approved
Organisations

Search in DiVA

Show all publications