Archive for the ‘database’ Category

Let’s Virtualize Everything! (Including Your Databases?)

Wednesday, January 6th, 2010

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Image CreditAfter You've Virtualized The Servers, Why Not Virtualize The Databases Too?

After You

The next time that you are at one of those cocktail parties that they throw for up-and-coming IT staffers who will someday become the CIO (you go to those don’t you?), do me a favor and listen very closely. I suspect that you’ll overhear a number of pretentious CIO-wannabes throwing around the phrase “virtualization”. Don’t worry about these showoffs, I’ve got something bigger and better for you to throw out there: database virtualization.

Have You Caught Vitalization Fever?

Maybe it would be helpful if we took a step back for just a moment and had a quick look at the virtualization landscape. A few years back, IT departments were running into a real estate problem: too many servers, not enough data center room. Any technical problem calls out for a technical solution and this one was solved by a company called VMware.

What VMware (now owned by EMC) did was to create a piece of software that sat between the operating system and the computer hardware. This software allowed multiple (different) operating systems to run on a single server without impacting each other. Ta-da! All of a sudden a mail server and a web server which were on different boxes could now be on a single box. Problem solved!

All of this server virtualization success has led IT folks to start thinking about what else they could virtualize. Right now everyone is thinking about virtualizing the desktop — great for call centers and large enterprises where keeping everything patched and up-to-date is a full-time job for many. This hasn’t hit big time just yet; however, wait a bit and it just may take off.

What nobody is really talking about yet is what will probably be the next really big thing in virtualization: making your databases virtual.

What Is A Virtual Database?

In a nutshell, when you virtualize a database you take the rows and columns of data are currently living in one of your multiple databases and you allow them to be more fluid. They are no long bound to living on a given server, now they can reside almost anywhere.

Why would you even dream of tampering with your company’s crown jewels like this? It turns out that there are three main drivers for considering taking your databases virtual: easier management, higher availability, and better performance.

One key point here: if you are currently using DB2 or SQL Server or some mainstream database, you get to keep using it. Additional software is added to the back end so that you can use a shared-nothing cluster of commodity servers.

The way that we build database systems today is to create a single-purpose system that has an active and a passive side. In essence, we only use 50% of our investment. In a database virtualization deployment all database servers are active at the same time.

You might think that this would require you to purchase additional database licenses. It turns out that you’d be wrong. Database virtualization allows you to decouple the database from the data and from having the data reside on a specific server.

What All Of This Means For You

As CIO you will be under constant pressure to reduce your operating costs. One of the biggest drains on your budget will be supporting all of the databases that your firm uses. Industry reports say that many firms have upwards of 15,000 separate databases that they are using. Additionally, more than 30% of the data in these databases is duplicated because databases can’t talk to each other.

The arrival of database virtualization will provide you with an option. This option will allow you to boost your database performance, reduce your risk of an outage, and reduce your overall IT costs. Sure sounds like database virtualization is something that you should look into.

Two companies that are active in this space are: Xkoto and Xeround.

Do you think the benefits are great enough to risk virtualizing your company’s databases?

Click here to get automatic updates when The Accidental Successful CIO Blog is updated.

What We’ll Be Talking About Next Time

A quick quiz for you: what has been the #1 task on every CIO’s to-do list for the better part of the past 20 years? If you guessed “aligning IT with the rest of the business” then you are correct. This has been an IT goal for the past 20 years? What’s up with that? When you become CIO what are you going to do to solve this problem. Can it even be solved?

Say Goodbye, Your Database Is Going Away

Wednesday, November 11th, 2009
Image Credit What Will Your IT Department Do Without Its Databases?

What Will Your IT Department Do Without Its Databases?

You know that database that your company relies on? No, not that one, the other one that is really, really important? Yep, that one – it’s going away, are you ready? It turns out that the databases that we’re using today were not designed for what we are asking them to do. All sorts of things like trying to deal with lots and lots of unstructured data is killing them. Looks like it’s time to go find yourself a new database. Are you ready?

The CIO’s Other Job

When you become CIO you are very quickly going to discover that on top of all of the cost cutting, uptime boosting, and IT team building that you have to do, you have yet another job. This is the job of chief technology visionary. The rest of the company (non-IT parts) are going to be looking at you to be all knowing and predict the (technology) future.

This means that you are going to be constantly learning. You’ll have to keep your fingers in a whole bunch of different pots so that when your CEO boss comes to you and says “I just read something about cloud computing, what does this mean for us?” you’ll have a smart and snappy comeback.

