VGU RESEARCH REPOSITORY
Please use this identifier to cite or link to this item:
https://epub.vgu.edu.vn/handle/dlibvgu/952
Title: | Implementation of DBML (database markup language) and product growth for dbdiagram.io (web application) | Authors: | Pham Thi Thanh Thao | Keywords: | Database markup language;Web application;Product growth | Issue Date: | 2019 | Publisher: | Vietnamese-German University | Abstract: | Structured Query Language (SQL) was first introduced in the 1970s and since its birth, it gradually became the standard in the industry to communicate with relational database [1]. After its significant growth, many alternatives were developed to enhance its use for a specific database platform like MySQL or PostgreSQL or Oracle. Nowadays, business analysts and data scientists as well as developers and database administrators are required to have basic knowledge about the use of SQL and being familiarized with the syntax. To design a database of any complexity, one must understand the EntityRelationship modeling tool. Thanks to rapid improvement in browser technology over the past decades, online database modeling tools have been created to put the database design process at ease. Several researches about different online tools such as Lucidchart, Creately, SqlDBM, and Vertabelo were conducted for this paper. The results suggested that there should be a typing code experience for the users to generate diagrams rather than drag-and-drop feature. This paper describes the methodology and technology to build a particular modeling tool that supports writing code called dbdiagram.io and further implementations to help it grow as a product. Besides, most of the SQL languages are suffering a lack of both human-readability and inter-operability, primarily when the systems work on different databases. To close this gap, there is a need to have a Database Markup Language with the ability to offer a standardized, extensible means of involving semantic content within documents. This thesis also gives an outline of Markup Language and an abandoned Database markup Language project called DML. Given the opportunity, a new Database Markup Language called DBML was introduced and well-explained in this thesis. At the time of this thesis, the language can cover basic syntax and will expand more syntax and dialects in future works. The goal of this thesis is to develop DBML to be the standard for the industry to document database design |
URI(1): | http://epub.vgu.edu.vn/handle/dlibvgu/952 | Rights: | Attribution-NonCommercial 4.0 International |
Appears in Collections: | Computer Science (CS) |
Files in This Item:
File | Description | Size | Format | Existing users please Login |
---|---|---|---|---|
Implementation of DBML (database markup language) and product growth for dbdiagram.io (web application).pdf | 2.06 MB | Adobe PDF |
Page view(s)
244
checked on Jun 1, 2024
Download(s)
35
checked on Jun 1, 2024
Google ScholarTM
Check
This item is licensed under a Creative Commons License