Database system concepts

Chapter 1 - Getting started. After completing this unit, you should be able to: Identify the purpose and scope of this book, know the potential problems with lists, understand the reasons for using a database, understand how related tables avoid the problems of lists, learn the components of database system, learn the elements of a database, learn the purpose of the database management system (DBMS), understand the functions of a database application.

32p tangtuy17 11-07-2016 43 2   Download

Chapter 7 - Database processing applications andbusiness intelligence. In this chapter, you will learn: Understand and be able to set up Web database processing, learn the basic concepts of Extensible Markup Language (XML), learn the basic concepts of business intelligence (BI) systems, learn the basic concepts of OLAP and data mining.

61p tangtuy17 11-07-2016 36 2   Download

In this chapter presenting the terminology and basic concepts that will be used throughout the lecture. This chapter discusses data models and defines the concepts of schemas and instances, which are fundamental to the study of database systems, discuss the three-schema DBMS architecture, provides a user’s perspective on what a DBMS is supposed to do, describe the types of interfaces and languages that are typically provided by a DBMS,...

33p kiepnaybinhyen_04 15-12-2015 66 3   Download

In chapter 3, we follow the traditional approach of concentrating on the database structures and constraints during conceptual database design. The design of application programs is typically covered in software engineering courses. this chapter also present the modeling concepts of the Entity-Relationship (ER) model, which is a popular high-level conceptual data model.

38p kiepnaybinhyen_04 15-12-2015 69 3   Download

In this chapter, we describing features that have been proposed for semantic data models, and show how the ER model can be enhanced to include these concepts, leading to the Enhanced ER (EER) model.

22p kiepnaybinhyen_04 15-12-2015 43 2   Download

In this chapter, The contents concentrate on describing the basic principles of the relational model of data, begin by defining the modeling concepts and notation of the relational model, discussion of relational constraints that are considered an important part of the relational model and are automatically enforced in most relational DBMSs, defines the update operations of the relational model,...

29p kiepnaybinhyen_04 15-12-2015 58 2   Download

Overview The Oracle server uses many memory components, background processes, and file structures for its backup and recovery mechanism. This lesson reviews the concepts presented in the Oracle9i Database Administration Fundamentals I course, with an emphasis on backup and recovery requirements. Oracle Instance An Oracle instance consists of memory areas (mainly System Global Area [SGA]) and background processes, namely PMON, SMON, DBWn, LGWR, and CKPT. An instance is created during the nomount stage of the database startup after the parameter file has been read.

46p trinh02 28-01-2013 55 4   Download

Data Model: A set of concepts to describe the structure of a database, and certain constraints that the database should obey. Data Model Operations: Operations for specifying database retrievals and updates by referring to the concepts of the data model. Operations on the data model may include basic operations and user-defined operations.

34p thienthanoze 12-11-2012 101 10   Download

Concept of User Interface The user interface is the part of the system that you see, hear and feel (look and feel) Other parts of the system are hidden to you, for instance the database where information is stored. Although users don’t see the hidden parts, they imagine to some extent what is going on ’behind the screen’. Examples When you use a computer, you give it orders, usually by means of the mouse and the keyboard. The computer replies, usually by showing something on the screen or making sounds.

65p thanh_k8cntt 13-09-2012 61 6   Download

Some features of a real world situation can be difficult to model using only the features of the E-R model that we have seen so far. • Some quite common concepts require extending the E-R model to incorporate mechanisms for modeling these features. Again, we won’t look at all of them, but rather an overview of some of the more important extensions.

37p vutoanptit 18-08-2010 81 11   Download

A data model is an integrated collection of concepts for describing and manipulating data, relationships between data, and constraints on the data in an organization. • A model is a representation of “real world” objects and events, and their associations. It is an abstraction that concentrates on the essential, inherent aspects of an organization and ignores accidental properties. • A data model must provide the basic concepts and notations that will allow database designers and end-users unambiguously and accurately to communicate their understanding of the organizational data....

66p vutoanptit 18-08-2010 114 9   Download

The registry concept itself isn't new to Windows. However, the modern registry is an impressive advance in improving system manageability from a single source-the registry database.

8p kisiheo 26-07-2010 89 8   Download

The Oracle Workflow Administrator’s Guide also assumes you have a basic understanding of operating system concepts and familiarity with Oracle Database, PL/SQL, and Oracle Application Server technology. If you have not yet been introduced to any of these systems, Oracle suggests you attend one or more of the training classes available through Oracle University.

316p thuxuan 04-08-2009 161 11   Download

Oracle Database Backup and Recovery Advanced User's Guide presents in-depth information on RMAN architecture, backup and recovery concepts and mechanisms, advanced recovery techniques such as point-in-time recovery and database flashback features, and backup and recovery performance tuning. It also covers user-managed backup and recovery, using host operating system facilities instead of RMAN. This volume is essential for backup and recovery of more sophisticated database deployments, and for advanced recovery scenarios....

28p thuxuan 03-08-2009 134 17   Download