TRANZAKSIYALARNI BOSHQARISHDA SO‘ROVLAR YARATISH VA QAYTA ISHLASH
Ключевые слова:
ma’lumotlar bazasi, tranzaksiya, SQL so‘rovlari, COMMIT, ROLLBACK, ma’lumotlar yaxlitligi.Аннотация
Ushbu maqolada ma’lumotlar bazasida tranzaksiyalarni boshqarish, SQL so‘rovlari orqali ularni yaratish va qayta ishlash jarayonlari yoritiladi. Amaliy qismda bank hisoblari o‘rtasida pul o‘tkazish misoli asosida tranzaksiyalarning ma’lumotlar yaxlitligi, ishonchliligi va xavfsizligini ta’minlashdagi ahamiyati ko‘rsatib beriladi.
Библиографические ссылки
Silberschatz A., Korth H. F., Sudarshan S. Database System Concepts. 7th edition. New York: McGraw-Hill Education, 2019.
Elmasri R., Navathe S. B. Fundamentals of Database Systems. 7th edition. Pearson Education, 2016.
Connolly T., Begg C. Database Systems: A Practical Approach to Design, Implementation, and Management. 6th edition. Pearson Education, 2015.
Date C. J. An Introduction to Database Systems. 8th edition. Addison-Wesley, 2004.
PostgreSQL Global Development Group. PostgreSQL Documentation: Transactions. Rasmiy hujjatlarda tranzaksiyalar COMMIT, ROLLBACK va SAVEPOINT kabi mexanizmlar orqali boshqarilishi ko‘rsatilgan. (PostgreSQL)
PostgreSQL Global Development Group. PostgreSQL Documentation: Transaction Isolation. Ushbu manbada tranzaksiyalarning izolyatsiya darajalari va bir vaqtda bajariladigan amallarni boshqarish masalalari yoritilgan. (PostgreSQL)
Oracle Corporation. MySQL 8.4 Reference Manual: START TRANSACTION, COMMIT, and ROLLBACK Statements. MySQL hujjatlarida START TRANSACTION tranzaksiyani boshlash uchun standart SQL sintaksisi ekani ko‘rsatilgan. (dev.mysql.com)
Oracle Corporation. MySQL Reference Manual: Transactional and Locking Statements. MySQL tranzaksiyalarni START TRANSACTION, COMMIT va ROLLBACK operatorlari orqali qo‘llab-quvvatlaydi. (dev.mysql.com)
Garcia-Molina H., Ullman J. D., Widom J. Database Systems: The Complete Book. 2nd edition. Pearson, 2008.
Ramakrishnan R., Gehrke J. Database Management Systems. 3rd edition. McGraw-Hill, 2003.
