Roles of multidimensionality and granularity in warehousing Australian resources data

Granularity of data modeled in multidimensional data structures is an important factor for a data warehouse. Grain sizes and number of dimensions participating in the model are critical in ascertaining the quality of analytical queries that are run on such data warehouses. In this paper, exploration and production data of Australian resources industry, pertinent to oil and gas, over the past five decades have been examined for multidimensionality and grain size. This research shows how using an ER approach combined with multidimensional data modeling helps in considerable reduction in the size of the data warehouse, making it more effective and efficient

Bounded Support Finite Mixtures for Multidimensional Data Modeling and Clustering

Data is ever increasing with today’s many technological advances in terms of both quantity and dimensions. Such inflation has posed various challenges in statistical and data analysis methods and hence requires the development of new powerful models for transforming the data into useful information. Therefore, it was necessary to explore and develop new ideas and techniques to keep pace with challenging learning applications in data analysis, modeling and pattern recognition. Finite mixture models have received considerable attention due to their ability to effectively and efficiently model high dimensional data. In mixtures, choice of distribution is a critical issue and it has been observed that in many real life applications, data exist in a bounded support region, whereas distributions adopted to model the data lie in unbounded support regions. Therefore, it was proposed to define bounded support distributions in mixtures and introduce a modified procedure for parameters estimation by considering the bounded support of underlying distributions. The main goal of this thesis is to introduce bounded support mixtures, their parameters estimation, automatic determination of number of mixture components and application of mixtures in feature extraction techniques to overall improve the learning pipeline. Five different unbounded support distributions are selected for applying the idea of bounded support mixtures and modified parameters estimation using maximum likelihood via Expectation-Maximization (EM). Probability density functions selected for this thesis include Gaussian, Laplace, generalized Gaussian, asymmetric Gaussian and asymmetric generalized Gaussian distributions, which are chosen due to their flexibility and broad applications in speech and image processing. The proposed bounded support mixtures are applied in various speech and images datasets to create leaning applications to demonstrate the effectiveness of proposed approach. Mixtures of bounded Gaussian and bounded Laplace are also applied in feature extraction and data representation techniques, which further improves the learning and modeling capability of underlying models. The proposed feature representation via bounded support mixtures is applied in both speech and images datasets to examine its performance. Automatic selection of number of mixture components is very important in clustering and parameter learning is highly dependent on model selection and it is proposed for mixture of bounded Gaussian and bounded asymmetric generalized Gaussian using minimum message length. Proposed model selection criterion and parameter learning are simultaneously applied in speech and images datasets for both models to examine the model selection performance in clustering

Analyzing RFID Data For The Management Of Reusable Packaging

A common issue that most automotive manufacturers have to face in production logistics is the efficient handling of a considerable number of cost-intensive pallets, trays, boxes and similar reusable packaging goods. As empirical studies show, deficiencies in monitoring, controlling and optimizing packaging material are widespread within this industry. In this contribution a case study is used to investigate the potential of supporting these managerial tasks with a combined use of RFID infrastructures and Business Intelligence (BI) infrastructures. This includes a derivation of relevant RFID reader locations, the identification of further relevant data sources as well as crafting concrete analysis and reporting scenarios based on the paradigm of multidimensional data modeling. The results are used to design a concept for a BI and RFID based system architecture. They highlight the need to include data management systems that bring data integration capabilities and that are capable of tracking historical data – as a possible component of a wider BI infrastructure for manufacturing and logistics

Internal Banking Auditing: From Conceptual Proposal to Technological Aids Development

Trabalho apresentado em CENTERIS 2016 - Conference on ENTERprise Information Systems, outibro 2016, Porto, PortugalN/

A UML Profile for Fuzzy Multidimensional Data Models

