Filters








50,450 Hits in 5.5 sec

A Framework for the Investigation of Aggregate Functions in Database Queries [chapter]

Luca Cabibbo, Riccardo Torlone
1999 Lecture Notes in Computer Science  
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

Joachim Nielandt, Antoon Bronselaer, Guy De Tre
2013 Proceedings of the 8th conference of the European Society for Fuzzy Logic and Technology  
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)

Michael H. Böhlen, Anton Dignös, Johann Gamper, Christian S. Jensen, Michael Wagner
2018 International Symposium/Workshop on Temporal Representation and Reasoning  
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

George Papastefanatos, Kostis Kyzirakos, Panos Vassiliadis, Yannis Vassiliou
2005 International Working Conference on Exploring Modeling Methods for Systems Analysis and Development  
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

MARCUS JÜRGERNS, HANS-J. LENZ
2001 International Journal of Cooperative Information Systems  
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

Sudeepa Roy, Laurel Orr, Dan Suciu
2015 Proceedings of the VLDB Endowment  
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]

Sepanta Zeighami, Cyrus Shahabi
2021 arXiv   pre-print
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

Mohamed Ben Brahim, Wassim Drira, Fethi Filali, Noureddine Hamdi
2016 Journal of Big Data  
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

Kostas Stefanidis, Evaggelia Pitoura, Panos Vassiliadis
2005 International Conference on Mobile Data Management  
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

Mariana Raykova, Ang Cui, Binh Vo, Bin Liu, Tal Malkin, Steven M. Bellovin, Salvatore J. Stolfo
2012 IEEE Security and Privacy  
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

Aya Gamal, Sherif Barakat, Amira Rezk
2021 International Journal of Advanced Computer Science and Applications  
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

Laurence Field, Joanna Huang, Min Tsai
2010 Journal of Physics, Conference Series  
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

Xiang Yu, Shaoting Zhang, Bo Liu, Lin Zhong, Dimitris N. Metaxas
2013 2013 IEEE Conference on Computer Vision and Pattern Recognition Workshops  
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

Misbah Uddin, Rolf Stadler, Alexander Clemm
2013 Proceedings of the 9th International Conference on Network and Service Management (CNSM 2013)  
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

Toni Taipalus, Piia Perälä
2019 Proceedings of the 50th ACM Technical Symposium on Computer Science Education - SIGCSE '19  
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