Business Intelligence-as-a-Service

2011 ◽  
pp. 199-221 ◽  
Author(s):  
Moez Essaidi ◽  
Aomar Osmani
Keyword(s):  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Data Warehousing ◽  
Software As A Service ◽  
Architecture Model ◽  
Model Driven ◽  
Industry Standards ◽  
Service Deployment ◽  
Methodological Aspects

In recent years, the data warehousing infrastructures have undergone many changes in various aspects. This is usually due to many factors: the emergence of Software-as-a-Service (SaaS) architecture model; the success of agile and iterative Data Warehouse (DW) development approaches; the introduction of new approaches based on the Model Driven Architecture (MDA); the changing needs of organizations and the extension of the DW into new application areas; and the evolving of standards and open-source technologies. This chapter explores several aspects that may influence the next-generation of data warehousing platforms: the architectural aspects for business intelligence-as-a-service deployment, the promising open industry standards and technologies recommended for use, and the emerging methodological aspects for DW components engineering.

Commercial and Open Source Business Intelligence Platforms for Big Data Warehousing

2019 ◽  
pp. 158-181 ◽  
Author(s):  
Jorge Bernardino ◽  
Joaquim Lapa ◽  
Ana Almeida
Keyword(s):  
Decision Making ◽  
Big Data ◽  
Decision Support ◽  
Comparative Analysis ◽  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Selection Process ◽  
Decision Making Processes ◽  
Big Data Warehouse

A big data warehouse enables the analysis of large amounts of information that typically comes from the organization's transactional systems (OLTP). However, today's data warehouse systems do not have the capacity to handle the massive amount of data that is currently produced. Business intelligence (BI) is a collection of decision support technologies that enable executives, managers, and analysts to make better and faster decisions. Organizations must make good use of business intelligence platforms to quickly acquire desirable information from the huge volume of data to reduce the time and increase the efficiency of decision-making processes. In this chapter, the authors present a comparative analysis of commercial and open source BI tools capabilities, in order to aid organizations in the selection process of the most suitable BI platform. They also evaluated and compared six major open source BI platforms: Actuate, Jaspersoft, Jedox/Palo, Pentaho, SpagoBI, and Vanilla; and six major commercial BI platforms: IBM Cognos, Microsoft BI, MicroStrategy, Oracle BI, SAP BI, and SAS BI & Analytics.

Implementasi Data Warehouse Menggunakan Pentaho BI di Hartaning House Homestay

2021 ◽  
Vol 10 (1) ◽  
pp. 153
Author(s):  
Made Rusdinda Hartani ◽  
Ida Bagus Made Mahendra
Keyword(s):  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Equal Distribution ◽  
Warehouse Design ◽  
System Designs ◽  
Made In

Hartaning House is one of the homestays in Ubud Gianyar that rents out homestay rooms to foreign and local tourists, but currently does not have a data-based system that facilitates business reports. This research aims to provide a proposed solution in the form of designing and implementing data related to room rental, to facilitate the determination of the promotion of equal distribution of all homestay rooms. The implementation will use an open source application, namely (Pentaho Business Intelligence) for making reports that are used to facilitate analysis. The data is made in a multi-dimensional design to facilitate the application of the data warehouse design and system designs that have been made.

Evolutionary Intelligent Data Warehousing Approach to Knowledge Discovery Systems: Dynamic Cubing

2019 ◽  
Vol 13 ◽  
Author(s):  
Harkiran Kaur ◽  
Kawaljeet Singh ◽  
Tejinder Kaur
Keyword(s):  
Knowledge Discovery ◽  
Data Warehouse ◽  
Business Intelligence ◽  
End Users ◽  
Processing Stage ◽  
Information Update ◽  
On Line ◽  
Analytical Processing ◽  
Warehouse Operations ◽  
Made In

