What Is a Data Warehouse

Question 1 What is a data warehouse? What problems does it solve for a business? A data warehouse is a place where data is stored for archival purpose, analysis purpose.

Usually a data warehouse is either a single computer or many computers servers tied together to create one giant computer systems. Data warehouse solve a lot of problems to companies as it helps to structure files and avoid unnecessary duplication of data.Data warehouse also allows to easily updating data and encourages management to regard data as a resource that must be properly managed just as any other resources. Question1B What do you see as the benefits of using a web-like browser to access information from a data warehouse? The benefits of using a web browser to access information from a data warehouse is that it allows users to have access to different search engines and opens up different links with the relevance key search. Some results will be more complete than others as they have different ways of indexing websites.Using a web browser to access information from a data warehouse is also useful as the links give you access to images and videos which interact users but can also slow down the logon level of speed operations meaning that the data warehouse is accessed at a fast speed. Question2 The SAP system is a collection of software that performs standard business functions for corporations.

Here are some applications developed by SAP for consumers use, they are regrouped into categories of utilities[1]. Financials applications The SAP Financials applications contain all of the functionality needed for enterprise-wide financial management. These include: Financial Accounting (FI), Provides a complete financial accounting solution, including income statements, balance sheets, journals, ledgers, and all areas of financial accounting. • Enterprise Controlling (EC): Assists in controller tasks. • Capital Investment Management (IM): Assists finance organizations in their capital investments and tracking. • Controlling (CO): Assists the controller organization. • Treasury (TR): Assists with transactions related to the U.

S. Treasury. Human Resources applications • Personnel Administration (PA): Assists with all areas of personnel administration, including applicant tracking and personnel history. Personnel Development (PD): Assists with training and educational status of employees. These systems handle all of the mundane HR tasks, such as personnel and payroll, and also a number of more esoteric HR functions, such as seminar and convention management. Logistics applications The SAP Logistics applications include SAP’s most popular modules. • Materials Management (MM): Manages raw materials, inventory, and all aspects of goods manufacturing.

• Production Planning (PP):Offers sophisticated tools for planning large production environments. General Logistics (LO): Manages logistics for companies that require large-scale deployment of goods and resources. • Sales and Distribution (SD): Manages the inventory and distribution of finished goods. • Plant Maintenance (PM): Manages the resources required for large manufacturing plants. • Quality Management (QM): Captures and maintains quality control for manufacturing environments. • Project System (PS): Assists with the scheduling of project tasks and interdependencies between tasks. ;; Oracle is the leading company in a leading software development and provides usiness with systems and information with reliable, secure, and integrated technologies[2].

