Logo

Transformation from Web Pages to Optimal Normal Form Database Schema Using a Conceptual Schema Approach

Yuliana, Oviliani Yenty and Chittayasothorn, Suphamit (2021) Transformation from Web Pages to Optimal Normal Form Database Schema Using a Conceptual Schema Approach. [UNSPECIFIED]

[img] PDF
Download (332Kb)
    [img] PDF
    Download (1858Kb)

      Abstract

      Web pages and their embedded documents are a good source of information. However, issuing complex queries directly on web pages using direct pattern-matching techniques are challenging tasks that require lengthy procedural programming. Also, programmers working directly on web pages are in charge of the search path and routing, which depend on individual document structures and affect the correctness, completeness, and performance of the results. In contrast, relational databases are well-structured and backed by mathematical principles. Well-designed relational database structures are known to be anomalies-free. The standard relational database language, SQL, is a non-procedural language that defines the required results precisely. Query results are both correct and complete. Performance issues are handled by intelligent query optimizers employed by modern-day Database Management System (DBMS). This paper suggests an approach that transforms documents embedded on web pages in HTML format to corresponding relational database structures and populations. Functional dependencies (FDs) and multi-valued dependencies (MVDs) obtained from documents on the webpages are used to construct conceptual schema diagrams, which are further transformed into the Optimal Normal Form (ONF) relational database structures. In this research project, the Object Role Model (ORM) conceptual schema model is employed. The paper discusses the ORM and the rationales behind its usage. The detection of FDs and MVDs from webpage documents and the technical properties of the ONF relational database structures. Illustrated examples are also provided.

      Item Type: UNSPECIFIED
      Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
      Divisions: Graduate Program > Economic Management
      Depositing User: Admin
      Date Deposited: 29 Jul 2021 02:05
      Last Modified: 02 Aug 2021 01:41
      URI: https://repository.petra.ac.id/id/eprint/19138

      Actions (login required)

      View Item