Abstract
Database growth and storage problems are basically the main high concerns of globally large and small enterprises, which directly have negative impact on database application performance. But something more important is that majority of it is unused in these large volumes of databases. According to industry analysts, the growth rate of enterprise databases is 125% yearly, in which 80% of the information in use is inactive. Database archiving is one of the solutions among all the solutions that are available for management. With the use of archiving database, many issues have been highlighted including selection and removal of unused data from OLTP system, integrity management, and performance. This paper introduces a methodology for where OLTP and archiving data are kept in a distributed database environment. Integrity management is important, but more significant than that is the performance of the desired query which maintains that integrity between OLTP and archiving database. The main feature of the proposed methodology is that it not only maintains data integrity for primary and unique keys between OLTP and archive database but will also focus on enhancing the query performance for maintaining that integrity by introducing a query execution plan and parallel processing in it.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Ibrahim, H., Alwan, A. A., & Udzir, N. I. (2007). Checking integrity constraints with various types of integrity tests for distributed databases. In 2007 8th international conference on parallel and distributed computing, applications and technologies, PDCAT 2007 (PDCAT) (pp. 151–152). https://doi.org/10.1109/PDCAT.2007.14
Hill, D. (2006). Database archiving: A necessity, not an option. Commentary, Mesabi Group. Available from https://www.mesabigroup.com/English/Collaterals/Whitepapers/20060511_Database_Archiving.pdf
Lee, J. (2004). Database archiving: A critical component of information lifecycle management. Available from https://www.databasejournal.com/sqletc/article.php/3340301/Database-Archiving-A-Critical-Component-of-Information-Lifecycle-Management.htm
Yuhanna, N. (2009). Enterprise database management systems. Cambridge: Forrester Research.
Pfleeger, C. P., & Pfleeger, S. L. (2003). Security in computing. Upper Saddle River: Prentice Hall Professional Technical Reference.
Özsu, M. T., & Valduriez, P. (2011). Distributed and parallel database systems. Boston: Springer.
Redman, T. C. (1998). The impact of poor data quality on the typical enterprise. Communications of the ACM, 41(2), 79–82.
Norris, J. S. (2004). Mission-critical development with open source software: Lessons learned. IEEE Software, 21(1), 42–49.
Lush, M. (2017). Getting to the bottom of data integrity Safeguarding quality systems requires understanding the thinking that drives human behaviour (pp. 12–13).
Eddolls, T. (2008). Database archiving for the future. Available from https://www.informationtechnologycrossing.com/article/370128/Database-Archiving-for-Tomorrow/
Mullins, C. (2006) Database archiving: Managing data for long retention periods. Available from http://tdan.com/database-archiving-for-long-term-data-retention/4591
Jan, M. A., Nanda, P., He, X., & Liu, R. P. (2015). A sybil attack detection scheme for a centralized clustering-based hierarchical network. In Proceedings of the 2015 IEEE Trustcom/BigDataSE/ISPA (Vol. 1, pp. 318–325). IEEE.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this chapter
Cite this chapter
Khattak, U.F., Mustapha, A., Yaseen, M., Shah, M.A., Shahzad, A. (2019). Enhancing Integrity Technique Using Distributed Query Operation. In: Jan, M., Khan, F., Alam, M. (eds) Recent Trends and Advances in Wireless and IoT-enabled Networks. EAI/Springer Innovations in Communication and Computing. Springer, Cham. https://doi.org/10.1007/978-3-319-99966-1_13
Download citation
DOI: https://doi.org/10.1007/978-3-319-99966-1_13
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-99965-4
Online ISBN: 978-3-319-99966-1
eBook Packages: EngineeringEngineering (R0)