UZLILAR VA JADVALLAR YORDAMIDA KENGAYTIRILGAN MA'LUMOTLAR BAZASINI BOSHQARISH
Keywords:
PostgreSQL, uzlilar, jadvallar, ma'lumotlar bazasi, so‘rovlar, optimallashtirish, xavfsizlikAbstract
Ushbu maqolada uzlilar (views) va jadvallar (tables) yordamida ma'lumotlar bazasini samarali boshqarish usullari ko‘rib chiqiladi. Asosiy e'tibor PostgreSQL tizimida kengaytirilgan tuzilmalarning qanday tashkil etilishi va ularning yirik hajmdagi ma'lumotlarni boshqarishdagi o‘rniga qaratiladi. Maqolada uzlilar orqali ko‘p bosqichli so‘rovlar, xavfsizlikni oshirish va ma'lumotlarni optimallashtirish kabi masalalar tahlil qilinadi.
References
1. PostgreSQL Global Development Group. PostgreSQL Documentation. https://www.postgresql.org/docs/
2. Klaas, P., & Baader, D. PostgreSQL: Up and Running. O'Reilly Media, 2019.
3. Chaudhuri, S., & Dayal, U. "An overview of data warehousing and OLAP technology." ACM SIGMOD Record, vol. 26, no. 1, 1997, pp. 65-74.
4. PostgreSQL Development Group. PostgreSQL Query Optimization and Performance Tuning. Packt Publishing, 2021.
5. Tojimamatov, I., & Sahobiddinov, A. (2025). BERILGANLAR BAZISI USTIDA HISOBOTLARNI SHAKILLANTIRISH. BRIDGING THE GAP: EDUCATION AND SCIENCE FOR A SUSTAINABLE FUTURE, 1(1), 83-90.
6. Tojimamatov, I., & Qirg’izboyev, D. (2025). SQL SO ‘ROVLAR TILI STRUKTURASI. SQL-STRUKTURALANGAN SOROVLAR TILI. BRIDGING THE GAP: EDUCATION AND SCIENCE FOR A SUSTAINABLE FUTURE, 1(1), 64-71.
