Filters








6,711 Hits in 4.9 sec

Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking
English

M. B. Ayub, N. Ali
2018 Journal of Internet and Information Systems  
In-memory database stores all data in physical memory, because of keeping entire data and changes of data in physical memory, the in-memory database provides very short response time and transactional  ...  Secondly, the underlying hardware infrastructure that consists of a server, storage, and network. During the application design lifecycle, the database schema is one area that continuously evolves.  ...  An in-memory database is designed to store entire data in the physical memory and update continuous changes of the data in the memory (Delaney, 2014) .  ... 
doi:10.5897/jiis2018.0106 fatcat:kxde3pvsavgibc33cykxxbbtri

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.  ...  Despite the ubiquity of temporal data and considerable research on processing such data, database systems largely remain designed for processing the current state of some modeled reality.  ...  Introduction and Background The storage and querying of temporal data in database management systems (DBMSs) has been researched for decades, evolving the field and covering multiple aspects of time, the  ... 
doi:10.4230/lipics.time.2018.2 dblp:conf/time/BohlenDGJ18 fatcat:j3kfsfijijfi7o6wpsytjbnw7u

ROX [chapter]

Alan Halverson, Vanja Josifovski, Guy Lohman, Hamid Pirahesh, Mathias Mörschel
2004 Proceedings 2004 VLDB Conference  
The impact of denormalization of data in XML documents is discussed both from a semantic and performance perspective. We also weigh the implications of ROX for manageability and query optimization.  ...  An increasing percentage of the data needed by business applications is being generated in XML format.  ...  , Chun Zhang and others.  ... 
doi:10.1016/b978-012088469-8.50026-7 dblp:conf/vldb/HalversonJLPM04 fatcat:gn6lrkd6bnh3vlci6cb6ineqme

Temporal Data Performance Optimization using Preprocessing Layer

Michal Kvet, Karol Matiasko
2018 Journal of Information Systems Engineering & Management  
The absence or presence of an index does not require a change in the wording of any SQL statement. An index is a fast access path to a single row of data. It affects only the speed of execution.  ...  comparison with standard Range Scan access (Kuhn, 2012) .  ...  Whereas the amount of data to be processed, stored and evaluated, is still rising, it is necessary to manage, store, process and evaluate them effectively.  ... 
doi:10.20897/jisem.201813 fatcat:jfmijiyzt5cjjau2jcjw5m2cye

Infrastructure with r package for anomaly detection in real time big log data

Zirije Hasani
2017 Pressacademia  
We explore implementation of several filters in order to post-process the log information and produce various statistics that suit our needs in analyzing log files containing SQL queries from a big national  ...  The post-processing of the SQL queries is mainly focused on preparing the log information in adequate format and information extraction.  ...  We plan to extend the pre-processing of the incoming logs by parameterization of the SQL queries to lower further the volume of the stored data and to enable easier future analyses.  ... 
doi:10.17261/pressacademia.2017.588 fatcat:flpt5fpezza4npzilqrmgx7bxi

The MADlib analytics library

Joseph M. Hellerstein, Kun Li, Arun Kumar, Christoper Ré, Florian Schoppmann, Daisy Zhe Wang, Eugene Fratkin, Aleksander Gorajek, Kee Siong Ng, Caleb Welton, Xixuan Feng
2012 Proceedings of the VLDB Endowment  
It provides an evolving suite of SQL-based algorithms for machine learning, data mining and statistics that run at scale within a database engine, with no need for data import/export to other tools.  ...  We provide an overview of the library's architecture and design patterns, and provide a description of various statistical methods in that context.  ...  At the same time that the Hadoop ecosystem has been evolving, the SQL-based analytics ecosystem has grown rapidly as well, and large volumes of valuable data are likely to pour into SQL systems for many  ... 
doi:10.14778/2367502.2367510 fatcat:bqz6ufkkpvf2jngbjbmw7jhnwu

Benchmarking OLTP/web databases in the cloud

Carlo A. Curino, Djellel E. Difallah, Andrew Pavlo, Philippe Cudre-Mauroux
2012 Proceedings of the fourth international workshop on Cloud data management - CloudDB '12  
and resource-consumption characteristics of a data management system.  ...  Benchmarking is a key activity in building and tuning data management systems, but the lack of reference workloads and a common platform makes it a time consuming and painful task.  ...  When considering data management systems, this implies: (1) the availability of representative workloads (data and data accesses), (2) an infrastructure to run such workloads against existing systems  ... 
doi:10.1145/2390021.2390025 dblp:conf/cikm/CurinoDPC12 fatcat:gi4z7si24vbh5puwkjpk2g2a44

Native XML Support in DB2 Universal Database