Background: Numerous E – Migrants databases assist the migrants to locate their peers in various countries; hence contributing largely in communication of migrants, staying overseas. Presently, these traditional E – Migrants databases face the issues of non – scalability, difficult search mechanisms and burdensome information update routines. Furthermore, analysis of migrants’ profiles in these databases has remained unhandled till date and hence do not generate any knowledge. Objective: To design and develop an efficient and multidimensional knowledge discovery framework for E - Migrants databases. Method: In the proposed technique, results of complex calculations related to most probable On-Line Analytical Processing operations required by end users, are stored in the form of Decision Trees, at the pre- processing stage of data analysis. While browsing the Cube, these pre-computed results are called; thus offering Dynamic Cubing feature to end users at runtime. This data-tuning step reduces the query processing time and increases efficiency of required data warehouse operations. Results: Experiments conducted with Data Warehouse of around 1000 migrants’ profiles confirm the knowledge discovery power of this proposal. Using the proposed methodology, authors have designed a framework efficient enough to incorporate the amendments made in the E – Migrants Data Warehouse systems on regular intervals, which was totally missing in the traditional E – Migrants databases. Conclusion: The proposed methodology facilitate migrants to generate dynamic knowledge and visualize it in the form of dynamic cubes. Applying Business Intelligence mechanisms, blending it with tuned OLAP operations, the authors have managed to transform traditional datasets into intelligent migrants Data Warehouse.

scholarly journals Open Source Control Device for Industry 4.0 Based on RAMI 4.0

Electronics ◽  
2021 ◽  
Vol 10 (7) ◽  
pp. 869
Author(s):  
Pablo F. S. Melo ◽  
Eduardo P. Godoy ◽  
Paolo Ferrari ◽  
Emiliano Sisinni
Keyword(s):  
Open Source ◽  
Industry 4.0 ◽  
Product Life Cycle ◽  
Manufacturing Systems ◽  
Industrial Revolution ◽  
Control Device ◽  
Source Control ◽  
Reference Architecture ◽  
Architecture Model ◽  
Complex Relationships

The technical innovation of the fourth industrial revolution (Industry 4.0—I4.0) is based on the following respective conditions: horizontal and vertical integration of manufacturing systems, decentralization of computing resources and continuous digital engineering throughout the product life cycle. The reference architecture model for Industry 4.0 (RAMI 4.0) is a common model for systematizing, structuring and mapping the complex relationships and functionalities required in I4.0 applications. Despite its adoption in I4.0 projects, RAMI 4.0 is an abstract model, not an implementation guide, which hinders its current adoption and full deployment. As a result, many papers have recently studied the interactions required among the elements distributed along the three axes of RAMI 4.0 to develop a solution compatible with the model. This paper investigates RAMI 4.0 and describes our proposal for the development of an open-source control device for I4.0 applications. The control device is one of the elements in the hierarchy-level axis of RAMI 4.0. Its main contribution is the integration of open-source solutions of hardware, software, communication and programming, covering the relationships among three layers of RAMI 4.0 (assets, integration and communication). The implementation of a proof of concept of the control device is discussed. Experiments in an I4.0 scenario were used to validate the operation of the control device and demonstrated its effectiveness and robustness without interruption, failure or communication problems during the experiments.

Universal Data Warehousing Based on a Meta-Data Modeling Approach

2003 ◽  
Vol 12 (03) ◽  
pp. 325-363 ◽  
Author(s):  
Joseph Fong ◽  
Qing Li ◽  
Shi-Ming Huang
Keyword(s):  
Data Warehouse ◽  
Data Warehousing ◽  
Object Oriented ◽  
Data Models ◽  
Heterogeneous Databases ◽  
Materialized Views ◽  
Prototype System ◽  
Relational View ◽  
Metadata Model ◽  
Star Schema

Data warehouse contains vast amount of data to support complex queries of various Decision Support Systems (DSSs). It needs to store materialized views of data, which must be available consistently and instantaneously. Using a frame metadata model, this paper presents an architecture of a universal data warehousing with different data models. The frame metadata model represents the metadata of a data warehouse, which structures an application domain into classes, and integrates schemas of heterogeneous databases by capturing their semantics. A star schema is derived from user requirements based on the integrated schema, catalogued in the metadata, which stores the schema of relational database (RDB) and object-oriented database (OODB). Data materialization between RDB and OODB is achieved by unloading source database into sequential file and reloading into target database, through which an object relational view can be defined so as to allow the users to obtain the same warehouse view in different data models simultaneously. We describe our procedures of building the relational view of star schema by multidimensional SQL query, and the object oriented view of the data warehouse by Online Analytical Processing (OLAP) through method call, derived from the integrated schema. To validate our work, an application prototype system has been developed in a product sales data warehousing domain based on this approach.

Sign in / Sign up

Export Citation Format

Share Document