In addition to providing full support for SQL Server 2005 SP2, CA ERwin Data Modeler provides enhanced support for the SQL Server 2008 database. All relational syntax and security objects are supported, along with providing new objects to support auditing and resource management. Support for bracketing of identifiers on forward engineer and improved use of ALTER statements for DDL scripts is also included.
The following SQL Server 2008 features are supported:
Filtered indexes
A filtered index is an optimized non-clustered index used by queries that run against a well-defined subset of data in a table. A filtered index uses a WHERE clause to index a portion of rows in a table. This means that the index contains only the rows referenced by the queries. Filtered indexes improve query performance while reducing maintenance and storage.
Sparse columns
Use sparse columns to manage NULL data in a SQL Server 2008 database so that it consumes no physical space. Filtered indexes that are built on sparse columns provide you with improved performance. You can also use column sets, which allow logical grouping of all sparse columns in a table; this simplifies the generic INSERT and UPDATE of a group of sparse columns in a table.
Change data capture
This feature lets you track database changes asynchronously and exposes the changes using a relational interface. With this relational interface, you can easily track changes based on your specific requirements, and then consume the changed data using the data access method you prefer. In CA ERwin Data Modeler, the change data capture object provides the specifications for capturing changes to data stored in a table. A table can have up to two specifications for data capture.
Synchronous net-changes change tracking
Use the Change Tracking options in the SQL Server Table Editor to synchronously track changes to data in tables without creating triggers or modifying the schema of the table. Lets you determine what data has changed since a baseline and obtain the latest data, all with using the least DML overhead.
New data types
Support for the following SQL Server 2008 data types is included in CA ERwin Data Modeler r8:
Data compression
Data compression lets you store data more efficiently to reduce the storage requirements for your database. Data compression reduces the storage and manageability cost of your database and provides significant performance improvements for IO bound workloads such as data warehousing. In CA ERwin Data Modeler, the data compression object defines how the data in a table or index is compressed to reduce the amount of storage space needed to store it.
Server Audit
Server Audit introduces native auditing capabilities to the SQL Server engine. The Audit object in CA ERwin Data Modeler defines a single instance of server or database-level actions to monitor. The audit is at the SQL Server instance level. Multiple audits can exist for a SQL Server instance. The Audit File object defines the specifications for the physical file used to contain the audit data.
Resource Governor
CA ERwin Data Modeler provides support in SQL Server 2008 for Resource Governor using new Workload Group and Resource Pool objects. With this support, you can define resource limits and priorities for different workloads and have consistent performance.
Transparent data encryption
SQL Server 2008 enables encryption of an entire database, data files, and log files, without the need for application changes. Encryption lets you meet the demands of regulatory compliance and overall concern for data privacy. Some of the benefits of transparent data encryption include searching encrypted data using both range and fuzzy searches, searching secure data from unauthorized users, and data encryption. These can all be enabled without changing existing applications.
Extensible key management
The SQL Server 2008 Extensible Key Management (EKM) enables third-party EKM/HSM vendors to register their modules in SQL Server. When registered, SQL Server users can use the encryption keys stored on EKM modules. This enables SQL Server to access the advanced encryption features these modules support such as bulk encryption and decryption, and key management functions such as key aging and key rotation.
New physical objects to support SQL Server 2008 include:
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |