Visualizing real-world relational database schema
Relational databases are important in data storage, management, and retrieval. Understanding the schema is paramount to effectively leverage such databases, especially in formulating optimized Structured Query Language (SQL) queries. However, as data grows in this digital age, real-world datab...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Final Year Project (FYP) |
| Language: | English |
| Published: |
Nanyang Technological University
2023
|
| Subjects: | |
| Online Access: | https://hdl.handle.net/10356/171972 |
| _version_ | 1826113690604142592 |
|---|---|
| author | Chua, Ming Kiang |
| author2 | Sourav S Bhowmick |
| author_facet | Sourav S Bhowmick Chua, Ming Kiang |
| author_sort | Chua, Ming Kiang |
| collection | NTU |
| description | Relational databases are important in data storage, management, and retrieval.
Understanding the schema is paramount to effectively leverage such databases,
especially in formulating optimized Structured Query Language (SQL) queries.
However, as data grows in this digital age, real-world databases are expanding
correspondingly to keep up, often encompassing dozens to hundreds of relations, each
potentially having hundreds of attributes. Such complexity poses a significant
challenge for users to navigate the database schema effectively to pose queries. This
research delves into potential methods to enhance visualization techniques. It focuses
on balancing better visual representation, features, and information to provide a
holistic yet clear view of the database schema. |
| first_indexed | 2024-10-01T03:27:21Z |
| format | Final Year Project (FYP) |
| id | ntu-10356/171972 |
| institution | Nanyang Technological University |
| language | English |
| last_indexed | 2024-10-01T03:27:21Z |
| publishDate | 2023 |
| publisher | Nanyang Technological University |
| record_format | dspace |
| spelling | ntu-10356/1719722023-11-24T15:36:59Z Visualizing real-world relational database schema Chua, Ming Kiang Sourav S Bhowmick School of Computer Science and Engineering ASSourav@ntu.edu.sg Engineering::Computer science and engineering::Information systems::Database management Relational databases are important in data storage, management, and retrieval. Understanding the schema is paramount to effectively leverage such databases, especially in formulating optimized Structured Query Language (SQL) queries. However, as data grows in this digital age, real-world databases are expanding correspondingly to keep up, often encompassing dozens to hundreds of relations, each potentially having hundreds of attributes. Such complexity poses a significant challenge for users to navigate the database schema effectively to pose queries. This research delves into potential methods to enhance visualization techniques. It focuses on balancing better visual representation, features, and information to provide a holistic yet clear view of the database schema. Bachelor of Engineering (Computer Science) 2023-11-20T02:20:15Z 2023-11-20T02:20:15Z 2023 Final Year Project (FYP) Chua, M. K. (2023). Visualizing real-world relational database schema. Final Year Project (FYP), Nanyang Technological University, Singapore. https://hdl.handle.net/10356/171972 https://hdl.handle.net/10356/171972 en SCSE22-0783 application/pdf application/octet-stream Nanyang Technological University |
| spellingShingle | Engineering::Computer science and engineering::Information systems::Database management Chua, Ming Kiang Visualizing real-world relational database schema |
| title | Visualizing real-world relational database schema |
| title_full | Visualizing real-world relational database schema |
| title_fullStr | Visualizing real-world relational database schema |
| title_full_unstemmed | Visualizing real-world relational database schema |
| title_short | Visualizing real-world relational database schema |
| title_sort | visualizing real world relational database schema |
| topic | Engineering::Computer science and engineering::Information systems::Database management |
| url | https://hdl.handle.net/10356/171972 |
| work_keys_str_mv | AT chuamingkiang visualizingrealworldrelationaldatabaseschema |