|
GoldenGate for Database Tiering is a software solution that enables the business to ensure highest performance of their production systems while still easily supporting necessary lookup-only activities -- with unlimited ability to scale as user and data volumes continue to grow over time.
KEY BENEFITS:
- Improve performance and availability of systems designated for critical transaction processing activity
- Off-load lookup-only activity to lower-cost databases and platforms
- Enable unlimited scalability with minimized total cost of ownership to manage online user growth
- Real-time data movement between primary and read-only systems ensures users have access to most current data
Business and IT Challenges
Many popular business applications that support important transaction processing activity -- whether Web-based, packaged, or custom -- are experiencing an increasing volume of users that are executing few, if any, actual transactions against those systems. Instead, database operations that access, sort through, customize, and view desired information may represent a significantly higher percentage of activity compared to actual committed transactions.
At the same time, those critical applications are likely seeing equal or greater growth in the amount of data that must be processed, stored, integrated, and made accessible to the end users.
The combination of those two trends, more data and more users, pose new scalability challenges that must be addressed to maintain top performance of those applications.
The Challenge of the "Look-to- Book" Ratio
Using the example of e-business or Web-based applications that support transactional activity, users typically spend most of their time looking up, sorting, and analyzing data rather than conducting an actual transaction.
This behavior places a tremendous burden on the primary databases supporting those applications. The inevitable result of that large ratio of "lookups" is performance degradation, which to the end user may manifest as an availability problem -- either through sluggish response times, or more visibly as "Server Too Busy"-like error messages. And when competitor websites or other options are just a click away, such availability issues become extremely detrimental to the business and can rapidly lead to losses in revenue, customer satisfaction, and service levels.
To support such growth in activity to those systems, the IT organization has two choices: buy more expensive production database and server infrastructure, or find a way to offload or partition that "lookup" activity to other lower-cost systems.
GoldenGate for Database Tiering
When the volume of lookup activity begins to significantly outpace transaction commits on those systems, it may be time to consider an innovative, proven solution from GoldenGate Software called Database Tiering.
GoldenGate Database Tiering enables the business to ensure highest performance of their production systems while still easily supporting necessary lookup-only activities with unlimited ability to scale as user and data volumes continue to grow over time.
Immediately capturing new insert, update, and delete operations at the primary system(s), GoldenGate pushes that new data in real time to any number of lower-cost databases designated to solely support "read-only" activity. For example, GoldenGate can capture and move changed data from more expensive, primary sources such as HP Nonstop, Oracle, or DB2 and simultaneously apply that new data with only sub-second latency to multiple instances of lower-cost MySQL or other open source databases running on Linux.
RESOURCES:
|
