ch. 11
document management system
allows for storage and management of a company's documents, such as word processing documents, presentations, and spreadsheets
database software
allows users to create a computerized database, add, modify, and delete data, sort and retrieve data, and create forms and reports from the data
report writer
allows users to design a report on the screen, retrieve data into the report design, and then display or print the report
expert system
an info system that captures and stores the knowledge of human experts and then imitates human reasoning and decision making
multidimensional database
can store data in more than two dimensions of data, also known as a hypercube, and can consolidate data much faster than a relational database
database
collection of data organized in a manner that allows access, retrieval, and use of that data
data
collection of unprocessed items, text, numbers, images, audio, video
field
combo of one or more related characters, field name, field size, data type
validation
compares data with a set of rules or values to find out if the data is correct
query language
consists of simple, English-like statements that allow users to specify the data to display, print, store, update, and delete
data dictionary
contains data about each file in the database and each field in those files
database administrator
creates and maintains the data dictionary, manages security of the database, monitors the performance of the database and checks backup and recovery procedures
database analyst
decides on proper placement of fields, defines data relationships, and identifies users' access privileges
data model
defines how users view the organization of the data
content management system
enables and manages the publishing, modification, organization, and access of various forms of documents and other files, including media and webpages, or a network or the web
query by example
feature that has a graphical user interface to assist users with retrieving data
record
group of related fields
decision support system
helps users analyze info and make decisions
data warehouse
huge database that stores and manages the data required to analyze historical and current transactions
management info system
info system that generates accurate, timely, and organized info, so that managers and other users can make decisions, solve problems, supervise activities, and track progress
transaction processing system
information system that captures and processes data from day-to-day business activities
Enterprise Resource planning
integrates MRPII with the info flow across an organization to manage and coordinate the ongoing activities of the enterprise, including product planning, manufacturing and distribution accounting and finance, sales, human resources, and customer support
primary key
is a field that uniquely identifies each record
character
one byte, numbers, letters, space, punctuation marks, or other symbols
structured Query language
popular query language that allows users to manage, update, and retrieve data
information
processed data that is organized, meaningful, and useful
DBMS
provides means to ensure that only authorized users access data
file maintenance
refers to the procedures that keep data current, like adding records, modifying records, and deleting records
information system
set of hardware, software, data, people, and procedures that work together to produce info
object-oriented database (OODB)
stores data in objects
relational database
stores data in tables that consist of rows and columns
form
window on the screen that provides areas entering or modifying data in a database
data file
collection of related records