what are the classifications of the database servers and what is ment by commercial database servers ?
922069
Your question is pretty open-ended... And you got so many questions here! :)\n\nClassification of database server... There are usually four classes that I see: desktop, multi-user, client-server, cluster-server. Those may not be the formal terms used in the industry, BTW. As I did not read YOUR text, I may have a different system of classification than your text, so... caveat emptor! :)\n\ndesktop -- your typical single user database, Access, Paradox, Filemaker, etc. \n\nMulti-user -- most of these programs will also work with multiple users when installed and configured on a network. \n\nClient-server -- A dedicated server program, that talks to SQL clients over a network. Examples are MS SQL Server, Oracle 9i, and so on. \n\nCluster-Server -- a database server that runs on a GROUP of servers (i.e. a cluster) \n\nWhere are they used? Anywhere there is data! Accounting system has a database system as its foundation. All Customer Relations Management (CRM) software are basically databases. A mailing list is a database, so is an addressbook, a phonelist, and so on. Most websites (such as this Yahoo Answers site) that requires interaction has a database backend where answers and questions and user data are stored. \n\nCommunication between the client and the server: there is no "standard" per se for those communications. Microsoft tried to impose a standard way back when, and with a little help from third-party the standard, known as ODBC (open database connectivity) actually stuck. Basically it defined a set of SQL commands that a database must minimally support. In other cases, the communication between client and server is that database's proprietary information. \n\nAdvantages? A database basically makes finding something easier. Say you want to check who among your clients are in California, or more specifically, northern California, you can find out by tapping a few commands, instead of going through each and every client record. For a short list there wouldn't be much difference, but the longer the list, the bigger the time savings. When the entry is a few thousand lines long, it is no longer practical to do by hand, and just imagine the size of a database used by the IRS to keep track of your tax info! The more complicated databases can also handle permissions, giving some people ability to enter but not delete, others view only, and so on and so forth. \n\nDisadvantage? Database usually cost money, at least the commercial ones. And most have a proprietary format and special commands that require expertise to use. You will need someone to set it up, then populate the data, and you will need\nsomeone to administer it later. It is another layer of complexity and expense. A database server that works well demands hefty hardware. We're not talking $500 desktops here, but rather $10000 dedicated servers armed with dual or quad Xeons / Opterons and 5-7 disk RAID arrays, and we haven't counted the software itself yet!
26037
In my opinion, look upto MySQL, it is the best database for your needs. Incase you have queries regarding its setup, you can lookup to the following professional forums where people discuss such problems :\n\n(1) http://forums.mysql.com/\n(2) http://forums.devshed.com/forumdisplay.php?forumid=4\n(3) http://www.ahfb2000.com/webmaster_help_desk/archive/index.php/f-47.html
717198
A collection of tables and other objects that support an application is called a schema.\nA database is a collection of system and schema data stored in files.  The files are organized into tablespaces for ease of reference.\nAn instance is the collection of processes that open the database and provide services to other programs and users by communicating with user sessions.\n\n- If you select a tablespace of an existing database for your application, you need to know what other applications are using that database instance.  Your performance will depend on how much resources of that database are already tied up by the other application schemas and sessions.  Your application will also have to shut down when those other applications need downtime for maintenance.  When the other users of that database upgrade to another version of oracle, you will have to upgrade with them.\n- If you select another database, the server that your database will run on needs to have enough resources to support two SGA memory structures.  You would be able to have that database tuned specifically for your database and to keep it running when the other database is down.  However, if the server is not large enough for two databases, your performance will suffer.
26847
Yep, their database servers have some serious problems sometimes. I've voted on answers before and gotten no points for it, which was very sad.
1167408
MySQL can handle that amount of queries, it depends on the available RAM and the CPU-time of the server that host MySQL.
1175671
collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: \ncomputerized library systems \nautomated teller machines \nflight reservation systems \ncomputerized parts inventory systems
969293
http://www.databaseanswers.org/data_models/
1137479
Here are some more discussions on the problems.\nhttp://forums.ebay.com/db2/forum.jspa?forumID=97
721004
Of course it has. There are too many flavours of AS/400 for it disappear (RISC, CISC, Netserver, Webhost etc). It has more power than many mainframes, yet is cheaper and smaller.\n\nDB/2 is the most commonly used DB in world.\n\nIt is very popular.
723480
The main database vendors in Microsoft, Oracle and IBM all now have a free express version of the database that can be downloaded and installed on a windows desktop.  I suggest you download and try it out for yourself.  It is difficult to get an independant opinion on the difference between each database as people will prefer the ones they are familiar with.\n\nAll three database types have relational tables, a simple SQL language, common objects such as procedures, indexes and triggers.  \n\nSQL Server used to be easier to install and administer but over time the three express versions are becoming easier to run so it is hard to seperate them.
831506
Go here...\nhttp://en.wikipedia.org/wiki/Database
206160
My guess is MySQL from looking at the front page of mysql.com.  I doubt they have only 1 solution for their entire company though.
30843
Well your question is not clear.But if you wanna know what a database system is ...\nA database keeps all possible information in the form of records that are normally maintained in the form of tables.\nThere are some really advance techniques of handling these databases using Oracle or SQL server or DB2 etc.\nIf you want to do some basic operations you'll have to learn the language called SQL(Structured Query Language) which is language for the manipulation of databases.\nThese systems are normally the backend support for systems whose front ends are visible to you in the form various Web Applications,Web services and other Desktop based applications.
23077
Your question needs a little more clarity.  Are you reffering to all applications feeding into one database, or creating one database from multiple databases?
1031966
Oracle\nDb2\nSQL Server \nSybase\nNCR Tera data/ PostGres\n\n\nand then you have MySQL too
332729
A popular one is Joomla (based on the original Mambo). Open-source (free; GPL liscense), clean interface, highly customizable. See sources below for link.\n\nRequires server with MySQL and PHP.\n\nEDIT: A quick check of the DEMO (privded through the site below) confirms that you can restrict registration.
471134
It's basically an invetory of clients or contact, i have developed one using c#, asp.net and sql server db :) let me know what you've go so far