Database Management Systems (DBMS)

Introduction :
1.  Other name is database manager.
2.  DBMS consist of software that operates databases, providing storage, access, security, backup & other facilities.
3.  A program that give 1 @ > computer users create and access data into database.
4.  The DBMS manages user requests to lead the users & other programs are free from  having to understand.
5.  It can be think of as a file manager that manage databases rather than files in file systems.
6.  DBMS can be categorized according to the database model that they support(such as : relational @ XML), the types of computer they support(such as : server cluster @ mobile phone), the query languages that access the database(such as : SQL @ XQuery), performance trade-offs(such as maximum scale @ maximum speed @ others).
7.  To get more information, please refer to http://en.wikipedia.org/wiki/Database ,
     http://searchsqlserver.techtarget.com/definition/database-management-system


DBMS Usage :
1.  Once database are created, the DBMS can to select records that meet user requirements based on the information in their fields. Exp : the user can check the availability of a product that meets certain criteria, such as style, colour, & additional features by using an inventory database.
2.  Different DBMS offer different method of entering commands or "queries" to retrieve information.
3.  Most common query command format is Structured Query Language(SQL) because it allows several users on a network to access a database simultaneously.
4.  DBMS allow the user to sort data in the field by any criteria, this could involve all records in a database and meet specified selection criteria.
5.  This software allows for generation of various printed @ electronic reports from the selected data.
6.  Mailing labels can be created by printing data from name & address fields.
7.  Some DBMS also incorporate additional software features, such as spreadsheet, word processing, and communications functions, permitting further manipulation of information retrieved from the database.
8.  For more information, please refer to http://www.referenceforbusiness.com/encyclopedia/Cos-Des/Database-Management-Systems.html

The informations are come from :

 http://wiki.answers.com/Q/Disadvantages_of_database_management_system

Advantages : 

• Reduced data redundancy
• Reduced updating errors and increased consistency
• Greater data integrity and independence from applications programs
• Improved data access to users through use of host and query languages
• Improved data security
• Reduced data entry, storage, and retrieval costs
• Facilitated development of new applications program

Disadvantages :

• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users

                 
                            http://www.fao.org/docrep/003/w0615e/W0615E05.HTM



Citation :
1.  http://en.wikipedia.org/wiki/Database
2.  http://searchsqlserver.techtarget.com/definition/database-management-system
3.  http://www.referenceforbusiness.com/encyclopedia/Cos-Des/Database-Management-Systems.html
4.  http://wiki.answers.com/Q/Disadvantages_of_database_management_system

CHAPTER 12 - DATABASES

DATABASES

1. A database is a system intended to organize, store, and retrieve large amounts of data easily. 
2. It consists of an organized collection of data for one or more uses, typically in digital form.  
3. Digital databases are managed using database management system, which store database contents, allowing data creation and maintenance, and search and other access.  
4. Traditional databases are organized by fields, records, and files. 
5.  A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records.  
6.  Example, a telephone book is analogous to a file, it contains a list of records, each of which consists of three fields: name, address, and telephone number.  
7. An alternative concept in database design is known as hypertext. 
8. In a Hypertext database, any object, whether it be a piece of text, a picture, or a film, can be linked to any other object.  
9. Hypertext databases are particularly useful for organizing large amounts of disparate information, but they are not designed for numerical analysis.        

                     

                             http://www.filebuzz.com/findsoftware/Kernel_Access_Password_Recovery_Serial/1.html  

                                      

                                  http://exonous.typepad.com/mis/2004/03/relational_data.html 

DATABASE MANAGEMENT SYSTEM  (DBMS)

• A collection of programs that enables you to store, modify, and extract information from a database. 
• There are many different types of DBMS, ranging from small systems that run on personal computers to huge systems that run on mainframes. 
• Consists of software that operates databases, providing storage, access, security, backup and other facilities.  
• Database management systems can be categorized according to the database model that they support, such as relational or XML, the type of computer they support. 
• Examples of some commonly used DBMS are MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker,Oracle,Sybase, dBASE, Clipper,FoxPro. 
• DBMS may be built around a custom multitasking kernel with built-in networking support, but modern DBMS typically rely on a standard operating system to provide these functions.   
• When a DBMS is used, information systems can be changed more easily as the organization's information requirements change.   

Advantages Database Management System 

• reduced operative expenses 
• quick and accurate decisions based on historical data  
• multi user and change capabilities  
• streamlined and structured workflow capabilities  
• client relationship and business management  
• Facilitated development of new applications program      

Disadvantages Database Management System 

• Database systems are complex, difficult, and time-consuming to design
• Substantial hardware and software start-up costs
• Damage to database affects virtually all applications programs
• Extensive conversion costs in moving form a file-based system to a database system
• Initial training required for all programmers and users   

                                                     http://www.pentasoft.com.my/sw.php?pg=pisf    

       http://www.fig.net/pub/proceedings/korea/full-papers/session24/scheu-rosenbaum.htm     

CITATION :   

• http://en.wikipedia.org/wiki/Database_management_system   
• http://www.webopedia.com/TERM/D/database_management_system_DBMS.html   
• http://en.wikipedia.org/wiki/Database  
• http://www.webopedia.com/TERM/D/database.html  
• http://wiki.answers.com/Q/Benefits_of_database_management_system 
• http://wiki.answers.com/Q/Disadvantages_of_database_management_system  
• http://www.wisegeek.com/what-are-the-advantages-of-dbms.htm