Visualizing real-world relational database schema
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...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Final Year Project (FYP) |
| Language: | English |
| Published: |
Nanyang Technological University
2022
|
| Subjects: | |
| Online Access: | https://hdl.handle.net/10356/156638 |
| _version_ | 1826123882716725248 |
|---|---|
| author | Chew, Yee Hian |
| author2 | Sourav S Bhowmick |
| author_facet | Sourav S Bhowmick Chew, Yee Hian |
| author_sort | Chew, Yee Hian |
| collection | NTU |
| description | 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. |
| first_indexed | 2024-10-01T06:11:55Z |
| format | Final Year Project (FYP) |
| id | ntu-10356/156638 |
| institution | Nanyang Technological University |
| language | English |
| last_indexed | 2024-10-01T06:11:55Z |
| publishDate | 2022 |
| publisher | Nanyang Technological University |
| record_format | dspace |
| spelling | ntu-10356/1566382022-04-21T08:03:42Z Visualizing real-world relational database schema Chew, Yee Hian 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 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. Bachelor of Business Bachelor of Engineering (Computer Science) 2022-04-21T08:03:42Z 2022-04-21T08:03:42Z 2022 Final Year Project (FYP) Chew, Y. H. (2022). Visualizing real-world relational database schema. Final Year Project (FYP), Nanyang Technological University, Singapore. https://hdl.handle.net/10356/156638 https://hdl.handle.net/10356/156638 en application/pdf Nanyang Technological University |
| spellingShingle | Engineering::Computer science and engineering::Information systems::Database management Chew, Yee Hian 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/156638 |
| work_keys_str_mv | AT chewyeehian visualizingrealworldrelationaldatabaseschema |