CALIBER2009

1. An Approach for Generic Information Query Retrieval in Web2.0 Thippeswamy.K Assistant Professor & HOD Dept. Information Science & Engineering R.L.Jalappa Institute of Technology Kodigehalli, Doddaballapura Bangalore Rural District , Karnataka, INDIA Email:- thippeswamy_yadav@yahoo.co.in Hanumanthappa. J Lecturer, Department of Studies, Manasagongotry, Mysore, INDIA Email:- hanums_j@yahoo.co Dr. Manjaiah.D.H. Reader Department of Studies Mangalagangothri, Mangalore, INDIA Email:- ylm321@yahoo.co.in An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

2. Contents • Introduction Web2.0 • Existing System Problems • Proposed System Problems • Information Exchange with Generic Query Retrieval System • Methodologies • Xml schema showing xml representation of relational database • Xml representation of input query • Block Diagram of Generic Query Retrieval Systems • Conclusion • References An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

3. Introduction Web2.0 • Web2.0 • Retrieval and analysis of information • Applications • Data analysis and mining is a major • task in all sectors • Integrate and exchange • Traditional approach An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

4. Existing System Problems • Application to application communication is tightly coupled and requires constants maintenance due to tightly coupled behaviors. • Traditional architecture lacks the ability to be reused and interact with new software. • In the traditional system information exchange and integration becomes a expensive task. An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

5. Proposed Systems • Creation of a loosely coupled query retrieval system • Approach to decompose the application in to services which can operate independently and also consume each other • Client program to access the generic framework services to do perform data analysis with out being dependent on the internal system • Approach to have application to application data communication by different means • Approach to develop a generic client module to communicate with the services. An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

6. Information Exchange with Generic Query Retrieval System DB1 Application 1 Generic Query Retrieval System Dynamic Query Interface DB2 Application 2 DB3 Application 3 An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

7. Methodologies • Generic Query retrieval system • The system can be decomposed to following modules which need to be worked upon to create a loosely coupled system. • Model to represent the underlying relational database in a generic form. • Model to represent the input query. • Model to generate queries based on input conditions and querying, filtering, grouping across databases based on the input query and dispatch the output. • Model to design the service interface to communicate with client application. Continues… An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

8. 2. Relational database representation in XML format • XML format was preferred over the traditional delimiter separated file • An XML schema was design to represent the tables in a database • Address the issue of heterogeneity • The synonym list section contains more than one synonym block which is for displaying the relations between tables An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

9. Xml schema showing xml representation of relational database An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

10. Xml representation of input query An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

11. Block Diagram of Generic Query Retrieval Systems Request interpreter XML File XML Parser Response SQL Constructor SQL Executor Primary key Object Xml Mapping Object JDBC Data Retrieval Sql Creator & Executer DB1 DB2 DB3 An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

12. Conclusion • In this paper we presented an approach and implementation of a generic Information querying retrieval system which can used in web2.0 for querying and analysis with each module being loosely coupled with other. Following the summery of results achieved • Context independent and configurable module design. • Service oriented model design where each module behaves independent of each other • Generic modules to perform querying and analysis on an underlying relational database. • Dynamic query interface module which can be plugged in to any web2.0 based program An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

13. References [1].Jerry R.Hobbs, Artificial Intelligence Center, SRI International, Menlo Park, CA 94025, A Generic Information Extraction System. [2].Ch.Dreier, Generic Data Access in XML-Based LighweightWorkflow Management System, In German., Master’s thesis, University of Klagenfurt, 2005. [3].Eyal Oren, Armin Haller, Manfrad Hauswith, Benjamin Heitmann and Stefan Decker< National University of Ireland, Gateway .Cedric Mesnage, University of Lugano. A Flexible Integration Framework for Semantic Web 2.0 Applications. [4]Ch.Dreier,Generic Data Access in XML-Based LighweightWorkflow Management System,In German., Master’s thesis, University of Klagenfurt, 2005. [5].Amit Sheth and James Larson, “Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases”, ACM Computing Surveys 22(3): 183-236 (1990) An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

14. Acknowledgment I would like to thank the Management, Principal & Staff the Department of Information Science & Engineering, R. L. JalappaInstitute of Technology, Doddaballapura, For their Continues Support. An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009

15. Thank You An Approach for Generic Information Query Retrieval in Web2.0 CALIBER2009