MISY261 Summary of Terms

Data Type

Monetary, Numerical, Date/Time, Text, etc.

Metadata

Used to describe other data, corresponds to the data put in the table (format of data, list of tables, restrictions, and consistency of data)

SAP trasaction

pre-programmed way to interaction with the database; complex and content-rich system that supports above 16,000 transactions

Analyzing

presenting lead information, or results from the lag information

Reporting

presents lag information that reflects past performances

Online Analytical Processing (OLAP)

refers to approaches to multidimensional data analysis which are used in business intelligence (star schema architecture, historical data and real-time data, calculated fields and redundant data)

Online Transactional Processing (OLTP)

refers to information systems that facilitate the entry and extraction of data for transactional purposes to support the daily operations of a company (simple queries, logical data, raw and real-time, no redundant data or calculated fields)

Information System

system that allows us to store, retrieve, and safeguard information

Enterprise Resource Planning (ERP)

system that supports the core business of many large institutions

Infrastructure

technologies required to manage, extract, transform, organize data so it can be accessed by uders

Condition Maintenance

transaction needed to change prices

Transactional Database

type of relational database that saves all data supporting business processes of a company

Primary key

unique code that allows us to uniquely identify each entity

Real-Added Value

value that benefits the customer

Key Performance Indicators (KPIs)

variable used to identify if the objective has been reached

Cloud computing

where computing services are delivered on-demand to customers over a network in a self-service fashion, independent of device and location

Relational Database

collection of data organized in tables

Throughput

concerns the time it takes to process tasks and how many tasks can be processed at one time without the system slowing down

Summary Sales Report

contains the list of day-by-day, product level summary of the sales orders you have received from your customers, specifically the number of separate orders you have received, the total units ordered and revenue value

Non-Added Value

costs of the business, photocopying a document order, doesn't affect consumer or add value to business

Material Resource Planning (MRP)

extracts the current level of inventory and the quantity already ordered in the current purchase order

Rational Database Management System (RDBMA)

helps manage the metadata of the relational database

Business Process Reengineering (BRP)

helps organizations rethink how to carry out work

Availability

how available the system is and any times it is unavailable

Scalability

how large the system can become in terms of data and volume and number of users

Data Format

integer, long integer, etc.

SAP

is the ERP we used for the dairy game, used for major organizations

Master data

known by the organization before taking the order

Inventory Report

list of all products and how many you have left in stock, referenced by a material code

Characteristics of a KPI

- S (specific) - M (measurable) - A (achievable) - R (result-oriented) - T (time-based)

Databases

a class of software applications to serve data retrieval and storage needs

One to Many Relationship

a professor belongs to only one department but a department can have many professor

Many-To-Many Relationship

a professor can teach many courses and many courses can be taught by a professor

Business Process

a series of logically related activities or tasks performed together to produce a defined set of results

Business- Added Value

activities that adds value that benefits the business (making a profit)

Referential Integrity

all of the values in the foreign key are also in the primary key of the other table

Foreign key

an attribute of a table that is a primary key of the table it is linked to

Software as a Service (Saas)

an organization will use a vendor's application through web interfaces, subscribing to all or selected modules, and integrate components with in-house, outsources, and/or third part systems using Web Services Application Programming Interfaces (API)

Dashboards

are strategic tools that include a set of key indicators to monitor performance and achievement of key tasks within the company

Security

can it be accessed through someone unauthorized, theft data

Database Management Systems (DBMS)

can service the data management needs of almost any software application, centralize data, promote data consistency, completeness, accuracy, and integrity (2-Tier Architecture vs. 3-Tier Architecture)

Transaction data

data unique to the order (products and quantity ordered) typically stored in relational databases

Sales Order Report

details of all the sales orders you have received, sales order number, total units, revenue values, etc.

Reliability

does the system behave consistently?

Tables

each column is a field, each row is a record

Mandatory Field Rule

each field needs to be filled for each row

Business analysts

establish the relationship between the organizational unit that has some software requirements and the IT professionals responsible for implementing an information system to meet those requirements