Telecommunications and Banking Industries

Today, telecommunications and banking industries continue to lead in data warehouse spending. As much as 15% of technology budgets in these industries is spent on data warehousing. Companies in these industries collect large volumes of transaction data. Data warehousing is able to transform such large volumes of data into strategic information useful for decision making.

At present, data warehouses exist in every conceivable industry. Figure 3-1 lists the industries in the order of the average salaries paid to data warehousing professionals. The utility industry leads the list with the highest average salary.

In the early stages of data warehousing, it was, for the most part, used exclusively by global corporations. lt was expensive to build a data warehouse and the tools were not quite adequate. Only large companies had the resources to spend on the new paradigm. Now we arc beginning to sec a strong presence of data warehousing in medium-sized and smaller companies, which are now able to afford the cost of building data warehouses or buying turnkey data marts. Take a look at the database management systems (DBMSs) you have been using in die past. You will find that the database vendors have now added femme:: to assist you in building data warehouses using these DBMSs. Packaged solutions have also become less expensive and operating systems robust enough to support data warehousing functions.

Data Warehousing is Becoming Mainstream

Data Warehousing is Becoming Mainstream

In the early stages, four significant features drove many companies to move into data warehousing:

• Fierce competition
• Government deregulation
• Need to revamp internal processes
•  Imperative for customized marketing  

Telecommunications, banking, and retail were the first ones to adopt data warehousing. That was largely because of government deregulation in telecommunications and banking. Retail businesses moved into data warehousing because of fiercer competition. Utility companies joined the group as that sector was deregulated. The next wave, of businesses to get into data warehousing consisted of companies in financial services, health care, insurance manufacturing, pharmaceutical, transportation, and distribution.

CONTINUED GROWTH IN DATA WAREHOUSING

CONTINUED GROWTH IN DATA WAREHOUSING
Data warehousing is no longer a purely novel idea for study and experimentation. It is be-coming mainstream. True the data warehouse is not in every dentist's office yet, but neither they it is confined only to high-end businesses. More than half of all U.S. companies has made a commitment to data warehousing. About 90% of multinational companies have data warehouses or ate planning, to implement data warehouses in the next 12 months.

In every industry across the board, from retail chain stores to financial institutions, from manufacturing enterprises to government departments, from airline companies to utility businesses, data warehousing is revolutionizing the way people perform business analysis and make strategic decisions. Every company that has a data Warehouse is realizing enormous benefits that get translated into positive results at the bottom line, many of these companies now incorporating Web-based technologies are en-ing the potent nil for greater and easier delivery of vital information.

Over the past five years hundreds of vendors have flooded the market with numerous products. Vendor solutions and products run the gamut or data warehousing, data modeling, data acquisition. Data quality, data analysis, metadata, and so on, the buyer's guide published by the Data Warehousing Institute features no fewer, than 105 leading products. The market is already huge and continues to glow.

CHAPTER 3 TRENDS IN DATA WAREHOUSING

CHAPTER 3 TRENDS IN DATA WAREHOUSING

CHAPTER OBJECTIVES 

• Review the continued growth in data warehousing
• Learn how data warehousing is becoming mainstream
• Discuss several major trends, one by one
• Grasp the need for standards and review the progress
• Understand Web-enabled data warehouse

In the previous chapter, we have seen why data warehousing is essential for enterprises, of all sizes in all industries. We have reviewed how businesses are reaping major benefits from data warehousing. We have also discussed the building blocks of a data warehouse. You now have a fairly good idea of the features and functions of the basic components and a reasonable definition of data warehousing. You have understood that it is a fundamentally simple concept at the same time you know it is also a blend of many technologies. Several business and technological drivers have moved data warehousing forward in the past few years.

Before we proceed further, we are at the point where we want to ask sonic relevant questions. What is the current scenario and slate of the market? What businesses have adopted data warehousing? What are the technological advances? In short what at the signets-nt trends.

It is too early in our discussion of the subject to talk about trends? The usual practice is to include a chapter on future trends towards the end, almost as an afterthought.
The reader typically glosses over the discussion on future trends. This chapter is not so much like looking into the crystal hall for possible future happenings: we want to deal with the important current trends that arc happening now. 

It is important for you to keep the knowledge about the current trends as a backdrop in your mind as you continue the deeper study of the subject. When you gather the informational requirements for your data warehouse, you need to be aware or the current trends. When you get into the design phase you need to be cognizant of the trends. When you implement your data warehouse. You need to that your data warehouse is in line with the trends, knowledge of the trends is important and necessary even at a fairly early stage of your study. In this chapter we will touch upon most of the major trends. You will understand how and why data warehousing continues to grow and become more and more pervasive. We will discuss the trends in vendor solutions and products. We will relate data warehousing with other technological phenomena such as the Internet and the Worldwide Web. Wherever More detailed discussions are necessary, we will revisit some or the trends in later chapters.

70-413 Question 4

70-413 Question 4

Your network contains an Active Directory domain named contoso.com. You plan to implement multiple DHCP servers. An administrator named Admin1 will authorize the DHCP servers. You need to ensure that Admin1 can authorize the planned DHCP servers. To which container should you assign Admin1 permissions?

70-413

To answer, select the appropriate node in the answer area.

Answer: