LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 01-10-2002, 01:52 AM   #1
Rutnut
Member
 
Registered: Dec 2000
Posts: 112

Rep: Reputation: 15
Database Management Systems


Q. What is a Database Management System.

Is Oracle one, or an SQL server one, a Client one or is Microsoft Word a DBMS.

I know it might be a stupid question but it would really help.

Can you give any examples please.

Thanks
 
Old 01-10-2002, 07:24 AM   #2
piranha
Member
 
Registered: Jan 2002
Distribution: Gentoo Linux 1.4
Posts: 52

Rep: Reputation: 15
A dbms is the part between your program and the raw data. The dbms handles the requests (querys, add, remove) of your program. The dbms can be mysql, mssql, access, ado, ... It calculates the fysical location of the selected rows in the datafile and returns those rows.
 
Old 01-10-2002, 04:46 PM   #3
keymoo
Member
 
Registered: Jan 2002
Location: UK
Distribution: Desktop - Ubuntu, Server - Debian, CentOS
Posts: 72

Rep: Reputation: 15
DBMS is a Database Management System. Microsoft SQL Server is one (and very good it is, too), Oracle, IBM DB2, Sybase, MySQL are all DBMSs.

DBMSs store data in things called tables like a grid, although they are not spreadsheets. They allow you to query data, store data and manipulate data. All posts in this forum are stored in a MySQL database in a table called Posts (probably). Each table will have a number of columns and each column will describe an aspect of the thing you're storing. ie. Post table might have columns such as MessageText, Smilies, Title, etc

They do not:
Present data - browsers and applications do this.

HTH
keymoo.

Last edited by keymoo; 01-10-2002 at 04:48 PM.
 
Old 01-12-2002, 01:18 AM   #4
Rutnut
Member
 
Registered: Dec 2000
Posts: 112

Original Poster
Rep: Reputation: 15
Thanks for your replies they have helped a great deal, it's great to have a very site like this.

Thanks again.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
content management systems hirts123 Linux - General 10 10-02-2005 04:20 PM
Graphical management tool for multiple systems? Ethan Linux - Software 4 05-05-2005 11:51 AM
database file systems bobwall Linux - General 1 11-04-2004 04:37 AM
Remote Systems Management professorfrink Linux - Software 0 03-23-2004 09:45 AM
User database management homerjpbody Linux - Newbie 1 12-01-2003 03:10 PM


All times are GMT -5. The time now is 09:22 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration