Defining Database Availability

Before anyone can reasonably discuss the importance of data and database availability, it is necessary to first have a good definition of availability. After all, we should know what we are talking about. Simply stated, availability is the condition wherein a given resource can be accessed by its consumers. So in terms of databases, availability means that if a database is available, the users of its data—that is, applications, customers, and business users—can access it. Any condition that renders the resource inaccessible causes the opposite of availability: unavailability.

Another perspective on defining availability is the percentage of time that a system can be used for productive work. The required availability of an application will vary from organization to organization, within an organization from system to system, and even from user to user.

Database availability and database performance are terms that are often confused with one another, and indeed, there are similarities between the two. The major difference lies in the user’s ability to access the database. It is possible to access a database suffering from poor performance, but it is not possible to access a database that is unavailable. So, when does poor performance turn into unavailability? If performance suffers to such a great degree that the users of the database cannot perform their job, the database has become, for all intents and purposes, unavailable. Nonetheless, keep in mind that availability and performance are different and must be treated by the DBA as separate issues—even though a severe performance problem is a potential availability problem.

Availability comprises four distinct components, which, in combination, assure that systems are running and business can be conducted:

  • Manageability—the ability to create and maintain an effective environment that delivers service to users
  • Recoverability—the ability to reestablish service in the event of an error or component failure
  • Reliability—the ability to deliver service at specified levels for a stated period
  • Serviceability—the ability to determine the existence of problems, diagnose their cause(s), and repair the problems.

All four of these “abilities” impact the overall availability of a system, database, or application.

Advertisements

About craig@craigsmullins.com

I'm a strategist, researcher, and consultant with nearly three decades of experience in all facets of database systems development.
This entry was posted in availability, backup & recovery, DBA, performance. Bookmark the permalink.

6 Responses to Defining Database Availability

  1. bbom says:

    this is very nice one and gives in depth information. i think it will be helpful. thank you very much for that extraordinarily first class editorial! keep up the good work.

  2. usb powered monitor says:

    Thanks for your sharing, I appreciate this. Keep up the good work.

  3. N W A D says:

    i like this website so much!

  4. Bobbie Nevis says:

    I simply want to mention I am just beginner to blogging and site-building and actually enjoyed you’re web site. More than likely I’m going to bookmark your blog . You certainly have fantastic article content. Many thanks for sharing your web page.

  5. Judson Wattenberg says:

    I simply want to tell you that I am just beginner to blogging and site-building and certainly loved you’re website. Very likely I’m planning to bookmark your blog . You surely come with very good article content. Thanks a bunch for sharing your blog site.

  6. lista de emails says:

    nice site. good job.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s