Results 71 to 80 of about 1,664 (204)

Аналіз способів оптимізації продуктивності OLTP систем [PDF]

, 2023
На сьогоднішній день основною проблемою ринку реляційних систем управління базами даних є досягнення високої продуктивності системи шляхом збільшення керованості серверів.
Старцев В. В., Возний О. О., Павлій Л. В., Дирман Ю. В., Євстрат Д. І., Гайдак В. П., Коломійцев О. В., Третяк В. Ф., Рибальченко А. О., Кривчун В. І., Пустоваров В. В., Голубничий Д. Ю.   +11 more
core  

DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI

Jurnal Informatika, 2009
Data Warehouse for higher education as a paradigm for helping high management in order to make an effective and efficient strategic decisions based on reliable and trusted reports which is produced from Data Warehouse itself.
Spits Warnars
doaj  

Benchmarking hybrid OLTP&OLAP database systems

, 2011
Recently, the case has been made for operational or real-time Business Intelligence (BI). As the traditional separation into OLTP database and OLAP data warehouse obviously incurs severe latency disadvantages for operational BI, hybrid OLTP&OLAP ...
Neumann, Thomas, Funke, Florian, Kemper, Alfons   +2 more
core  

A Comparative Study of OLTP and OLAP Technologies

, 2020
This paper provides an overview of Data warehousing and comparative study of OLAP, OLTP technologies. The data warehouse supports On-Line Analytical Processing (OLAP) who's functional and performance requirements are different from those of the On ...
Jatinderpal Singh, Anshul Sood
core  

GalOP: Towards a GPU-Accelerated OLTP DBMS

, 2021
In this paper, we present GalOP - a GPU-accelerated main memory DBMS for OLTP. At the core GalOP is based on a novel deterministic concurrency scheme for GPUs which orders conflicting transactions before the execution on the GPU.
Carsten Binnig, Binnig, Carsten, Boeschen, Nils, Nils Boeschen   +3 more
core   +1 more source

Data Mining on an OLTP System (Nearly) for Free

, 2000
This paper proposes a scheme for scheduling disk requests that takes advantage of the ability of high-level functions to operate directly at individual disk drives. We show that such a scheme makes it possible to support a Data Mining workload on an OLTP
Christos Faloutsos (5359838), Gregory R Ganger (5357558), David Nagle (5415335), Erik Riedel (5416064)   +3 more
core   +1 more source

Database workload forecasting for hybrid transactional/analytical processing scenario

Journal of Big Data
Popular approaches to DBMS (Database Management System) management rely on monitoring log files or using third-party statistical tools to observe workload variations, which requires continuous manual intervention from DBAs (Database Administrator) for ...
Qiaowang Li, Jalal Kawash, Reda Alhajj
doaj   +1 more source

Merging Queries in OLTP Workloads.

, 2022
OLTP applications are usually executed by a high number of clients in parallel and are typically faced with high throughput demand as well as a constraint latency requirement for individual statements. In enterprise scenarios, they often face the challenge to deal with overload spikes resulting from events such as Cyber Monday or Black Friday.
openaire   +2 more sources

OGSSim: Open Generic data Storage systems Simulation tool

EAI Endorsed Transactions on Scalable Information Systems, 2016
In this paper, an open and generic storage simulator is proposed. It simulates with accuracy multi-tiered storage systems based on heterogeneous devices including HDDs, SSDs and the connecting buses.
Sebastien Gougeaud, Soraya Zertal, Jacques-Charles Lafoucriere, Philippe Deniel   +3 more
doaj   +1 more source

Adaptive Physische Optimierung in Hybriden OLTP & OLAP Hauptspeicherdatenbanksystemen

, 2015
Hardware developments in the recent past have facilitated in-memory database systems. Using this technology, the once separated areas of Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) can be reconciled in a single hybrid ...
Funke, Florian Andreas
core