Source author record

Girish Sundaram

Girish Sundaram appears in the imported research catalog. Authorship, coauthor and topic links are available while profile ownership is still unclaimed.

ResearcherUnclaimed source record

Catalog footprint

What is connected

5works
4topics
4close collaborators

Actions

Connect this record

Log in to claim

Research graph

See the researcher in context

Open full explorer

Inspect adjacent papers, topics, institutions and collaborators without losing the researcher page.

Building this map preview

BZPEER is loading the nearby papers, people, topics and institutions for this page.

Published work

5 published item(s)

preprint2016arXiv

Deriving Application Level Relationships by Analysing the Run Time Behaviour of Simple and Complex SQL Queries

This paper describes a unique approach to perform application behavioral analysis for identifying how tables might be related to each other. The analysis techniques are based on the properties of primary and foreign keys and also the data present in their respective columns. We have also implemented the idea using JAVA and presented experimental results in Demo Section.This paper introduces a unique approach to predict the possible application level relationships in databases with the help of the application relationship analysis of simple and complex SQL queries. Complex SQL queries are those which contain multiple constraints at different levels of the database. In the process of deriving relations, we first parse the SQL statements and then analyse the parsed information to extract related information.

preprint2013arXiv

Application Behavior Enforcement Based On Network Characteristics

Every device defines the behavior of various applications running on it with the help of user profiles or settings. What if a user wants different different applications to run in different different networks. Then he cannot do this because in todays existing operating systems the application profile, user specific tool settings and any such system usage settings do not consider the current network characteristics of the user or system and are therefore static in nature.Therefore there is a need for an intelligent system which will dynamically change or apply changes to the settings of various applications running on the system considering the current network characteristics based on user specifications. This paper presents an idea such that a user can set different different applications in different different networks.This paper presents how the user will get pop up messages when he visits to safe web sites. And according to the users current network status he will get a pop up message when he will go for download or stream audio or video files.

preprint2013arXiv

Just In Time Indexing

One of the major challenges being faced by Database managers today is to manage the performance of complex SQL queries which are dynamic in nature. Since it is not possible to tune each and every query because of its dynamic nature, there is a definite possibility that these queries may cause serious database performance issues if left alone. Conventional indexes are useful only for those queries which are frequently executed or those columns which are frequently joined in SQL queries. This proposal is regarding a method, a query optimizer for optimizing database queries in a database management system. Just In Time(JIT) indexes are On Demand, temporary indexes created on the fly based on current needs so that they would be able to satisfy any kind of queries. JIT indexes are created only when the configured threshold values for resource consumption are exceeded for a query. JIT indexes will be stored in a temporary basis and will get replaced by new JIT indexes in course of time. The proposal is substantiated with the help of experimental programs and with various test cases. The idea of parallel programming is also brought into picture as it can be effectively used in a multiprocessor system. Multiple threads are employed while one set of threads proceed in the conventional way and the other set of threads proceed with the proposed way. A live switch over is made when a suitable stage is reached and from then onwards the proposed method will only come into picture.

preprint2013arXiv

Privatizing user credential information of Web services in a shared user environment

User credentials security is one of the most important tasks in Web World. Most Web sites on the Internet that support user accounts store the users credentials in a database. Now a days, most of the web browsers offer auto login feature for the favorite web sites such as yahoo, google, gmail etc. using these credential information. This facilitates the misuse of user credentials. Privatizing user credential information of web services in a shared user environment provides a feature enhancement where the root user will be able to privatize his stored credentials by enforcing some masking techniques such that even a user logs on to the system with root user credentials, he will not be able to access privatized data. In case of web browsers auto login feature, a root user can disable the feature manually by deleting entries from web browsers' saved password list. But this involves spending a considerable amount of time and the biggest problem is that he has to insert those credentials once again when he next visits these websites. This application resumes auto login feature whenever root user disable the masked mode. The application includes two parts: Masked Application Mode and Disabling the Masked Application Mode. When the system goes for masked application mode, the other user will not be able to use the credentials of the root user.If the other user tries to access any of the web pages which have been masked, the other user will have to authenticate with his own credentials. Disabling the masked mode requires authentication from the root user. As long as this credential is not shared, masked mode can be disabled only by the root user.

preprint2013arXiv

System and Methods for Converting Speech to SQL

This paper concerns with the conversion of a Spoken English Language Query into SQL for retrieving data from RDBMS. A User submits a query as speech signal through the user interface and gets the result of the query in the text format. We have developed the acoustic and language models using which a speech utterance can be converted into English text query and thus natural language processing techniques can be applied on this English text query to generate an equivalent SQL query. For conversion of speech into English text HTK and Julius tools have been used and for conversion of English text query into SQL query we have implemented a System which uses rule based translation to translate English Language Query into SQL Query. The translation uses lexical analyzer, parser and syntax directed translation techniques like in compilers. JFLex and BYACC tools have been used to build lexical analyzer and parser respectively. System is domain independent i.e. system can run on different database as it generates lex files from the underlying database.