Chapter 1 Flashcards
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