Business Intelligence and Data Warehouses
Business Intelligence and Data Warehouses
Popular in Department
verified elite notetaker
This 0 page Study Guide was uploaded by NUMBER1TUTOR Notetaker on Wednesday November 4, 2015. The Study Guide belongs to at California State University - Dominguez Hills taught by in Summer 2015. Since its upload, it has received 49 views.
Reviews for Business Intelligence and Data Warehouses
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 11/04/15
Running Head Business Intelligence and Data Warehouses Business Intelligence and Data Warehouses Student IDS Business Intelligence and Data Warehouses 2 1 Differences among the formations of a relational database optimized for online transactions against a data warehouse optimized for processing as well as summarizing large quantities of information Warehouse is a database which is planned to development for query as well as analysis quite than for deal processing along with it is generally contains historical information derived from transaction information other than can contain information from other sources although RDO for online transaction which contains insertions updates as well as deletion Fundamentally Data Warehouse is classified as a subject oriented and also non volatile as well as time modification group of database which supports supervision s decisions And also Data Warehouse is extremely distinct from online deal systems Numerous of differences are given under One of chief difference and also a data warehouse you can accomplish separate study workload form deal workload which creates it very greatly read oriented systems And also Data warehouses are planned to contain ad hoc queries You may not recognize the workload of mainly data warehouse in proceeds consequently a data warehouse must be optimized to do well for a broad range of possible query processes Data warehousing engages the extraction as well as moving of relational information from one or extra source databases into the information warehouse for study Business Intelligence 2014 2 Differences among database needs for operational data as well as for decision support data are Operational databases are more and more supporting spread database structural design that gives high availability along with fault acceptance through duplication as well as scale out facility Operational databases are applied to store supervise as well as track real time industry information And also Operational data are usually stored in numerous tables as well as the stored information symbolize the information regarding a given transaction simply Business Intelligence and Data Warehouses 3 Decision support information also needs periodic updates to load latest information that are concise from the operational data At last the concurrent deal volume in operational data is inclined to be very extra when evaluated with the low to medium stages found in decision support information Decision support data may be gathered to check such aggregates as entire sales for all stores or for all creation The reason of the summaries is easy they are to be applied to establish as well as calculate sales trends creation sales comparisons as well as so on that provide decision requirements 3 Examples in which databases might be applied to support decision making in big organizational surroundings are Examples of M88 are supervision information systems in the sixties DSS in the seventies and D88 can be considered as a common term for information arrangements which offer support for supervision tasks For instance decision creators anchor on the first information they get as well as that pressures how they understand following information Moreover decision makers are inclined to place the maximum attention on extra current information as well as either disregard or not remember past information For example computers as well as information technology can assist citizens make significant decisions Computerized DSS help as well as support executives along with keep them linked to the decision making ring The overriding objective is getting better decision making success as well as competence not automating decisions Database Administration 2012 4 Examples in which data warehouses as well as data mining could be applied to support data processing along with trend analysis in big managerial surroundings For instance one Midwest grocery sequence applied the data mining power of Oracle software to define local purchasing patterns They exposed that when men purchase diapers on Thursdays as well as Saturdays and also they also are inclined to purchase beer Additional study showed that these shoppers normally did their Business Intelligence and Data Warehouses 4 periodical grocery shopping On Thursdays conversely they merely bought some items The seller concluded that they buy the beer to have it obtainable for the approaching weekend For instance Blockbuster Entertainment excavates its Video rental record database to suggest rentals to individual purchasers American Express can recommend goods to its cardholders related on study of their periodical expenditures For example an outdoor tools retailer could forecast the probability of a backpack being buys based on a purchaser39s buy of sleeping bags as well as hiking shoes Joseph 2014 Business Intelligence and Data Warehouses 5 References Business Intelligence 2014 Retrieved from httpdocsoraclecom httpdocsoraclecomcdB 1930601 server 102bl4220busintlhtm Database Administration 2012 Retrieved from WWWinformitcom WWWinformitcom gt Articles gt Data Joseph M 2014 Significance of Data Warehousing and Data Mining in Retrieved from WWWij sceorg WWWijsceorgattachmentsFilev3ilA1391033 l l3pdf
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'