Performance Benefits

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 magniture improvement over similar buffered DB2 or cached DB2 systems. The image to the right shows mesured results of DB2 + tableBASE v.s. buffered DB2. (The information was obtained at the IBM zSeries Benchmarking Center in Poughkeepsie, NY.) In many systems, applications fetch data from either a DB2 database, or a buffered DB2 database (see Fig 2, top). 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 (Fig 2, bottom). 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. Fig. 1: DB2 with tableBASE Fig 2: tableBASE processing at memory speed

More efficient applications

More efficient applications More than that however, tableBASE-powered applications are market-adaptive, growing and changing with the company as it grows and changes. They are as compatible with mergers and acquisitions as they are with divestitures. They are vital to business operations, and become an essential part of the company's value by enabling business top-line growth, while reducing costs. What does this mean to my company? Changes to business rules that take months to implement can now be managed in a day. And that is without a performance hit. Many other rules externalization solutions involve a serious performance hit—often including transferring information between applications, or requiring a great deal of I/O as part of the solution. tableBASE allows for separation of business rule from applications, while retaining ultra-high-speed processing— without extra I/Os, without scrapping your existing applications, and without the need for new hardware. Swap thousands of lines of If-Then logic from application code for a single call to an in-memory table. Fig. 3: tableBASE controls maintenance costs

How do you access tableBASE?

How do you access tableBASE? tableBASE is accessed via its API—a single-call, and can be used in batch, CICS, IMS and other operating environments. What does this mean to my company? You can retain your existing applications. Swap your I/O calls for tableBASE API calls to obtain at least a 300% improvement in application performance.

Additional Products

The following products complement our flagship product, tableBASE: tableBASE VTS tableBASE Process Manager tableBASE CICS Interface tableBASE IMS Interface tablesONLINE®/CICS tablesONLINE®/ISPF

Get the White Paper

For more information, see the white paper: Download the Get More From Your Mainframe white paper to learn how you can do more with your MIPS.