By its very nature, a DBMS permits many users to have access to its database either individually or simultaneously. It is not important for users to be aware of how and where the data they access is stored.
Backup and recovery are methods that allow you to protect your data from loss. The database system provides a separate process, from that of a network backup, for backing up and recovering data.
If a hard drive fails and the database stored on the hard drive is not accessible, the only way to recover the database is from a backup. If a computer system fails in the middle of a complex update process, the recovery subsystem is responsible for making sure that the database is restored to its original state.
These are two more benefits of a database management system. Skip to content Main Body. How is a DBMS distinguished from a file-based system? What is data independence and why is it important? What is the purpose of managing information?
Discuss the uses of databases in a business environment. What is metadata? Previous: Chapter 2 Fundamental Concepts. Control asset inventory, such as software or office equipment. Host the content for your Web site. How to get the most out of your database — from sourcing to implementation Your database is only as strong as its underlying structure.
To use a database effectively, schedule the following events. Talk to your staff about which features they believe would help them to better perform their roles. Meet with your staff to emphasize the importance of the database to the company's overall operation.
Explain how it will help them to perform their jobs, earn more money and grow the company. Using the Internet, research the products on the market to get an understanding of available features.
Total costs: purchase price, installation, training and support. Tip: the best solution may not be the most expensive. There are some very affordable database solutions that can be created for only a few thousand dollars. Optional components. Most applications have a core offering with optional add-ons that will expand the database's capabilities to meet your needs.
Start with what you need and add modules as the company grows or can afford the extras. Compatibility with other programs and existing applications. If you are not purchasing the billing system option, for example, you want to make certain the new database and your existing billing system can be integrated. Alternatively, you want existing data to be easily transferred to the new database from whatever program you are currently using.
Additional functions, such as remote access and the ease of making minor administrative changes. Technical support and service agreements.
Training programs. Preferably, you will get on-site training for all staff plus multiple copies of a well-documented user guide. Customer lists. Ideally, some current users will be companies of similar size, industry, application, etc. Make sure your office computers each have the hardware necessary to run the database application. Information stored in the other databases listed could be used in similar ways. Why use a database?
Databases can store very large numbers of records efficiently they take up little space. It is very quick and easy to find information. You can use the database to find out which clients have bought the most from you, which ones buy the most frequently, and which ones haven't purchased from you recently.
This information allows you to contact clients to thank them or to ask what you can do to bring them back in. Far from being impersonal, a database gives you the information you need to maintain personal contact with important clients. Your accounting department looks up transactions in your database to clarify how much a customer paid you, how much of that amount went to sales tax and whether the transaction was paid by cash, check or credit card.
This can be useful when a customer questions a transaction, or when you need to audit your cash handling procedures to see how efficiently money is being counted and deposited. In the event of an Internal Revenue Service audit, your ability to retrieve specific transactions can support your claims for income and expenses.
0コメント