DIY Guide to Selecting the Right Tool for the Database Project

By: Irene Kopaliani
Submitted: 2007-01-17 16:08:02
Print this article | Tell a friend | For publisher | Social Bookmarking
Rating:
 

As any person, who remodeled their home, will tell you that “choosing the right tool for the right job” makes all the difference. The same statement applies when choosing the right database for a project. Some databases are basic, some are “battery operated” and some are “mighty power tools.” Below is a guide on selecting the perfect database for the right project.

When you only need to store a limited amount of data and require a quick and easy development cycle, Microsoft Access is the right tool for you. It provides a powerful set of database and graphical user interface tools that allows the user to quickly organize, access and share information. Since Access is part of the Microsoft family of office products, it easily integrates with Excel, Word and SQL Server. In addition, it supports Open Database Connectivity (ODBC). However, if the database is going to hit 1GB threshold, you may encounter various performance issues, including slow response and record corruption. Microsoft Access is an equivalent of a Swiss army knife. Each part individually is not as impressive; however, when combined together, it produces an appealing solution.

My SQL is a viable alternative to Microsoft Access. Major advantages of My SQL are the low cost (licensing starts below $500) and platform independence (it can be installed on Windows, Linux, Macintosh and UNIX operating systems). My SQL does not, however, come with the development interface tools that Microsoft Access provides and would require the use of a programming language, such as Visual Basic, C, etc., to create user interface and reporting. This is your battery-operated power tool!

Microsoft SQL Server is a powerful alternative to My SQL and Oracle. It is moderately priced and yet quite powerful and scalable. It provides a user administration module capable of handling user, group and column-level security. Record-retrieval speed of the SQL Server outperforms both Microsoft Access and My SQL. In addition, Microsoft SQL Server is highly scalable. This is your power tool!

Oracle is the oldest of the relational database management systems (RDBMS) discussed in this overview and the most powerful. However, it is also the most expensive and most difficult to implement. Oracle is highly scalable and allows storage of a tremendous amount of records without jeopardizing performance. Like Microsoft SQL Server, it has a powerful user administration module. This is the mighty power tool!

When selecting the right tool for your next database project, keep in mind the following:

  • The size of the data to be stored over time;
  • Budgetary constraints;
  • Security essentials;
  • Future growth requirements;
  • Platform needs; and
  • Development tools.

    • Comparison Matrix and Cost and Functionality chart are available at www.cxtgroup.com/diy_db.pdf

    Irene Kopaliani is a programmer, database architect, author and speaker, as well as a managing director of CxT Group, Inc.(http://www.cxtgroup.com), which provides custom software solutions to mid-size companies. She can be reached at irene@cxtgroup.com or 877-439-2539.

    Article source: Expert Articles

    Most Recent Articles in Computers category

    • Online Poker Rooms: The best places for minting money - By: Melville Jackson
      he software is stable and responsive. Even with more than a thousand players using it simultaneously, the software has never crashed or slowed down till date.
    • Play Texas Hold 'em online: Get connected with your buddies - By: Melville Jackson
      Texas Hold 'em poker (also called Texas Holdem or Texas Hold'em) is one of the most popular card games available today.
    • Data Centre Solutions: Outsource the IT Infrastructure for Business Success - By: Isla Campbell
      When a company outgrows their existing IT infrastructure, what are the options available to them?
    • Computer Problems? Call the Computer Doctor - By: Elizabeth Gray
      Computers are one of the greatest things that we can have and it really opens up the world to us, especially when we are connected to the Internet. Unfortunately, computers can also be one of the most frustrating things that we can own and whenever they are giving us a problem, very few of us enjoy owning one.
    • Benefits of a Server Room Portable Air Conditioner - By: Jeanie Wong
      Server rooms are essentially rooms that house computer servers and in the informational technology sector, the term generally applies to smaller arrangements of servers, while larger groups of servers are housed in data centers. Learn how a server room air conditioner can benefit you.
    • The Technological Revolution - Pod casting For Beginners - By: Ravii Kumarr
      Podcasting is the latest technological revolution that happened in the World Wide Web. It is the latest innovation in broadcasting and a new medium in publishing shows. Podcasting show is termed as podcast.
    • To Find Easy Computer Financing - By: Sudhir Kumar
      Finding easy computer financing is not as simple for some as it is for others. Chances are that if you have perfect credit, you can finance just about anything.
    • Ipod Troubleshooting - By: Sumit Sharma
      Do you have an iPod that refuses to work the way you want it to? Looks like you need some help. If you poke around a bit online, you can find excellent iPod troubleshooting tips. Whatever your problems are, they can likely be fixed quite easily.
    • Looking Carefully When Shopping For A Turnkey Website - By: Adnan Ahmed
      When starting a new home based internet business, you can get overwhelmed with everything that you need to learn to get started and be successful. You will need to build and design your website, decide on how you will generate income from your website, and learn internet marketing techniques on how to promote and direct visitors to your new website.
    • Simple Ways To Success For Online Jv's - By: Prakash Singh
      1. Be Personal and different - most successful marketers get propositioned on a daily basis. 2. Find major players in your industry (well-known product creators, service providers, website owners, list owners etc..) and get to know them a little (join their newsletter, read their information, buy a product or 2 from them) and if possible speak to them in person or via the phone.