A Comprehensive Study on Data Warehouse, OLAP and OLTP Technology
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2014, Vol 2, Issue 11
Abstract
Data warehouse is an integrated, subject oriented, time variant and non-volatile collection of data used for decision making. It is a type of database for decision making which is separately maintained from the operational database. Data warehouse provides a very important tool OLAP (online analytical processing) for more intensive decision support. The main characteristics of OLAP are: advanced database support, analysis of multidimensional data, support client-server architecture and easy to use end user interface. So, data warehouse and OLAP are very important elements for decision making and knowledge discovery process. In this paper, we discussed about data warehouse, OLAP and OLTP and also described data warehouse model and some back end tools.
Authors and Affiliations
Namrata, Dr. Saket Bihari Singh
Keywords
Related Articles
- EP ID EP19052
- DOI -
- Views 298
- Downloads 12
Garden Game Playing Robot
This project deals with the development and construction of a manual robot capable to play various game activity with the parent & child robot. Parent robot has to carry child robot up to the play zone & child robot pla...
A Modern Approach of Quantum Cryptography for Wireless Network Security
“SECURITY” in these contemporary scenarios has become a more sensible issue for the “REAL WORLD” or in the “CYBER WORLD”. Data that is transient over an unsecured wireless network is always susceptible to being intercep...
Precipitate Data Dissemination (PDD) Protocol for Infostations Based Content Delivery Systems in VANET
Vehicular Ad-Hoc Network (VANET) communication has become an increasingly popular topic recently in the area of Wireless Communication networking for efficient and epidemic data dissemination with required scalability....
A Novel High Voltage Gain Boost-Fly backForward Converter with Voltage Multiplier Cell for Solar Fed Induction Motor Drive Application
A high voltage gain boost-fly back converter with voltage multiplier cell is proposed in this paper to avoid the exceptionally slight turn-off period and to decrease the current ripple. The voltage multiplier unit is co...
Effect of change of substrate on I shape patch antenna using slots and stub for wireless applications
in this paper an rectangular patch whose top corner has been cut and I shape slot, L shape slot along with stub is introduced. The substrate Duroide is used for the designed antenna with dielectric constant 2.2 and thic...