Sunday 26 October 2014

Hello World from KuttyPayan

KuttyPayan's initial Hello World module will be a designed for basic CURD operation for the given database. the basic CURD operation may be selecting all contents from a table or collection, selecting a limited contents from a table, updating a content from a table or collection, deleting a record from a table or collection.

The initial UI will be just a text box for the user to type for a basic SQL like queries but actually not a complete query, rather the query which is being used by humans that should fall under a specific or predefined schema

e.g. "select employeetable",  "read employeetable", "open employeetable", "search employeetable".

The above query falls under the schema - "select_action table_name". All the above 4 statements refers to selecting the table - employeetable. This literally means selecting all records from table-employee i.e. (select * from dbo.employeetable - the relevant SQL query).

All the above select, read, open and search phrases refers to the same action word - select in English. The Hello World module of KP will understand the synonymical action words from the list of predefined schemas and performs the corresponding CURD operation.

Sample word list with CURD mappings

select, search, open, read - select
edit, update, modify, alter - update
create, new, make, construct - create
delete, clear, destroy, exclude - delete

The application will be using supervised learning methodology to understand the associated meaning for the given action word from the query. Later un supervised learning with prediction algorithm will be used to understand the meaning and perform the required action.

Welcome to KuttyPayan

Kutty Payan means a small kid in Tamil language. The ultimate aim of the project is to build an AI Application Assistant which will understand your application and aid you doing simple task against your application. Kutty Payan (KP) will understand application specific queries using a bit of Natural Language Processing techniques and help you out performing the query with minimal or less user interaction - the process will follow a bit of Gamification techniques  to make the application rich and interactive user experience.

KP will understand your application in both Database and Application levels to aid users easing the complex and time consuming tasks in a simple and interactive way. The assistance will keep on learn day to day along with the application usage makes it to become a proactive tool to help users to aid in an intellectual way. Initially KP will be under a supervised learning model until it becomes a full fledged tool kit to help users in a real situation.

KP development has been started with .NET with MongoDB - NoSql database uses ,NET MongoDB driver for connectivity.