Application of Multidimensional Data Model in the Traffic Accident Data Warehouse

2014 ◽  
Vol 548-549 ◽  
pp. 1857-1861
Author(s):  
Mou Zhong Liu ◽  
Min Sun
Keyword(s):  
Data Mining ◽  
Statistical Analysis ◽  
Data Warehouse ◽  
Data Model ◽  
Traffic Accident ◽  
Multidimensional Data ◽  
Processing Theory ◽  
Accident Data ◽  
Real Time Information ◽  
Time Information

The traffic administrative department would record real-time information of accidents and update the corresponding database when dealing with daily traffic routines. It is of great significance to study and analyze these data. In this paper, we propose a Multi-dimensional Data Warehouse Model (M-DWM) combined with the concept of Data Warehouse and multi-dimensional data processing theory. The model can greatly improve the efficiency for statistical analysis and data mining.

AN ARCHITECTURE FOR DATA WAREHOUSING SUPPORTING DATA INDEPENDENCE AND INTEROPERABILITY

2001 ◽  
Vol 10 (03) ◽  
pp. 377-397 ◽  
Author(s):  
LUCA CABIBBO ◽  
RICCARDO TORLONE
Keyword(s):  
Data Warehouse ◽  
Data Model ◽  
Data Warehousing ◽  
Heterogeneous Data ◽  
Multidimensional Data ◽  
Multidimensional Databases ◽  
Level Of Aggregation ◽  
High Level ◽  
Data Independence ◽  
Logical Architecture

We report on the design of a novel architecture for data warehousing based on the introduction of an explicit "logical" layer to the traditional data warehousing framework. This layer serves to guarantee a complete independence of OLAP applications from the physical storage structure of the data warehouse and thus allows users and applications to manipulate multidimensional data ignoring implementation details. For example, it makes possible the modification of the data warehouse organization (e.g. MOLAP or ROLAP implementation, star scheme or snowflake scheme structure) without influencing the high level description of multidimensional data and programs that use the data. Also, it supports the integration of multidimensional data stored in heterogeneous OLAP servers. We propose [Formula: see text], a simple data model for multidimensional databases, as the reference for the logical layer. [Formula: see text] provides an abstract formalism to describe the basic concepts that can be found in any OLAP system (fact, dimension, level of aggregation, and measure). We show that [Formula: see text] databases can be implemented in both relational and multidimensional storage systems. We also show that [Formula: see text] can be profitably used in OLAP applications as front-end. We finally describe the design of a practical system that supports the above logical architecture; this system is used to show in practice how the architecture we propose can hide implementation details and provides a support for interoperability between different and possibly heterogeneous data warehouse applications.

Data Warehouse and Business Intelligence Systems in the Context of E-HRM

2009 ◽  
pp. 223-229
Author(s):  
Martin Burgard ◽  
Franca Piazza
Keyword(s):  
Data Mining ◽  
Information Technology ◽  
Resource Management ◽  
Human Resource Management ◽  
Data Warehouse ◽  
Human Resource ◽  
Business Intelligence ◽  
Multidimensional Data ◽  
Business Intelligence Systems ◽  
Analytical Processing

The increased use of information technology leads to the generation of huge amounts of data which have to be stored and analyzed by appropriate systems. Data warehouse systems allow the storage of these data in a special multidimensional data base. Based on a data warehouse, business intelligence systems provide different analysis methods such as online analytical processing (OLAP) and data mining to analyze these data. Although these systems are already widely used and the usage is still growing, their application in the area of electronic human resource management (e-HRM) is rather scarce. Therefore, the objective of this article is to depict the components and functionality of these systems and to illustrate the application possibilities and benefits of these systems by selected application examples in the context of e-HRM.

An Envisioned Approach for Modeling and Supporting User-Centric Query Activities on Data Warehouses

2013 ◽  
Vol 9 (2) ◽  
pp. 89-109 ◽  
Author(s):  
Marie-Aude Aufaure ◽  
Alfredo Cuzzocrea ◽  
Cécile Favre ◽  
Patrick Marcel ◽  
Rokia Missaoui
Keyword(s):  
Data Mining ◽  
Knowledge Management ◽  
Information Retrieval ◽  
Query Processing ◽  
Data Warehouse ◽  
Multidimensional Data ◽  
Data Warehouses ◽  
Cooperative Query Answering ◽  
User Centric ◽  
Use Of Knowledge

