Logo des Repositoriums

Auflistung nach Schlagwort "OLAP"

1 - 5 von 5
  • Zeitschriftenartikel
    Data-Warehouse als Applikationsbasis? — Zur Kosten- und Leistungsrechnung (nicht nur) im Gesundheits- und Sozialwesen
    (Wirtschaftsinformatik: Vol. 46, No. 1, 2004) Hofschröer, Peter; Romberg, Tim
    Using the hospital as an example for service sectors with a heterogeneous application landscape, we put forward the hypothesis that it is not feasible to implement cost accounting applications inside operative systems such as ERP, as it is assumed by the conventional data warehousing approach. Rather, the data warehouse, with its extraction, validation and transformation tools, delivers the right platform, creating an application layer which acts on the data before it is being loaded into multidimensional cubes.The cost accounting application enriches the data in the data warehouse by imputing costs and profits to the various calculatory objects such as ledgers, cost centres and cost objects (products).Our hypothesis is further validated by the fact that typical data warehousing tools, e.g. tree structures, are ideal for defining the often complicated calculation metadata.
  • Zeitschriftenartikel
    Einsatzpotenziale von XML in Business-Intelligence-Systemen
    (Wirtschaftsinformatik: Vol. 46, No. 1, 2004) Schwalm, Stephan; Bange, Carsten
    This article describes the actual applications of XML in the context of Business- Intelligence-Systems (BI). The potentials and synergies of XML and BI will be emphasized. ▪XML applications can be found within all levels of BI-systems.▪The application of core-standards will be introduced as well as the possibilities of BI specific-standards.▪The discussion of the impact of XML for BI-systems follows along the dimensions: externalisation, integration, standardisation and rationalization.
  • Zeitschriftenartikel
    EM-OLAP Framework
    (Business & Information Systems Engineering: Vol. 60, No. 6, 2018) Tyrychtr, Jan; Pelikán, Martin; Štiková, Hana; Vrana, Ivan
    Econometrics is currently one of the most popular approaches to economic analysis. To better support advances in these areas as much as possible, it is necessary to apply econometric problems to econometric intelligent systems. The article describes an econometric OLAP framework that supports the design of a multidimensional database to secure econometric analyses to increase the effectiveness of the development of econometric intelligent systems. The first part of the article consists of the creation of formal rules for the new transformation of the econometric model (TEM) method for the econometric model transformation of multidimensional schema through the use of mathematical notation. In the proposed TEM method, the authors pay attention to the measurement of quality and understandability of the multidimensional schema, and compare the proposed method with the original TEM-CM method. In the second part of the article, the authors create a multidimensional database prototype according to the new TEM method and design an OLAP application for econometric analysis.
  • Konferenzbeitrag
    An Experimental Analysis of Different Key-Value Stores and Relational Databases
    (Datenbanksysteme für Business, Technologie und Web (BTW 2017), 2017) Gembalczyk, David; Schuhknecht, Felix Martin; Dittrich, Jens
    Nowadays, databases serve two main workloads: Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP). For decades, relational databases dominated both areas. With the hype on NoSQL databases, the picture has changed. Initially designed as inter-process hash tables handling OLTP requested, some key-value store vendors have started to tackle the area of OLAP as well. Therefore, in this performance study, we compare the relational databases PostgreSQL, MonetDB, and HyPer with the key-value stores Redis and Aerospike in their write, read, and analytical capabilities. Based on the results, we investigate the reasons of the database’s respective advantages and disadvantages.
  • Zeitschriftenartikel
    HyPer Beyond Software: Exploiting Modern Hardware for Main-Memory Database Systems
    (Datenbank-Spektrum: Vol. 14, No. 3, 2014) Funke, Florian; Kemper, Alfons; Mühlbauer, Tobias; Neumann, Thomas; Leis, Viktor
    In this paper, we survey the use of advanced hardware features for optimizing main-memory database systems in the context of our HyPer project. We exploit the virtual memory management for snapshotting the transactional data in order to separate OLAP queries from parallel OLTP transactions. The access behavior of database objects from simultaneous OLTP transactions is monitored using the virtual memory management component in order to compact the database into hot and cold partitions. Utilizing many-core NUMA-organized database servers is facilitated by the morsel-driven adaptive parallelization and partitioning that guarantees data locality w.r.t. the processing core. The most recent Hardware Transactional Memory support of, e.g., Intel’s Haswell processor, can be used as the basis for a lock-free concurrency control scheme for OLTP transactions. Finally, we show how heterogeneous processors of “wimpy” devices such as tablets can be utilized for high-performance and energy-efficient query processing.