Upgrade to remove ads
Chapter 9 CISP
Terms in this set (71)
attribute used to identify and provide a means to search a database
most important key in the field
process of moving through a database file, examining each record and looking for information.
to manipulate the data
help users narrow down info. needed to be searched
allows users to ask questions designed to retrieve info.
Structured Query Language (SQL)
the most popular database query language.
asks a database to return records that match specific criteria.
matches data from fields in various files
include: restricting access by requiring a password and user id.
information about data
a body of metadata
a database that runs using languages, platforms, or models that are no longer supported by an organization's current database system.
restoration of data
flat file database
a traditional data file storage system that lacks the ability to interrelate data in an organizational structure.
a database in which fields can be shared among all the files in the database, making it possible to connect them.
a way to organize data
a file (consisting of rows and columns)
object oriented database
stores data in the form of objects
in addition to text and numbers the typical database handles, this type of database also allows for the storage of picx, movies, sound, and hyperlinked fields.
a database not limited to employing a single data model.
working systems that are continually being updated.
a database that is spread across multiple networked computers, with each computer storing a portion of the total amount of data.
used to store data gathered from one or more databases.
someone who plans and designs a database system
database management approach
Three steps a systems analyst follows in developing and maintaining a database
front end interface program
it interacts with the DBMS, the software that manipulates and manages the database
an element within an object oriented database, such as a form, report, or a data filter.
a way to filter criteria; so that only a subset of the data is presented.
the activities performed with in the database.
data processing occurs at scheduled time or when a critical point has been reached
a template that allows users to enter data into the database.
is a formatted body of output from a database.
a more continuous and tends to be done with smaller databases or with operational databases that require all info to be very current.
real time system
data must be kept accurate down to the second in these systems to provide data for critical functions
online transactional processing
fast, always on processing
data entry operator
types data into a database and makes sure it is accurate
a computerized system for storing info in an organized manner so that it can be searched for and retrieved when needed.
a person, place, thing or event
a single value, such as a name, address or dollar amount
consists of numbers only
consists of numbers, letters, and special characters
a collection of related fields
a collection of records of the same type
a system of computer hardware, software, and operating procedures. (the most common database application)
management information system(MIS)
used to track and control every transaction through a database
a business activity central to the nature of an enterprise.
office information system(OIS)
a replacement for paper based information systems
an office that implements an OIS
decision support system
a common form of information system. designed to help management make decisions about an operation.
computer aided manufacturing
information system that helps in manufacturing - supporting factory automation
computer integrated manufacturing
a higher level concept indicating a system that controls a manufacturing process from beginning to end.
database management systems (DBMS)
software that allows a user to create and manage a computerized database.
responsible for maintaining and updating the database and DBMS software.
time which the computer system is not available.
when data is unreadable, incomplete or damaged
backup and recovery plan
this ensures data is backed up and recoverable in case of some sort of outage
database response time
lag time between a user issuing a command and the database system taking action
an automatic protection process that occurs when users attempt to edit existing records in a multi user system.
data integrity (data quality)
used to describe the accuracy of the info provided to database users.
duplication of data in several fields
a process intended to eliminate redundancy among fields in relational databases
an error that can cause a ripple effect...the spread of incorrect info.
process of making certain that data entered int o the system is both correct and complete.
involves a check to make sure the deleting a record in one table will not affect it in other tables.
a simple error-checking system usually performed on numeric data entries.
prevents users from using incorrect characters
a check made against previously entered data that has already been validated.
ensures that every required field is filled out.
YOU MIGHT ALSO LIKE...
CIS FINAL EXAM
Information Systems, Chapters 4 &5
CIS Chapter 11
Chapter 14 - Databases and Database Management Sys…
OTHER SETS BY THIS CREATOR
Law and Ethics
Law and Ethics
OTHER QUIZLET SETS
MIS EXAM 2
MIS 302F Test 2