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 :
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
No comments:
Post a Comment