The main focus of our work is to develop, apply and assess cheminformatics tools and methods. In particular, we focus on the following three areas: Integration of open source tools with application to drug discovery, usability studies to assess the efficacy of these software tools and finally, developing novel techniques for database query. Rapid globalization in the present time has sparked a need in the scientific community to interact with each other at an economic and a fast pace. This is achieved by developing and sharing open source databases using World Wide Web. A web based open source database application has been developed to incorporate freeware from varied sources. The deployment of developed database and user interface in a university lab setting is discussed. To aid in connecting the end user and the software tools, usability studies are necessary. These studies communicate the end users’ needs and desires, resulting in a user-friendly and more powerful interactive software packages. Usability studies were conducted on developed database student application and on different drawing packages to determine their effectiveness. Developing new and interactive search engines to query publicly available databases helps researchers work more efficiently. The huge volume of data available and its heterogeneous nature presents issues related to querying, integration and presentation. In aiding the retrieval process, an innovative multi faceted classification system, called ChemFacets, is developed. This system provides dynamic categorization of large result sets retrieved from multiple databases.