1、Oracle与Postgresql对比方案,Oracle 数据库产品,A oracle 数据库产品系列 B oracle 数据库发展史 C oracle vs Postgresql 以及市场份额 D oracle 常用选件,Oracle 数据库产品系列,应用,中间件,数据库,系统与硬件,Oracle 数据库产品系列,Oracle 数据库产品系列,84 读一致性,89 并行服务器,97 表分区,闪回查询,82 跨平台,01 RAC与DG,04 自动管理,Oracle 数据库发展史, 2009 GZ PMPARK Ltd. All Rights Reserved.,Postgresql简介,Pos
2、tgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX,
3、 BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVA
4、L, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C+, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.http:/www.postgresql.org/, 2009 GZ PMPARK Ltd. All Rights Re
5、served.,Postgresql数据库限制,Oracle vs Postgresql,2009年国内 数据库市场份额,从国内企业应用的数据库市场 调查看，Oracle数据库遥遥领先其它关系型数据库，Oracle数据库在国内企业得到了广泛的认可。,Oracle 常用选件,高可用性-Oracle RAC Oracle RAC 自动存储管理（ASM） Oracle partitioning 数据分区 数据卫士 DateGuard GoldenGate,Oracle RAC体系架构,Oracle RAC体系架构,Oracle Partitioning管理,Oracle DataGuard体系架构,QLCS系统数据库选型,QLCS系统为生产线系统，需要达到较高可用性及稳定性，充分考虑的性能及服务支持，建议采用目前主流的关系型数据库Oracle 11g R2，并且购买Oracle RAC套件，以达到系统安全稳定运行。,
