Websphere Portal Express

This feature can reduce the cost and risk of moving legacy applications built for the Oracle Database to DB2.Once on DB2, you can realize immediate cost savings with the flexible licensing terms. You can take advantage ofdeep compression, pureXML,autonomics,and other advanced DB2 features to further lower your ongoing database ownership costs.

Highlights:

Simplify the move to DB2, Hit the ground running, Lower operational

a. Encryption for Data at Rest

Native encryption assists organizations to meet organizational and regulatory requirements to protect sensitive data by providing native encryption capabilities that encrypt data at rest for the entire database, including backup images.

b. Encryption for Data in Transit

It is this feature that will help you prevent hackers from seeing your data while it's being transmitted through the network using the DB2 Secure Socket Layer (SSL) capability.The DB2 SSL capability encrypts all your database traffic including your authentication credentials.

c. Authentication

Users must authenticate before attaching to a DB2 instance, or connecting to a DB2 database. It is a process of validating that users are who they claim to be.You can configure DB2 to authenticate users viaa Lightweight Directory Access Protocol (LDAP)server, or via Kerberos., via the operating system, DB2 supports custom authentication plug-ins, so you have the flexibility to configure DB2 to more closely match your specific authentication needs.

d. Authorization

After a user is authenticated, DB2 performs an authorization check.Authorizationis the process where the DB2 database manager verifies that a user is authorized to perform certain operations on specific data or resources.

e. Trusted contexts

Trusted contexts makes way tobuild more secure and faster three-tier applications. It also address many security concerns in the three-tier application model, such as user accountability, loss of user's identityand the granting of unnecessary privileges to access certain information. You can also use trusted contexts to limit a user to connecting to the database from certain IP addresses.

f. Row and Column Access Control

DB2 includes Row and Column Access Control for fine-grained security. You can use Row and Column Access Control to restrict the rows and mask the columns that a user sees.

g. Auditing

DB2 includes an audit facility that allows you to monitor data access and provides information needed for subsequent analysis. Auditing can help discover unwanted, unknown, and unacceptable access to the data as well as keep history records of the activities on the database system.

h. Label-Based Access Control

Label Based Access Control (LBAC) provides multi-level security for managing classified data. Once the LBAC rules have been defined, data access control is managed by DB2 and is completely transparent to the user.

DB2 has many performance optimization capabilities which helps to optimize workload execution. These capabilities can reduce costs, lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity.

Highlights:

Table partitioning, Database partitioning, Massively Parallel Processing (MPP), Continuous Ingest, Multidimensional Clustering (MDC), Aggregates, Multi-Temperature Data Management, Mixed Workload Management

This feature enables you to transparently compress data on disk in order to decrease disk space and storage infrastructure requirements. Disk storage systems are mostly the most expensive components of a database solution, even a small reduction in the storage subsystem can reduce substantial cost savings for the entire database solution.

Highlights:

Row Compression, Adaptive Row Compression, Actionable Compression

DB2 can analyze data and explore information from different perspectives for a more extensive view of your business.

a. Cubing Services for OLAP -

Online analytic processing (OLAP) allows you to interrogate data by navigating from summary to detail information. DB2 enables you to create, edit, import, export and deploy OLAP models in a data warehouse environment. It provides access to terabytes of data from multiple angles and perspectives so you can view and analyze it to make informed decisions.

b. Data Mining

Data mining helps you to analyze patterns and make predictions. The historical data is put through mathematical functions to determine business rules. Applying business rules to new data can help predict outcomes such as up-sell or cross-sell opportunities, customer buying behaviors, customer churn or fraud.

Unstructured data accounts up to 80 percent of the data within an organization. DB2 helps you to extract information from your unstructured business text and correlate it with your structured data to increase business insight in areas such as customer attrition and product defect analysis.

The NoSQL movement isaboutrapid deployment of applications and agility. The relational database has proved to be quite durable over the years, sometimes when you do not want to deal with schemas or want a more flexible schema without the constraints frequently imposed by the traditional relational model. For eg., you may want to store XML data in its native XML format with DB2 pureXML. Or, you may want to use the DB2 RDF Store that is optimized for quick and efficient storage and retrieval of graph triples. Or, for mobile and social media applications you may want to take advantage of the agility of document stores by using DB2 JSON.

a. DB2 pureXML – Intelligent XML database management

DB2 pureXML offers sophisticated capabilities to store,manage XML data in its native hierarchical format and store. By integrating XML datainto a relational database structure, users can take full advantage of DB2’s relational data management features.

Highlights:

Lower IT costs, Strong performance and scalability, Increase business agility

It is complex and expensive for businesses to develop their own infrastructure for temporal data management, such as additional tables, triggers, and application logic.Time Travel Query makes your database time-aware and keeps a history of your data changes by using temporal tables.You can travel to the past and the future, and query your data as it appeared at different points in time without having to build, maintain, and administer a complex temporal infrastructure.

High availability ensures that a database system or other critical server functions remain operational both during planned or unplanned outages, such as maintenance operations, or hardware or network failures.Reduced database down-time enables you to meet strict Service Level Agreements (SLAs) with no loss of data during infrastructure failures.

DB2 high availability disaster recovery (HADR) feature provides a high availability solution for both partial and complete site failures.DB2 HADR supports up to three remote standby servers and is available in all DB2 editions excluding DB2 Express-C.HADR protects against data loss by replicating data changes from a source or the primary server, to one or more standby servers.

IBM DB2 pureScalehelps change the economics of continuous data availability. This is designed for organizations that requirehigh availability, reliability and scalability for online transaction processing (OLTP) to meet stringent service level agreements.

In the event of unplanned downtime, DB2 pureScale and HADR are designed to failover in seconds 1. HADR can also help disaster recovery of pureScale clusters over distance of 1000s km 1. Together, DB2 pureScale and HADR reduce the risks of planned and unplanned outages to help meet your SLA requirements