This website uses cookies to ensure you have the best experience. Learn more

Implementing A Data Warehouse In A Kar Dealer Network

1378 words - 6 pages

Data warehouse architecture
Goldfarelli & Rizzi (2009) describe two classifications of a data warehouse architecture. The first classification describes the physical separation of the data warehouse's architectural layers. The second classification is based on the methods devised by Inmon and Kimball. Inmon advocates the use of hub-and-spoke architecture, while Kimball prefers an architecture based on the data mart bus (Ariyachandra & Watson, 2006).
The advantage of the hub-and-spoke approach is data integration versus the ease of development and a lower cost of the federated approach (Hwang & Cappel, 2002).
Data warehouses are implemented in a layered architecture. In the single layer, both the OLTP and OLAP compete for system resources causing performance degradation (Goldfarelli & Rizzi, 2009). The multi-layers architectures like the two and three layer designs create a physical separation so that the two systems don't interfere with each other (Goldfarelli & Rizzi, 2009).
The three layer architecture includes a reconciled layer where a database contains data that has been cleansed, adjusted, or enhanced to provide reliable and consistent data that can be imported an mapped into the data warehouse schemata for data analytics (Goldfarelli & Rizzi, 2009).
Data warehouse development approaches
There are two major approaches to choose from when implementing a data warehouse. The first is the top-down approach, which is the most expensive, requires that the global business needs are thoroughly analyzed so that a enterprise wide data warehouse is implemented (Goldfarelli & Rizzi, 2009).
The second method, which is more universally accepted, is the less costly bottom-up approach that uses departmental facts and an incremental method of discovery to create several data marts (Goldfarelli & Rizzi, 2009).
Vowler (2002) suggests that in order to decide on which approach to use, the designer must ask where the urgent need lies. If the business need is at the highest level and the CEO can wait, then the top-down approach should be chosen. However, if the need is at the lowest levels, then the bottom-up approach should be used for a quick return on investment (Vowler, 2002).
Pep Boys implemented their data warehouse by using the bottom-up approach. They included sales people and field managers during the requirement stage (King, 2003).
Building data warehouses is an expensive undertaking. Hwang & Cappel (2002) indicate that the cost difference between hub-and-spoke and federated approaches are negligible. The average cost for hub-and-spoke and federated data marts are $4.7 million and $5.1 million respectively (Hwang & Cappel, 2002).
Business Dimension Lifecycle
When starting a data warehouse project, the designers must focus on the types of questions the users will ask (Hammergren & Simon, 2009). Business users query data that is organized in a multidimensional format where the first dimension are the columns headings and the second...

Find Another Essay On Implementing a Data Warehouse in a Kar Dealer Network

Implementing Medication Information in a Forensic Setting

4272 words - 17 pages IntroductionService user's who interrupt their prescribed medication regime or even refrain from it altogether are at an increased risk of experiencing a relapse of their mental illness (Mueser et al, 2002). This is the case regardless of their diagnosis but in this assignment the author will be solely discussing those diagnosed with schizophrenia.Literature highlights the increase in relapse rates when antipsychotic medication is not adhered to

Implementing a New Wide Secure Wireless Network at Brigham Young University Hawaii

2628 words - 11 pages mutual authentication— TLS: The authentication server supplies the certificate. IKE: In this the server demonstrates possession of preshared key. Kerberos: The server proves knowledge of the session key. Encryption: We have discussed about the various types of threats and attacks for a wireless network. Since information is transmitted in free space, that data can be easily Eavesdropped or captured. So, it is a must that this data should be

Notes from Business Data Communication Class, Local Area Network Technology. (download it is set up in a table)

2902 words - 12 pages Networks The 802 committee created also the 802.5 Network standardFirst operated at 4Mbps but which quickly grew to 16MbpsWas faster than and more reliable then 208.3 but was more expensiveit has still a niche in companies with strong IBM mainframe groupsFIBER DISTRIBUTED DATA INTERFACE(FDDI) Another legacy of token-ring network technologyOperates at 100mbpsCan have an amazing circumference for 200kmWas popular as a core LAN technology when desktop

Implementing a Wellness Program

805 words - 4 pages the committees’ challenges will be, in order to lay out the frame work of the program. 2. Next, analyze the survey data to determine what will motivate employees and works with the existing culture. Combining wellness education with physical activity is the best way to start building a plan. *Wellness education includes; wellness workshops such as learning to prepare healthy foods, comprehensive weight loss programs, and stress

Implementing Medical Record Software Systems in a Hospital

