Summary of The REA Approach to Database Modeling.

By -

Summary

This chapter opened by comparing the function and data storage techniques of a traditional flat-file or database system with that of an ERP. An important distinction was drawn between OLTP and OLAP applications. Similarly, the differences between the ERP’s operational database and the data ware- house were discussed. Next, ERP configurations were examined related to servers, databases, and bolt-on software. We discussed SCM as an area of contention. ERP vendors are moving quickly to provide SCM functionality. Simultaneously, SCM vendors are encroaching on traditional ERP territory.

Data warehousing was the topic of the third section. A data warehouse is a relational or multidimensional database that supports OLAP. A number of data warehouse issues were discussed, including data modeling, data extraction from operational databases, data cleansing, data transformation, and data loading into the warehouse.

The fourth section examined common risks associated with ERP implementation. Among these are the risks associated with the big bang approach, internal opposition to changing the way a company does its business, choosing the wrong ERP model, choosing the wrong consultant, cost overrun issues, and disruptions to operations. Also presented were a number of issues to consider when implementing an ERP. These include selecting a system that is a good fit for the organization, understanding that the term scalability can mean different things to different people, potential problems associated with customizing the software, the need for assigning performance measures, and the need to control outside consultants. The chapter concluded with a review of the internal control and auditing issues related to ERPs.

Comments

Post a Comment

Popular posts from this blog

The Conversion Cycle:The Traditional Manufacturing Environment

By -
Image
The Traditional Manufacturing Environment The conversion cycle consists of both physical and information activities related to manufacturing products for sale. The context-level data flow diagram (DFD) in Figure 7-1 illustrates the central role of the conversion cycle and its interactions with other business cycles. Production is triggered by customer orders from the revenue cycle and/or by sales forecasts from marketing. These inputs are used to set a production target and prepare a production plan, which drives production activities. Purchase requisitions for the raw materials needed to meet production objectives are sent to the purchases procedures (expenditure cycle), which prepares purchase orders for vendors. Labor used in production is transmitted to the payroll system (expenditure cycle) for payroll processing. Manufacturing costs associated with intermediate work-in-process and finished goods (FG) are sent to the general ledger (GL) and financial reporting system. Dependin
Read more

The Revenue Cycle:Manual Systems

By -
Image
Manual Systems The purpose of this section is to support the system concepts presented in the previous section with models depicting people, organizational units, and physical documents and files. This section should help you envision the segregation of duties and independent verifications, which are essential to effective internal control regardless of the technology in place. In addition, we highlight inefficiencies intrinsic to manual systems, which gave rise to modern systems using improved technologies. SALES ORDER PROCESSING The system flowchart in Figure 4-12 shows the procedures and the documents typical to a manual sales order system. In manual systems, maintaining physical files of source documents is critical to the audit trail. As we walk through the flowchart, notice that in each department, after completion of the assigned task, one or more documents are filed as evidence that the task was completed. Sales Department The sales process begins with a customer cont
Read more

Nassi-Shneiderman charts

By -
Image
Nassi-Shneiderman charts 56.1 Purpose Nassi-Shneiderman charts were developed by Nassi and Shneiderman as an alternative to traditional logic flowcharts. Their intent was to provide a structured, hierarchical, graphical view of the flow of logic through a program, a routine, a module, or a process. Nassi-Shneiderman charts are used to document, plan, and design detailed program logic. 56.2 Strengths, weaknesses, and limitations A properly prepared Nassi-Shneiderman chart can illustrate the flow of logic through a module or routine at a glance. Nassi-Shneiderman charts are useful for describing or planning relatively small modules, routines, or processes. They can be used to clearly show nesting and recursion, and are easily converted to structured code. Nassi-Shneiderman charts should not be used for documenting complete programs or large routines. As a general rule, Nassi-Shneiderman charts should be limited to a single page with no more than 20 subdivisions. For larger rout
Read more