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

全面介紹

Saved in:
書目詳細資料
主要作者: Chua, Ming Kiang
其他作者: Sourav S Bhowmick
格式: Final Year Project
語言:English
出版: Nanyang Technological University 2023
主題:
在線閱讀:https://hdl.handle.net/10356/171972
標簽: 添加標簽
沒有標簽, 成為第一個標記此記錄!
實物特徵
總結: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.