sharding
在这个NOSQL sharding满天飞的时代, Oracle将以完美支持SQL、事务、并行、丰富查询功能的姿态一头扎向sharding的怀抱。Oracle Core Database, 核心数据库版本,Native Install for Core Database
oracle将针对Linux提出一个新的安装版本 Oracle Core Datbase ,该Core Database将使用Linux上的原生安装方式 例如rpm或其他package,这意味着你安装Oracle Core Database只需要一条命令 yum install oracle-core-database。这与之前Oracle发布过的Oracle Express版本 Oracle XE 看起来有些相似,但是和Oracle XE的有巨大的差别,因为Oracle XE是一个阉割的不能再阉割的一个版本,而Oracle Core Database不是,Oracle Core Database在Oracle数据库的基本功能上完全没有限制,仅仅限制了部分企业版的option。这意味着Oracle将其核心功能精简到一个Core Database中,并在Linux上以 rpm或其他package形式快速发布。"Oracle Core Database 12gR1 will be packaged as an RPM. RPM is considered the standard way to deploy packages on most Linux systems. Also, RPM was originally known as ‘Redhat Package Manager’ which is now updated and known as ‘RPMPackage Manager’." Oracle Core Database的提出显然是为了在12cR2 sharding的预言, Oracle Core Database版本将区别于Oracle EE enterprise edition企业版的较高价格,其本身的出现就是为sharding而设计的,为了让用户能从sharding中充分获得横向扩展能力,显然Oracle要在原有EE企业版的基础上搞出一个即易于安装部署、具备Oracle数据库的核心功能,又与Oracle原有EE企业版有功能差距的这么一个版本。在这个Core Database版本上,Oracle可以大幅降低其license 成本费用,达到Oracle EE企业版的几分之一乃至几十分之一的价格。 毕竟Oracle license许可证的价格是阻碍Oracle Sharding大规模横向扩展的唯一的瓶颈,Oracle真要搞sharding,那么其技术上几乎没有什么瓶颈。 Oracle Core Database与Oracle XE的另一些区别是:Oracle XE是免费的,没有官方支持也没有补丁。 而Oracle Core database 是需要license许可证,同时官方也提供支持和补丁。 Oracle Core database将支持的option :Application Development, Language, andDatabase Features SQL*Plus PL/SQL stored procedures and triggers PL/SQL server pages PL/SQL native compilation JDBC drivers XML support in the database(no JNDI , or Servlet Support) Native .NET data provider support ASP.NET Providers OLE DB support ODBC support .NET Stored Procedures Microsoft Distributed Transaction Coordinator support Large Page memory support DML triggers Database event triggers Instead-of triggers Index-organized tables Temporary table Objects and Extensibility LOB (large object) support Oracle Text Oracle Locator Function-based index Regular Expressions Sample Scan SQL Model SQL Analytic functions Star query transformation (B-tree indexes only) Globalization support (excluding Locale Data Customization) Multiple block size support Availability/BackupandRecovery Features Drop column Rename column, constraint Flashback Query Online Backup Incremental backup and recovery ((no change tracking file or optimized incremental backup capability) Oracle Logminer Data Movement/Integration Features Direct Path Load API External tables External procedures Advanced Queuing Basic Replication (read-only and updateable materialized view site only) Distributed queries Distributed transactions Generic connectivity Manageability Features Automatic Datafile Management Automatic Memory Management Automatic Optimizer Statistics Management Server-generated Alerts