230 Hits in 4.1 sec

A survey of logical models for OLAP databases

Panos Vassiliadis, Timos Sellis
1999 SIGMOD record  
This work is supported by the European Commission in ESPRIT Long Term Research Project DWQ (Foundations of Data Warehouse Quality). We would also like to thank Prof. Matthias Jarke.  ...  In Table 1 , 'SQL ext.' indicates extension of SQL, and N/A means that the information is not directly available in the material examined (papers).  ...  OLAP functionality is characterized by dynamic multidimensional analysis of consolidated enterprise data supporting end user analytical and navigational activities including calculations and modeling applied  ... 
doi:10.1145/344816.344869 fatcat:jkxbaaus7fatdprh5brv75sbui

Time Series Management Systems: A Survey

Soren Kejser Jensen, Torben Bach Pedersen, Christian Thomsen
2017 IEEE Transactions on Knowledge and Data Engineering  
Last, we provide a summary of research directions proposed by other researchers in the field and present our vision for a next generation TSMS.  ...  The collection of time series data increases as more monitoring and automation are being deployed.  ...  ACKNOWLEDGMENTS This research was supported by the DiCyPS center funded by Innovation Fund Denmark [95] .  ... 
doi:10.1109/tkde.2017.2740932 fatcat:3phn7rowfbhsxdzjwcvfgcjigu

NEEL: The Nested Complex Event Language for Real-Time Event Analytics [chapter]

Mo Liu, Elke A. Rundensteiner, Dan Dougherty, Chetan Gupta, Song Wang, Ismail Ari, Abhay Mehta
2011 Lecture Notes in Business Information Processing  
An E-Analytics system for processing nested CEP queries expressed in the NEEL language has been developed.  ...  Lastly, we demonstrate the utility of this technology by describing a case study of a real-world application in health care.  ...  Acknowledgements This work is supported by HP Labs Innovation Research Program and National Science Foundation under grants NSF 1018443 and NSF IIS 0917017, Turkish foundation under TUBITAK career award  ... 
doi:10.1007/978-3-642-22970-1_9 fatcat:6ksnbn3vwfdw7fuuuyvg2rzusy

Sherlock: an open-source data platform to store, analyze and integrate Big Data for biology

Balázs Bohár, David Fazekas, Matthew Madgwick, Luca Csabai, Marton Olbei, Tamás Korcsmáros, Mate Szalay-Beko
2021 F1000Research  
In the era of Big Data, data collection underpins biological research more so than ever before.  ...  For computational biology and large-scale bioinformatics projects, Sherlock provides an open-source platform empowering data management, data analytics, data integration and collaboration through modern  ...  Acknowledgements We would like to thank all of the members of the Korcsmaros Group for their advice and feedback. Page 10 of 14 F1000Research 2021, 10:409 Last updated: 17 JUN 2021  ... 
doi:10.12688/f1000research.52791.1 fatcat:rns4awoaffgdji37fjznqv4j3a

Using domain-specific languages for analytic graph databases

Martin Sevenich, Sungpack Hong, Oskar van Rest, Zhe Wu, Jayanta Banerjee, Hassan Chafi
2016 Proceedings of the VLDB Endowment  
Recently graph has been drawing lots of attention both as a natural data model that captures fine-grained relationships between data entities and as a tool for powerful data analysis that considers such  ...  In this paper, we present a new graph database system that integrates a robust graph storage with an efficient graph analytics engine.  ...  ACKNOWLEDGMENTS We thank Felix Kaser, Jinha Kim, Korbinian Schmid and Alexander Weld (Oracle Labs) for their work and contributions to PGX, the PGQL and Green-Marl language and for reviewing this paper  ... 
doi:10.14778/3007263.3007265 fatcat:xa7yedsjk5aa7o6uzrp5vjkrvi

Towards unified ad-hoc data processing

Xiaogang Shi, Bin Cui, Gillian Dobbie, Beng Chin Ooi
2014 Proceedings of the 2014 ACM SIGMOD international conference on Management of data - SIGMOD '14  
The experimental results on four benchmarks demonstrate that our techniques can significantly improve the performance of a wide range of data processing programs.  ...  In this paper, we present UniAD, a system designed to simplify the programming of data processing tasks and provide efficient execution for user programs.  ...  The language provided by UniAD is similar to those procedural languages in modern databases which are extensions to the SQL language.  ... 
doi:10.1145/2588555.2610492 dblp:conf/sigmod/ShiCDO14 fatcat:3azvp3d3afet3ogbzjodq3jpvq

Adapted Framework for Data Mining Technique to Improve Decision Support System in an Uncertain Situation

Ahmed Bahgat El Seddawy
2012 International Journal of Data Mining & Knowledge Management Process  
Most of imported data are being used in solutions like data mining (DM).  ...  With the addition of models, analytic tools, and user interfaces, they have the potential to provide actionable information that supports effective problem and opportunity identification, critical decision-making  ...  DSS provides access to data items. • Data analysis systems: Those support the manipulation of data by computerized tools tailored to a specific task or by more general tools and operators. • Analytical  ... 
doi:10.5121/ijdkp.2012.2301 fatcat:towp3tmvizez7m5bjvxjv23ztu

Facilitating SQL Query Composition and Analysis [article]

