ISOM Quiz 3

A database hold information for a single application, while data warehouse stores information for multiple applications and multiple databases.

Transactional information is all the inforamtion created in a single business processes, that information is stored and then used in daily operational functions (Example ATM withdrawl). Analytical inforamtion is the organizational information that is stored and then used in daily managerial analysis tasks. (Example product statistics)

Operational Database: collection of transactional data

Data Warehouse: Collection of analytical information

A data mart contains a subset of warehouse information.
Dependent Data Mart: extracts information from data warehouses.
Independent Data Mart: extracts information from stand alone mini data warehouses.

Information is sent to these Data Marts through the process of ETL, which is extraction, transformation, and loading

The processes of analyzing information from extracted data that raw data alone could not tell you. Data Mining tools must be used to do so.

A Transactional processing system is a basic system in which a business runs on a day-to-day operations. Online transactional processing the standard updating, querying, and presenting text and number data from databases for operational purpuses. Online analytical processing does standard querying and presenting text and number data from the data warehouses for an analytical purpose.

Models information to support managers and business professionals in the descion making process.

Excel can be used as a Decision support system

Affinity grouping is also known as market basket analysis finds correlations amoung data or variables.

1.) Materials flow from suppliers
2.) Transformation of materials into semi-finished and finished products through the organizations production process.
3.)Distribution of products to the costumers.

5 Basic Supply Chain Management Components:
Plan- Source- Make- Deliver- Return

Supply Chain planning software uses mathmetical algorithms to improve the flow of the supply chain, supply chain execution software automates the different steps and stages of a supply chain.

Recency, Frequency, and Monatery Value. Meaning how recent a costumer has bought a product, the frequencey a costumer purchases items, how much a costumer spends each purchase.

A single information system that does business processes and funcations on an enterprise level. (A system that spans enterprise wide)

E-Commerce is buying and selling goods via the internet. E-Business is conducting business via the internet, not just buying and selling goods but communicating with costumers and business partners.