Database Blog


  • Oracle Security — Data Masking using Enterprise Manager

    by Robert Buda | Sep 27, 2010 | Best Practices , Database Security , Oracle

    Reading Time: 2 minutes Database administrators often have to provide test data sets to developers, QA teams, or UAT teams. This can be done manually creating test data sets, which can take a very long time especially when the goal is to stress test a new system and a large amount of data is required. An alternative approach often taken by database administrators is to copy the production database. Too often, an exact copy of the production data is used for…..

    Read more Add new comment
  • The importance of documentation, organization, and cross-training

    by Robert Buda | Sep 16, 2010 | Best Practices

    Reading Time: 2 minutes A recent experience on a large database development project illustrates three very important principals to follow when developing a large computer system;  keeping code well organized, keeping code well documented, and ensuring that more than one person is familiar with all portions of the code base. After about four months of development the lead developer on our project suddenly became very ill. His illness was serious enough to result in immediate hospitalization and he is…..

    Read more Add new comment
  • Oracle Performance Tuning — Log Sync Waits

    by Robert Buda | Aug 5, 2010 | Oracle

    Reading Time: 3 minutes I recently worked with a client to resolve a significant performance issue related to painfully slow queries in an Oracle database. One of the queries that they wished to execute was taking over five hours to run. This is an Oracle 10g database running on a Solaris platform. The server has 8 processors so there is plenty of processing power. The database is very large with a very high insertion rate. The database is about…..

    Read more Add new comment
  • Five reasons why I avoid database query hints

    by Robert Buda | Jul 28, 2010 | Best Practices , Uncategorized

    Reading Time: 2 minutes I know that some will disagree with me on this but I have never been a fan of query hints.

    Most database vendors give you the ability to override the query optimizer with hints that you specify in a query. Each query can be executed in a variety of ways by the…

    Read more Add new comment
  • Five reasons why I avoid database query hints

    by Robert Buda | Jul 28, 2010 | Database

    Reading Time: 2 minutes I know that some will disagree with me on this but I have never been a fan of database query hints. Most database vendors give you the ability to override the query optimizer with hints that you specify in a query. Each query can be executed in a variety of ways by the database engine. Normally, the optimizer evaluates the statistics about the data in each of the tables involved in the query and makes…..

    Read more Add new comment
  • Storing documents in a MongoDB database instead of the file system

    by Robert Buda | Jul 9, 2010 | Database , MySQL

    Reading Time: < 1 minute We are currently working on an application that uses a mysql database. The application produces a large number of csv files that must be kept around for a few weeks, and then removed after being used in various ways by the users of the system. We need to keep track of all of these files and present a list of the files to the user so they can download them to their local machine, or send…..

    Read more Add new comment