Chapter 11 - ERP Systems Flashcards
___________ are multiple module software packages that evolved primarily from traditional
manufacturing resource planning (MRP II) systems.
ERP systems
The _______________ coined the term ERP, which has become widely used in recent years.
Gartner Group
The objective of ERP is:
to integrate key processes of the organization such as order entry, manufacturing, procurement and accounts payable, payroll, and human resources.
Under this approach, a database management system is used to provide minimal technological advantage over flat-file systems.
closed database architecture
ERP functionality falls into two general groups of applications:
core applications and business analysis applications
________________ are those applications that operationally support the day-to-day activities of the business. If these applications fail, so does the business. Typical examples include, but are not limited to, sales and distribution, business planning, production planning, shop floor control, and logistics
Core applications
Core applications are also called ___________________.
online transaction processing (OLTP) applications
A ____________ is a database constructed for quick searching, retrieval, ad hoc queries, and ease of use
data warehouse
__________________ includes decision support, modeling, information retrieval, ad hoc reporting/analysis, and what-if analysis.
Online analytical processing (OLAP)
An ERP system could not exist without having a data warehouse. TRUE OR FALSE.
FALSE
Organizations that have not implemented an ERP may deploy data warehouses. TRUE OR FALSE.
TRUE
Most ERP systems are based on the ______________
client-server model
Most ERP systems are based on the ______________
client-server model
The ___________________ is a form of network topology in which a user’s computer or terminal (the client) accesses the ERP programs and data via a host computer called the server.
client-server model
Two basic architectures of a client-server model are the _____________________.
two-tier model and the three-tier model
In a typical __________ the server handles both application and database duties. Client computers are responsible for presenting data to the user and passing user input back to the server. Some ERP vendors use this approach for local area network (LAN) applications for which the demand on the server is restricted to relatively small population of users.
two-tier model
The database and application functions are separated in the _______________. This architecture is typical of large ERP systems that use wide area networks (WANs) for connectivity among the users. Satisfying client requests requires two or more network connections. Initially, the client establishes communications with the application server.
three-tier model
___________ consist of large numbers of relatively simple transactions, such as
updating accounting records that are stored in several related tables.
OLTP events
When implementing an ERP system that will include a data warehouse, a clear distinction needs to be made between the competing types of data processing:
OLTP and OLAP
____________ is the aggregation or roll-up of data. For example, sales offices data can be rolled up to districts and districts rolled up to regions
Consolidation
____________ permits disaggregating data to reveal the underlying details that explain
certain phenomena. For example, the user can drill down from total sales returns for
a period to identify the actual products returned and the reasons for their return.
Drill-down
__________________ enables the user to examine data from different viewpoints. One
slice of data might show sales within each region. Another slice might present sales
by product across regions. This is often performed along a time axis to
depict trends and patterns.
Slicing and dicing
____________ allow users to analyze complex data relationships. The physical database itself is organized in such a way that related data may be rapidly retrieved across
multiple dimensions. These servers need to be efficient when storing and processing multidimensional data.
OLAP servers
OLAP can be characterized as online transactions that:
• Access very large amounts of data (e.g., several years of sales data).
• Analyze the relationships among many types of business elements such as sales, products, geographic regions, and marketing channels.
• Involve aggregated data such as sales volumes, budgeted dollars, and dollars spent.
• Compare aggregated data over hierarchical time periods (e.g., monthly, quarterly, yearly).
• Present data in different perspectives such as sales by region, by distribution channel, or by product.
• Involve complex calculations among data elements such as expected profit as a function of sales revenue for each type of sales channel in a particular region.
• Respond quickly to user requests so they can pursue an analytical thought process without being stymied by system delays.