Web Hosting FAQs
  Home arrow Web Hosting FAQs arrow Database Hosting FAQ
Web Hosting Articles  
Web Hosting FAQs  
Web Hosting How-Tos  
Web Hosting News  
Web Hosting Security  
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter 
 
Developer Updates  
Free Website Content 
ASP Web Hosting  
ASP.NET Web Hosting 
Budget Hosting 
Coldfusion 
Colocation 
Mobile Linux 
APP Generation ROI 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Reseller Web Hosting 
Shared Hosting 
Small Business Hosting 
Virtual Private Servers 
Windows Web Hosting
 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
WEB HOSTING FAQS

Database Hosting FAQ
By: Developer Shed
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 4
    2004-09-14

    Table of Contents:

    Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Learn about database hosting, whether you need it and what is involved in our database hosting FAQs section.

    What is Database hosting? 
    In most cases a database host is a specific kind of dedicated server, which is going to be used to run a database intensive application. The server can either be just for the database itself or it could also run the web site too, it really depends on how much system resources will be needed by the database. A system setup to run intense database applications will have a significant amount more RAM than a regular server. For example, if you are looking at a regular web-hosting server and you think 512 Megs will be enough then you would probably be looking at between 1 Gig to 2 Gigs for a database server.

    Who needs a database host?
    Anyone who is using a database intensive program like a CRM, ERP, or a custom made application should look into a database host because they have more memory, which will increase the speed and reliability of the application.

    Why use a database server? 
    A database server is just a specific kind of dedicated server. So if a database server fits your needs it is something you should look into.

    What are some applications that might run on a database server? 
    Some examples of applications that are used on database servers are CRM (Customer Relationship Management) and ERP (Enterprise Resource Planning) systems.

    Can a database server only be used for a database? 
    No a database server can be used for anything but it is a specific kind of dedicated server that is setup to get the maximum performance out of a database or applications that rely heavily on a database. To do this the server has a large amount of memory and a few other configurations are done so that the database is the priority over anything else running on the system.

    Why do database servers contain more RAM? 
    Database servers are interesting pieces of software in that they store megs and even gigs of information in tables, which are made up of columns and rows, and yet doing a simple command we can get a result set that match the information we want in a matter of tenths of a second. Just as an example, google.com strives to keep all its searches down below half a second and they have over 3 trillion web pages in their database.

    Very quickly, without getting to in-depth on how database software works, I will cover why having more RAM usually speeds up the process of getting data from a database. It is about 10 times faster to get data out of RAM, as it is to get data off a hard drive. This means that if we were to store some of the database data in RAM then getting results from that data in ram would be at least 10 times faster than if we pulled it off of the hard drive. Due to this fact database software developers use special algorithms to figure out what data to store in RAM so that results from queries are faster. The more RAM the server has the more data from the database can be stored in it and that leads to faster results. When the database is the key part of the entire application faster is always better so this is why database servers have so much more ram than a regular web server.

    Does my E-commerce site need a database host? 
    Chances are you do not need a database host for your E-commerce site, you probably just need a web-hosting package/plan that gives you access to a database. The difference here between a database host and having access to a database is significant. When doing database hosting the database is the most important part of the entire application and is where all the processing is done.

    What kind of administration is needed? 
    Just like in a dedicated server there is a lot of work to be done. Unlike a regular dedicated server though there will be more time spent on doing database administration tasks: optimizing tables and other database specific tasks.

    If you do not know exactly what needs to be done or don’t have someone to do it for you then you might be interested in a managed system. A managed system is where the hosting company does some or most of the system security patching for you. This also includes general maintenance in most cases but you should ask about specifics.

    Other companies that don’t have “managed” database servers are usually able to sell you a service along with your hosting package for a monthly fee, which usually includes patching of the server and regular maintenance. Then beyond that they will do optimization of the tables and check to make sure the tables are setup in such a way that it does not take more resources than it should in terms of how long it takes for queries to finish running. If you needed a database server and do not have the time or desire to do all the maintenance on it then you might be interested in looking for a managed server or at least an add-on service package that will have the hosting company take care of the maintenance for you. 


    What about custom software on a database server?
     
    The developer of the software should give you guidelines as to how much disk space, memory, and processing power is needed just to run the software. They should also tell you what is required per user beyond just running the server. From this point you will have to figure out how many users will be connected at the same time. Once you know how many users will be connected at the same time and how much resources are needed per user just do the simple multiplication to figure out exactly what is going to be needed. A database server is great for applications that heavily use a database and require a lot of memory so if your results show you need a lot of memory then a database server is the best way to go.


    Glossary of terms:

    Database
    A database is a collection of data in tables and rows arranged in such a way that searching and retrieving the data is quick.

    MySQL
    “The world’s most popular open source database” as they say. MySQL does not have all the features the other database servers have but because it leaves out a few features it tends to be faster than some of the other database servers.

    MS SQL
    “The enterprise relational database management and analysis system” as Microsoft calls it. Microsoft’s SQL server runs on the Windows operating system.

    CRM
    Customer Resource Management systems usually run on database servers because they are database intensive applications. While there are some web based CRM systems most are not web based and therefore require a special client to connect to the system. CRM systems are used to manage issues with customers to make sure no one is left unhappy.

    ERP
    Enterprise Resource Planning systems usually run on database servers much like CRM systems because they are database intensive applications. Much like CRM systems, ERP systems are not usually web based either and require a special client to connect to the application. ERP systems are used to help companies manage their resources from money to personnel to make the most of what they have.

    Dedicated Server
    The Dedicated Hosting environment provides an exclusive server or servers devoted solely to your web site. You do not share a server with other customers, as with shared hosting.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More Web Hosting FAQs Articles
    More By Developer Shed

     

    IBM® developerWorks developerWorks - FREE Tools!


    Build Forge Express demo: Enabling software delivery excellence for small and midsized businesses

    This demonstration gives you an overview of IBM® Rational® Build Forge Express Edition, a global offering that provides a framework to automate and execute software processes. Rational Build Forge provides a software assembly line that can support all of your tools, technologies, and platforms so you can achieve a repeatable, reliable, and traceable build and release process.
    FREE! Go There Now!


    NEW! Applying lean thinking to the governance of software development

    Effective governance for lean development isn’t about command and control. Instead, the focus is on enabling the right behaviors and practices through collaborative and supportive techniques. Hear from Scott Ambler on how it is far more effective to motivate people to do the right thing than it is to force them to do so. Learn how to form a lightweight, collaboration-based framework that reflects the realities of modern IT organizations.
    FREE! Go There Now!


    NEW! BlammoSplat: Build a community Web site of OpenLaszlo animations, Part 3: The community animation

    Learn to enable users to both rate existing animations and to combine existing animations into new snippets. This is the third in a series of three tutorials that chronicle the building of a site that enables collaborative discussion and animation building using Domino and OpenLaszlo.
    FREE! Go There Now!


    NEW! Download DB2 Express-C 9.5

    Visit IBM developerWorks to download IBM DB2 Express-C 9.5, a no-charge version of DB2 Express 9 database server. DB2 Express-C offers the same core data server base features as other DB2 Express editions and provides a solid base to build and deploy applications developed using C/C++, Java, .NET, PHP, and other programming languages.
    FREE! Go There Now!


    NEW! Download IBM Data Studio V1.1

    Visit IBM developerWorks to download the latest trial version of IBM Data Studio V1.1 at no cost. IBM Data Studio is a comprehensive data management solution that helps you effectively design, develop, deploy and manage your data, databases, and database applications throughout the data management life cycle utilizing a consistent and integrated user interface. Unlike other client-side data management solutions that focus on only one aspect of the application lifecycle or database administration, Data Studio complements the Rational Software Delivery platform, providing unparalleled flexibility for a heterogeneous data server environment across platforms.
    FREE! Go There Now!


    NEW! Download the free Web Application Security eKit

    Discover how IBM Rational AppScan Standard Edition can help you detext vulnerabilities in your web applications in the Web Application Security eKit. IBM Rational AppScan is a leading suite of automated web application security solutions that scan and test for common Web application vulnerabilities. The new Web Application Security eKit provides you with valuable resources, including white papers, demos, and additional information on the benefits of testing your Web applications.
    FREE! Go There Now!


    NEW! Evaluate Rational Host Access Transformation Services (HATS) Toolkit V7.1

    Visit IBM developerWorks to download a free trial of the Rational Host Access Transformation Services (HATS) Toolkit. The HATS toolkit provides a set of plug-ins for the IBM Rational Software Delivery Platform to help you easily extend your legacy applications. HATS makes your 3270 and 5250 applications available as HTML through the most popular Web browsers, while converting your host screens to a Web look and feel and it also enables you to develop new Web, portal, and rich-client applications.
    FREE! Go There Now!


    NEW! Rational Modeling Extension for Microsoft.Net

    Rational Modeling Extension for Microsoft .NET enhances usability for code generation supporting a more intelligent refactoring. The latest enhancements enable organizations with Java and .NET systems and software development maintain architectural integrity across heterogeneous platforms.
    FREE! Go There Now!


    NEW! Trial download: IBM Lotus Forms V3.0

    Get a free trial download of IBM Lotus Forms V3.0 (formerly Workplace Forms), which provides a zero-footprint eForms solution to help you automate and move forms-based business processes off the desktop and onto the Web. With Lotus Forms, you can extend applications beyond the firewall by creating a single electronic form document ready for use in both thick and Web 2.0 thin client format.
    FREE! Go There Now!


    NEW! Webcast: Striking the right balance between manual and automated testing

    Join this webcast to learn how IBM Rational's Functional Testing solution enables you to implement automation your way, at your pace, with your existing staff. In this webcast, you’ll learn how you can eliminate redundancy of manual test scripts, reduce errors, and increase test coverage through test automation. After this presentation you will understand how IBM Rational Functional Testing solution can streamline your manual testing and make test automation easily attainable.
    FREE! Go There Now!



    All FREE IBM® developerWorks Tools!

    WEB HOSTING FAQS ARTICLES

    - What is Cybersquatting?
    - Web Hosting 101
    - Should You Buy Domains Solely For Their PR?
    - Designing Flash Websites: Pros and Cons
    - Reseller Web Hosting: Frequently Asked Quest...
    - Blogs: Frequently Asked Questions
    - Database Hosting FAQ
    - Reseller Web Hosting FAQ
    - Virtual Private Servers FAQ
    - Colocation Web Hosting FAQ
    - E-Commerce Hosting FAQ
    - Exchange Hosting FAQ
    - Enterprise Web Hosting FAQ
    - Windows Web Hosting FAQ
    - Managed Web Hosting FAQ






    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 Hosted by Hostway
    Stay green...Green IT