Contributed by Anja Jessica Paessler
Last weekend I spent quite some time thinking about how to create a blog post to get people as excited about DB2 for z/OS temporal data management as I am. After a while I decided to call an old friend to take a break and maybe receive new input. Somehow we ended up playing an old childhood game in which you put each letter of your name in a different line and then find a word for each letter that describes you. In the end you have a list of attributes describing your personality. So why not trying this to describe something technical such as temporal data management as well? Here is what I came up with:
- Time-based data management that can help businesses manage the increasing amounts of data and retention requirements
- Enables you to accurately track information and data changes over time.
- Makes it easy to insert, update, delete and query data in the past, present or future by using new and standardized SQL syntax.
- Provides an efficient and cost-effective way to address auditing and compliance requirements.
- Opportunity to have multiple stored versions for every logical row.
- Remembers all past versions of rows in a table. If we are talking about a bank account for example, DB2 for z/OS temporal data management will help you to provide a detailed history of their accounts to your customers – and not by using additional tables with triggers or stored procedures as is current practice.
- Application development, maintenance and management can be simplified.
- Leverage DB2 for z/OS temporal data management to obey regulations and fulfill customer needs, no matter if you are in the insurance, financial, retail, human resources or any other sector.
As you can see DB2 for z/OS temporal data management provides many ways to help you and your customers to successfully face today’s business challenges by recording and maintaining ever increasing amounts of data.
Eager to learn more about DB2 for z/OS temporal data management? Read the IBM Redbooks publication Managing Ever Increasing Amounts of Data with DB2 for z/OS Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator.