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.


Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning

A significant amount of the world's knowledge is stored in relational da...

SQL Query Completion for Data Exploration

Within the big data tsunami, relational databases and SQL are still ther...

Visual Diagrammatic Queries in ViziQuer: Overview and Implementation

Knowledge graphs (KG) have become an important data organization paradig...

Design of Intelligent layer for flexible querying in databases

Computer-based information technologies have been extensively used to he...

Exploring Query Results

Users typically interact with a database by asking queries and examining...

Leveraging Application Data Constraints to Optimize Database-Backed Web Applications

Exploiting the relationships among data, such as primary and foreign key...

A Survey on Visual Query Systems in the Web Era (extended version)

As more and more collections of data are becoming available on the web t...

Please sign up or login with your details

Forgot password? Click here to reset