These software’s include: • Agile Link-to-SAP XI: Agile Product Collaboration provides a comprehensive solution to manage bill of material (BOM), item, and engineering change order (ECO) data necessary for product content collaboration across the manufacturing supply chain. • Oracle Communications for SAP RM-CA Manage: SAP RM-CA Manager integrates the BRM billing platform with SAP Revenue Management–Contract Accounting (SAP RM-CA), a revenue management system that SAP offers to the telecommunications industry Siebel Connector for SAP R/3: The Siebel Connector for SAP R/3 supports both synchronous and asynchronous transactions across application boundaries. The resulting consistency of data provides efficient coordination between front and back-office operations. • Oracle Business Intelligence Applications (BI Apps) are prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organisation that enable better decisions, actions, and business processes.Based on best practices, these solutions enable organisations to gain greater insight and value from a range of data sources and applications including Oracle E-Business Suite, PeopleSoft, Siebel, and third party systems such as SAP. • Imaging ; Process Management (I/PM), part of the Stellent assets, provides organizations with a scalable solution focused on process-oriented imaging applications and image-enabling enterprise applications.With I/PM, organizations can quickly integrate their content and processes directly with Oracle and other third 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 two very competitive companies in the industry of enterprise application software reported by Eweek[3]. Oracle advantages |Control of the Oracle database | |Without data, enterprise applications are little more than empty containers.As the Oracle database platform evolves, it is | |becoming the data management system for enterprise applications. | | | |More open environment | |Oracle has done a better job of embracing Web- and Java-based application development paradigms that are familiar to a broader| |number of developers. | | |Customers relationship management | |Due to its acquisitions of Siebel and PeopleSoft, Oracle has a deeper knowledge of business processes, driven more often than | |not by front-end CRM (customer relationship management) applications. | | | |Middleware | |Oracle isnt that much better than SAP in this category, but at least Oracle has recognized its weakness in the middleware area| |enough to try and acquire BEA. | | |Mid market channel | |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 flexible in its approach to the business processes it will support, compared with the more | |hierarchical SAP model. | | |Global development Team | |Oracle development teams work together around the globe 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 critical piece of enterprise software driving server sales for Dell and Hewlett-Packard (and making | |the latter companys sales force an extension | SAP advantages Legion of consultants | |A large army’s worth of business consultants owe their professional existence to SAP and help keep SAP the market leader. | | | |CIO loyalty | |Many CIO’s3 have invested millions of dollars in SAP and have staked their careers on its continued success. | | |Partnership 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 own applications, a marriage of convenience results | |in a lot of Microsoft Office-to-SAP enterprise application work.

| | |Open source | |Although SAP would balk at the idea of open-source application software, it provides tons of resources for the development of | |open-source infrastructure software—making more money available for SAP software. | | |Business Process Integration | |Years of work in this area have resulted in a depth of expertise 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 attention to detail works in SAPs overall 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 paper[4] found that Oracle has a strong middleware platform and better support of open standard and as such it is the right choice for customers who rely heavily on custom development in conjunction with packaged applications. The reporters Wang and Rymer asserted that companies in the high-tech manufacturing market segment would likely be better off with Oracle while companies in the pharmaceutical and utilities industries would be more likely to choose SAP.

In the light of this report my choice between theses systems will be based on the targeted market segment, in other words I will select the vendor 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 satisfaction since they provide employees with the best equipments to serve these customers.Question3 Week 4 Lecture summary relating to: Data base models A data base model is a theory or specification describing how a data base is structured and used . several models have been suggested: The Hierarchal model is organized in to a tree like structure aiming to keep data in an organized manner. This structure allows one relationship between two types of data i.

e the parent child relationship, the child may have only one parent but the parent can have many children’s. The Network model organizes data using two fundamental records and sets.In other words the network model allows a many to many relationship meaning that the program maintains a current position and navigates fron one record to another by following relationships in which the record participates records can also be located b supplying key values. ( we have seen that most data bases used on man frame and minicomputer are based on the network or the hierarchal model. Relational model 3 key terms are widely used in the relational 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 independent.

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 nature 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 specified picture of the current and requested system data.Normalization Normalization is the procedure of removing duplication of data. Normalization is also the process of verifying by making sure that 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 spread 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.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyStudyWriters
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Customer 452591, March 18th, 2021
Business and administrative studies
Customer 452773, February 23rd, 2023
Business and administrative studies
Thank you
Customer 452773, March 19th, 2023
Business and administrative studies
Excellent work ,always done early
Customer 452773, February 21st, 2023
I just need some minor alterations. Thanks.
Customer 452547, February 10th, 2021
Don't really see any of sources I provided, but elsewise its great, thank you!
Customer 452697, May 8th, 2021
Great job
Customer 452773, February 13th, 2023
thank you so much
Customer 452749, June 10th, 2021
Business and administrative studies
excellent job
Customer 452773, March 12th, 2023
Criminal Justice
The paper was not accused of plagiarism and was written very well. I will let you know the grade once it is graded. Thank you
Customer 452671, April 26th, 2021
Business and administrative studies
Thank you for your hard work and help
Customer 452773, February 21st, 2023
Business and administrative studies
excellent work
Customer 452773, March 9th, 2023
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes



eskişehir eskort



eskişehir eskort

Live ChatWhatsApp