An Approach for Automatically Generating Star Schema from Natural Language
Abstract: The star schema is a
form of data warehouse modelling, which acts primary storage for dimensional
data that enables efficient retrieval of business information for decision
making. Star schemas can be generated from business needs that we refer to as a
user business key or from a relational schema of the operational system. There
are many tools available to automatically generate star schema from relational
schema, such as BIRST and SAMSTAR; however, there is no application that can
automatically generate it from a user business key that is represented in the
form of human language. In this paper, we offered an approach for automatically
generating star schema from user business key(s). It begins by processing the
user business key using a syntactical parsing process to identify noun words.
Those identified words will be used to generate dimension table candidates and
a fact table. The evaluation result indicates that the tool can generate star
schema based on the inputted user business key(s) with some limitations in that
the star schema will not be formed if the dimensional tables do not have a
direct relationship.
Author: Rosni Lumbantoruan,
Elisa Margareth Sibarani, Monica Verawaty Sitorus, Ayunisa Mindari, Suhendrowan
Putra Sinaga
Journal Code: jptkomputergg140063
Artikel Terkait :
Jp Teknik Komputer gg 2014
- Research on Keyhole Diameter’s Vision Measurement Based on Parallel Technology
- Strain Transfer and Test Research of Stick-up Fiber Bragg Grating Sensors
- Matrix Mask Overlapping and Convolution Eight Directions for Blood Vessel Segmentation on Fundus Retinal Image
- Application Status of the Barkhausen Effect in Nondestructive Testing
- The New Complex-Valued Wavelet Neural Network
- A Review of Current Control Strategy for Single-Phase Grid-Connected Inverters
- Wireless Power Transfer by Using Solar Energy
- One-Time Password Implementation on Lego Mindstorms NXT
- Simple HAWT Prototype Efficiency at Small Scale Wind Speed
- Combine Target Extraction and Enhancement Methods to Fuse Infrared and LLL Images
- Batik Image Retrieval Based on Color Difference Histogram and Gray Level Co-Occurrence Matrix
- A Novel Part-of-Speech Set Developing Method for Statistical Machine Translation
- A Different Single-Phase Hybrid Five-Level Voltage-Source Inverter Using DC-Voltage Modules
- Multi Population Evolutionary Programming Approach for Distributed Generation Installation
- Failure Mechanism Analysis and Failure Number Prediction of Wind Turbine Blades
- Searching and Visualization of References in Research Documents
- Self-learning PID Control for X-Y NC Position Table with Uncertainty Base on Neural Network
- Adaptive Control of Space Robot Manipulators with Task Space Base on Neural Network
- Planar Finger-Shaped Antenna Used in Ultra-Wideband Wireless Systems
- Information Interchange Layer based on Classification of Information Use (IU)
- A Novel Multi-focus Image Fusion Method Based on Non-negative Matrix Factorization
- A Decision Tree Based on Spatial Relationships for Predicting Hotspots in Peatlands
- Traveling-Wave-Based Fault Location in Electrical Distribution Systems with Digital Simulations
- Multi-focus Image Fusion with Sparse Feature Based Pulse Coupled Neural Network
- Measuring Information Security Awareness of Indonesian Smartphone Users