Matthias Nicola, Bert Van der Linden
2005 Very Large Data Bases Conference  
This makes DB2 a true hybrid database system which places equal weight on XML and relational data management.  ...  The native XML storage is complemented with XML indexes, full XQuery, SQL/XML, and XML Schema support, as well as utilities such as a parallel high-speed XML bulk loader.  ...  Acknowledgement We would like to thank and recognize the large number of engineers at the IBM Toronto Lab, IBM Silicon Valley Lab, IBM Almaden Research Center, IBM Portland Lab, and IBM T.J.  ... 
dblp:conf/vldb/NicolaL05 fatcat:jznfhoryw5hbvo3ruyi4vjxk64

Jim Gray's Tandem contributions

John Nauman, Wendy Bartlett
2008 SIGMOD record  
This paper discusses the contributions and accomplishments of Jim Gray while he was at Tandem Computers between 1980 and the early 1990s.  ...  Jim and others realized that, for there to meaningful comparison between systems, a transaction benchmark was required.  ...  First, the sheer technical challenge of providing a fault tolerant and high-performance transaction processing system with SQL as its interface meant that much of the underlying Tandem data management  ... 
doi:10.1145/1379387.1379402 fatcat:frwq4zdtanbularq3a6ezjm5da

OLTP-Bench

Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, Philippe Cudre-Mauroux
2013 Proceedings of the VLDB Endowment  
Benchmarking is an essential aspect of any database management system (DBMS) effort.  ...  This is due to the lack of a universal benchmarking infrastructure, and to the difficulty of gaining access to real data and workloads.  ...  This work was supported (in part) by Amazon and the Swiss National Science Foundation (#PP00P2-128459).  ... 
doi:10.14778/2732240.2732246 fatcat:dpduljjyivf6dkfmikezxwmzym

The MADlib Analytics Library or MAD Skills, the SQL [article]

Joe Hellerstein, Christopher Ré, Florian Schoppmann, Daisy Zhe Wang, Eugene Fratkin, Aleksander Gorajek, Kee Siong Ng, Caleb Welton, Xixuan Feng, Kun Li, Arun Kumar
2012 arXiv   pre-print
It provides an evolving suite of SQL-based algorithms for machine learning, data mining and statistics that run at scale within a database engine, with no need for data import/export to other tools.  ...  We provide an overview of the library's architecture and design patterns, and provide a description of various statistical methods in that context.  ...  At the same time that the Hadoop ecosystem has been evolving, the SQL-based analytics ecosystem has grown rapidly as well, and large volumes of valuable data are likely to pour into SQL systems for many  ... 
arXiv:1208.4165v1 fatcat:uouyhvyo3va2veamidxbeacou4

Integrating K-means clustering with a relational DBMS using SQL

C. Ordonez
2006 IEEE Transactions on Knowledge and Data Engineering  
version based on improved data organization, efficient indexing, sufficient statistics and rewritten queries. (3) An incremental version that uses the optimized version as a building block with fast convergence  ...  We compare K-means implementations in SQL and C++ with respect to speed and scalability and we also study the time to export data sets outside of the DBMS.  ...  INTRODUCTION The integration of data mining algorithms with a relational Data Base Management System (DBMS) is an important and challenging problem [23] .  ... 
doi:10.1109/tkde.2006.31 fatcat:i5jd3sm6drgtfhhaydmhqllq74

Fluxdata.org: Publication and Curation of Shared Scientific Climate and Earth Sciences Data

Marty Humphrey, Deb Agarwal, Catharine van Ingen
2009 2009 Fifth IEEE International Conference on e-Science  
accounts, and terminate via comparison with more than one data set.  ...  Note: scalability to be collected, processed, and utilized in an evolvable does not necessarily require distributed management of manner while  ... 
doi:10.1109/e-science.2009.25 dblp:conf/eScience/HumphreyAI09 fatcat:xzgx6i5wvvdt7mqfmm2tpldu64

DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL

K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Ozcan, H. Pirahesh, N. Seemann (+6 others)
2006 IBM Systems Journal  
Comprehensive and efficient support for XML data management is a rapidly increasing requirement for database systems.  ...  This makes DB2t a truly hybrid database management system with first-class support for both XML and relational data processing as well as the integration of the two.  ...  Hvizdos is an advisory software developer at the IBM Toronto lab, responsible for the design and implementation of the DB2 CLI/ODBC and embedded SQL application interfaces to XML data and XQuery.  ... 
doi:10.1147/sj.452.0271 fatcat:wppk2sdeq5d2rhbwfwc6lf4niu

The effect of visual query languages on the improvement of information retrieval skills

Jozef Hvorecký, Martin Drlík, Michal Munk
2010 Procedia - Social and Behavioral Sciences  
Using an experiment, two forms of query creation (SQL and QBE) have been compared from three points of view: the time period necessary for forming queries, their correctness, and their authors' comfort  ...  The results were analyzed using advanced statistical methods.  ...  They evolve with the progression of our knowledge in order to find an optimal way for codifying it.  ... 
doi:10.1016/j.sbspro.2010.03.090 fatcat:h7bvae73yrd5tgiyt3jm42csq4
« Previous Showing results 1 — 15 out of 6,711 results