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

ERP and E-Business Application Deployment in Open Source Distributed Cloud Systems

In this paper we present the way in which we combine SlapOS, the fist open source operating system for distributed cloud computing, and Enterprise Resource Modeling (ERP) to provide an simple, unified API for E-Business...

SEO Techniques for Business Websites

In the world of website marketing, search engines are an essential key to success. They are the most important way to bring traffic to websites. Understanding how search engines work and what they require is an important...

Data mining in Cloud Computing

This paper describes how data mining is used in cloud computing. Data Mining is used for extracting potentially useful information from raw data. The integration of data mining techniques into normal day-to-day activitie...

Security Aspects for Business Solution Development on Portal Technology

In the scope of portal development, in order to talk about security issues, concerns, and solutions, it is necessary to define a few terms: authentication, authorization, Single Sign-On (SSO), confidentiality, integrity,...

Optimized Data Indexing Algorithms for OLAP Systems

The need to process and analyze large data volumes, as well as to convey the information contained therein to decision makers naturally led to the development of OLAP systems. Similarly to SGBDs, OLAP systems must ensure...

Download PDF file
  • EP ID EP124279
  • DOI -
  • Views 117
  • Downloads 0

How To Cite

Gheorghe MATEI (2010). Column-Oriented Databases, an Alternative for Analytical Environment. Database Systems Journal, 1(2), 3-16. https://europub.co.uk/articles/-A-124279