1 / 17

A Free-Form Database Query Language for Mobile Phones

A Free-Form Database Query Language for Mobile Phones. Kevin Pheasey. Presentation Overview. Introduction Related Work How the language was implemented Main concepts of query language Test. Current Limits.

tayten
Download Presentation

A Free-Form Database Query Language for Mobile Phones

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Free-Form Database Query Language for Mobile Phones Kevin Pheasey

  2. Presentation Overview • Introduction • Related Work • How the language was implemented • Main concepts of query language • Test

  3. Current Limits • Majority of the database querying systems developed for mobile access are for use on PDAs • The systems only provide minimal querying capabilities • Mostly pre-determined queries limits the use

  4. To Be Successful • Support for different types of queries as well as unplanned queries • Use Minimal Resources • Be easy to use given the restricted screen size

  5. Related Work • Current query languages are restricted by the domain of the application • Hung and Zhang telemedicine system • Kobayashi and Paungma transportation system

  6. Menu Structure • Systems cannot be put on a mobile phone because of a complex menu structure • Study shows users prefer direct input opposed to a menu system • Menus are acceptable on a PDA where a stylus is used • Polyviou, Samaras and Evripidou implemented a directory like interface

  7. Relational Query Types • Survey of 45 students • Created 3 queries each of a University database • Unplanned queries still conformed to the relational level of query expressiveness

  8. Universal Relation • A relation that contains all other relations (universal) • Different attributes must have different names and the same attribute must have the same name in every relation it‘s present • Useful in the normalization process • Reduces terms in query formation

  9. Schema Based Approach • Lack of foreign keys • Use of precise terms • Minimal term ambiguity

  10. Summary of Query Interpretation • Relation names denote all attributes will be displayed • Attribute name denotes the attribute will be displayed • Conditions only in a query denote that all attributes of the first relation tested will be displayed

  11. Sample Queries • STUDENT SUBJECT • SUBJECT.name STAFF.name • SUBJECT STAFF.name • STAFF.ID=112971 SUBJECT.crhr>3

  12. Prototype • Prototype developed on Java phone emulator • Interface is drop down menus • interface for small devices should be simple and use as many as possible high-level APIs • Created on Nokia 6681

  13. Testing • Part 1 • Pre-determined queries, allowed to ask for help • Part 2 • Custom queries, allowed to ask for help • Part 3 • Custom queries, no help, rated • Part 4 • Pre-determined queries, no help, rated

  14. Effectiveness Groups’ Overall Effectiveness Scores Query Types’ Overall Effectiveness Scores

  15. Conclusion • Creating a free-form query language for mobile devices is possible • Free-form language eliminates the need for Join and simplifies the number of query inputs • Usability tests show the language is effective

  16. ?

  17. Source • Rohiza Ahmad, Sameem Abdul-Kareem, "A Free-Form Database Query Language for Mobile Phones," 2009 WRI International Conference on Communications and Mobile Computing, January 2009, 279-284.

More Related