My SQL Vs Postgre SQL o o My


























































- Slides: 58














My. SQL Vs Postgre. SQL o o My. SQL -层次结构清晰,松耦合。 -Designed by/for Database Application Developers Postgre. SQL -层次结构复杂,紧耦合。 -设计缜密,超前,很学院派。 - Designed by/for Database Administrators

My. SQL Vs Postgre. SQL (cont. ) o 1 2 3 4 5 6 7 8 开发重点 My. SQL: Vs Postgre. SQL: Ease-of-use Data integrity Performance Security Programmer Features Reliability Standards DB Features Data integrity Performance Security Ease-of-use Standards Programmer Features


The Answer










Template o 主要数据结构描述 -数据结构定义 struct __db_mpool { db_mutex_t mutex; DB_MPREG *pg_inout; LIST_HEAD(__db_mpregh, __db_mpreg)dbreg; TAILQ_HEAD(__db_mpoolfileh, __db_mpoolfile) dbmfq; ENV *env; REGINFO *reginfo; }









Berkeley DB产品种类 o o 普通数据存储(Berkeley DB Data Store) 并发数据存储(Berkeley DB Concurrent Data Store) 事务数据存储(Berkeley DB Transactional Data Store) 高可用性数据存储(Berkeley DB High Availability)






Berkeley DB存取系统(cont. ) o 例子:水果 ——销售商 店名称数据 库表: 字段 为(fruit, store), 其中fruit字 段为主键 KEY: DATA: Apple Convenience Store Blueberry Farmer's Market Peach Shopway Pear Farmer's Market Raspberry Shopway Strawberry Farmer's Market







Berkeley DB事务系统(cont. ) o 当创建事务应用程序时,通常需要围绕数据库环境创建 一个管理架构。这个架构有5个部分: (1)死锁检查: db_deadlock, DB_ENV>lock_detect, DB_ENV->set_lk_detect (2)检查点: db_checkpoint, DB_ENV>txn_checkpoint (3)数据库和日志文件归档: db_archive, DB_ENV>log_archive (4)恢复处理: db_recover, DB_ENV->open



Berkeley DB事务系统(cont. ) o 事务的并发控制:两段锁协议(Two-Phase Locking, 简称 2 PL)。 lock A- lock B- lock C- unlock B|< -扩展阶段 -- >|< - unlock A- unlock C 收缩阶段 -- >|


Berkeley DB锁系统(cont. ) o Berkeley DB的标准锁模式: (1)DB_LOCK_NG: not granted (2)DB_LOCK_READ: read (3)DB_LOCK_WRITE: write (4)DB_LOCK_IREAD: intention to read (5)DB_LOCK_IWR: intention to read and write 0 shared exclusive shared




Q&A
Postgre
Postgre
Postgre serial
Postgre pronounce
Difference between sql and pl/sql
Pl sql unit testing
Sql developer modeler
Sql server management studio tips and tricks
Basic structure of sql
Whoisactive sql query
Hotel database sql queries
Datalog sql
Syslockinfo
Guestbook.php sql
Mimer development tool
Mycompiler sql
Sql plan explorer
Sql server filestream
Sql commit
Sql yong
Plpg sql
Storage engine in sql server
Uc berkeley sql class
Pengertian sql
Codigo sql
Sql select anidados
Inside the sql server query optimizer
Shape2sql
Ddl dml dcl in sql
Sql
Sql lid
Sql jezik
Open sql
Oracle developer tools for visual studio 2015
Sql
Entity relationship data model
Grant showplan
Restart sql sbs monitoring
Sql alikysely
Exercice pl/sql function procédure
Pl sql block structure example
Azure clour
Sqlquerystress
Sql reminder
Sql slammer worm bytes
Sql server
My sql
Select distinct sql
Introduction to sql programming techniques
Slidetodoc.com
Sql datumové funkce
Sql exercise
Ms sql server architecture
Parentheses in sql
Sql
Sql stands for structured query language
Web project
Volt database
Azure event hub sla