The Deal With Databases

As an example of the type of information that you are going to have to be staying on top of, let’s take a moment and talk about databases. They are the workhorses of the modern IT department. We set them up, pound them with requests, and desperately try to keep their contents secure.

However, we are at a critical junction with databases right now and things are getting ready to change. Are you going to be ready to tell your management and peers why things have to change and how they are going to turn out? If not, then read on.

Back in May of 2008 out at the Claremont Resort in Berkeley, CA, Rakesh Agrawal and 26 other prominent database researchers got together to talk about this very issue. What came out of this meeting is what you need to know.

Causes…

Databases have to change. There are a number of reasons why they need to change and how they need to change. Here are some of the reasons that the brightest minds in the database world think that changes are coming:

  • Big Data: the datasets that we are working with have just become huge. What used to be an exception that was limited to government statisticians or astrophysicists, has now become almost commonplace and today’s databases were never designed to deal with this much data.
  • Big Money In Data Analysis: databases used to be something that ran quietly in the backoffice. However, nowadays databases are operating close to the front lines of business and are responsible for driving corporate profits. The arrival of business intelligence software has turned databases into real-time engines, a job that they were never designed for.
  • Unstructured Data: today’s databases like data that can be broken up into comma delimitated fields. However, a lot of the data that you find in a modern workplace is of the unstructured format: blogs, documents, web pages, etc. The databases that we are using were never designed to deal with data that is in this format.
  • The Arrival Of : Why Use The Cloud?” href=” http://www.theaccidentalsuccessfulcio.com/cloud-computing/cio-cloud-computing-101-why-use-the-cloud”>Cloud Computing: the very architecture of the corporate data center is starting to change. Will the database remain onsite or will it be hosted? How about the data that it is using – where will that be located? What kind of data latency and security issues will this cause?

… and Effects

“Great!” I can hear you saying, so things are going to change. How are they going to change – what will the future look like? The answer is … I don’t know. However, with the help of those smart database researchers we can predict what areas you are going to see the most change in (and thus are where you should be watching):

  • Database Engine changes: it’s got a Hemi! Well, maybe not but today’s database engines have been tuned for specific tasks (OLTP anyone?) and will basically need to be rebuilt from the ground up in order to deal with tomorrow’s data needs.
  • Programmer Productivity: no matter how fast your database engine runs, if it takes your database programmers forever to program it, then business will still be moving too slowly. Creating a way for your non-expert database programmers to create good code that can run in a multi-processor environment is going to be a must.
  • Data Harmony: in future databases both structured and unstructured data are going to have to learn to get along with each other. Structured data is not going away even as unstructured data continues to grow. Tomorrow’s databases are going to have to be able to deal ably with both at the same time.
  • The Mobile World: the need to be able to provide real-time services to a large collection of mobile users who will be generating lots of user created data will become a critical function that tomorrow’s databases will need to be able to provide. The need to participate in virtual worlds as a mobile user will only increase the amount of data that will need to be processed.

What All This Means For You

When you become CIO, you are going to instantly be thrust into a spotlight where the rest of the company is going to be looking to you to understand and translate all of the changes that are occurring in IT technology. This will be a new role and in order to do it, you are going to have to start spending time researching what is going to be happening next in IT.

Your database systems are going to be a big part of the IT technology change. The reason that database systems are going to have to change range from the arrival of massive datasets, real-time processing demands, the arrival of unstructured data, and the emergence of cloud computing.

As a CIO you are going to have to be able to determine what changes in the database field you are going to have to watch because they will determine how the databases that you’ll be using tomorrow will operate. The key areas that will require your attention will include database engine changes, programmer productivity, data harmony, and support for mobile applications.

Spending your limited time watching these specific areas will provide you with the key insights that you will need in order to predict the future of database technology. Once you start doing this, you will have become the technology visionary that your firm wants in their CIO.

What function do you hope to add to your databases in the future?
Click here to get automatic updates when The Accidental Successful CIO Blog is updated.

What We’ll Be Talking About Next Time

So this story should probably be filed in the “it should have never happened” drawer: Microsoft has lost the information that T-Mobile users of the Sidekick mobile phone entrusted them to store for them. Wait a minute, isn’t this the grand and glorious 21st Century in which data loss like this is never supposed to happen any more? How did Microsoft’s CIO let the ball get dropped like this?