Unit 4 - Module 8 Flashcards
closed database architecture
Database management system used to provide minimal technological advantage over flat-file systems.
Traditional Information System
ERP System
Core applications
Applications that operationally support the day-to-day activities of the business.
online transaction processing (OLTP)
Events consisting of large numbers of relatively simple transactions such as updating accounting records that are stored in several related tables.
Online analytical processing (OLAP)
Enterprise resource planning decision support tool used to supply management with real-time information. It also permits timely decisions that are needed to improve performance and achieve a competitive advantage.
data mart
Data warehouse organized for a single department or function.
The data warehousing process has the following essential stages:
Modeling data for the data warehouse
Extracting data from operational databases
Cleansing extracted data
Transforming data into the warehouse model
Loading data into the data warehouse database
Which of the following is one of the core ERP applications?
Distribution Operational databases Bolt-on applications On-line analytics
Distribution
The correct answer is “Distribution.” The core ERP applications are sales, distribution, business planning, shop floor control and logistics. Core applications are those applications that operationally support the day-to-day activities of the business. If these applications fail, so does the business. Typical core applications include, but are not limited to, sales and distribution, business planning, production planning, shop floor control, and logistics. Core applications are also called online transaction processing (OLTP) applications.
The objective of an ERP is:
to integrate key processes of the organization, such as order entry, manufacturing, procurement and accounts payable, payroll, and human resources.
The correct answer is “to integrate key processes of the organization, such as order entry, manufacturing, procurement and accounts payable, payroll, and human resources.” The objective of an ERP is to integrate key processes of the organization, such as order entry, manufacturing, procurement and accounts payable, payroll, and human resources. By doing so, a single computer system can serve the unique needs of each functional area.
Closed Database architecture is
similar in concept to the basic flat-file model. advanced systems without a data warehouse. stable database systems after debugging. old manual systems that are still in place.
similar in concept to the basic flat-file model.
The correct answer is “similar in concept to the basic flat-file model.” Closed database architecture is similar in concept to the basic flat-file model. Under this approach, a database management system is used to provide minimal technological advantage over flat-file systems. The database management system is little more than a private but powerful file system.
A data mart is
another name for a data warehouse. an enterprise resource planning system. a data warehouse created for a single function or department. a database that provides data to an organization’s customers.
a data warehouse created for a single function or department.
The correct answer is “a data warehouse created for a single function or department.” A data mart is a data warehouse created for a single function or department. Modern data warehouses may contain gigabytes of data for use by all business functions and departments. To maximize value for single functions or departments, a data mart may be created within the data warehouse that contains the data specific to the function’s requirements. For example, a sales data mart will contain all of the data related to customers, salespeople, inventory, sales orders, etc., but not manufacturing or financial data.
Most organizations implement data warehousing
as part of a strategic ERP initiative. as an add-on to a legacy system. because the data they require is not available in the ERP system. as a replacement for a legacy system.
as part of a strategic ERP initiative.
The correct answer is “as part of a strategic ERP initiative.” Most organizations implement a data warehouse as part of a strategic IT initiative that involves an ERP system. Implementing a successful data warehouse involves installing a process for gathering data on an ongoing basis, organizing it into meaningful information, and delivering it for evaluation. The data warehousing process has the following essential stages: Modeling data for the data warehouse, extracting data from operational databases, cleansing extracted data, transforming data into the warehouse model, and finally, loading data into the data warehouse database.
Most organizations implement data warehousing
as part of a strategic ERP initiative. as an add-on to a legacy system. as a replacement for a legacy system. because the data they require is not available in the ERP system.
as part of a strategic ERP initiative.
The correct answer is “as part of a strategic ERP initiative.” Most organizations implement a data warehouse as part of a strategic IT initiative that involves an ERP system. Implementing a successful data warehouse involves installing a process for gathering data on an ongoing basis, organizing it into meaningful information, and delivering it for evaluation. The data warehousing process has the following essential stages: Modeling data for the data warehouse, extracting data from operational databases, cleansing extracted data, transforming data into the warehouse model, and finally, loading data into the data warehouse database.
