Visualizing real-world relational database schema

• Main Author: Chew, Yee Hian
• Other Authors: Sourav S Bhowmick
• Format: Final Year Project
• Language: English
• Published: Nanyang Technological University 2022
• Subjects: Engineering::Computer science and engineering::Information systems::Database management
• Online Access: https://hdl.handle.net/10356/156638
• Institution: Nanyang Technological University

Relational databases are prevalent in almost every industry. Formulating Structured Query Language (SQL) queries for data of interest can be challenging when relational databases grow to become large and complex. The database schema provides information to help with the queries, but the information provided is overly dense and complicated to be used efficiently in large databases, that can contain tens to hundreds of relations and tables having hundreds of attributes. As such, a better way of data visualization is needed, especially so in a world today filled with Big Data. To solve the problem of information overload in database schemas, abstraction is key. Visualization of such database schemas requires much selection on what information to be displayed on the screen. It is important to balance the amount of information displayed while maintaining the visual’s usability. A web application is developed in this project to selectively visualize information of database schemas. The application should serve to facilitate easier SQL queries in real world large databases.