Cognitive Visual-learning Environment for PostgreSQL
PostgreSQL is an object-relational database (ORDBMS) that was introduced into
the database community and has been avidly used for a variety of information
extraction use cases. It is also known to be an advanced SQL-compliant open
source Object RDBMS. However, users have not yet resolved to PostgreSQL due to
the fact that it is still under the layers and the complexity of its persistent
textual environment for an amateur user. Hence, there is a dire need to provide
an easy environment for users to comprehend the procedure and standards with
which databases are created, tables and the relationships among them,
manipulating queries and their flow based on conditions in PostgreSQL. As such,
this project identifies the dominant features offered by Postgresql, analyzes
the constraints that exist in the database user community in migrating to
PostgreSQL and based on the scope and constraints identified, develop a system
that will serve as a query generation platform as well as a learning tool that
will provide an interactive environment to cognitively learn PostgreSQL query
building. This is achieved using a visual editor incorporating a textual editor
for a well-versed user. By providing visually-draggable query components to
work with, this research aims to offer a cognitive, visual and tactile
environment where users can interactively learn PostgreSQL query generation.