{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:37:53Z","timestamp":1781109473293,"version":"3.54.1"},"reference-count":19,"publisher":"IGI Global Scientific Publishing","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2010,7,1]]},"abstract":"<p>Checking the consistency of a database state generally involves the execution of integrity tests on the database, which verify whether the database is satisfying its constraints or not. This paper presents the various types of integrity tests as reported in previous works and discusses how these tests can significantly improve the performance of the constraint checking mechanisms without limiting to a certain type of test. Having these test alternatives and selecting the most suitable test is an issue that needs to be tackled. In this regard, the authors propose a model to rank and select the suitable test to be evaluated given several alternative tests. The model uses the amount of data transferred across the network, the number of sites involved, and the amount of data accessed as the parameters in deciding the suitable test. Several analyses have been performed to evaluate the proposed model, and results show that the model achieves a higher percentage of local processing as compared to the previous selected strategies.<\/p>","DOI":"10.4018\/jitwe.2010070104","type":"journal-article","created":{"date-parts":[[2011,2,15]],"date-time":"2011-02-15T15:18:25Z","timestamp":1297783105000},"page":"65-84","source":"Crossref","is-referenced-by-count":0,"title":["A Model for Ranking and Selecting Integrity Tests in a Distributed Database"],"prefix":"10.4018","volume":"5","author":[{"given":"Ali Amer","family":"Alwan","sequence":"first","affiliation":[{"name":"Universiti Putra Malaysia, Malaysia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Hamidah","family":"Ibrahim","sequence":"additional","affiliation":[{"name":"Universiti Putra Malaysia, Malaysia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Nur Izura","family":"Udzir","sequence":"additional","affiliation":[{"name":"Universiti Putra Malaysia, Malaysia"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"jitwe.2010070104-0","doi-asserted-by":"publisher","DOI":"10.1007\/s11390-009-9261-0"},{"key":"jitwe.2010070104-1","unstructured":"Feras, A. H. H. (2006). Integrity constraints maintenance for parallel databases. Unpublished doctoral dissertation, Universiti Putra Malaysia, Malaysia."},{"key":"jitwe.2010070104-2","unstructured":"Grefen, P. W. P. J. (1993). Combining theory and practice in integrity control: A Declarative approach to the specification of a transaction modification subsystem. In Proceedings of the 19th International Conference on Very Large Data Bases, Dublin (pp. 581-591). ISBN 1-55860-152-X"},{"key":"jitwe.2010070104-3","unstructured":"Gupta, A. (1994). Partial information based integrity constraint checking. Unpublished doctoral dissertation, Stanford University, Stanford, CA."},{"key":"jitwe.2010070104-4","doi-asserted-by":"crossref","unstructured":"Hsu, A., & Imielinski, T. (1985). Integrity checking for multiple updates. In Proceedings of the 1985 ACM SIGMOD International Conference on the Management of Data, Austin, TX (pp. 152-168).","DOI":"10.1145\/971699.318914"},{"key":"jitwe.2010070104-5","unstructured":"Ibrahim, H. (1998). Semantic integrity constraints enforcement for a distributed database. Unpublished doctoral dissertation, University of Wales College of Cardiff, Cardiff, UK."},{"key":"jitwe.2010070104-6","unstructured":"Ibrahim, H. (2002). A Strategy for semantic integrity checking in distributed databases. In Proceedings of the Ninth International Conference on Parallel and Distributed Systems (pp. 139-146). Washington, DC: IEEE."},{"key":"jitwe.2010070104-7","doi-asserted-by":"crossref","unstructured":"Ibrahim, H. (2006). Checking integrity constraints \u2013 How it differs in centralized, distributed and parallel databases. In Proceedings of the 17th International Conference on Database and Expert System Application - 2nd International Workshop on Logical Aspects and Applications of Integrity Constraints, Krakow, Poland (pp. 563-568).","DOI":"10.1109\/DEXA.2006.39"},{"issue":"3","key":"jitwe.2010070104-8","first-page":"285","article-title":"Optimizing fragment constraints \u2013 A Performance evaluation. International Journal of Intelligent Systems \u2013 Verification and Validation Issues in Databases","volume":"16","author":"H.Ibrahim","year":"2001","journal-title":"Knowledge-Based Systems, and Ontologies"},{"key":"jitwe.2010070104-9","doi-asserted-by":"crossref","unstructured":"Madiraju, P., Sunderraman, R., & Haibin, W. (2006). A Framework for global constraint checking involving aggregates in multidatabases using granular computing. In Proceedings of IEEE International Conference on Granular Computing, Atlanta (pp. 506-509).","DOI":"10.1109\/GRC.2006.1635851"},{"key":"jitwe.2010070104-10","unstructured":"Martinenghi, D. (2005). Advanced techniques for efficient data integrity checking. Unpublished doctoral dissertation, Roskilde University, Roskilde, Denmark."},{"key":"jitwe.2010070104-11","doi-asserted-by":"crossref","unstructured":"Mazumdar, S. (1993). Optimizing distributed integrity constraints. In Proceedings of the 3rd International Symposium on Database Systems for Advanced Applications, Taejon, Korea (Vol. 4, pp. 327-334).","DOI":"10.1142\/9789814503730_0037"},{"key":"jitwe.2010070104-12","unstructured":"McCarroll, N. F. (1995). Semantic integrity enforcement in parallel database machines. Unpublished doctoral dissertation, University of Sheffield, Sheffield, UK."},{"issue":"1","key":"jitwe.2010070104-13","doi-asserted-by":"crossref","first-page":"46","DOI":"10.1145\/58562.59302","article-title":"Maintaining state constraints in relational databases. A Proof theoretic basis.","volume":"36","author":"W. W.McCune","year":"1989","journal-title":"Journal of the Association for Computing Machinery"},{"issue":"3-4","key":"jitwe.2010070104-14","first-page":"377","article-title":"Maintaining global integrity constraints in distributed databases.","volume":"2","author":"Q. H.Nam","year":"1998","journal-title":"Constraints: An International Journal"},{"key":"jitwe.2010070104-15","doi-asserted-by":"publisher","DOI":"10.1007\/BF00263192"},{"key":"jitwe.2010070104-16","unstructured":"Qian, X. (1989). Distribution design of integrity constraints. In Proceedings of the 2nd International Conference on Expert Database Systems, Vienna, VA (pp. 205-226)."},{"key":"jitwe.2010070104-17","unstructured":"Simon, E., & Valduriez, P. (1989). Integrity control in distributed database systems. In Proceedings of the 19th Hawaii International Conference on System Sciences, HI (pp. 622-632)."},{"key":"jitwe.2010070104-18","unstructured":"Soumya, B., Madiraju, P., & Ibrahim, H. (2008). Constraint optimization for a system of relation databases. In Proceedings of the IEEE 8th International Conference on Computer and Information Technology, Sydney, Australia (pp. 155-160)."}],"container-title":["International Journal of Information Technology and Web Engineering"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=47027","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T16:16:17Z","timestamp":1654100177000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jitwe.2010070104"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2010,7,1]]},"references-count":19,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2010,7]]}},"URL":"https:\/\/doi.org\/10.4018\/jitwe.2010070104","relation":{},"ISSN":["1554-1045","1554-1053"],"issn-type":[{"value":"1554-1045","type":"print"},{"value":"1554-1053","type":"electronic"}],"subject":[],"published":{"date-parts":[[2010,7,1]]}}}