Academic Journal
A semantic approach to automated design and construction of star schemas
| العنوان: | A semantic approach to automated design and construction of star schemas |
|---|---|
| المؤلفون: | Non Sanprasit, Taravichet Titijaroonroj, Kraisak Kesorn |
| المصدر: | Engineering and Applied Science Research, Vol 48, Iss 5, Pp 518-528 (2021) |
| بيانات النشر: | Khon Kaen University, 2021. |
| سنة النشر: | 2021 |
| المجموعة: | LCC:Technology LCC:Technology (General) |
| مصطلحات موضوعية: | semantic approach, knowledge-based, star schema, data warehouse, Technology, Technology (General), T1-995 |
| الوصف: | Designing a star schema is a complex and time-consuming process requiring an expert to perform several tasks such as denormalization, dimension design, and construction of fact tables. This study presents a method to automatically design and generate star schema models, or so-called multidimensional models. We first introduce a method to incorporate a novel knowledge-based framework to enable an automation system to construct dimensional and fact tables as well as measures, which are the key elements of star schema models. The proposed framework provides a capability of column name identification using the arithmetic coding approach and measures identification using a natural language processing framework (NLP), resulting in dimensions and fact tables being constructed automatically without human intervention. Although the current version of our system is limited to reading data from semi-structured datasets such as CSV files and spreadsheets, the experimental results demonstrate that our framework can generate a star schema effectively, and can support online analytical processing (OLAP) operations. The experimental results show that our method is superior to other conventional approaches, achieving 96.67% accuracy for numerical data, higher than any of the prior models used for comparison. |
| نوع الوثيقة: | article |
| وصف الملف: | electronic resource |
| اللغة: | English |
| تدمد: | 2539-6161 2539-6218 |
| Relation: | https://ph01.tci-thaijo.org/index.php/easr/article/download/243602/166480/; https://doaj.org/toc/2539-6161; https://doaj.org/toc/2539-6218 |
| URL الوصول: | https://doaj.org/article/b3bf594d3a4643f8bfa8b3e3f3e57bb3 |
| رقم الانضمام: | edsdoj.b3bf594d3a4643f8bfa8b3e3f3e57bb3 |
| قاعدة البيانات: | Directory of Open Access Journals |
| تدمد: | 25396161 25396218 |
|---|