Path: Top -> Journal -> Telkomnika -> 2014 -> Vol 12, No 2: June

An Approach for Automatically Generate Star Schema from Natural Language

An Approach for Automatically Generate Star Schema from Natural Language

Journal from gdlhub / 2016-11-12 07:41:38
Oleh : Rosni Lumbantoruan, Elisa Margareth Sibarani, Monica Verawati Sitorus, Ayunisa Mindari, Suhendrowan Putra Sinaga, Telkomnika
Dibuat : 2014-06-01, dengan 1 file

Keyword : star schema, user business key, parsing process, fact table, dimensional table
Url : http://journal.uad.ac.id/index.php/TELKOMNIKA/article/view/63

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.

Deskripsi Alternatif :

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.

Beri Komentar ?#(0) | Bookmark

PropertiNilai Properti
ID Publishergdlhub
OrganisasiTelkomnika
Nama KontakHerti Yani, S.Kom
AlamatJln. Jenderal Sudirman
KotaJambi
DaerahJambi
NegaraIndonesia
Telepon0741-35095
Fax0741-35093
E-mail Administratorelibrarystikom@gmail.com
E-mail CKOelibrarystikom@gmail.com

Print ...

Kontributor...

  • , Editor: sukadi

Download...

  • Download hanya untuk member.

    63-67-1-PB
    Download Image
    File : 63-67-1-PB.pdf

    (148915 bytes)