When deciding on a new DBMS, the DBA usually creates a checklist. The evaluation
ID: 3708799 • Letter: W
Question
When deciding on a new DBMS, the DBA usually creates a checklist. The evaluation checklist in Figure 8-8 has 18 items. Which 5 items in this list do you consider to be the most important? Why? Which 5 items in this list do you consider to be the least important? Why?ure Thup7he.itasource.comook9781305 177413/ct/ 278/4/400.00:21.0 1. Data Definition a. Data types (1) Numeric (2) Character (3) 4) Logical (T/F) (5) Memo (6) Currency (7) Binary object (pictures, drawings, sounds, and so on) (8) Link to an Internet, Web, or other address (9) User-defined data types (10) Other Date b. Support for nulls c. Support for primary keys d. Support for foreign keys e. Unique indexes f. Views 2. Data Restructuring a. Possible restructuring (1) Add new tables (2) Delete existing tables (3) Add new columns (4) Change the layout of existing columns (5) Delete columns (6) Add new indexes (7) Delete existing indexes b. Ease of restructuring 3. Nonprocedural Languages985 a. Nonprocedural languages supported (1) SQL (2) QBE (3) Natural language (4) Language unique to the DBMS. Award points on t basis of ease of use as well as the types of operations (joining, sorting, grouping, calculating various statistics, and so on) that are available in the language. You can use SQL as a standard against which you can judge the language b. Optimization done by one of the following e to search
Explanation / Answer
The DBA daily, weekly tasks for a DBMS systems are the following:
Keeping in view of the DBA role on day to day basis his top priorities will to first look at the features which he is going to use if they are supported in DBMS or not. The following are the key items, which he will consider most important.
The reason as I specified in the beginning as these are the key activities he will be performing daily, weekly or monthly. Any DBMS, which is not supporting these, will make his task very difficult so he needs to be careful extent of support and difficulty in supporting these.
The least important will be list items, which are normally used by developer and do not fall into his daily tasks. Ideally these should be reviewed and taken care by DB architect or developer. These are nice to have for him. Following are the least items for DBA perspective:
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.