New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Fundamentals Of Database Management Systems 2nd Edition Mark L. Gillenson - Solutions
Explain why concurrency control is important.
What is the lost-update problem?
What are locks and how are they used to prevent the lost-update problem?
What is deadlock and how can it occur?
What is a client/server database system?
Explain the database server approach to client/server database.
What are the advantages of the database server approach to client/server database compared to the file server approach?
What is data transparency in client/server database?Why is it important?
Compare the two-tier arrangement of client/server database to the three-tier arrangement.
What is a distributed database?What is a distributed database management system?
Why would a company be interested inmoving from the centralized to the distributed database approach?
What are the advantages of locating a portion of a database in the city in which it is most frequently used?
What are the advantages and disadvantages of data replication in a distributed database?
Describe the concept of asynchronous updating of replicated data. For what kinds of applications would it work or not work?
Describe the two-phase commit approach to updating replicated data.
Describe the factors used in deciding how to accomplish a particular distributed join.
Describe horizontal and vertical partitioning in a distributed database.
What are the advantages and disadvantages of horizontal partitioning in a distributed database?
What are the advantages and disadvantages of vertical partitioning in a distributed database?
What is the purpose of a directory in a distributed database? Where should the directory be located?
Discuss the problem of directory management for distributed database. Do you think that, as an issue, it is more critical, less critical, or about the same as the distribution of the data itself? Explain.
What is the difference between transactional processing systems and decision support systems?
Decision support applications have been around for many years, typically using captive files that belong to each individual application. What factors led to the movement from this environment towards the data warehouse?
What is a data warehouse? What is a data warehouse used for?
Explain each of the following concepts. The data in a data warehouse:a. Is subject oriented.b. Is integrated.c. Is non-volatile.d. Is time variant.e. Must be high quality.f. May be aggregated.g. Is often denormalized.h. Is not necessarily absolutely current.
What is the difference between an enterprise data warehouse and a data mart?
Under what circumstances would a company build data marts from an enterprise data warehouse? Build an enterprise data warehouse from data marts?
What is a multidimensional database?
What is a star schema? What are fact tables? What are dimension tables?
What is a snowflake feature in a star schema?
After a data warehouse is designed, what are the four steps in building it?
Name and describe three possible problems in transactional data that would require ‘‘data cleaning’’before the data can be used in a data warehouse.
Name and describe three kinds of data transformations that might be necessary as transactional data is integrated and copied into a data warehouse.
What is online analytic processing (OLAP?) What does OLAP have to do with data warehouses?
What do the following OLAP terms mean?a. Drill-down.b. Slice.c. Pivot or rotation.
What is data mining? What does data mining have to do with data warehouses?
Describe the ideal background for an employee who is going to manage the data warehouse.
Describe the challenges involved in satisfying a data warehouse’s user community.
Explain why the World Wide Web is like a giant client/server system.
One of the principles of client/server systems is that the processing functions are divided among different computers in the system. Describe and explain this‘‘division of labor’’ in the World Wide Web.
Describe the arrangement of computers and disks at a Web site.
Describe the various software components needed to reach a database within a Web site.
Why is it important to have standardized software interfaces between the various Web site components?
List three multimedia data types that might be required for a Web site.
What is a BLOB? What is a CLOB? What are they used for?
List some factors that can affect response time in e-commerce.
List some factors that can cause large variations in the number of people trying to access a Web site simultaneously.
What can a company do to handle spikes in traffic to its Web site?
What does ‘‘availability’’ mean?Why is it important in the e-commerce environment?
What factors or events can affect a Web site’s availability?
What does ‘‘scalability’’ mean?Why is it important in the e-commerce environment?
What is different about data security concerns in the Internet environment vs. the non-Internet environment?
What techniques or equipment can be employed for data security in the Internet environment?
Why is data privacy a concern in the e-commerce environment?
What isXMLand why is it useful regarding database in the e-commerce environment?
Define and compare data administration and database administration.
List and describe the advantages of data administration and database administration.
List and describe the responsibilities of data administration and database administration.
Explain the concept of metadata.
List and describe suchmetadata realizations as passive and active data dictionaries, relational DBMS catalogs, and data repositories.
List the major data control issues handled by database management systems.
List and describe the types of data security breaches.
List and describe the types of data security measures.
Describe the concept of backup and recovery.
Explain what an object/relational database is.
Describe the value of developing abstract data types.
Explain the concept and practical use of data modeling.
Relate the idea of data as a corporate resource that can be used to gain a competitive advantage to the development of the database management systems environment.
Describe the evolution of data storage media during the last century.
Describe how data needs have historically driven many information technology developments.
Explain why humankind’s interest in data dates back to ancient times.
List several limitations in the relational database model.
Describe the concept of physical database design.
Model data using such complex relationships as generalization and aggregation, and such concepts as inheritance and polymorphism.
Describe the benefits of encapsulation.
Describe the major backup and recovery techniques.
Explain the problem of disaster recovery.
Describe the concept of concurrency control.
Design a data warehouse.
Build a data warehouse, including the steps of data extraction, data cleaning, data transformation, and data loading.
Describe how to use a data warehouse with online analytic processing and data mining.
List the types of expertise needed to administer a data warehouse.
List the challenges in data warehousing.
List the four differences between the Internet database environment and the standard database environment.
Describe the database connectivity issues in the Internet environment.
Describe the expanded set of data types found in the Internet environment.
Compare the enterprise data warehouse with the data mart.
Describe the data warehouse concept and list its main features.
Compare the data needs of transaction processing systems with those of decision support systems.
Describe such concurrency control issues andmeasures as the lost update problem, locks and deadlock, and versioning.
Describe the concepts and advantages of the client/server database approach.
Describe the concepts and advantages of the distributed database approach.
Explain how data can be distributed and replicated in a distributed database.
Describe the problem of concurrency control in a distributed database.
Describe the distributed join process.
Describe data partitioning in a distributed database.
Describe distributed directory management.
Describe such database control issues as performance, availability, scalability, and security and privacy in the Internet environment.
Describe the object-oriented database concept.
Describe how the referential integrity restrict, cascade, and set-to-null delete rules operate in a relational database.
Showing 3000 - 3100
of 3225
First
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Step by Step Answers
Get 50% OFF
Claim Now
