Chapter 1 Flashcards
(27 cards)
Persistent property for database?
Mean that data reside on table storage. Relevance of intended operational usage: only potentially relevant data are stored
Lasts a long time (not transient)
Interrelated property for databases?
Separate data units can be connected to provide a broader view
Entity: cluster of data about a topic
Relationship: connection among entities
Shared property for databases?
A database can have multiple users and uses.
A database as a common information repository and information exchange platform
What is a DBMS?
Collection of components that support data acquisition, storage, maintenance, and retrieval (Database Software)
Major parts: enterprise, desktop, embedded DBMS
What is SQL?
An industry standard database language that includes statements for database definition, database manipulation, and database control
Describe the difference between a procedural and a nonprocedural language. What statements belong in a procedural language but not in a nonprocedural language?
Non-procedural Database language such as SQL allows you to specify the parts of a database to access rather than to code a complex procedure. These languages do not include looping statements.
Why is nonprocedural access an important feature of DBMSs?
Nonprocedural access allows users with limited computing skills to submit queries.
Nonprocedural access makes formand report creation possible without extensive coding.
What is the connection between nonprocedural access and application development? Can nonprocedural access be used in application development?
Nonprocedural access and application development tools, though convenient and powerful, are sometimes not efficient enough or do not provide the level of control necessary for application development.
What is the difference between a form and a report?
Form: formatted document for data entry and display
Report: formatted document for display
What is a procedural language interface?
Procedural Language Interface is a method to combine a nonprocedural language such as SQL with a programming language such as Java
What is a transaction?
A unit of work that should be processed reliably without interference from other users and without loss of data due to failures
What features does a DBMS provide to support transaction processing?
DBMSs ensure that simultaneous users do not interfere with each other and failures do not cause lost work. (Database tuning)
What is an enterprise DBMS?
Supporting mission critical information systems
What is a desktop DBMS?
For small and end-user databases
What is an embedded DBMS?
Resides in a separate system or device such PDA or web browser
Data Independence?
A database should have an identity separate from the applications(computer programs, forms, and reports_ that use it. The separate identity allows the database definition to be changed without affecting related applications.
What is the purpose of the mappings in the Three Schema Architecture? Is the user or DBMS responsible for using the mappings?
Mappings describe how schema at a higher level is derived from a schema at a lower level; ensure data independence
How does the Three Schema Architecture support data independence?
For compartmentalizing database descriptions in order to achieve data independence
What is the state of the cloud computing segment of the DBMS marketplace?
Rapidly evolving
What is the relationship between the cloud-based database architecture and other distributed processing architectures for database computing?
Cloud computing provides a new approach without initial product licensing costs and no hosting requirements
Internally, the cloud can use any distributed processing approach although the internal details of the cloud are invisible to organizations using the cloud service
What is information resources management?
Focuses on information technology as a tool for processing, distributing, and integrating information throughout an organization
What is data governance?
The exercise of decision-making and authority for data-related matters
Parallel DBMS
A DBMS capable of utilizing tightly-coupled computing resources
Distributed data?
A database in which parts are located at different network sites