the process of handling context-based rules, and to
this end, we need a DE (domain expert) to define the
rules according to the application domain; we work
with standard SQL, so there is no need to change the
internal algorithm of the underlying relational
DBMS; we accomplish query rewriting by means of
query expansion, formatting and relaxation
according to specific acquired context on the fly.
6 CONCLUSIONS AND FUTURE
WORK
In data-oriented applications, the context
surrounding queries and users are rather important to
produce answers with more relevance. In this work,
we have presented the CORE approach, which uses
context information to personalize user queries
submitted in data-oriented applications. The CORE
approach is accomplished by means of query
expansion, relaxation and formatting in accordance
with the acquired context. Directives and SQL
specific clauses are generated to this end.
Experiments carried out with real users have
shown that query answers have become more
relevant when the context has been considered to
rewrite the original query and produce another one.
Some limitations were observed in our approach,
namely: (i) The DE needs to be an experienced
person in the application domain in order to create
and maintain the context-based rules. If the rules are
poorly designed, the process of query rewriting
produces a query that may return less relevant
answers; (ii) The CORE approach is based on the
SQL 92 standard; (iii) Also, it does not perform
optimization operations on the original submitted
query nor on the rewritten query.
As further work, we intend to proceed with some
extensions in order to deal with these mentioned
limitations.
REFERENCES
Amo, S. and Pereira, F. Evaluation of conditional
preference queries. Journal of Information and Data
Management (JIDM). p. 521–536, 2010.
Andreou, A. Ontologies and query expansion. Master’s
thesis, University of Edin-burgh, 2005.
ANSI. Standard SQL 92 Available at:
<http://www.ansi.org/>. Accessed on: December, 15,
2014.
Dey, A. Understanding and Using Context. Personal and
Ubiquitous Computing Journal, p. 4-7, 2001.
Godfrey, P. Gryz, J. A framework for intensional query
optimization. Workshop on Deductive Databases and
Logic Programming, Germany, p. 57–68, 1996.
Ines, F. Habib, O. An ontological approach for SQL query
expansion. 2012 International Conference on
Information Technology and e-Services (ICITeS), p.
24-26, 2012.
JbossDrools. Available at <http://www.jboss.org/drools/>.
Accessed on December, 29, 2014.
Kostadinov, D., Bouzeghoub, M. e Lopes, S. Query
Rewriting Based on User's Profile Knowledge. In O.
Boucelma, M.-S. Hacid, T. Libourel & J. M. Petit
(eds.), BDA, 2007.
Koutrika, G. and Ioannidis, Y. Personalized Queries under
a Generalized Preference Model. 21st Intl. Conf. On
Data Engineering, Tokyo, p. 841-852, 2005.
Levandoski J. J., Mokbel M. F., and Khalefa M. E.
CareDB: A Context and Preference-Aware Location-
Based Database System. In Proceedings of the VLDB
Endowment, p. 1529-1532, 2010.
Lian, l. Ma, J. Lei, J. Song, L. Zhang, D. Query relaxing
based on ontology and users’ behavior in service
discovery. In Proceedings of the Fourth International
Conference on Fuzzy Systems and Knowledge
Discovery, 2007.
Maciel, P., Mendonça, A. Texere, a Context-aware System
for Improving Database Queries. Technical Report,
Federal University of Pernambuco, Brazil, 2013.
Newell A. In Visual Information Processing. Academic
Press. Chase E. (editor). 1973.
Rijsbergen, C. J., 1979. Inforamation Retrieval. London:
Butterworths.
Stefanidis, K. Drosou, M. and Pitoura, E. You May Also
Like Results in Relational Databases. Proc. 3rd
International Workshop on Personalized Access,
Profile Managementand Context Awareness in
Databases, Lyon, p. 37-42, 2009.
Stuckenschmidt H., Giunchiglia F., and van Harmelen F.
Query processing in ontology-based peer-to-peer
systems. In V. Tamma, S. Craneeld, T. Finin, and S.
Willmott, editors, Ontologies for Agents: Theory and
Experiences. Birkhuser, 2005.
Vieira, V., Tedesco, P., and Salgado A. C. Designing
Context-Sensitive Systems: An Integrated Approach.
Expert Systems with Applications 38. p. 1119-1138,
2011.
ICEIS2015-17thInternationalConferenceonEnterpriseInformationSystems
398