Omis

Front 1

Information Granularity

Back 1

The extent of information (i.e. coarse and abstract or fine and detailed)

Front 2

Transactional Information

Back 2

all data the information contained within a business process or unit of work that helps support business operations

Front 3

Analytical Data

Back 3

All data and information contained and pertaining to the organization and organizational information which helps support managerial analysis tasks

Front 4

Real time information

Back 4

Current and immediate/up-to-date/on the spot information

Front 5

Real-time systems

Back 5

provides immediate and up-to-date information based on/in response to requests

Front 6

Information inconsistency

Back 6

When a piece of data has inconsistent or conflicting values

Front 7

Information Integrity Issues

Back 7

When a system has or is giving out incorrect, inconsistent or duplicate data

Front 8

Database

Back 8

Contains information about 4things

Events, Objects, People, and Places (EOPP)

Front 9

Database Management Systems

Back 9

Creates, Reads, Updates, and Deletes data in the database while controlling access and security

Front 10

Database Management Systems Primary Tools

Back 10

1.) QBE - Query By Example - Helps users graphically design the answer to a question against the database - Used mostly by managers

2.) SQL - Standard Query Language - Users will need to code answers to questions against the database - Mostly done by OMIS professionals

Front 11

Data Element/Data Field

Back 11

The most simple and basic piece of data

(i.e. employee name, email, quantity ordered)

Front 12

Data Models

Back 12

Logical data structures that detail relationships among data elements using graphics and pictures

Front 13

Metadata

Back 13

Details about the data

(ex. picture, metadata = size, resolution, date created)

Front 14

Data Dictionary

Back 14

Compiles all metadata about the data elements within a given data model

Front 15

Relational Database model

Back 15

Stores information in the form of logically related two-dimensional tables

Front 16

Entity

Back 16

Stores information about a person, place, thing, transaction or event

In a relational database it is similar to a title and will have columns and rows below it

Front 17

Attributes

Back 17

Are the elements associated with the Entity

Front 18

Record*

Back 18

Is a collection of related data elements

Front 19

Primary Key

Back 19

Is a field that uniquely identifies a given record or table

(ex. recording ID)

Front 20

Foreign Key

Back 20

Is one tables Primary key but appears in another table as an attribute

Acts to provide a logical relationship between two tables

Front 21

Physical view of information

Back 21

Deals with the physical storage of information in a storage device

Front 22

Logical View of informations

Back 22

Focuses on how individual users logically access information to meet their own particular business needs

Front 23

Information Redundancy

Back 23

is the duplication of data or storage of data in multiple places

Front 24

Information Integrity

Back 24

A measure of the quality of information

Front 25

Integrity Constraints

Back 25

Rules that help ensure the quality of information

Front 26

Relational Integrity Constraints

Back 26

Rules that enforce basic information based constraints (ex. these constraints wouldn't allow someone to order 0 lbs of raw materials)

Front 27

Business Critical Integrity Constraints

Back 27

Rules that enforce vital business rules that are vital to the success of an organization

Require more insight and knowledge than Relational Integrity Constraints

Front 28

Content Creator

Back 28

The person responsible for creating the original website content

Front 29

Content Editor

Back 29

The person responsible for updating and maintaining website content

Front 30

Static Information

Back 30

includes data incapable of change in the event of user action

Front 31

Dynamic information

Back 31

Includes data that changes based on user requests/actions

(ex. movie ticket availability, airline prices)

Front 32

Data driven website

Back 32

Using a database for an interactive website kept constantly updated and relevant to the needs of its customers

Front 33

Advantages to a Database driven website

Back 33

It's easily managed

It's easy to store large amounts of data

It's easy to eliminate human errors

Front 34

Integration (River)

Back 34

Allows separate systems to communicate directly with each other

Front 35

Types of Integration

Back 35

1.) Forward/Downstream (ex. Sales to Billing)

2.) Backward/upstream (ex. billing to sales)

Front 36

Without Integration

Back 36

have to deal with redundancy

and entering the same information into multiple systems

Front 37

Data Warehouse

Back 37

A logical collection of information gathered from many different databases

supports business analysis and decision making without disrupting day-to-day operations

Usually multidimensional

Front 38

Extraction, Transformation, and Loading (ETL)

Back 38

A process that:

1.) Extracts information from internal and external databases

2.) Transforms the informations using a common set of enterprise definitions

3.) Loads the information into a data warehouse

Front 39

Data Mart

Back 39

contains a subset of information held within a Data Warehouse

Front 40

Dimension

Back 40

a particular attribute of information

Front 41

Cube

Back 41

The common term for representing multidimensional information

Front 42

Block

Back 42

A subset of multidimensional information within a cube

Front 43

Data Mining

Back 43

The process of analyzing data to extract information not offered by the raw data alone

Front 44

Data Mining Tools

Back 44

A variety of techniques to find patterns and relationships in large volumes of information and infer rules from them to help predict future behavior and assist in decision making

Front 45

Information Cleansing/Scrubbing

Back 45

A process that weeds out and fixes or discards inconsistent, incorrect and incomplete information

Front 46

Informing

Back 46

Accessing large amounts of data from different management information systems

Front 47

Infographics

Back 47

Information displayed graphically so that it can be easily understood

Front 48

Data visualization

Back 48

describes technologies that allow users to see or visualize data to transform that information into a specific bush perspective

Front 49

Data visualization techniques

Back 49

moving beyond excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, maps, times series graphs etc.

Front 50

Business Intelligence Dashboard

Back 50

Tracks corporate metrics such as CSF's and KPI's and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis

Front 51

Problem with the business world?

Back 51

Data rich, information poor