Sybase数据库新特性教程分析.pptVIP

速度 –––新的查询优化器 管理自动的update Statistics 管理更简单的开发 滚动游标 可以利用fetch加next，prior，first，last，absolute，relative 关键字定位游标。 计算列与索引 由本行的列名，函数，计算操作，组成的字符表达式。提高查询速度。 函数索引 用户可以利用表达式创建一个函数索引，提高查询速度。 RTDS　for MQ ASE内存数据库 零磁盘“足迹” 经典，可靠 创建在可信扩展和可靠的企业级功能之上：ASE 性能： 通过宽松ACID，获得高性能 允许使用大量内存来提升读写性能 易用： 与传统ASE在SQL语言，管理，监控等方面完全兼容一致 最小化现有的Sybase应用开发者和DBA的学习曲线 低TCO 内存技术和 磁盘技术的无缝集成 应用可以在一个数据库服务器合理使用2种技术 不需要引入新的产品和技术，降低复杂度 * * To fully understand the unique capabilities of ASE Cluster Edition, we need to understand the real advantage of Virtualizing and managing resources through logical clusters At the bottom diagram we have the physical cluster. These are the actual physical servers, called nodes, that have one or more ASE servers, called instances, running on them. ASE Cluster Edition introduces the concept of a logical cluster, which is made up of a grouping of ASE instances that are likely operating on two or more physical nodes. This in effect enables administrators to create multiple clusters each with their own “virtualized” resources all operating on one physical cluster. Administrators create and manage logical clusters and its virtualized resources using the Workload Manager, an administration tool specific to the Cluster Edition. Administrators can then take the workloads or applications they are looking to run on the Cluster Edition and assign them to a logical cluster. This in effect enables administrators to load multiple applications or workloads onto a single physical cluster while still giving each Workload the benefits of it’s own dedicated cluster. * * * * * If you attempt to connect to an instance that is down, behavior is the same as with a nonclustered Adaptive Server: the client tries all entries in the directory service of a given server until it can connect successfully. Because of this, your server entries in the directory service should contain connection information for all instances in the cluster. This example includes the Adaptive Servers “ase1