Database Blog

  • Oracle Editioning — Upgrading database applications while in use

    by Robert Buda | Jun 24, 2013 | Oracle

    Reading Time: < 1 minute Among the features introduced in Oracle 11g is Edition Based Redefinition. This feature enables us to have multiple active versions of database objects in order to facilitiate online application upgrades. Prior to this release, if an application used stored procedures or triggers, upgrades required database downtime in order to redefine database objects. This new feature facilitates zero down-time application upgrades but it is a complicated feature and using it can be difficult. Our colleague, Dennis…..

    Read more Add new comment
  • Critical Oracle Security and Stability Flaw Discovered

    by Robert Buda | Jun 17, 2013 | Backup and Recovery , Database Security , Oracle

    Reading Time: < 1 minute Infoworld today announced that they have been researching a flaw in oracle that can result in the inability to restore your database. Large oracle shops with interconnected databases are most at risk. The problem revolves around oracle’s SCN (system change number). The number has a limit that if exceeded, can render a database unusable, even after restoring the database. Under normal circumstances, this limit would never be reached. However, there are two ways that the…..

    Read more Add new comment
  • Fast and Simple: Use Cases for noSQL Database Technology

    by Robert Buda | May 9, 2013 | NoSQL

    Reading Time: 2 minutes The relational database has ruled information technology sectors for decades. Ask any analyst, report writer, or database admin about day-to-day issues, and they are likely to recount headache-filled hours spent on joins and query troubleshooting. Although NoSQL technology is not about to replace the reigning data champion, NoSQL is being leveraged across multiple applications and enterprises with good results. Here are a few use cases for NoSQL databases. Varied Data Models for Varied Problems: The Netflix Solution…..

    Read more Add new comment
  • Total System Failure: Why you should validate your database backup

    by Robert Buda | Apr 23, 2013 | Backup and Recovery , Best Practices , Database

    Reading Time: 3 minutes Every now and then things happen that make us realize how important double checking things can be. I had a recent experience in which four unrelated parties (including me) did the wrong thing regarding one business transaction. If any one of us had done the right thing, there would have been no problem. But all four parties dropped the ball, causing potentially serious problem. This is why it is important to leave nothing to chance……

    Read more Add new comment
  • Database Downtime: Prepare For The Unexpected

    by Robert Buda | Jan 21, 2013 | Backup and Recovery , Best Practices , Database

    Reading Time: 2 minutes Test your Assumptions: Database Backup and Recovery Every now and then something happens that really drives home the need to test and validate the assumptions that we have about the availability of our IT assets. I had an experience this week that brought to mind the importance of testing backup and recovery and business continuity plans. Planning At the beginning of each week, I look at each day’s activities and any travel that I need to…..

    Read more Add new comment
  • Relational Database Design: It’s All About The Set

    by Robert Buda | Dec 5, 2011 | Best Practices , Database , MySQL , SQL Server

    Reading Time: 5 minutes The Lost Science of Relational Algebra and Set Theory. I originally wrote this post in 2011. Much has changed in the database technology landscape since then. Big Data Technologies such as Hadoop have gone mainstream, cloud technology and is changing how and where we think about hosting our databases. But relational databases are still relied upon as the best option for rich transactional data. So, since this technology is still the foundation of our mission critical…..

    Read more Add new comment
  • Query Rewrite: What is MySQL Doing To My Queries?

    by Robert Buda | Nov 30, 2011 | MySQL

    Reading Time: < 1 minute The Impact of Query Rewrite on MySQL Query Optimization When processing a query, every relational database vendor takes a number of similar steps to parse, validate, and optimize a query. MySQL does the following: Validates the query syntax — does it use valid operators, are the clauses in the proper order, etc. Validates the query semantics — are the the objects (tables, views, columns) valid database objects in the database, etc. Transforms the query —…..

    Read more Add new comment
  • Database Security: Is Your Database Vulnerable To Internal Attack?

    by Robert Buda | Nov 15, 2011 | Database Security

    Reading Time: 2 minutes Enforcing Least Privilege To Enhance Database Security The principle of least privilege refers to the practice of ensuring that each individual has only the privilege and access that is necessary to perform their job function. In most IT shops that run an Oracle database, there are a group of individuals that need administrative access to the operating system and the database. These individuals include both operating system administrators and database administrators. In order to ensure Database Security, particularly Oracle Security, it…..

    Read more Add new comment
  • Database Security Issues in the Cloud, Part 2: Regulatory Compliance

    by Robert Buda | Aug 26, 2011 | Best Practices , Cloud , Database Security

    Reading Time: 2 minutes As the number of databases moving to public, private and hybrid cloud computing infrastructure increases, security concerns are a significant and growing problem. Organizations will do well to scrutinize the security practices of cloud providers and other third parties that store their data. But wherever databases are running, responsibility for the security and integrity of data ultimately rests with the organization that owns the data – even when it resides with a service provider. As…..

    Read more Add new comment
  • Advantages and Disadvantages of Disk-based Backup and Recovery

    by Robert Buda | Jul 14, 2011 | Backup and Recovery , Best Practices

    Reading Time: 2 minutes While tape-based backup approaches may still be optimal for long-term data retention, more and more database storage/backup administrators are moving from tape to disk technology for everyday data backup and recovery. This is not surprising as disk is faster to write to and faster to recover from, as well as more reliable overall. A further advantage of disk backup is the ability to perform deduplication on the data being backed up, which reduces both backup/recovery…..

    Read more Add new comment