Enhanced Query-By-Object Approach for Information Requirement Elicitation in Large Databases

  • Ammar Yasir
  • Mittapally Kumara Swamy
  • Polepalli Krishna Reddy
  • Subhash Bhalla
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7678)


Information Requirement Elicitation (IRE) recommends a framework for developing interactive interfaces, which allow users to access database systems without having prior knowledge of a query language. An approach called ‘Query-by-Object’ (QBO) has been proposed in the literature for IRE by exploiting simple calculator like operations. However, the QBO approach was proposed by assuming that the underlying database is simple and contains few tables of small size. In this paper, we propose an enhanced QBO approach called Query-by-Topics (QBT), for designing calculator like user interfaces for large databases. We use methodologies for clustering database entities and discovering topical structures to represent objects at a higher level of abstraction. The QBO approach is then enhanced to allow users to query by topics (QBT). We developed a prototype system based on QBT and conducted experimental studies to show effectiveness of the proposed approach.


User Interfaces Information Systems Information Requirement Elicitation Query-by-Object 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Sun, J.: Information requirement elicitation in mobile commerce. Communications of the ACM 46(12) (2003)Google Scholar
  2. 2.
    Akiyama, T., Watanobe, Y.: An advanced search interface for mobile devices. In: HCCE 2012 (2012)Google Scholar
  3. 3.
    Rahman, S.A., Bhalla, S., Hashimoto, T.: Query-by-object interface for information requirement elicitation in m-commerce. International Journal of Human Computer Interaction 20(2) (2006)Google Scholar
  4. 4.
    Nemoto, K., Watanobe, Y.: An advanced search system for learning objects. In: HC 2010 (2010)Google Scholar
  5. 5.
    Jagadish, H.V., Chapman, A., Elkiss, A., Jayapandian, M., Li, Y., Nandi, A., Yu, C.: Making database systems usable. In: SIGMOD 2007 (2007)Google Scholar
  6. 6.
    Yu, C., Jagadish, H.V.: Querying complex structured databases. In: VLDB 2007. VLDB Endowment (2007)Google Scholar
  7. 7.
    Yang, X., Procopiuc, C.M., Srivastava, D.: Summarizing relational databases. Proc. VLDB Endow. (2009)Google Scholar
  8. 8.
    Wu, W., Reinwald, B., Sismanis, Y., Manjrekar, R.: Discovering topical structures of databases. In: SIGMOD 2008 (2008)Google Scholar
  9. 9.
    Choobineh, J., Mannino, M.V., Tseng, V.P.: A form-based approach for database analysis and design. Commun. ACM (1992)Google Scholar
  10. 10.
    Jayapandian, M., Jagadish, H.V.: Automating the design and construction of query forms. IEEE Trans. on Knowl. and Data Eng. (2009)Google Scholar
  11. 11.
    Qin, L., Yu, J.X., Chang, L.: Keyword search in databases: the power of rdbms. In: SIGMOD 2009 (2009)Google Scholar
  12. 12.
    Nandi, A., Jagadish, H.V.: Guided interaction: Rethinking the query-result paradigm. PVLDB (2011)Google Scholar
  13. 13.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal (2001)Google Scholar
  14. 14.
    Lund, A.: Measuring usability with the use questionnaire. Usability and User Experience Special Interest Group 8(2) (October 2001)Google Scholar
  15. 15.
    Borges, C.R., Macías, J.A.: Feasible database querying using a visual end-user approach. In: EICS 2010 (2010)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Ammar Yasir
    • 1
  • Mittapally Kumara Swamy
    • 1
  • Polepalli Krishna Reddy
    • 1
  • Subhash Bhalla
    • 2
  1. 1.Center for Data EngineeringInternational Institute of Information Technology-HyderabadHyderabadIndia
  2. 2.Graduate School of Computer Science and EngineeringUniversity of AizuFukushimaJapan

Personalised recommendations