MIS CHAPTER 6
Terms in this set (47)
the extent of detail within the information (fine and detailed or coarse and abstract).
immediate, up-to-date information
provide real-time information in response to requests.
occurs when the same data element has different values.
data integrity issues
occurs when a system produces incorrect, inconsistent, or duplicate data.
the overall management of the availability, usability, integrity, and security of company data.
maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
database management system
creates, reads, updates, and deletes data in a database while controlling access and security.
helps users graphically design the answer to a question against a database.
structured query language
users to write lines of code to answer questions against a database.
the smallest or basic unit of information.
logical data structures that detail the relationships among data elements using graphics or pictures.
details about data.
compiles all of the metadata about the data elements in the data model.
relational database model
stores information in the form of logically related two-dimensional tables.
relational database management system
allows users to create, read, update, and delete data in a relational database.
stores information about a person, place, thing, transaction, or event.
the data elements associated with an entity.
a collection of related data elements
a field (or group of fields) that uniquely identifies a given record in a table.
a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
the physical storage of information on a storage device.
shows how individual users logically access information to meet their own particular business needs.
the duplication of data, or the storage of the same data in multiple places.
a measure of the quality of information.
rules that help ensure the quality of information.
relational integrity constraints
rules that enforce basic and fundamental information-based constraints.
business-critical integrity constraints
enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
an interactive website kept constantly updated and relevant to the needs of its customers using a database.
a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
extraction, transformation, and loading
a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
contains a subset of data warehouse information.
the common term for the representation of multidimensional information.
a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
data quality audits
determine the accuracy and completeness of their data.
the process of analyzing data to extract information not offered by the raw data alone.
use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.
data that is already in a database or a spreadsheet
data that do not exist in a fixed location and can include text documents, PDFs, voice messages, emails, and so on.
analyzes unstructured data to find trends and patterns in words and sentences.
analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.
reveals the relationship between variables along with the nature and frequency of the relationships.
market basket analysis
analyzes such items as websites and checkout scanner information to detect customers' buying behavior and predict future behavior by identifying affinities among customers' choices of products and service
performs such functions as information correlations, distributions, calculations, and variance analysis.
time-stamped information collected at a particular frequency.
predictions based on time-series information.