DATAWAREHOUSE HistoryData has begun to proliferate during the 70’s and 80’sso there is a need for the organizations to have an easy way to store andaccess the data/information. Bill Inmon is considered as the father of datawarehousing as he was the first to coin the term and define the concepts in1970. His book “Building the Data Warehouse” is considered as the fundamentalsource for warehousing during the year 1992. According to Inmon, centralizedrepository is established first and within the repository, data marts whichcontain specific subsets of data are created so his definition of warehouse iscalled top-down approach. Later in 1992 Ralph Kimball suggested a slightlydifferent tactic to data warehousing concept with his bottom-top approach,where individual marts are developed first and are integrated together tocreate a data warehouse. 1ImportanceTo make informed decisions organizations need data so,this makes the concept of data warehouses an important topic because they storeall that data.
Data warehouses can store large amount of data in the standardformat in the central database. They can integrate the data from differentsources and standardize the data which is helpful for analytics/reporting. Theymaintain the data in a single location, so the data stored is secured and canbe accessed to those who need specific data.
They provide quick access whichwill help in improving the business decisions. ToolsThere are many tools that help the companies to meettheir comprehensive needs. Some of the examples of data warehouse tools that areavailable in the market are Ab Initio software, Amazon red lift, analytiX DS,Code futures, datallegro, holistic data management, informatica corporation,paraccel, Teradata corporation, bime, vertica, profit base, net app, keboola,kalido, Greenplum, Netezza, pervasive, SAP business warehouse, hyperion,numetic, alteryx, talend, mark logic, Par Accel, IBM infosphere, informatica. Asthere are many tools available in the market, there is a need for the companiesto choose a proper tool based on their requirements which help them to grow.Having number of options in the market also lays stress over the importance ofproper analysis. As the data warehouse being the central repository, it is veryimportant for every organization to choose the correct tool. 2 Some of thecompanies that are using amazon redlift (data warehouse tools) are financialtimes, nokia, vivaki, foursquare, Zalora, commercialize tv, everything me, viki,redmart, pocketmath.
FutureEarlier companies used to use spreadsheetsto manage the data but now due to big data revolution there has been manychanges on how companies collect, store, manage and analyze the data. Manyadvances in data warehousing have helped the companies to take rows ofdifferent bits of information and generate insights to make smarter decisions.In the last few years size of open database has grown approximately double itsmagnitude which clearly shows its significance. And as the size of databasesgrow the estimates of what constitutes a large database continuous to grow. TrendsThe internet of things and other sources aregenerating large amount of data everyday which is termed as fire hose of data.IT departments in various companies are responding to this situation by addingnew features and capabilities to data ware houses so that they can add newtypes of data and perform faster than ever. Many companies have started usingphysical and logical consolidation to help reduce cost.
Open source Hadoop andparallel Map Reduce paradigm are used at processing very large data sets. Today most of the data warehousemanagers are using Hadoop to decrease the level of workloads. Customerservice strategies are used in thecompanies where they collect customer information which helps them in sentimentanalysis, sales, customer service, automation, marketing, etc. For large scaleinformation management new generation companies are using engineering systems whichhelp them to preconfigure and optimize specific kinds of workload. Thesesystems deliver the highest level of performance without integration problems.In memory technologies can process large data sets in the RAM which helps in acceleratingthe reportAdvanced compression methods such as Oracle’s hybridcolumnar are used by companies to capture and store more valuable data.
These latest trends are making the data warehouses biggerand faster than the former and these trends help in transforming data intoactionable insights with great speed and accuracy. 3BenefitsA company can benefit in many ways by implementing thedata warehouses into business intelligence plans. Many companies are using datawarehouse instead of direct access because they can integrate many data sourcesin real time which will help in making better decisions. This helps in saving alot of time for the companies. These are mainly used for making strategic decisionsand also help in making finance and inventory management.References1.
[email protected] Institute Inc. (2016). Data warehouse, what is it and why it matters.Retrieved fromhttps://www.sas.com/en_us/insights/data-management/data-warehouse.
html#2. JesalShethna. (2016, March 2). EDUCBA. 10 popular data warehouse tools andtechnologies. Retrieved from https://www.educba.com/10-popular-data-warehouse-tools/3.
ForbesBrandVoice.(2017, Dec 8). Forbes. Tech.
The top 10 trends in Data warehouse. Retrievedfromhttps://www.forbes.com/sites/oracle/2014/03/10/the-top-10-trends-in-data-warehousing/#13df9b761373