In this vision paper, the authors discuss models and techniques for integrating, processing and querying data, information and knowledge within data warehouses in a user-centric manner. The user-centric emphasis allows us to achieve a number of clear advantages with respect to classical data warehouse architectures, whose most relevant ones are the following: (i) a unified and meaningful representation of multidimensional data and knowledge patterns throughout the data warehouse layers (i.e., loading, storage, metadata, etc); (ii) advanced query mechanisms and guidance that are capable of extracting targeted information and knowledge by means of innovative information retrieval and data mining techniques. Following this main framework, the authors first outline the importance of knowledge representation and management in data warehouses, where knowledge is expressed by existing ontology or patterns discovered from data. Then, the authors propose a user-centric architecture for OLAP query processing, which is the typical applicative interface to data warehouse systems. Finally, the authors propose insights towards cooperative query answering that make use of knowledge management principles and exploit the peculiarities of data warehouses (e.g., multidimensionality, multi-resolution, and so forth).

scholarly journals Data Warehouse Schemas using Multidimensional Data Model for Retail

2017 ◽  
Vol 2 (1) ◽  
pp. 84
Author(s):  
Kheri Arionadi Shobirin ◽  
Adi Panca Saputra Iskandar ◽  
Ida Bagus Alit Swamardika
Keyword(s):  
Decision Making ◽  
Real Time ◽  
Data Warehouse ◽  
Data Model ◽  
Transaction Processing ◽  
Multidimensional Data ◽  
Complex Query ◽  
On Line ◽  
Analytical Processing ◽  
Operational Data

A data warehouse are central repositories of integrated data from one or more disparate sources from operational data in On-Line Transaction Processing (OLTP) system to use in decision making strategy and business intelligent using On-Line Analytical Processing (OLAP) techniques. Data warehouses support OLAP applications by storing and maintaining data in multidimensional format. Multidimensional data models as an integral part of OLAP designed to solve complex query analysis in real time.

scholarly journals K-Means Clustering untuk Data Kecelakaan Lalu Lintas Jalan Raya di Kecamatan Pelaihari

2018 ◽  
Vol 5 (5) ◽  
pp. 613 ◽  
Author(s):  
Winda Aprianti ◽  
Jaka Permadi
Keyword(s):  
Data Mining ◽  
Traffic Accident ◽  
Traffic Accidents ◽  
Distance Measure ◽  
Data Traffic ◽  
First Aid Training ◽  
Accident Data ◽  
Special Concern ◽  
Clustering Data ◽  
Minor Injuries

<p>Kecelakaan lalu lintas di jalan raya masih menjadi penyumbang tingginya angka kematian di Indonesia, sehingga menjadi perhatian khusus bagi kepolisian di negara ini. Termasuk Kepolisian Resor (Polres) Tanah Laut, yang telah membuktikan perhatian tersebut dengan membentuk komunitas korban kecelakaan lalu lintas dan Pelatihan Pertolongan Pertama Gawat Darurat (PPGD). Tahapan awal pencegahan kecelakaan lalu lintas adalah dengan mengetahui faktor-faktor penyebab kecelakaan lalu lintas yang diperoleh melalui analisa data kecelakaan. Analisa tersebut dapat dilakukan dengan data mining, yaitu <em>K-Means Clustering.</em> <em>K-Means Clustering</em> mengelompokkan data menjadi beberapa <em>cluster</em> sesuai karakteristik data tersebut. Data kecelakaan lalu lintas dibagi menjadi 2 dataset, yakni dataset 1 dan dataset 2. Hasil <em>cluster </em>penerapan <em>K-means clustering </em>terhadap dataset 1 dan dataset 2 kemudian dilakukan pengujian <em>silhoutte coefficient </em>untuk mencari hasil <em>cluster </em>dengan kualitas terbaik<em>. </em>Pengujian <em>silhoutte coefficient</em> secara berurutan menghasilkan <em>distance measure </em>paling optimal yakni <em>clustering </em>dengan 4 <em>cluster</em> untuk dataset 1 dan <em>clustering </em>dengan 2 <em>cluster</em> untuk dataset 2. Selain memperoleh <em>cluster </em>dengan kualitas terbaik, penganalisaan data juga menghasilkan beberapa informasi kecelakaan lalu lintas yang sering terjadi, yakni faktor penyebab dan korban kecelakaan adalah pengemudi, umur korban adalah 9 sampai 28 tahun, dan keadaan korban kecelakaan adalah luka ringan.</p><p> </p><p class="Judul2"><strong><em>Abstract</em></strong></p><p><em>Traffic accidents on the highway are still contribute to the high mortality rate in Indonesia, which are becoming a special concern for the police. Including the Police of Tanah Laut Resort where prove themselves by established The Community of Traffic Accident Victims and Emergency First Aid Training. The first prevention of traffic accidents is knowing the factors causing traffic accidents which is obtained through the analysis of traffic accident’s data. It can be done through data mining, i.e. K-Means Clustering, which is clustering data into clusters according to characteristics of the data. Traffic accident data is divided into two datasets, namely dataset 1 and dataset 2. After obtaining the cluster results, the next step is to calculate silhoutte coefficient which is used to find the best quality cluster result. The result of testing silhoutte coefficient are clustering with 4 clusters for dataset 1 and clustering with 2 clusters for dataset 2. Analyzing data in this research also produces some information on traffic accidents that often occur, namely the causes and victims of accidents are drivers, the age of the victims is between 9 and 28 years old, and the circumstance of the accidents victims are minor injuries.</em></p>

