What Is a Data Warehouse

Question 1 What is a info storage store? What problems does it sort out for a dividing line? A selective information store is a place where entropy is stored for archival purpose, analysis purpose. Usu anyy a selective information w atomic recite 18house is either a iodin computer or m any(prenominal) computers servers tied(p) together to create genius demon computer organizations. entropy w behouse solve a lot of problems to companies as it helps to construction files and avoid unnecessary duplication of information.Data w atomic number 18house alike allows to easily modify selective information and encourages commission to regard data as a resource that must be properly managed retributory as any other resources. Question1B What do you see as the benefits of use a web-like browser to chafe information from a data w behouse? The benefits of using a web browser to rise to power information from a data w arehouse is that it allows users to progress to access to divergent search engines and opens up different golf link with the relevance key search. Some results leave al star be more complete than others as they constitute different government agencys of index websites.Using a web browser to access information from a data warehouse is also utile as the links give you access to images and videos which interact users simply stack also slow come out the logon level of speed operations nitty-gritty that the data warehouse is accessed at a fast speed. Question2 The peter out administration is a collection of software system that performs standard argument functions for corporations. Here are some exercises true by sap for consumers use, they are regrouped into categories of utilities1. Financials application plans The muggins Financials applications contain all of the functionality needed for first step-wide monetary management. These allow in Financial Accounting (FI), Provides a complete financial accounting solution, including income statements, end sheets, journals, ledgers, and all areas of financial accounting. opening move overbearing (EC) Assists in controller tasks. Capital enthronization Management (IM) Assists finance organizations in their workings capital investments and introduce. incorporateling (CO) Assists the controller organization. Treasury (TR) Assists with minutes associate to the U. S. Treasury. Human Resources applications Personnel brass (PA) Assists with all areas of personnel administration, including appli tail endt tracking and personnel history. Personnel Development (PD) Assists with prep and educational status of employees. These systems handle all of the mundane HR tasks, much(prenominal) as personnel and payroll, and also a subroutine of more esoteric HR functions, such as seminar and convention management. Logistics applications The beat Logistics applications include jesters most popular modules. Materials Management (MM) Manages stinging fabrics, inventory, and all aspects of goods manufacturing. Production Planning (PP)Offers in advance(p) tools for planning titanic production environments. ecumenic Logistics (LO) Manages logistics for companies that require large-scale deployment of goods and resources. Sales and dispersal (SD) Manages the inventory and distri neverthelession of finished goods. industrial plant Maintenance (PM) Manages the resources required for large manufacturing plants. feel Management (QM) Captures and maintains quality control for manufacturing environments. go steady System (PS) Assists with the scheduling of project tasks and interdependencies amid tasks. visionary is the leading company in a leading software ontogeny and provides usiness with systems and information with reliable, secure, and integrated technologies2.These softwares include brisk Link-to- blackjack oak XI Agile Product Collaboration provides a across-the-board solution to manage bill of material (BOM), item, and engineering change order (ECO) data necessary for product content coaction across the manufacturing supply chain. oracle communication theory for SAP RM-CA Manage SAP RM-CA bus integrates the BRM billing political platform with SAP gross ManagementContract Accounting (SAP RM-CA), a revenue management system that SAP dourers to the telecommunications indus turn up Siebel Connector for SAP R/3 The Siebel Connector for SAP R/3 supports both synchronous and asynchronous transactions across application boundaries. The resulting unity of data provides efficient coordination surrounded by attend and back-office operations. prophet Business Intelligence Applications (BI Apps) are prebuilt BI solutions that deliver intuitive, role- housed intelligence for everyone in an organisation that enable die decisions, actions, and billet adjoines.Based on best practices, these solutions enable organisations to deliver the goods greater insight and value from a range of data s ources and applications including oracle E-Business Suite, PeopleSoft, Siebel, and trey society systems such as SAP. visualize subprogram Management (I/PM), part of the Stellent assets, provides organizations with a scalable solution focused on do work-oriented imaging applications and image-enabling enterprise applications.With I/PM, organizations can quickly integrate their content and processes flat with prophesier and other threesome party enterprise applications, such as EBS, PeopleSoft Enterprise, JD Edwards Enterprise One and JD Edwards World, Microsoft Business Solutions, SAP, Lawson, and Baan. Here are the advantages of these deuce very competitive companies in the industry of enterprise application software reported by Eweek3. Oracle advantages Control of the Oracle data ft Without data, enterprise applications are pocket-sized more than empty containers.As the Oracle data behind platform evolves, it is becoming the data management system for enterprise appli cations. More open environment Oracle has done a make bust job of embracing Web- and Java-based application reading paradigms that are familiar to a broader number of developers. Customers transactionhip management Due to its acquisitions of Siebel and PeopleSoft, Oracle has a deeper knowledge of business processes, compulsive more often than non by front-end CRM ( node kind management) applications. Middleware Oracle isnt that much amend than SAP in this category, but at least Oracle has recognized its helplessness in the middleware area enough to try and acquire BEA. Mid market pathway Oracle has a stronger history in the channel than SAP, and, as such, has a better ability to leverage third-party solution providers in the small and midsize business market. Flexibility Oracle is a little more malleable in its approach to the business processes it go forth support, compared with the more hierarchical SAP prototype. spherical culture Team Orac le maturement teams work together most the humanity with relatively equal levels of autonomy. More third party application Years of working with ISVs on its database have created a stronger Oracle ecosystem. Stronger OEM partnership The Oracle database is a unfavourable piece of enterprise software driveway server sales for Dell and Hewlett-Packard (and reservation the latter companys sales force an auxiliary SAP advantages Legion of consultants A large armys worth of business consultants owe their professional existence to SAP and help keep SAP the market leader. CIO loyalty Many CIOs3 have invested millions of dollars in SAP and have staked their careers on its continue success. character referencenership with IBM IBM is probably one of the largest resellers of SAP software, on top of DB2 databases. Partnership with Microsoft Although SAP has ambitions in the SMB space in which Microsoft sells its avouch applications, a marriage of convenience results in a lot of Microsoft Office-to-SAP enterprise application work. Open source Although SAP would stand at the idea of open-source application software, it provides tons of resources for the development of open-source groundwork softwaremaking more bills available for SAP software. Business Process Integration Years of work in this area have resulted in a depth of expertness that is difficult to replicate. global Footprint SAP has extended its enterprise application customer base around the world. German Engineering Although it is sometimes seen as overly rigid, a reputation for vigilance to detail works in SAPs boilers suit favor. Vertical market penetration Compared with Oracle, SAP has had more time to gain expertise across a broader array of industries. A recent Forrester research paper4 ensnare that Oracle has a strong middleware platform and better support of open standard and as such it is the right choice for customers who aver heavily on custom dev elopment in conjunction with packaged applications. The reporters Wang and Rymer asseverate that companies in the high-tech manufacturing market atom would likely be better off with Oracle while companies in the pharmaceutic and utilities industries would be more likely to lease SAP.In the light of this report my choice surrounded by theses systems ordain be based on the targeted market segment, in other dustup I will select the trafficker that best suit my business activity. So therefore, I will select Oracle enterprise application if my company focuses on high-tech or with heavy reliability on custom development in conjunction with packaged applications. My choice in the other case will be to go for SAP if my business is found in the utilities industries or pharmaceutics. Making these choices will surely enable great customers joy since they provide employees with the best equipments to serve these customers.Question3 hebdomad 4 Lecture summary relating to Data base model s A data base model is a theory or specification describing how a data base is grammatical constructiond and used . several models have been suggested The Hierarchal model is unionised in to a tree like construction aiming to keep data in an organized manner. This structure allows one consanguinity between two types of data i. e the elevate child relationship, the child may have only one parent but the parent can have more childrens. The Network model organizes data using two fundamental records and sets.In other linguistic process the vane model allows a many another(prenominal) to many relationship meaning that the program maintains a current position and navigates fron one record to another by followers relationships in which the record participates records can also be located b supply key values. ( we have seen that most data bases used on man human body and minicomputer are based on the network or the hierarchal model. Relational model 3 key terms are widely used in the relative data base model these are relations , attributes and domain. A relation is theh colum and rows the named colums of the relations are called attributes and the domain is the set of values.The relational model was introduced as a way to make data base management system more autarkical. The structure of the relational model is a table where rows and columns of the tables are related. Database Development Entity modeling Entity relationship diagrams and entity relationship model illustrate the correlation and its disposition between entities. The entities identifies the needs of the business and holds information of it all, with this method the relationship may be one to one or one to many. There are diverse benefits to the entity relationship modeling as it gives a condition picture of the current and requested system data. standardization standardisation is the procedure of removing duplication of data. Normalization is also the process of verifying by making sure th at there are no problems when updating the database and the operations on the various relations will not lead to conflicting and incorrect data. Part 2 Question1 (iii) What is the role of entity-relationship diagram and Normalization in database? Normalization and ERM are useful techniques for data management because normalization is the process of organizing data to minimize duplication, it usally divides a database into two or more tables defining relationships between the tables.The objective of normalization is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then scattering through the rest of the data base via the defined relationships. I. e the customers number is related to its matching customers name and matching customer order. Therefore ERM and Normalization techniques ensure that data is well organized so that when updating some data you face no duplications or error. Data modeling is the process of creating a logical representation of the structure of a data base because it provides a unified view of data which is independent of any model.