ADI : A NoSQL system for bi-temporal databases

Azhar Ait Ouassarah 1, 2
2 BD - Base de Données
LIRIS - Laboratoire d'InfoRmatique en Image et Systèmes d'information
Abstract : Nowadays, every company is operating in very dynamic and complex environments which require from its managers to have a deep understanding of its business in order to take rapid and relevant decisions, and thus maintain or improve their company's activities. They can rely on analyzing the data deluge generated by the company's activities. A new class of systems has emerged in the decision support system galaxy called "Operational Intelligence" (OI) to meet this challenge. The objective is to enable operational managers to understand what happened in the past as well as what is currently happening in their business. In this context, the notions of time and traceability turns out to play a crucial role to understand what happened in the company and what is currently happening in the company. In this thesis, we present "Axway Decision Insight" (ADI), an "Operational Intelligence" solution developed by Axway. ADI's key component is a proprietary bi-temporal and column-oriented DBMS that has specially been designed to meet OI requirements. Its bi-temporal capabilities enable to catch both data evolution in the modeled reality (valid time) and in the database (transaction time).We first introduce ADI by focusing on two topics: 1) the GUI that makes the platform "code-free". 2) The adopted bi-temporal modeling approaches. Then we propose a performance benchmark that meets ADI's requirements. Next, we present two bi-temporal query optimizations for ADI. The first one consists in redefining a complex bi-temporal query into: 1) a set of continuous queries in charge of computing aggregation operations as data is collected. 2) A bi-temporal query that accesses the continuous queries' results and feeds the GUI. The second one is a cost-based optimization that uses statistics on bi-temporal data to determine an "optimal" query plan. For these two optimizations, we conducted some experiments, using our benchmark, which show their interests.
Document type :
Theses
Complete list of metadatas

Cited literature [67 references]  Display  Hide  Download

https://tel.archives-ouvertes.fr/tel-01494697
Contributor : Abes Star <>
Submitted on : Thursday, March 23, 2017 - 6:50:10 PM
Last modification on : Thursday, November 21, 2019 - 2:19:58 AM
Long-term archiving on: Saturday, June 24, 2017 - 4:21:55 PM

File

these.pdf
Version validated by the jury (STAR)

Identifiers

  • HAL Id : tel-01494697, version 1

Citation

Azhar Ait Ouassarah. ADI : A NoSQL system for bi-temporal databases. Business administration. Université de Lyon, 2016. English. ⟨NNT : 2016LYSEI046⟩. ⟨tel-01494697⟩

Share

Metrics

Record views

473

Files downloads

1155