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