Column-Oriented Databases, an Alternative for Analytical Environment
Journal Title: Database Systems Journal - Year 2010, Vol 1, Issue 2
Abstract
It is widely accepted that a data warehouse is the central place of a Business Intelligence system. It stores all data that is relevant for the company, data that is acquired both from internal and external sources. Such a repository stores data from more years than a transactional system can do, and offer valuable information to its users to make the best decisions, based on accurate and reliable data. As the volume of data stored in an enterprise data warehouse becomes larger and larger, new approaches are needed to make the analytical system more efficient. This paper presents column-oriented databases, which are considered an element of the new generation of DBMS technology. The paper emphasizes the need and the advantages of these databases for an analytical environment and make a short presentation of two of the DBMS built in a columnar approach.
Authors and Affiliations
Gheorghe MATEI
Keywords
Related Articles
- EP ID EP124279
- DOI -
- Views 120
- Downloads 0
Perspectives on the Role of Business Rules in Database Design
Business rules are at the foundation of every information system as they drive and offer guidelines for managing and conducting all activities within an organizations. They are important both for operational system...
Database Optimizing Services
Almost every organization has at its centre a database. The database provides support for conducting different activities, whether it is production, sales and marketing or internal operations. Every day, a database is ac...
Implementation of Cloud Computing into VoIP
This article defines Cloud Computing and highlights key concepts, the benefits of using virtualization, its weaknesses and ways of combining it with classical VoIP technologies applied to large scale businesses. The anal...
The Optimization of Algorithms in the Process of Temporal Data Mining Using the Compute Unified Device Architecture
Considering the importance and usefulness of real time data mining, in recent years the concern of researchers to discover new hardware architectures that can manage and process large volumes of data has increased si...
SOA - An Architecture Which Creates a Flexible Link between Business Processes and IT
To be viable, a company must be adapted continously to the market’s requirements. The adaption of a company to the market’s requirements means also changes in the business processes of the firm. Till several years...