Zainab Zolaktaf, Mostafa Milani, Rachel Pottinger
2020 arXiv   pre-print
Formulating efficient SQL queries requires several cycles of tuning and execution, particularly for inexperienced users.  ...  We examine methods that can accelerate and improve this interaction by providing insights about SQL queries prior to execution.  ...  Although SQL-Share queries access more tables on average (as depicted by a higher mean value and maximum in Figure Figure 4d) .  ... 
arXiv:2002.09091v1 fatcat:bvvvrugpbvh2tmmohz32anf47m

From Blackboard to Green Screen

Torsten Grust
2020 Datenbank-Spektrum  
of database-supported computation that treats SQL like a true programming language.  ...  This new focus on the live interaction with the underlying database systems, led us (1) to adopt the idea of SQL probe queries that are specifically crafted to reveal database internals and (2) a study  ...  The summer semester of 2020 was special in many ways and I do sincerely thank the three of them for being a dependable team.  ... 
doi:10.1007/s13222-020-00362-8 pmid:33390876 pmcid:PMC7770500 fatcat:gqfa55qgujadfladjurogefcle

Chapter 7: Architectures and Implementations of Spatio-temporal Database Management Systems [chapter]

Martin Breunig, Can Türker, Michael H. Böhlen, Stefan Dieker, Ralf Hartmut Güting, Christian S. Jensen, Lukas Relly, Philippe Rigaux, Hans-Jörg Schek, Michel Scholl
2003 Lecture Notes in Computer Science  
Managing spatio-temporal data requires providing spatiotemporal data types and operations, extensions to the query and data manipulation language, and index support for spatio-temporal data.  ...  It starts with a general introduction into architectures and commercial approaches to extending databases by spatiotemporal features.  ...  with the standard SQL language.  ... 
doi:10.1007/978-3-540-45081-8_7 fatcat:232ihvkrzrcrtgv3yo7afbql4e

HBelt: Integrating an Incremental ETL Pipeline with a Big Data Store for Real-Time Analytics [chapter]

Weiping Qu, Sahana Shankar, Sandy Ganza, Stefan Dessloch
2015 Lecture Notes in Computer Science  
in HBelt for real-time analytics.  ...  The objective is to provide HBase tables with realtime data freshness in an efficient manner. A distributed ETL engine is extended and integrated as an overlay of HBase.  ...  For large scale data analytics over HBase, there have already been efforts that implements an extra SQL layer over HBase which accesses tables stored in HBase through these primitive operations [4, 5]  ... 
doi:10.1007/978-3-319-23135-8_9 fatcat:awmiwjrbijgmhllzkfdu2smoiu

Holistic evaluation in multi-model databases benchmarking

Chao Zhang, Jiaheng Lu
2019 Distributed and parallel databases  
Finally, the extensive experiments based on the proposed benchmark were performed on four representatives of MMDBs: ArangoDB, OrientDB, AgensGraph and Spark SQL.  ...  UniBench consists of a set of mixed data models that mimics a social commerce application, which covers data models including JSON, XML, key-value, tabular, and graph.  ...  To view a copy of this licence, visit  ... 
doi:10.1007/s10619-019-07279-6 fatcat:abvnwc6m2ne27ppdjqcwociwim

Translation of array-based loops to distributed data-parallel programs

Leonidas Fegaras, Hasanuzzaman Noor
2020 Proceedings of the VLDB Endowment  
Large volumes of data generated by scientific experiments and simulations come in the form of arrays, while programs that analyze these data are frequently expressed in terms of array operations in an  ...  imperative, loop-based language.  ...  Acknowledgments: Our evaluations were performed at the XSEDE Comet cloud computing infrastructure at the San Diego Supercomputer Center (SDSC),, supported by NSF.  ... 
doi:10.14778/3389133.3389141 fatcat:xp2vaebvibhrfckxgzbsd2kg3y

Snel: SQL Native Execution for LLVM [article]

Marcelo Mottalli, Alejo Sanchez, Gustavo Ajzenman, Carlos Sarraute
2020 arXiv   pre-print
Snel is designed for fast on-line analytics by leveraging the LLVM compiler infrastructure. It also has custom special methods like resolving histograms as extensions to the SQL language.  ...  Snel is a relational database engine featuring Just-In-Time (JIT) compilation of queries and columnar data representation.  ...  It is designed for fast on-line analytics by leveraging the LLVM compiler infrastructure [1] . It also has custom special methods like resolving histograms as extensions to the SQL language.  ... 
arXiv:2002.09449v2 fatcat:ueppsc556jap7hgyjtyq7jd3qi


Sriskandarajah Suhothayan, Kasun Gajasinghe, Isuru Loku Narangoda, Subash Chaturanga, Srinath Perera, Vishaka Nanayakkara
2011 Proceedings of the 2011 ACM workshop on Gateway computing environments - GCE '11  
Making sense of this avalanche of data requires efficient and fast processing.  ...  in data processing. e-Science use-cases, business applications, financial trading applications, operational analytics applications and business activity monitoring applications are some use-cases that  ...  We are exploring the possibilities of automatically breaking down queries and processing them using a pipeline.  ... 
doi:10.1145/2110486.2110493 dblp:conf/sc/SuhothayanGNCPN11 fatcat:5f3advzjqfflvotcwdhbsrcu5y
« Previous Showing results 1 — 15 out of 230 results