Upcoming Events

Cloud Connect
Santa Clara
Feb 13-16, 2012

Cloud Connect brings together the entire cloud eco-system to better understand the transformation we're experiencing and promises to be the defining event of the cloud computing industry. Learn about the latest cloud technologies and platforms from thought leaders in Cloud Connect’s comprehensive conference.

Register Now!

More Events »

Subscribe to Newsletter

  • Keep up with all of the latest news and analysis on the fast-moving IT industry with Network Computing newsletters.
Sign Up



  F E A T U R E 
The Name of the Game: IP Addressing

August 23, 1999


To SQL or Not To SQL?
The biggest difference among the products we tested was the type of primary data store each uses. Nortel's NetID and Lucent's QIP Enterprise both rely on a strong SQL database to store the configuration and, to a varying degree, on runtime data. This means that you can use the included Oracle or Sybase database or use another SQL server that you run on your network. The other products--Shadow IP, Join and MetaIP--rely on a non-SQL back end to store data.

Two factors to consider when purchasing NetID or QIP are price and administration. If your organization is licensing a SQL server, you do not need to install a special version just for the product. Besides, that's a job for a database administrator, not for a network administrator. For purchasers who already own a SQL server, both Nortel and Lucent said they would reduce the sales price of their products accordingly.

However, if you do not have access to a SQL database, the picture becomes murky. Clearly, if you are a network administrator, you most likely do not have database administration experience, much less training. While all the products (including NetID and, to some extent, QIP) can be installed with ease, data-store maintenance will cause problems. For instance, NetID offers full single-point-of-failure protection only if you are using a redundant SQL database.

Which type of product is right for you? That depends. If your company owns a SQL database and has the staff to run it, you might be able to leave the data storage and protection worries to them.

This is not to say that a centralized database is necessarily the better alternative. It has its advantages, especially in lookup and reporting, but it has drawbacks as well. The alternatives to SQL storage are not only easier to install, they also generally are able to do self-maintenance. We have found that problems with noncentralized storage products are easier to solve than any difficulties with database-centric products. The only issues are in reporting and in customizing the package. SQL provides an open means to access your storage, whereas the alternatives generally limit you to what each program offers.

PAGE: 1 I 2 I 3 I 4 I 5 I 6 I 7 I 8 I 9 I 10 | NEXT PAGE
 

Research and Reports

Hypervisor Derby
August 2011

Network Computing: August 2011

TechWeb Careers