Abstract
Nowadays, with the evolution of data and their geographical distribution, Distributed Database Management Systems (DDBMS) have become undoubtedly a need for Information Systems (IS) users. Unfortunately, query optimization remains a handicap for existing DDBMS, given the high cost of network traffic caused by the access to geographically distributed data in different sites. To remedy this problem, we propose a new effective approach of querying Distributed Database (DDB) based on the definition of relevant sites to the query knowing fragmentation and /or duplication of distributed data. This approach allows us to minimize the volume of transferred data via network and consequently reduces the query execution cost. This approach has been validated by implementing a layer “effective-query” on Oracle DDBMS.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Dye, C., Russell, D.: Oracle distributed systems. O’Reilly (1999)
Franke, C., Morin, S., Chebotko, A., Abraham, J., Brazier, P.: Distributed semantic web data management in HBase and MySQL cluster. In: Proceedings of 2011 IEEE International Conference on Cloud Computing (CLOUD), pp. 105–112 (2011)
Stonebraker, M., Held, G., Wong, E., Kreps, P.: The design and implementation of INGRES. ACM Trans. Database Syst. 1, 189–222 (1976)
Hewitt, E.: Cassandra: The Definitive Guide. O’Reilly Media, Inc (2010)
Chrisment, C., Pujolle, G., Zurfluh, G.: Bases de données réparties. Les Techniques de l’Ingénieur (1993)
Hevner, A.R., Yao, S.B.: Optimization of Data Access in Distributed Systems. Purdue University, Tech. rep (1978)
Ceri, S., Negri, M., Pelagatti, G.: Horizontal data partitioning in database design. In: Proceedings of the 1982 ACM SIGMOD international conference on Management of data, pp. 128–136 (1982)
Gardarin, G., Valduriez, P.: SGBD avancés: bases de données objets, déductives, réparties. Eyrolles (1990)
Liu, L., ÖZsu, M.: Encyclopedia of Database Systems. Springer Publishing Company, Incorporated (2009)
Özsu, M., Valduriez, P.: Principles of Distributed Database Systems. Springer Science and Business Media (2011)
Polychroniou, O., Sen, R., Ross, K.A.: Track join: distributed joins with minimal network traffic. Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, pp. 1483–1494 (2014)
Iacob, N.: Distributed query optimization. Ann. Econ. Ser. 4, 182–192 (2010)
Kemme, B., Jiménez-Peris, R., Patiño-Martinez, M.: Database Replication. Morgan & Claypool Publishers
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Kacem, A.B., Touzi, A.G. (2015). Towards a New Approach for an Effective Querying of Distributed Databases. In: Neves-Silva, R., Jain, L., Howlett, R. (eds) Intelligent Decision Technologies. IDT 2017. Smart Innovation, Systems and Technologies, vol 39. Springer, Cham. https://doi.org/10.1007/978-3-319-19857-6_27
Download citation
DOI: https://doi.org/10.1007/978-3-319-19857-6_27
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19856-9
Online ISBN: 978-3-319-19857-6
eBook Packages: EngineeringEngineering (R0)