A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
Filters
A Framework for the Investigation of Aggregate Functions in Database Queries
[chapter]
1999
Lecture Notes in Computer Science
Preserved Fulltext
In this paper we present a new approach for studying aggregations in the context of database query languages. ...
This notion yields an e ective tool to study the e ect of the embedding of a class of built-in aggregate functions in a query language. ...
Uniform Aggregate Functions In order to provide a concrete basis for the investigation of aggregations in the context of database queries, we n o w re ne the de nition of aggregate function. ...
doi:10.1007/3-540-49257-7_24
fatcat:oohf57hdfzdhve54pw36ghb35u
Efficient GCD functions in SQL
2013
Proceedings of the 8th conference of the European Society for Fuzzy Logic and Technology
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
This research focuses on making it possible to interpret a complex aggregation of criteria and retrieve results in the standard language of the target database. ...
The translation of user query to database query is presented and some experiments regarding performance are given. ...
This includes investigating presets for the framework that sacrifice functionality for transparancy. ...
doi:10.2991/eusflat.2013.99
dblp:conf/eusflat/NielandtBT13
fatcat:ttdcjgphujcv7oc6zj7qeroefa
Database Technology for Processing Temporal Data (Invited Paper)
2018
International Symposium/Workshop on Temporal Representation and Reasoning
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
The SQL:2011 standard introduced some temporal features, and commercial database management systems have started to offer temporal functionalities in a step-by-step manner. ...
There has also been a proposal for a more fundamental and comprehensive solution for sequenced temporal queries, which allows a tight integration into relational database systems, thereby taking advantage ...
While temporal alignment provides a framework for implementing temporal query support in relational database systems, open issues remain that require further investigation. ...
doi:10.4230/lipics.time.2018.2
dblp:conf/time/BohlenDGJ18
fatcat:j3kfsfijijfi7o6wpsytjbnw7u
Hecataeus: A Framework for Representing SQL Constructs as Graphs
2005
International Working Conference on Exploring Modeling Methods for Systems Analysis and Development
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
We then present HECATAEUS, a tool for implementing and visualizing the above framework. ...
Traditional modeling techniques typically focus on the static part of databases and ignore their dynamic part (e.g., queries or data-centric workflows). ...
Moreover, for every aggregated attribute in the query schema, there exists an edge directing from this attribute towards the aggregate function node as well as an edge from the function node towards the ...
dblp:conf/emmsad/PapastefanatosK05
fatcat:xjdt4ra4qvejtdi2yilgxzz77i
TREE BASED INDEXES VERSUS BITMAP INDEXES: A PERFORMANCE STUDY
2001
International Journal of Cooperative Information Systems
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
In this paper, a framework is presented to evaluate different index structures analytically depending on nine parameters for the use in a data warehouse environment. ...
The framework is applied to four different index structures to evaluate which structure works best for range queries. We show that all parameters influence the performance. ...
Acknowledgments Part of this research was supported by the German Research Society, Berlin-Brandenburg Graduate School in Distributed Information Systems (DFG grant no. GRK 316) ...
doi:10.1142/s0218843001000382
fatcat:xfguifjsozgbtjekq3cldvt2eq
Explaining query answers with explanation-ready databases
2015
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
In this paper, we propose a generic framework that can support much richer, insightful explanations by preparing the database offline, so that top explanations can be found interactively at query time. ...
The main idea in such explanationready databases is to pre-compute the effects of potential explanations (called interventions), and efficiently re-evaluate the original query taking into account these ...
We thank the anonymous reviewers for their detailed feedback, and Milos Nikolic for helpful communication about DBToaster. This work was supported in part by NSF grant IIS-0911036. ...
doi:10.14778/2856318.2856329
fatcat:pjy5sm4kvbhkdbrr3jhdfvknw4
NeuroDB: A Neural Network Framework for Answering Range Aggregate Queries and Beyond
[article]
2021
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
Moreover, the same neural network architecture as for RAQs is used, bringing to light the possibility of using a generic framework to answer any query type efficiently. ...
Range aggregate queries (RAQs) are an integral part of many real-world applications, where, often, fast and approximate answers for the queries are desired. ...
The above formulation divides the set of all possible RAQs into a set of different query functions, each defined for a specific aggregation and predicate function. ...
arXiv:2107.04922v1
fatcat:negiogig7fh3niihslosaqmjpq
Spatial data extension for Cassandra NoSQL database
2016
Journal of Big Data
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2018; you can also visit the original URL.
The file type is application/pdf.
The developed framework showed the feasibility of this approach where basic spatial queries are underpinned and the query response time is reduced by up to 70 times for a fairly large area. ...
The emergence of the NoSQL databases, like Cassandra, with their massive scalability and high availability encourages us to investigate the management of the stored data within such storage system. ...
Acknowledgements This publication was made possible by NPRP Grant #[5-1272-1-214] from the Qatar National Research Fund (a member of Qatar Foundation). ...
doi:10.1186/s40537-016-0045-4
fatcat:lypjqi7p5rha7ibowqu2pputwm
On Supporting Context-Aware Preferences in Relational Database Systems
2005
International Conference on Mobile Data Management
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
We propose using data cubes to store the dependencies between context and database relations and OLAP techniques for the manipulation of context-aware queries. ...
In this paper, we consider a preference system that facilitates context-aware OLAP queries, that is OLAP queries whose result depends on the context at the time of their submission. ...
In this paper, we investigate the use of context in relational database management systems. ...
dblp:conf/mdm/StefanidisPV05
fatcat:3agoyy7kcbesrawj7gu22i7ik4
Usable, Secure, Private Search
2012
IEEE Security and Privacy
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2012; you can also visit the original URL.
The file type is application/pdf.
Building on the cryptographic and privacy preserving guarantees of the SADS primitive, we then describe a general framework for engineering usable private secure search systems. ...
encrypted database in a controlled manner. ...
For example, consider a hypothetical criminal investigation database. For obvious reasons, access to details pertaining to ongoing investigations should be strictly controlled. ...
doi:10.1109/msp.2011.155
fatcat:ot5ecq4befel7onjpbodmekj3u
Integrated Document-based Electronic Health Records Persistence Framework
2021
International Journal of Advanced Computer Science and Applications
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
It investigates the suitability of the documentbased NoSQL persistence mechanism, storing electronic health records data as a design choice for managing varied complexity ad hoc queries used in operational ...
The performance of the most popular two document-based NoSQL back-ends, Couchbase Server and MongoDB, is compared according to the size of the database and query execution time. ...
While Couchbase Server investigates two database topologies, which are single node cluster and multinode cluster. www.ijacsa.thesai.org For Single node topology in MongoDB, the aggregation pipeline framework ...
doi:10.14569/ijacsa.2021.0121017
fatcat:doy3afttv5gzbovsa3nmj4tm2y
GStat 2.0: Grid Information System Status Monitoring
2010
Journal of Physics, Conference Series
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2018; you can also visit the original URL.
The file type is application/pdf.
Grid Status (GStat) is a tool that monitors the structural integrity of the EGEE information system, which is a hierarchical system built out of more than 260 site-level and approximately 70 global aggregation ...
A major new version, GStat 2.0, aims to build on the production experience of GStat and provides additional functionality, which enables it to be extended and combined with other tools. ...
This script queries an information aggregation point and stores the result in the GStat database. ...
doi:10.1088/1742-6596/219/6/062045
fatcat:ijys3a3wnrhi7oe2r76kwyqbki
Large Scale Medical Image Search via Unsupervised PCA Hashing
2013
2013 IEEE Conference on Computer Vision and Pattern Recognition Workshops
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
Medical image search is a significant way to provide similar clinical cases for doctors. Text based and content based image retrieval techniques have been widely investigated in the last decades. ...
We focus on investigating the efficiency of PCA hashing while maintaining its competitive performance in medical image search. ...
For different features, we run 545 query images which are not in the 137k image database. ...
doi:10.1109/cvprw.2013.66
dblp:conf/cvpr/YuZLZM13
fatcat:s664rnuuvjckpivyknyppfchcu
Scalable matching and ranking for network search
2013
Proceedings of the 9th International Conference on Network and Service Management (CNSM 2013)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2016; you can also visit the original URL.
The file type is application/pdf.
Further, we present the design of a search node, which maintains a real-time database of operational information and allows for parallel processing of search queries. ...
The search plane is realized as a network of search nodes that process search queries in a distributed fashion. This paper introduces matching and ranking for network search queries. ...
Aggregator for processing a query q on a node with local database D. operators of the full query language [2] , including, the projection, aggregation, and link operators, is missing. ...
doi:10.1109/cnsm.2013.6727844
dblp:conf/cnsm/UddinSC13
fatcat:jdn5fdyynjbofktpel3ekozjnu
What to Expect and What to Focus on in SQL Query Teaching
2019
Proceedings of the 50th ACM Technical Symposium on Computer Science Education - SIGCSE '19
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
In the process of learning a new computer language, writing erroneous statements is part of the learning experience. ...
Structured Query Language (SQL) consists of a number of different concepts such as expressions, joins, grouping and ordering, all of which by nature invite different possible errors in the query writing ...
ACKNOWLEDGMENTS The authors would like to thank Dr. Mikko Rönkkö for his invaluable advice and support regarding the methodology, and the anonymous reviewers for their comments and suggestions. ...
doi:10.1145/3287324.3287359
dblp:conf/sigcse/TaipalusP19
fatcat:ze2lmpo66jgoxdhn6pl37b4pvy
« Previous
Showing results 1 — 15 out of 50,450 results