2130 words - 9 pages hospital such as having no more than 25 inpatient beds and maintaining an annual length of stay of no more than 96 hours for acute inpatient care. The critical access hospital has to have 24-hour, 7-days-a-week emergency care and must be located in a rural area. The critical access hospital cannot be close to another CAH up to 35 miles. The company that I would choose for implementing electronic medical records would be Athenahealth. Athenahealth

Implementing a Road Price to Reduce Traffic Congestion in Stockholm

2340 words - 10 pages that can be taken lightly. To solve the congestion, people have begun to use road pricing as one of their strategies. In the study done by the Metro Vancouver Regional District for the BC Business Council (2007, p. 1), road pricing is defined as the concept, in which drivers pay for using the road, bridge or tunnel, or for driving into a defined zone. In that study, we are introduced with the idea of implementing a road pricing strategy to fight

Virtual Networks in a Network Vitualization Environment

1528 words - 7 pages networks. For this reason, virtual link aggregation will constitute an important requirement for network virtualization. Virtual link aggregation can be defined as a set of virtual links that follow a common path and are similarly treated between a pair of virtual nodes. It can be performed by carrying at least two types of identifiers in the data plane, one for virtual network identification and another for hop-by-hop forwarding. Hence, virtual

Design a Network Infrastructure Because Networks are Configured in Many Ways, Network Systems and Data Communications Analysts are Needed to Design, Test, and Evaluate Systems Such as Local Area...

8965 words - 36 pages Cover PageNetwork systems andData communicationDesign a network infrastructureBecause networks are configured in many ways, network systems and data communications analysts are needed to design, test, and evaluate systems such as local area networks (LANs), wide area networks (WANs), the Internet, intranets, and other data communications systems.The term WAN (Wide Area Network) refers to a network, which covers a large geographical area, and use

Implementing a Successful Management Plan

1035 words - 5 pages , effectiveness and implemented controls, the OHSMS system needs to be reviewed regularly. Question Three Employer commitment to safety management practices The employer is able to exhibit their active commitment to health and safety in the work place, A proactive employer who demonstrates active roles in health and safety, who involves their staff as opposed to taking a lax approach to health and safety is more inclined to have a safer work

Accessing Persistent Data in a Relational Database

2345 words - 9 pages Introduction Most applications will need to access persistent data at some point, which may reside in relational databases, flat files, mainframe systems, LDAP repositories, or be provided by services through external systems. When business components need to access a data source, they need to use the appropriate mechanism to achieve connectivity and manipulate the stored data. Mechanisms to access these different types of persistent storage

Building a secure network

906 words - 4 pages downloaded for free. Wireshark is a packet analyzer that to captures and displays the data packets. This tool helps users see a data packet and check it for tampering. It is used in conjunction with SNORT. Building and Designing a network can long and tedious task. The time and development of security policies is a process that can equal the creation time of the network topology. The security implementations to secure the infrastructure must be

Similar Essays

Developing A Payment Data Warehouse Essay

1162 words - 5 pages Citigroup PDW: Developing a Global Payment Data Warehouse MIS600–Information Systems Capstone December 13, 2013   Table of Contents Data Model 3 Entity Model 5 Purge Records 7 Project Costs, Staffing, Resources, Dependencies, and Schedule 8 Scope Change Documetation 10 References 12 Data Model Facts Table The star schema is the essential model of a data warehouse blueprint in which a central fact table or

Analysis And Research For A Data Warehouse System

992 words - 4 pages optimizing ETL is an ongoing research topic. There are a couple problems to think about when creating data warehouses: business problems and technical problems. From a business perspective, implementing a data warehouse is an immense project that can take months or years to complete. There are two models for doing this: the Bruce Kimball bottom-up method and the Bill Inmann top-down method. In the bottom-up method, the organization starts

Challenges Facing A Corporation When Implementing A Network

1218 words - 5 pages needs. If it is a small local area network (LAN) the infrastructure will be different than that of a wide area network (WAN) Data is transmitted differently and would, therefore require a completely different infrastructure from the LAN. It is important to note, however, that communication between the two is easily achieved through routers, and other hardware devices. In either case a good solid infrastructure must be built. The infrastructure

Metrics That Should Be Developed To Measure The Performance Of A Data Warehouse In The Following Environments: 1) Health Care, 2) Retail And 3) Pharma

1525 words - 6 pages In most of the Database guide papers, eight performance-based metrics were used to communicate areas of concern to the data warehousing vendor. Also, the ninth one was developed as a weighted average measure using four of the eight metrics, which were deemed the most critical to the organization assessing data warehouse performance to determine how the vendor stacked up relative to data quality and systems quality.The nine metrics that were