CITM 595 Chapter 11 Review
CHAPTER 11 KEY CONCEPTS:
ERP: are multiplemodule software packages that evolved primarily fromtraditional manufacturing resource planning (MRP II) systems. - objective of ERP is to integrate key processes of the organization - a single computer system can serve the unique needs of each functional area. - facilitate the sharing of information and to improve communications across the organization
Closed Database structure: - similar in concept to the basic flat-file model. - database management system is used to provide minimal technological advantage over flat-file systems - is little more than a private but powerful file system - high degree of data redundancy - distinct, separate, and independent databases exist - order begins a paper-based journey around the company where it is keyed and rekeyed into the systems of several different departments - Cause lost orders - Increase entry errors
- Customers may be to told to contact different departments for information - Delays entire processes within the companies - Lack of communication between departments- very fragmented
ERP Core Applications - functionality falls into two general groups of applications: core applications and business analysis applications.
- Core applications are those applications that operationally support the day-to-day activities of the business. Also called Online Transaction Processing [OTLP} - Business will fail without them - Production planning, sales and dstribution etc.
OLAP Online analytical processing (OLAP) includes decision support, modeling, information retrieval, ad hoc reporting/analysis, and what-if analysis
A data warehouse - database constructed for quick searching, retrieval, ad hoc queries, and ease of use. - Organizations employe each of the above, ERPs, OLAP and Data warehouses for competive advantages
OLAP servers support common analytical operations including consolidation, drilldown,
and
ERP: are multiplemodule software packages that evolved primarily fromtraditional manufacturing resource planning (MRP II) systems. - objective of ERP is to integrate key processes of the organization - a single computer system can serve the unique needs of each functional area. - facilitate the sharing of information and to improve communications across the organization
Closed Database structure: - similar in concept to the basic flat-file model. - database management system is used to provide minimal technological advantage over flat-file systems - is little more than a private but powerful file system - high degree of data redundancy - distinct, separate, and independent databases exist - order begins a paper-based journey around the company where it is keyed and rekeyed into the systems of several different departments - Cause lost orders - Increase entry errors
- Customers may be to told to contact different departments for information - Delays entire processes within the companies - Lack of communication between departments- very fragmented
ERP Core Applications - functionality falls into two general groups of applications: core applications and business analysis applications.
- Core applications are those applications that operationally support the day-to-day activities of the business. Also called Online Transaction Processing [OTLP} - Business will fail without them - Production planning, sales and dstribution etc.
OLAP Online analytical processing (OLAP) includes decision support, modeling, information retrieval, ad hoc reporting/analysis, and what-if analysis
A data warehouse - database constructed for quick searching, retrieval, ad hoc queries, and ease of use. - Organizations employe each of the above, ERPs, OLAP and Data warehouses for competive advantages
OLAP servers support common analytical operations including consolidation, drilldown,
and