scholarly journals The Clinical Nursing and Midwifery Dashboard (CNMD): A State-Wide Implementation

2021 ◽  
Author(s):  
Ahmad Abdel-Hafez ◽  
Don Baker ◽  
Michelle Winning ◽  
Alan Scanlon
Keyword(s):  
Statistical Analysis ◽  
Risk Assessments ◽  
P Value ◽  
Maternity Unit ◽  
Evaluation Approach ◽  
Clinical Nursing ◽  
Real Time Information ◽  
The Impact ◽  
Time Information ◽  
Completion Times

The clinical nursing and midwifery dashboard (CNMD) was built to provide a near real-time information and data visualisations for nurse unit managers (NUMs) and maternity unit managers (MUMs) within only a 5-15 minutes delay from when they enter data to the integrated electronic medical records (ieMR) system. The dashboard displays metrics and information about current adult inpatients in overnight wards. The aim is to support NUMs and MUMs to manage their daily workload and have continuous visibility of patients nursing risk and safety assessment documentation. A quantitative evaluation approach was conducted to measure the impact of the dashboard on key performance indicators. Statistical analysis was completed to compare risk assessment average completion times prior to and post CNMD implementation. The results of the evaluation were positive, and the statistical analysis shows significant reduction in the average time to complete different risk assessments with p-value<0.01.

scholarly journals Spatial Data Warehouse Modelling

2011 ◽  
pp. 282-300
Author(s):  
Maria Luisa Damiani ◽  
Stefano Spaccapietra
Keyword(s):  
Data Warehouse ◽  
Spatial Data ◽  
Data Model ◽  
Spatial Dimension ◽  
Research Area ◽  
Multidimensional Data ◽  
Spatial Data Warehouse ◽  
Definition Of ◽  
Spatial Data Warehouses ◽  
Current Standards

This chapter is concerned with multidimensional data models for spatial data warehouses. Over the last few years different approaches have been proposed in the literature for modelling multidimensional data with geometric extent. Nevertheless, the definition of a comprehensive and formal data model is still a major research issue. The main contributions of the chapter are twofold: First, it draws a picture of the research area; second it introduces a novel spatial multidimensional data model for spatial objects with geometry (MuSD – multigranular spatial data warehouse). MuSD complies with current standards for spatial data modelling, augmented by data warehousing concepts such as spatial fact, spatial dimension and spatial measure. The novelty of the model is the representation of spatial measures at multiple levels of geometric granularity. Besides the representation concepts, the model includes a set of OLAP operators supporting the navigation across dimension and measure levels.

scholarly journals A Provenance-based Approach to Support Cognitive Training of the Elderly Using Serious Games

2018 ◽  
Author(s):  
Leonardo Nardi ◽  
Daniela Trevisan ◽  
Daniel De Oliveira
Keyword(s):  
Data Mining ◽  
Statistical Analysis ◽  
Cognitive Training ◽  
Data Model ◽  
Cognitive Skills ◽  
Serious Games ◽  
The Elderly ◽  
Training Data ◽  
Computer Based ◽  
Source Of Information

It is a well-known fact that cognitive skills tend to decline in elderly people. There are several approaches that try to reduce the cognitive losses. One of the most prominent is cognitive training through serious games in several game sessions. This paper introduces a data model and a database for storing computer-based cognitive training data. Using this database, researchers have an integrated database that allows for extracting useful information that can be input for statistical analysis and further data mining tasks. In order to evaluate the feasibility of the proposed approach we have performed a statistical analysis on the evaluations of the ”Eye for Detail” game stored in the proposed database. Results reinforced the potential of the database as a rich source of information.

Sign in / Sign up

Export Citation Format

Share Document