存档
【IT168 资讯】 DB-Engines于近日发布2014年12月份的数据库系统排名。这个排行榜和TIOBE编程语言排行榜一样权威,在每个月的上旬发布。根据数据库的受欢迎程度进行排名。与之前的比较,整个排名并无太大变化,尤其是前三位。
根据排行榜显示,Oracle居首,而开源的MySQL数据库排名第二,SQL Server位列第三,原本第十名的Sybase ASE被非关系型数据库Redis所取代,而Sybase ASE则跌至第十一名。Redis是内存数据库,在本月的增长较大。到目前为止,前十名中的NoSQL数据库占了三席分别是MongoDB、Cassandra和Redis。
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase Open Server在各操作系统平台上的认证情况,根据Open Server版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
Open Server | 16.0 | 32/64-bit | HP-UX 11.31(ia) | view more |
Open Server | 16.0 | 32/64-bit | IBM AIX 6.1 | view more |
Open Server | 16.0 | 32/64-bit | IBM AIX 7.1 | view more |
Open Server | 16.0 | 32/64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Open Server | 16.0 | 32/64-bit | Red Hat EL 5.0 (IBM POWER) | view more |
Open Server | 16.0 | 32-bit | Red Hat EL 5.0 (x86) | view more |
Open Server | 16.0 | 32/64-bit | Red Hat EL 6.0 (AMD64/EM64T) | view more |
Open Server | 16.0 | 32/64-bit | Red Hat EL 6.0 (IBM POWER) | view more |
Open Server | 16.0 | 32-bit | Red Hat EL6.0 (x86) | view more |
Open Server | 16.0 | 32/64-bit | SuSE SLES 11 (AMD64/EM64T) | view more |
Open Server | 16.0 | 32/64-bit | SuSE SLES 11 (IBM POWER) | view more |
Open Server | 16.0 | 32-bit | SuSE SLES 11 (x86) | view more |
Open Server | 16.0 | 32/64-bit | Sun Solaris 10 (SPARC) | view more |
Open Server | 16.0 | 32/64-bit | Sun Solaris 10 (x64) | view more |
Open Server | 16.0 | 32-bit | Sun Solaris 10 (x86) | view more |
Open Server | 16.0 | 32/64-bit | Sun Solaris 11 (SPARC) | view more |
Open Server | 16.0 | 32/64-bit | Sun Solaris 11 (x64) | view more |
Open Server | 16.0 | 32/64-bit | Windows 2008 R2 (x64) | view more |
Open Server | 16.0 | 32/64-bit | Windows 2012 (x64) | view more |
Open Server | 16.0 | 32/64-bit | Windows 7 (x64) |
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase Replication Server在各操作系统平台上的认证情况,根据Replication Server版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
Replication Server | 15.7.1 | 64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Replication Server | 15.7.1 | 64-bit | Red Hat EL 6.0 (AMD64/EM64T) | view more |
Replication Server | 15.7.1 | 64-bit | Sun Solaris 11 (SPARC) | view more |
Replication Server | 15.7.1 | 64-bit | Sun Solaris 11 (x64) | view more |
Replication Server | 15.7 | 64-bit | HP-UX 11.31(ia) | view more |
Replication Server | 15.7 | 64-bit | IBM AIX 6.1 | view more |
Replication Server | 15.7 | 64-bit | IBM AIX 7.1 | view more |
Replication Server | 15.7 | 64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Replication Server | 15.7 | 64-bit | Red Hat EL 5.0 (IBM POWER) | view more |
Replication Server | 15.7 | 64-bit | Red Hat EL 6.0 (AMD64/EM64T) | view more |
Replication Server | 15.7 | 64-bit | Red Hat EL 6.0 (IBM POWER) | view more |
Replication Server | 15.7 | 64-bit | SuSE SLES 10 (AMD64/EM64T) | view more |
Replication Server | 15.7 | 64-bit | SuSE SLES 10 (IBM POWER) | view more |
Replication Server | 15.7 | 64-bit | SuSE SLES 11 (AMD64/EM64T) | view more |
Replication Server | 15.7 | 64-bit | SuSE SLES 11 (IBM POWER) | view more |
Replication Server | 15.7 | 64-bit | Sun Solaris 10 (SPARC) | view more |
Replication Server | 15.7 | 64-bit | Sun Solaris 10 (x64) | view more |
Replication Server | 15.7 | 32-bit | Windows 2008 (x86) | view more |
Replication Server | 15.7 | 64-bit | Windows 2008 R2 (x64) | view more |
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Software Developer Kit在各操作系统平台上的认证情况,根据Software Developer Kit版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
Software Developer Kit | 16.0 | 32/64-bit | HP-UX 11.31(ia) | view more |
Software Developer Kit | 16.0 | 32/64-bit | IBM AIX 6.1 | view more |
Software Developer Kit | 16.0 | 32/64-bit | IBM AIX 7.1 | view more |
Software Developer Kit | 16.0 | 32/64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Red Hat EL 5.0 (IBM POWER) | view more |
Software Developer Kit | 16.0 | 32-bit | Red Hat EL 5.0 (x86) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Red Hat EL 6.0 (AMD64/EM64T) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Red Hat EL 6.0 (IBM POWER) | view more |
Software Developer Kit | 16.0 | 32-bit | Red Hat EL6.0 (x86) | view more |
Software Developer Kit | 16.0 | 32/64-bit | SuSE SLES 11 (AMD64/EM64T) | view more |
Software Developer Kit | 16.0 | 32/64-bit | SuSE SLES 11 (IBM POWER) | view more |
Software Developer Kit | 16.0 | 32-bit | SuSE SLES 11 (x86) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Sun Solaris 10 (SPARC) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Sun Solaris 10 (x64) | view more |
Software Developer Kit | 16.0 | 32-bit | Sun Solaris 10 (x86) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Sun Solaris 11 (SPARC) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Sun Solaris 11 (x64) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Windows 2008 R2 (x64) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Windows 2012 (x64) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Windows 7 (x64) | view more |
Software Developer Kit | 16.0 | 32-bit | Windows 7 (x86) | view more |
Software Developer Kit | 16.0 | 32/64-bit | Windows 8 (x64) | view more |
Software Developer Kit | 15.7 | 32/64-bit | HP-UX 11.31(ia) | view more |
Software Developer Kit | 15.7 | 32/64-bit | IBM AIX 6.1 | view more |
Software Developer Kit | 15.7 | 32/64-bit | IBM AIX 7.1 | view more |
Software Developer Kit | 15.7 | 32/64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Software Developer Kit | 15.7 | 32/64-bit | Red Hat EL 5.0 (IBM POWER) | view more |
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是SQL Anywhere在各操作系统平台上的认证情况,根据SQL Anywhere版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Sun Solaris 10 (SPARC) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Sun Solaris 2.7 (SPARC) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Sun Solaris 2.8 (SPARC) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Sun Solaris 2.9 (SPARC) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | SuSE Prof. 9.1 (AMD64/EM64T) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Windows 2003 (ia64) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Windows 2003 (x64) | view more |
Adaptive Server Anywhere | 9.0.2 | 32/64-bit | Windows 2003 (x86) | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | HP-UX 11.0 PA-RISC | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | HP-UX 11i PA-RISC | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | NetWare 5.1 | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | NetWare 6.0 | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | NetWare 6.5 | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | Red Hat EL 2.1 (x86) | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | Red Hat EL 3.0 (x86) | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | Red Hat EL 4.0 (AMD64/EM64T) | view more |
Adaptive Server Anywhere | 9.0.2 | 32-bit | Red Hat EL 4.0 (x86) | view more |
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase IQ在各操作系统平台上的认证情况,根据Sybase IQ 版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
IQ Enterprise Edition | 12.7 | 64-bit | HP-UX 11.23 PA-RISC | view more |
IQ Enterprise Edition | 12.7 | 64-bit | HP-UX 11.23(ia) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | HP-UX 11.31 PA-RISC | view more |
IQ Enterprise Edition | 12.7 | 64-bit | HP-UX 11.31(ia) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | IBM AIX 5.3 | view more |
IQ Enterprise Edition | 12.7 | 64-bit | IBM AIX 6.1 | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Flag 5.0 (IBM POWER) | view more |
IQ Enterprise Edition | 12.7 | 32-bit | Red Flag 5.0 (x86) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Hat EL 3.0 (IBM POWER) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Hat EL 3.0 (AMD64/EM64T) | view more |
IQ Enterprise Edition | 12.7 | 32-bit | Red Hat EL 3.0 (x86) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Hat EL 4.0 (AMD64/EM64T) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Hat EL 4.0 (IBM POWER) | view more |
IQ Enterprise Edition | 12.7 | 32-bit | Red Hat EL 4.0 (x86) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | SuSE SLES 10 (AMD64/EM64T) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | SuSE SLES 10 (IBM POWER) | view more |
IQ Enterprise Edition | 12.7 | 32-bit | SuSE SLES 10 (x86) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | SuSE SLES 9.0 (AMD64/EM64T) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | SuSE SLES 9.0 (IBM POWER) | view more |
IQ Enterprise Edition | 12.7 | 32-bit | SuSE SLES 9.0 (x86) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Sun Solaris 10 (SPARC) | view more |
IQ Enterprise Edition | 12.7 | 64-bit | Sun Solaris 10 (x64) | view more |
在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase ASE在各操作系统平台上的认证情况,根据Adaptive Server Enterprise版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)
Product | Prod Version | WordSize | OS Version | More Information |
Adaptive Server Enterprise | 15.0.3 | 32-bit | SuSE SLES 11 (x86) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | HP-UX 11.31(ia) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | IBM AIX 6.1 | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | IBM AIX 7.1 | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Red Hat EL 4.0 (AMD64/EM64T) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Red Hat EL 5.0 (AMD64/EM64T) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Red Hat EL 6.0 (AMD64/EM64T) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Sun Solaris 10 (SPARC) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Sun Solaris 10 (SPARC) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Sun Solaris 2.9 (SPARC) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | Sun Solaris 2.9 (SPARC) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | SuSE SLES 11 (AMD64/EM64T) | view more |
Adaptive Server Enterprise | 15.0 CE | 64-bit | SuSE SLES 9.0 (AMD64/EM64T) | view more |
Adaptive Server Enterprise | 12.5.4 | 32-bit | Windows 2008 (x64) | view more |
Adaptive Server Enterprise | 12.5.4 | 64-bit | Red Flag 5.0 (IBM POWER) | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | Compaq Tru64 4.0f | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | Compaq Tru64 5.1 | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | Digital UNIX 4.0d | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | Digital UNIX 4.0e | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | HP-UX 11.0 PA-RISC | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | HP-UX 11.11 PA-RISC | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | IBM AIX 4.3.1 | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | IBM AIX 4.3.2 | view more |
Adaptive Server Enterprise | 11.9.3 | 64-bit | IBM AIX 4.3.3 | view more |
之前博文中介绍了ASE中使用union来删除重复数据的方法:Sybase去除重复数据的一种方法!用union的方法要求先把不重复的数据行插入到临时表中,然后清空源表后再把数据倒回到源表中。
本文介绍使用索引的with ignore_dup_row选项来在线删除表的重复数据行。
创建非唯一、聚簇索引,带选项 : with ignore_dup_row
在索引的创建语法中,unique 和 with ignore_dup_row 是互斥的,nonclustered 和 with ignore_dup_row 是互斥的;也就是说,使用with ignore_dup_row选项时索引必须是非唯一、聚簇的。
通过索引删除重复数据后,再把新建的非唯一、聚簇索引删除。