A Conceptual Schema Based XML Schema with Integrity Constraints Checking

Yuliana, Oviliani Yenty; Chittayasothorn, Suphamit

doi:10.1109/ichit.2008.271

Cited by 4 publications

(4 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Reference [8], whose major objective is to reengineer poorly designed XML Schemas into the normalized ones, also employs the NIAM as the conceptual schema model of XML databases. 4) CM [9] In [9], an XML conceptual schema is presented using the ORM conceptual model. The authors focus on constraints and derivation rules.…”

Section: Previous Workmentioning

confidence: 99%

A survey to conceptual modeling for XML

Chen

Liao

2010

2010 3rd International Conference on Computer Science and Information Technology

View full text Add to dashboard Cite

XML has become the de facto standard for representing and interchanging information in web-based applications. And conceptual modeling approaches, such as EER and UML, have been widely applied to illustrating data structure and relationships in traditional database. However, there is no standard methodology for designing XML data at conceptual leveI. In this paper, we give a survey to conceptual modeling for XML in terms of the basic models they employ.Most of them are based on well-established conceptual models. Some novel conceptual models are proposed to capture the hierarchical structure of XML. A set of requirements for a good conceptual models for XML are concluded. In particular, we emphasize the two phases modeling methodology and the importance of data semantics.

show abstract

Section: Previous Workmentioning

confidence: 99%

A survey to conceptual modeling for XML

Chen

Liao

2010

2010 3rd International Conference on Computer Science and Information Technology

View full text Add to dashboard Cite

show abstract

“…Research on ETL to extract and transform other semi-structured data, such as XML as a language for data interchange, into relational databases have been conducted, e.g., [7,8]. However, the ETL to extract and transform semi-structured, i.e., XML data, into the optimal normal-schema database using the conceptual schema approach were conducted by [9][10][11]. With the internet of things in Industry 4.0, more and more data/information will be published on the internet.…”

Section: Introductionmentioning

confidence: 99%

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

Yuliana

Chittayasothorn

2021

2021 7th International Conference on Engineering, Applied Sciences and Technology (ICEAST)

Self Cite

View full text Add to dashboard Cite

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 modernday 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.

show abstract

“…XML Schemas design using the Object-Role Modeling (ORM) as its conceptual schema are conducted by [2,3,4]. In addition, [4] captured all of ORM constraints that are still not defined in [1] and used XQueries to detect invalid constraints in XML Databases.…”

Section: Introductionmentioning

confidence: 99%

“…In addition, [4] captured all of ORM constraints that are still not defined in [1] and used XQueries to detect invalid constraints in XML Databases. Furthermore, [5] proposed reengineering the existing XML Databases using a conceptual schema approach.…”

Section: Introductionmentioning

confidence: 99%