Tag Archives: Database Archiving

Lean Data Warehouse – Clean Up The Waste

Many years ago (over 30 to be precise) I can recall walking the halls of more than one fortune 500 company and seeing four-foot high stacks of boxes with computer printouts in the hallway outside of managers’ offices.  In fact it was not uncommon to see pallet-loads of computer printouts in some companies. When I [...]

Optimize Data Warehouses with Data Usage Monitoring and Data Warehouse Archiving

Data warehouses are applications– so why not manage them like one? In fact, data grows at a much faster rate in data warehouses, since they integrate date from multiple applications and cater to many different groups of users who need different types of analysis. Data warehouses also keep historical data for a long time, so [...]

Database Partitioning and Database Archiving; Can They Be Used Together to Optimize Applications?

Database partitioning and database archiving are both methods for improving application performance. Many IT organizations use one or the other, but using them together can provide additional incremental value to an organization. Database partitioning is a well-known method to DBAs and is supported by most of the commercially available databases. The benefits of partitioning include:

Dodd-Frank Legislation and Structured Data Retention

The “Dodd-Frank Wall Street Reform and Consumer Protection Act” has recently been passed by the US federal government to regulate financial institutions. Per this legislation, there will be more “watchdog” agencies that will be auditing banks, lending and investment institutions to ensure compliance. As an example, there will be an Office of Financial Research within [...]

Seven Essential Best Practices For Data Center Consolidation

Data center consolidation is much more than physical movement of servers and infrastructure.  In fact, the facility costs and power savings are just the tip of the opportunity. The biggest benefits come from using the consolidation initiative as a catalyst to rationalize the application portfolio, archive inactive data and establish one version of the truth [...]