Over the last several years, multidimensional data modeling has had several proposals for its formalisation; on the other hand, the incorporation of fuzzy logic in databases has increased the need to represent uncertainty. However, to our knowledge, so far projects in both areas have not been developed. This paper suggests joining those two needs to create a solution; proposing a UML profile oriented to design multidimensional data models with the presence of fuzzy elements.Presentado en el VII Workshop Bases de Datos y Minería de Datos (WBD)Red de Universidades con Carreras en Informática (RedUNCI

Combining Objects with Rules to Represent Aggregation Knowledge in Data Warehouse and OLAP Systems

Les entrepôts de données reposent sur la modélisation multidimensionnelle. A l'aide d'outils OLAP, les décideurs analysent les données à différents niveaux d'agrégation. Il est donc nécessaire de représenter les connaissances d'agrégation dans les modèles conceptuels multidimensionnels, puis de les traduire dans les modèles logiques et physiques. Cependant, les modèles conceptuels multidimensionnels actuels représentent imparfaitement les connaissances d'agrégation, qui (1) ont une structure et une dynamique complexes et (2) sont fortement contextuelles. Afin de prendre en compte les caractéristiques de ces connaissances, nous proposons de les représenter avec des objets (diagrammes de classes UML) et des règles en langage PRR (Production Rule Representation). Les connaissances d'agrégation statiques sont représentées dans les digrammes de classes, tandis que les règles représentent la dynamique (c'est-à-dire comment l'agrégation peut être effectuée en fonction du contexte). Nous présentons les diagrammes de classes, ainsi qu'une typologie et des exemples de règles associées.Agrégation ; Entrepôt de données ; Modèle conceptuel multidimensionnel ; OLAP ; Règle de production ; UML

Business intelligence as the support of decision-making processes in e-commerce systems environment

The present state of world economy urges managers to look for new methods, which can help to start the economic growth. To achieve this goal, managers use standard as well as new procedures. The fundamental prerequisite of the efficient decision-making processes are actual and right information. Managers need to monitor past information and current actual information to generate trends of future development based on it. Managers always should define strictly what do they want to know, how do they want to see it and for what purpose do they want to use it. Only in this case they can get right information applicable to efficient decision-making. Generally, managers´ decisions should lead to make the customers´ decision-making process easier. More frequently than ever, companies use e-commerce systems for the support of their business activities. In connection with the present state and future development, cross-border online shopping growth can be expected. To support this, companies will need much better systems providing the managers adequate and sufficient information. This type of information, which is usually multidimensional, can be provided by the Business Intelligence (BI) technologies. Besides special BI systems, some of BI technologies are obtained in quite a few of ERP (Enterprise Resource Planning) systems. One of the crucial questions is whether should companies and firms buy or develop special BI software, or whether they can use BI tools contained in some ERP systems. In respect of this, there is a question if the modern ERP systems can provide the managers sufficient possibilities relating to ad-hoc reporting, static and dynamic reports and OLAP analyses. A one of the main goals of this article is to show and verify Business Intelligence tools of Microsoft Dynamics NAV for the support of decision-making in terms of the cross-border online purchasing. Pursuant to above-mentioned, in this article authors deal with problems relating to managers´ decision-making, customers´ decision-making and a support of its using the BI tools contained in ERP system Microsoft Dynamics NAV. A great deal of this article is aimed at area of multidimensional data which are the source data of e-commerce systems.Business Intelligence, decision-making, e-commerce system, cross-border online purchasing, multi-dimensional data, reporting, data visualization

Combining Objects with Rules to Represent Aggregation Knowledge in Data Warehouse and OLAP Systems

Data warehouses are based on multidimensional modeling. Using On-Line Analytical Processing (OLAP) tools, decision makers navigate through and analyze multidimensional data. Typically, users need to analyze data at different aggregation levels (using roll-up and drill-down functions). Therefore, aggregation knowledge should be adequately represented in conceptual multidimensional models, and mapped in subsequent logical and physical models. However, current conceptual multidimensional models poorly represent aggregation knowledge, which (1) has a complex structure and dynamics and (2) is highly contextual. In order to account for the characteristics of this knowledge, we propose to represent it with objects (UML class diagrams) and rules in Production Rule Representation (PRR) language. Static aggregation knowledge is represented in the class diagrams, while rules represent the dynamics (i.e. how aggregation may be performed depending on context). We present the class diagrams, and a typology and examples of associated rules. We argue that this representation of aggregation knowledge allows an early modeling of user requirements in a data warehouse project.Aggregation; Conceptual Multidimensional Model; Data Warehouse; On-line Analytical Processing (OLAP); Production Rule; UML

Computer-Aided Warehouse Engineering (CAWE): Leveraging MDA and ADM for the Development of Data Warehouses

During the last decade, data warehousing has reached a high maturity and is a well-accepted technology in decision support systems. Nevertheless, development and maintenance are still tedious tasks since the systems grow over time and complex architectures have been established. The paper at hand adopts the concepts of Model Driven Architecture (MDA) and Architecture Driven Modernization (ADM) taken from the software engineering discipline to the data warehousing discipline. We show the works already available, outline further research directions and give hints for implementation of Computer-Aided Warehouse Engineering systems

Towards Principles for Structuring and Managing Very Large Semantic Multidimensional Data Models

The management of semantic multidimensional data models plays an important role during the phases of development and maintenance of data warehouse systems. Unfortunately, this is not done with the necessary stress by now. Reasons might be seen in the plethora of semantic notations or the insufficient tool support for multidimensional modeling. The paper on hand provides experiences gained within a project with an industry partner of the telecommunications industry. Their problem is a very huge data warehouse with more than 400 data cubes and several hundred key performance indicators. We developed a repository-based solution for managing the semantic data models. Our lessons learned show that especially for very large data models there has to be a repository based solution as well as a clear concept on how to break them up into their component pars. The aim of our principles is to increase the understandability as well as the maintainability of semantic multidimensional data models