Database management

Data Warehousing Documentation Requirements

One of the most frequently asked questions when starting a Data Warehousing initiative is: “What best practices should I be following?” In this series of posts, we will outline our recommendations to follow when building a data warehouse – starting with data warehousing documentation. Data Warehousing Best Practice: Documentation  A successful data warehouse implementation boils down to […]

Cloud management

How to Select the Right Cloud Vendor

When migrating to the cloud, one of the primary hurdles you’ll have to overcome is selecting the right cloud provider. Make the process easier by evaluating four key areas of consideration: Technical Considerations Service Level Agreement Transparency Security Considerations Each of these areas can be evaluated based by asking a few simple questions of your internal team and the […]

Database management

Oracle RMAN Myth Busting

Background: Database Administration ChallengesManaging Oracle database backup and recovery is a critical operational requirement for database administrators (DBAs). With increasing database sizes and Service Level Agreements (some requiring 24×7-database availability), DBAs need to effectively design and manage data protection solutions to minimize performance impact on production databases. Below are key operational goals that DBAs need […]

Database management

Oracle RMAN Best Practices

In our last post we discussed the top myths and benefits associated with Oracle RMAN. Now that you’re ready for (or already have reached) implementation, we’d like to share some best practices to follow. 1. Take regular backups and verify that they work. Use validate command of Oracle RMAN or restore them to a test environment periodically:RMAN> […]

Database management
Top Three Requirements for Creating a Data Warehouse Solution

Top Three Requirements for Creating a Data Warehouse Solution

In our last post, “What are Data Warehouses?”, we talked about what a data warehouse is, some of the history behind it, and when your organization may need a data warehouse solution. Now we will going to explain the top three requirements for creating a data warehouse solution. #1. Executive Sponsorship Without buy-in from senior executives, data warehouse projects […]

Database management

What Are Data Warehouses?

A data warehouse is a large, central store of data from sources across an organization or company. The information contained in this central data store is used for making strategic and tactical business decisions. Building a Data Warehouse When it comes to building a data warehouse for your organization, the most commonly utilized methodologies are […]