Graduate Project
 

Visual SQL analyzer project report

Public Deposited

Contenu téléchargeable

Télécharger le fichier PDF
https://ir.library.oregonstate.edu/concern/graduate_projects/th83m6683

Descriptions

Attribute NameValues
Creator
Abstract
  • Structure Query Language (SQL) is widely used to access data stored in relational database systems. Although a powerful and flexible language, SQL can also be complex and hard to learn. For most new SQL users, it's easy to write SQL statement by following SQL grammar and syntax rules, but it's hard to know if the statement expresses what the user really wants. In most cases, a visual representation can help the user interpret and understand the SQL Statement being represented. An effective graphical representation often conveys a concept immediately and more clearly than a literal explanation. To help new users to learn SQL, we have developed a tool to help them understand the SQL statements, and check if the semantics matches their intentions. For this project we developed a simple Visual SQL Analyzer tool to translate SQL statement into Visual diagrams to show what the database will do with th.is statement, so that the user could understand and confirm their intentions. The implementation of our tool has five tables and ten fields per table limitation and only implements the six most common SQL statements. However, it can be extended. The visual representation used in our project was introduced in the book "A Visual Introduction to SQL", and has been used in other system such as MS SQL Server. our system is the only web_based and free tool.
  • 2001 best estimate for issue date and commencement year based on available information.
Resource Type
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Academic Affiliation
Déclaration de droits
Publisher
Peer Reviewed
Language

Des relations

Parents:

This work has no parents.

Articles

La vignette Titre Date de téléchargement Visibilité actes
file details Li_Xiaoyan_Visual_SQL_Analyzer_Project_Report.pdf 2023-03-27 Public Télécharger