Bridging Relational Databases to Context-Aware Services

The provision of context-aware services in terms of the anytime/anywhere/anymedia paradigm requires the consideration of certain context properties in terms of time, location, device, or simply the user’s preferences. The specific characteristics of context, comprising among others large amounts of data, frequent and concurrent updates and heterogeneous sources often in terms of XML schemata, demand for an efficient management of context data. Relational databases seem to be a promising key technology for the efficient storage, retrieval, and processing of XML-based context data at the server-side. This is not least since relational databases allow to seamlessly combine context data with existing legacy data, hereby constituting a major advantage compared with native XML databases or object-oriented databases. The focus of this paper is twofold. First, requirements for managing context data are elaborated from a database perspective. Second, based on this, a generic approach called X-Ray, mediating between existing XML-based context and content stored in relational databases, is presented. With this approach, maintainability and changeability of context data is enhanced, since the mapping knowledge is not hard-coded but rather reified within a meta schema. The meta schema allows to automatically compose context data out of the relational database when requested and decompose them when they have to

[1]  Erhard Rahm,et al.  A survey of approaches to automatic schema matching , 2001, The VLDB Journal.

[2]  Mahadev Satyanarayanan,et al.  A conceptual framework for network and client adaptation , 2000, Mob. Networks Appl..

[3]  Philippe Bonnet,et al.  Database tuning principles, experiments, and troubleshooting techniques , 2004, SGMD.

[4]  C. M. Sperberg-McQueen,et al.  eXtensible Markup Language (XML) 1.0 (Second Edition) , 2000 .

[5]  Jim Melton,et al.  SQL/XML is making good progress , 2002, SGMD.

[6]  Moira C. Norrie,et al.  Empowering Databases for Context-Dependent Information Delivery , 2003, CAiSE Workshops.

[7]  Patrick Brézillon,et al.  Modeling and Using Context for System Development: Lessons from Experience , 2001, J. Decis. Syst..

[8]  Gerti Kappel,et al.  X-Ray - Towards Integrating XML and Relational Database Systems , 2000, ER.

[9]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[10]  Jürgen Wäsch,et al.  Tamino - An Internet Database System , 2000, EDBT.

[11]  Roy Goldman,et al.  From Semistructured Data to XML: Migrating the Lore Data Model and Query Language , 1999, Markup Lang..

[12]  Patrick Valduriez,et al.  Principles of distributed database systems (2nd ed.) , 1999 .

[13]  Eric van der Vlist,et al.  XML Schema , 2002 .

[14]  C. M. Sperberg-McQueen,et al.  Extensible Markup Language (XML) , 1997, World Wide Web J..

[15]  Dennis R. Wixon,et al.  Building a user-derived interface , 1984, CACM.

[16]  Albrecht Schmidt,et al.  Situated Interaction and Context-Aware Computing , 2001, Personal and Ubiquitous Computing.

[17]  Gregory D. Abowd,et al.  A Conceptual Framework and a Toolkit for Supporting the Rapid Prototyping of Context-Aware Applications , 2001, Hum. Comput. Interact..

[18]  John Krumm,et al.  Location-aware computing comes of age , 2004, Computer.

[19]  John M. Carroll,et al.  Learning by doing with simulated intelligent help , 1988, CACM.

[20]  John R. Smith,et al.  Adapting Multimedia Internet Content for Universal Access , 1999, IEEE Trans. Multim..

[21]  Reinhard Wilhelm Informatics - 10 Years Back. 10 Years Ahead , 2001, Informatics - 10 Years Back. 10 Years Ahead..

[22]  Knut Stolze,et al.  SQL/MM Spatial - The Standard to Manage Spatial Data in a Relational Database System , 2003, BTW.

[23]  H SchollMarc,et al.  Transactional information systems , 2001 .

[24]  Dan Suciu,et al.  SilkRoute: trading between relations and XML , 2000, Comput. Networks.

[25]  Eugene J. Shekita,et al.  XTABLES: Bridging relational technology and XML , 2002, IBM Syst. J..

[26]  Alfred Kobsa,et al.  Personalised hypermedia presentation techniques for improving online customer relationships , 2001, The Knowledge Engineering Review.

[27]  RahmErhard,et al.  A survey of approaches to automatic schema matching , 2001, VLDB 2001.

[28]  Werner Retschitzegger,et al.  Context-awareness on mobile devices - the hydrogen approach , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[29]  Michael J. Franklin,et al.  Challenges in Ubiquitous Data Management , 2001, Informatics.

[30]  Peter Brusilovsky,et al.  From adaptive hypermedia to the adaptive web , 2002, CACM.

[31]  Christian S. Jensen,et al.  Effective timestamping in databases , 2000, The VLDB Journal.

[32]  Alin Deutsch,et al.  MARS: A System for Publishing XML from Mixed and Redundant Storage , 2003, VLDB.

[33]  Klaus H. Hinrichs,et al.  Managing uncertainty in moving objects databases , 2004, TODS.

[34]  Alois Ferscha,et al.  Context Sensing, Aggregation, Representation and Exploitation in Wireless Networks , 2001, Scalable Comput. Pract. Exp..

[35]  Leonard Kleinrock,et al.  Nomadicity: Anytime, Anywhere in a Disconnected World , 1996, Mob. Networks Appl..

[36]  Gerti Kappel,et al.  Customisation for ubiquitous web applications a comparison of approaches , 2003, Int. J. Web Eng. Technol..

[37]  Ahmad Ashari,et al.  Storing And Querying XML Data Using RDBMS , 2004, iiWAS.

[38]  Scott Boag,et al.  XQuery 1.0 : An XML Query Language , 2007 .

[39]  Gerti Kappel,et al.  Integrating XML and Relational Database Systems , 2004, World Wide Web.

[40]  Gerti Kappel,et al.  Towards a Generic Customisation Model for Ubiquitous Web Applications , 2002 .