Basic Elements of a Data Warehouse essay

Basic Elements of a Data Warehouse essay Basic Elements of a Data Warehouse essay Basic Elements of a Data Warehouse essayDate warehouses are defined as subject-oriented, integrated, time-variant collection of data in support of management decisions. Their architecture is based on relational database management system server functioning as central repository for information data. The central information repository is surrounded by different components designed to make the environment functional, accessible and manageable for both the operational systems and the end user query.Unlike database that is merely a collection of related data and database system, a data warehouse is a collection of large amounts of data from multiple sources and a supporting system optimized for access and designed to support efficient extraction, processing and presentation of data for different purposes. Thus, warehouses are able to store and manage large volumes of data for complex analysis. There are several key components of data warehousing. The first component is operational source systems that hold the transactional data and have little control over the format and content of the data and maintain little historical data. Another component is data staging area that stores data and encompasses a set of process between the operational source systems and the data presentation area. The process is generally called extract-transformation-load, the first step of which is extraction. It presupposes reading and understanding the source data and copying it into the staging area for further transformation. After cleansing the data and doing other relevant manipulations the quality assured data is loaded in a data warehouse. Another essential component of a data warehouse is data presentation area that is a set of integrated data marts. The data is selected according to the business needs, it is atomic, detailed and logically organized as well as finally made available for direct querying. Data marts are sets of summarized and aggregated data that take less time and are cheaper. One more component of a data warehouse is data access tools. All data access tools query the data in the data presentation area and are the software like Cognos 10 and Roambi. Depending on the purpose they can be either elementary or sophisticated. Tools may fall into the following categories: query and reporting tools, online analytical processing tools, application development tools and data mining tools. Every data warehouse has meta data that is used for its maintaining and managing, it helps users to understand content, find data and can be classified into technical meta data and business meta data. The former contains data about warehouse for designers and administrators, while the latter gives users easy access to information. In business data warehousing is used to support management decision making and provide efficient storage, functionality and responsiveness. Moreover, data warehouses are indispensible when an enterprise has to facilitate complex and frequent ad hoc queries, it provides effective query support, gives historical information for analysis, supplements disaster recovery plans etc.Data warehouses merge data from different sources into one database and analyze development over time, they perform integration of disparate data sources. Managers and executives no longer have to make decisions based on limited data. Warehousing offers considerable flexibility in operational systems and simplify the processes of data reporting and analysis. Thus, it improves the efficiency of decision-making. Presently warehousing is still expensive and only successful corporations implement it, however, if data warehouses are designed properly and function adequately, they give a company numerous benefits, generate higher amounts of revenue, provide considerable cost and time savings etc.

Brewing Beer at the White House - First Homebrewer President

Brewing Beer at the White House - First Homebrewer President Lots of American presidents enjoyed their booze, and many brewed their own beer. George Washington was well known as a  home brewer and made  his own porter and whiskey at Mount Vernon. Thomas Jefferson did the same thing at  Monticello. But  the first American president known to have brewed his own beer on the grounds of the White House in  Washington, D.C. was Barack Obama, who made porter and ale beginning in his first term. As far as we know the White House Honey Brown Ale is the first alcohol brewed or distilled on the White House grounds, wrote  Sam Kass, the White House senior policy adviser on  nutrition  policy, in September 2012. George Washington brewed beer and distilled whiskey at Mount Vernon and Thomas Jefferson made wine but theres no evidence that any beer has been brewed in the White House. Obama as Home Brewer Obama began brewing beer in 2011 after the president bought his first home-brewing kit. He started brewing beer because he was in search of a hobby, according  to  published reports. Shortly after his home-brewing activities were made public, the  American Homebrewers Association made Obama a lifetime member. Though beer has long been part of the country’s history and traditions, Obama made history when, as president, he purchased a homebrewing kit and then - alongside chef Kass - spearheaded the effort to brew White House Honey Ale, the first beer known to have been brewed in the White House, the association wrote. About the Obama White House Beer The Obama staff made at least three difference styles of beer: a brown ale, a porter, and a blonde ale. All three were brewed with honey that was drawn from a beehive on the South Lawn of the White House. The honey gives the beer a rich aroma and a nice finish but it doesnt sweeten it, the White House said of the ingredient. The names of the  Obama White House beers were: White House Honey Brown AleWhite House Honey PorterWhite House Honey Blonde When Obama ran for a second term in  the 2012 presidential election, he  stocked his campaign buses with the White House brews. While  the White House brewed  the beer, it did not market or sell the beer publicly. It did,  however, publish the recipes for likeminded home brewers to try. Both the brown ale and honey porter were given good marks by fellow home brewers. Remarked Ray Daniels, in an interview with Bloomberg Businessweek:  Ã¢â‚¬Å"They are both pretty malty and on the sweeter side of the scale in overall balance. That will certainly make them crowd pleasers or at least unobjectionable to a broad range of people.† Wrote critic Gary Dzen in The Boston Globe: The White House knew what they were doing when they brewed this beer. Its approachable enough to serve to casual beer enthusiasts but flavorful enough to be interesting to those of us who know what we want our beer to taste like. Why Beer for Obama Obama is a beer drinker who was known to invite members of Congress and other important figures in American politics to the White House to talk and quaff a brew or two. In 2009, for example, Obama called what came to be known as a beer summit between himself,  Vice President Joe Biden, Harvard professor Henry Louis Gates Jr., and Cambridge, Mass. police Sergeant James Crowley.  Obama invited the men to the White House to talk over beers after police in Crowleys force arrested  Gates at his home.