scholarly journals A Survey of Open Source Tools for Business Intelligence

2010 ◽  
pp. 624-644
Author(s):  
Christian Thomsen ◽  
Torben Bach Pedersen
Keyword(s):  
Open Source ◽  
Business Intelligence ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Survey Article ◽  
On Line ◽  
Analytical Processing ◽  
Industrial Use ◽  
On Line Analytical Processing

The industrial use of open source Business Intelligence (BI) tools is becoming more common, but is still not as widespread as for other types of software. It is therefore of interest to explore which possibilities are available for open source BI and compare the tools. In this survey article, we consider the capabilities of a number of open source tools for BI. In the article, we consider a number of Extract-Transform-Load (ETL) tools, database management systems (DBMSs), On-Line Analytical Processing (OLAP) servers, and OLAP clients. We find that, unlike the situation a few years ago, there now exist mature and powerful tools in all these categories. However, the functionality still falls somewhat short of that found in commercial tools.

scholarly journals A Survey of Open Source Tools for Business Intelligence

2011 ◽  
pp. 237-257
Keyword(s):  
Open Source ◽  
Business Intelligence ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Survey Article ◽  
On Line ◽  
Analytical Processing ◽  
Industrial Use ◽  
On Line Analytical Processing

The industrial use of open source Business Intelligence (BI) tools is becoming more common, but is still not as widespread as for other types of software. It is therefore of interest to explore which possibilities are available for open source BI and compare the tools. In this survey article, we consider the capabilities of a number of open source tools for BI. In the article, we consider a number of Extract- Transform-Load (ETL) tools, database management systems (DBMSs), On-Line Analytical Processing (OLAP) servers, and OLAP clients. We find that, unlike the situation a few years ago, there now exist mature and powerful tools in all these categories. However, the functionality still falls somewhat short of that found in commercial tools.

Open Source Database Management Systems

2005 ◽  
pp. 457-462 ◽  
Author(s):  
Sulayman K. Sowe ◽  
Ioannis Samoladas ◽  
Ioannis Stamelos
Keyword(s):  
Software Development ◽  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Free Open Source Software ◽  
Source Database ◽  
1960S And 1970S ◽  
Free Open Source

This article discusses open source database management systems (OSDBMS) trends from two broad perspectives. First, the software engineering discipline platform on which databases are built has recently witnessed a new form of software development—Free/Open Source Software Development (F/OSSD). Methodically, the F/OSSD paradigm has changed the way relational databases, initiated in the 1960s and 1970s, are developed, distributed, supported, and maintained. Second, commercial relational database management systems (RDBMS) still dominate the database market because, on one hand, vendors and users are skeptical of the boon of applications developed and distributed under the F/OSSD paradigm, and on the other hand, it has been argued that OSDBMS are not likely to follow the successful trend of other robust Free/Open Source Software (F/OSS) systems (Linux, Apache, etc.). This article presents trends in OSDBMS by looking at the morphology and landscape of the type of applications developed by the F/OSS community. Implementation of F/OSS strategies and factors mitigating the adoption and utilization of OSDBMS are explored by looking at the interactions between the F/OSSD process and database firms, vendors, and users.

scholarly journals Overview of Modern Nosql Database Management Systems. Case Study: Apache Cassandra

2018 ◽  
Vol 9 (1) ◽  
pp. 83-86
Author(s):  
Katalin Ferencz
Keyword(s):  
Open Source ◽  
Database Management ◽  
Query Language ◽  
Distributed Database ◽  
Database Management Systems ◽  
Sensor Data ◽  
Management Systems ◽  
Database Server ◽  
Server Software ◽  
Iot Devices

Abstract The wide spread of IoT devices makes possible the collection of enormous amounts of sensor data. Traditional SQL (structured query language) database management systems are not the most appropriate for storing this type of data. For this task, distributed database management systems are the most adequate. Apache Cassandra is an open source, distributed database server software that stores large amounts of data on low-coast servers, providing high availability. The Cassandra uses the gossip protocol to exchange information between the distributed servers. The query language used is the CQL (Cassandra Query Language). In this paper we present an alternative solution to traditional SQL-based database management systems - the so called NoSQL type database management systems, summarize the main types of these systems and provide a detailed description of the Apache Cassandra open source distributed database server installation, configuration and operation.

A Generalized Comparison of Open Source and Commercial Database Management Systems

2011 ◽  
pp. 296-304
Author(s):  
Theodoros Evdoridis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

scholarly journals HTAP With Reactive Streaming ETL

2021 ◽  
Vol 23 (4) ◽  
pp. 0-0
Keyword(s):  
Database Management ◽  
Database Management Systems ◽  
Online Analytical Processing ◽  
Management Systems ◽  
Business Decisions ◽  
Industry Standard ◽  
Analytical Processing ◽  
Transactional Data

In database management systems (DBMSs), query workloads can be classified as online transactional processing (OLTP) or online analytical processing (OLAP). These often run within separate DBMSs. In hybrid transactional and analytical processing (HTAP), both workloads may execute within the same DBMS. This article shows that it is possible to run separate OLTP and OLAP DBMSs, and still support timely business decisions from analytical queries running off fresh transactional data. Several setups to manage OLTP and OLAP workloads are analysed. Then, benchmarks on two industry standard DBMSs empirically show that, under an OLTP workload, a row-store DBMS sustains a 1000 times higher throughput than a columnar DBMS, whilst OLAP queries are more than 4 times faster on a columnar DBMS. Finally, a reactive streaming ETL pipeline is implemented which connects these two DBMSs. Separate benchmarks show that OLTP events can be streamed to an OLAP database within a few seconds.

A Generalized Comparison of Open Source and Commercial Database Management Systems

2009 ◽  
pp. 13-27
Author(s):  
Theodoros Evdoridis ◽  
Theodoros Tzouramanis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

A Generalized Comparison of Open Source and Commercial Database Management Systems

2011 ◽  
pp. 294-308
Author(s):  
Theodoros Evdoridis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

scholarly journals Uma proposta de aplicação de business intelligence no chão-de-fábrica

2005 ◽  
Vol 12 (1) ◽  
pp. 55-66 ◽  
Author(s):  
Marcos Roberto Fortulan ◽  
Eduardo Vila Gonçalves Filho
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing

A evolução do chão-de-fábrica tem sido significativa nas últimas décadas, quando grandes investimentos têm sido realizados em infra-estrutura, automação, treinamento e sistemas de informação, transformando-o numa área estratégica para as empresas. O chão-de-fábrica gera hoje grande quantidade de dados que, por estarem dispersos ou desorganizados, não são utilizados em todo o seu potencial como fonte de informação. Com vistas nessa deficiência, este trabalho propõe a implantação de um sistema de Business Intelligence por meio do uso de ferramentas de Data Warehouse e OLAP (On-Line Analytical Processing), aplicadas especificamente ao chão-de-fábrica. O objetivo é desenvolver um sistema que utilize os dados resultantes do processo produtivo e os transforme em informações que auxiliem o gerente na tomada de decisões, de forma a garantir a competitividade da empresa. Um protótipo foi construído com dados simulados para testar a proposta.

Sign in / Sign up

Export Citation Format

Share Document