tableBASE (Vendor: DataKinetics, Canada)
URL: http://www.dkl.com
DataKinetics tableBASE is a real-time in-memory table management solution that reduces mainframe resource usage, allowing for much faster applications, especially in transaction processing environments. The original Advanced Data Optimization Performance Technology (ADOPT) product, tableBASE can lower your costs, lower your mainframe TCO and optimize your MIPS usage, offering dramatic performance benefits and more powerful and efficient applications.
tableBASE can dramatically improve the performance of DB2 systems. Performance increases of two orders of magnitude can be expected over existing I/O intensive DB2 systems; an order of magnitude improvement over similar buffered DB2 or cached DB2 systems.
In many systems, applications fetch data from either a DB2 database, or a buffered DB2 database. These systems access data either directly via I/O or from buffers, using the same path lengths as standard I/O.
In systems using tableBASE optimization, the DB2 database populates in-memory tables once. Application I/O calls are substituted with calls to memory-based tables. This results in an improvement of from one to two orders of magnitude in application performance. Instead of fetching data at I/O speeds, or buffered I/O speeds, your applications now fetch data at memory speeds. Without buffering, without extra hardware.
What does this mean to my company?
Instead of investing significantly in more hardware to gain 2x, 3x, or 4x capacity, you can invest modestly in tableBASE, and gain 30x your current data access capacity. Instead of struggling with a near-full batch window, use tableBASE to reduce the amount of time needed to complete your processing to 10% or less than what it is now.