InfoSphere Warehouse Terabyte Pricing
Today's competitive environment requires that business software provides both value and performance. Enterprises need a warehouse that can scale as their data grows, deliver answers to user queries at lightning speeds, and demonstrate the flexibility to meet any challenge thrown their way. At the same time, enterprises are no longer willing to pay for unused capacity or to be penalized for upgrading to the latest hardware technologies. Today's IT departments are increasingly challenged to contain costs despite exponential data growth and to the demonstrate business value of IT projects faster than ever before. With this in mind, IBM InfoSphere Warehouse has a simple terabyte pricing mechanism that allows organizations to pay only based on the terabytes of compressed user data to help organization achieve these objectives.
Terabyte pricing - buy what you need, when you need it
Terabyte-based pricing structure allows organizations to license the software based on the actual amount of user data being managed in the warehouse. As the warehouse data volumes grow, customers can purchase additional warehousing capacity on a just-in-time basis. Terabyte pricing allows customers to exploit new hardware innovations and processor technologies without impacting software licensing costs. Our industry-leading compression capabilities can further help increase the value of this new pricing option as the terabyte pricing measurement is based on a post compression size. Customers are able to purchase either InfoSphere Warehouse Enterprise or Departmental Editions, also the Advanced Editions of both, under this new terabyte-based pricing. Without any hardware dependencies, many organizations will find that purchasing the warehouse using a terabyte metric also facilitates data mart consolidation.
Do what's right for your business and your users - put the best warehouse software on the best machine for the job. How Terabyte pricing works:
If your entitlement to InfoSphere Warehouse is based on terabyte pricing, then your entitlement is determined by the sum of the number of terabytes (TB) of user data in each database that you analyze. The size of each database is rounded up to the next terabyte (a terabyte is 2 to the 40th power bytes). IBM provides an SQL script that measures the number of terabytes that are allocated to your data. For each database, you must acquire enough TB entitlements to cover the amount of user data stored in the database.
Example A: A database with 1.75 TB of data must acquire a 2 TB entitlement.
Example B: A instance with 2 databases, one storing 1.4 TB, and a second with 3.2 TB must acquire 6 TB (2 plus 4) worth of entitlement.
What is considered as "User Data" when calculating the Terabyte Size:
The SQL script used to measure terabyte entitlement requirement queries the administrative view ADMINTABINFO(*) to add up the sizes of the user data stored in all the user tables of the currently connected database. The sizes of user data are determined by adding the logical sizes of data objects, long objects, LOB objects and XML objects. This includes the sizes of metadata stored inside user tables, such compression dictionaries, data record headers, and free space control records.
The following types of table objects are included in the output of the script:
- user-created temporary tables
- hierarchy tables
- detached tables
- materialized query tables
- typed tables
- untyped tables
The following objects are not included in the output of the script:
- system-created temporary files
- system/catalog tables
- index objects
- database log files
- table aliases
The above example show for a customer that wants to load 80 Terabytes of source data into a warehouse, that after creating the warehouse models and associated ETL to load the source data that the post compression size of the user tables is under 25 Terabytes. The customer would then only need to acquire 25TB of InfoSphere Warehouse entitlements to accommodate the usage requirements. As the warehouse environment grows over time, the customer can obtain additional entitlements to cover the growth of user data managed by the warehouse.