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

وصف كامل

محفوظ في:
التفاصيل البيبلوغرافية
المؤلف الرئيسي: Chua, Ming Kiang
مؤلفون آخرون: Sourav S Bhowmick
التنسيق: Final Year Project
اللغة:English
منشور في: Nanyang Technological University 2023
الموضوعات:
الوصول للمادة أونلاين:https://hdl.handle.net/10356/171972
الوسوم: إضافة وسم
لا توجد وسوم, كن أول من يضع وسما على هذه التسجيلة!
id sg-ntu-dr.10356-171972
record_format dspace
spelling sg-ntu-dr.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
institution Nanyang Technological University
building NTU Library
continent Asia
country Singapore
Singapore
content_provider NTU Library
collection DR-NTU
language English
topic Engineering::Computer science and engineering::Information systems::Database management
spellingShingle Engineering::Computer science and engineering::Information systems::Database management
Chua, Ming Kiang
Visualizing real-world relational database schema
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.
author2 Sourav S Bhowmick
author_facet Sourav S Bhowmick
Chua, Ming Kiang
format Final Year Project
author Chua, Ming Kiang
author_sort Chua, Ming Kiang
title Visualizing real-world relational database schema
title_short 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_sort visualizing real-world relational database schema
publisher Nanyang Technological University
publishDate 2023
url https://hdl.handle.net/10356/171972
_version_ 1783955523570237440