Running head: Summary and Review of Data Warehousing Fundamentals
Data Warehousing: Data Warehousing Fundamentals for IT Professionals
By
Paulraj Ponniah
Summary and Review
By
Department of Computer Science, Engineering, and Physics
University of Michigan-Flint
SUMMARY
Below is a summary of the book “Data Warehousing Fundamentals for IT Professionals”, written by Paulraj Ponniah. Data Warehousing Fundamentals was written in June, 2010 containing 544 pages in its first edition, published by Wiley India Pvt Ltd and the edition type of this book is student. The author has above thirty years of experience in the field of IT and he has command over the design and implementations of database systems. Dr. Paulraj Ponniah has
…show more content…
Since the first version of “Data Warehousing Fundamentals”, many corporations have implemented data warehousing systems, in addition to implementation the great benefits are notice. Many more enterprises are in the process of adopting this technology.
REVIEW
Author Ponniah divided the book into six major parts such as; Overview and Concepts. Planning and Requirements, Architecture and Infrastructure, Data Design and Data Preparation, Information Access and Delivery, and the sixth one is Implementation and Maintenance.
First 3 chapters of the book are written in a way that beginners may get clear view of the basic concepts. First chapter described the need regarding strategic information, information crisis, and that the data warehousing is a better solution for information crisis. Features and components of Data warehouse, along with the concept and need of metadata is described. Various trends in data warehouse are mentioned by the author based on his own industrial experience. Areas like Continued growth in data warehousing
The purpose of data warehousing is to combine all of a company 's data and allows users to access the data directly, create reports, and obtain responses to
TCS Company provided a solution to one of its client for changing hardware and software to existing database presented in client’s data warehouse for reutilization. Client is leading global provider for offering communication services, it delivers solutions to multinational Companies and Indian consumers (Tata consultancy). Company implemented a solution by replacing the existing hardware and software with TATA Company data warehouse
A data warehouse is a large databased organized for reporting. It preserves history, integrates data from multiple sources, and is typically not updated in real time. The key components of data warehousing is the ability to access data of the operational systems, data staging area, data presentation area, and data access tools (HIMSS, 2009). The goal of the data warehouse platform is to improve the decision-making for clinical, financial, and operational purposes.
The implementation of the data warehouse was based on Kimball’s (Kimball and Ross, 2013) dimensional modelling techniques which involved business requirements analysis & and determination of data realities and the four step dimensional modelling design process. These was followed by the design and
Data warehousing is defined as the design and implementation of processes and tools to manage and deliver complete, timely, accurate, and understandable data for
We can say that “Data is the fuel of next generation”. Today we live in the world that is driven by data. The World Economic Forum summarizes the fourth industrial revolution as a possibility for billions to be connected, machines with enormous processing power and high-volume data storage. These possibilities are evolving exponentially in field of Internet of Things, Artificial Intelligence, Machine Learning, bio technology, autonomous vehicles, etc. To handle such a large volume of data in a uniform manner, it is required to be processed and stored for analysing and getting business insights. This exponential growth and the increasing demands in all fields has led the data warehousing technology to emerge tremendously. In this report, we will discuss about the two broad approaches for designing and implementing data warehouse presented by two data warehouse giants Ralph Kimball and Bill Inmon. Also, we will compare the architectural design approach, implementation approach along with their advantage and dis advantage from a business point of view.
Chapter 2 describes the Avalon data warehouse functionality and chapter 3 the scope of the Avalon data warehouse. Chapter 4 lists the motivation for supporting the Avalon data warehouse implementation. In chapter 5, the process of collecting and processing business requirements is described. At chapters 6 and 7, there is a technical description of the architecture and data security, and Chapter 8 outlines the implementation plan.
In Philip Russom’s webinar he provides an overview of what a Data Warehouse (DW) modernization is, why many users’ DWs need modernization. The top five most common reasons for DW modernization including: Advanced Analytics, Scale, Speed, Productivity and Cost Control, what is the result from modernization, and his recommendations
The concept of data warehousing dates back to the late 1980s when IBM researchers Barry Devlin and Paul Murphy developed the “business data warehouse”. Data warehouse (DW) is an application which allowed you to execute ad-hoc queries; multi-dimensional analysis and query information by
This paper will present the return on investment (ROI) of data warehousing (DW). The history of data warehousing is based on the definition and timeline. Then, detailed information about return on investment will be discussed. Following, will be information about data warehousing new technology of hardware and software. Data Warehousing is a new term in my department where we use the Network Appliance (NetApps) Netfiler storage devices/units. The information read was very informative and helpful in my understanding data warehousing better. Finally, a conclusion about the return on investment of data warehousing.
Summary: The text book I have chosen is “The Data Warehouse Toolkit” third edition, written by Ralph Kimball and Margy Ross. This book mainly involves on techniques to develop the business in real-time. As the authors had a lot of experience because of their work from 1980’s, they have seen both the growth and failures of the companies in the market. Chapters in this text book involves goals of data warehousing which include Data staging area, data presentation, data access tools. Kimball modeling techniques involves gathering business requirements and data realities, business processes, different table techniques. Case studies in retail sales are explained in this text book, four step dimensional design process which includes the design process with the help of different dimensions and facts. In order management chapter it deals with the business processes that to be implemented in data warehouses as they supply core business performances metrics and finally provide the real time warehousing requirements. Customer relationship management involves in improving the customer relation with the company or product, understanding the needs of customer and providing high level service is the goal of this chapter. In accounting, we deal with model of general ledger information for the data warehouse, it describe the years and dates at which things to be happened and show different dimensional models which helps to combine the data from
Data warehouse are multiple databases that work together. In other words, data warehouse integrates data from other databases. This will provide a better understanding to the data. Its primary goal is not to just store data, but to enhance the business, in this case, higher education institute, a means to make decisions that can influence their success. This is accomplished, by the data warehouse providing architecture and tools which organizes and understands the
Data has always been analyzed within companies and used to help benefit the future of businesses. However, the evolution of how the data stored, combined, analyzed and used to predict the pattern and tendencies of consumers has evolved as technology has seen numerous advancements throughout the past century. In the 1900s databases began as “computer hard disks” and in 1965, after many other discoveries including voice recognition, “the US Government plans the world’s first data center to store 742 million tax returns and 175 million sets of fingerprints on magnetic tape.” The evolution of data and how it evolved into forming large databases continues in 1991 when the internet began to pop up and “digital storage became more cost effective than paper. And with the constant increase of the data supplied digitally, Hadoop was created in 2005 and from that point forward there was “14.7 Exabytes of new information are produced this year" and this number is rapidly increasing with a lot of mobile devices the people in our society have today (Marr). The evolution of the internet and then the expansion of the number of mobile devices society has access to today led data to evolve and companies now need large central Database management systems in order to run an efficient and a successful business.
A common feature of data warehouse on which most of the scholars agree upon is that a data warehouse acts as storage of historical data. This
The major of subjects is arranged in data warehouse. For example, inventory, products and customer, to get more benefits form data warehouse it must be integrated by collecting from databases across enterprises, the information for customers should have code or described specifically according to departments. All departments the procedures on database are updated on a regular basis with deletion, insertion and changes. The operations that only be in data warehouse the data can be loaded and the data can be accessed. Once whole data forms and models are recorded, the data can not change. The design of retrospective data warehousing is traditional, and many questions before starting design to be work as required. What we sale? What will be the importance of our debt in the next six months? Where is the best market for a new service? A data warehouse in the World Wide Web is a predictable to save Lawrence Livermore National Laboratories in California a lot of related costs whit clients.