Data Warehouse

In: Computers and Technology

Submitted By reva3088
Words 1489
Pages 6
The purpose of this assignment is to introduce and familiarise students with examples of emerging information technologies and concepts. Assignment 1 consists of two tasks.

TASK 1 (5%) Task 1 is an individual task. In this task, each student is required to conduct research on emergent information technology topics. Students are then required to post at minimum of two topics they have researched on the LeanJCU discussion board. TASK 2 (25%) Task 2 is a group assignment with students working in groups of two or three. Each group will select an emergent technology topic from the posted list from task 1. Each group will then write a report and a presentation on the selected topic. The composition of each group will be confirmed and finalised on Session 2 (Townsville – Saturday, 29/10/07, Cairns – Sunday, 7/10/07). Required for task 2: Task 2 involves a group presentation and a written report on the selected emergent technology topic. Both the presentation and report should highlight today’s capabilities of the selected emergent technology by: • • • • • • Describing the technology, its features and functionality (not technical components); describing how organizations can potentially use the technology to improve business performance; describing how organizations are currently using it; identifying issues and risks managers that should know about; providing a list of additional references or sources for information for anyone who wants to learn more. You might also suggest future developments that affect your technology of choice.

Topics must be confirmed with the lecturer. Preferable, each group of students should present a different topic.

Deliverables: 1. Task 1: Posting of Emergent Technology Topics (5%) Due Date: 2. Townsville…...

Similar Documents

Data Warehouses

...huge amounts of data that is stored in a data warehouse that is used for the company’s employees. The employees will pull data that is needed each day to do their daily tasks. The company handles with several different parts that make up one part. Each part is labeled and has a barcode so that the part can be identified. The system that holds all of the data is basically a data warehouse that when an employee needs certain information about a single part can be retrieved from the data warehouse. The data warehouse is also used to follow the vendors to see how well they are doing. What I mean by see how they are doing is to follow how many good parts they build versus the bad parts that are built and sent to the company. The data that is recorded when a bad part is found leads to an inspection of the parts. When the inspection starts there are required steps that are followed and entered into the database. When this data is entered into the database it can show how many parts that have been inspected and how many were good and how many bad. With this company’s regular database that is being used every day and the data warehouse being used to see how the parts are being handle and how the vendors are doing, there are a lot of variables that are put in place for the company. When the employee needs certain data about a vendor to see what parts they are building then the employee can retrieve this information from the data warehouse. The......

Words: 473 - Pages: 2

Data Warehouses and Data Mining

...Data Warehouses and Data Mining Your Name DBM 384 May 13, 2013 Jim Cervi Data Warehouses and Data Mining Data warehouses serve an integral function within many different industries. In the government and law enforcement agencies this is especially prevalent. Vast amount of data and information from multiple sources is often collected by these agencies. This data and information must be put into a format that allows for workable details by the analysts (, 2012). Data mining and data warehouses provide these agencies with the ability to select specific data out of the large volumes of data available to the analyst Data Warehouse A data warehouse is a database of information collected from several resources, saved under a specific schema, at only one site according to (Siberschatz, Korth, & Sudarshan, 2011). This type of system is effective for government intelligence agencies in storing and categorizing the data sources. By effectively categorizing and storing the data, the data warehouse provides the analyst with a location where an effective query can produce tailored and specific results from vast stores of records. The data warehouse does this by linking the data sources through common threads. These threads are what allow the analyst to access the correct related information through the query. The data warehouse provides the structure of the data sources that the information will be categorized in. To be truly effective, a well-designed......

Words: 575 - Pages: 3

Rei/ Data Warehouse

...Data Warehouse A data warehouse has many different processes that require several different technologies. Batch and transaction processing data has to first be taken out of the operational databases and then it can be cleaned up. Then the data is uploaded onto a relational database. Data warehouses are the basis for customer relationship management systems because they can be used for consolidating customer data and identifying areas of customer satisfaction and frustration. These warehouses can be used for fraud detection, production analysis, profit center, and corporate management. For retailers, a data warehouse can help identify customer demographics, identify shopping patterns, and improve mailing responses. Data Warehouse REI The data warehouse REI is building is going to have many different types of information about its customers. In order to better serve its clientele, REI has to know what their customers do outdoors. With the help from IBM, REI thinks that their data warehouse will help them better identify their individual’s needs and help them better as a company. This will also help them identity what the customers bought online or in the retail stores. The warehouse will also give them insight whether they attended special training for equipment and outdoor activities, or even what items a particular customer has returned. Data Warehouse Concerns There are many issues that are surrounding a data warehouse that companies need......

Words: 665 - Pages: 3

Creating a Data Warehouse

... Creating a Data Warehouse Introduction Data warehouses are the latest buzz in the business world. Not only are they used to store data for reporting and forecasting, but they are part of a decision support system. There are many reasons for creating and using a data warehouse. The data warehouse will support the decisions a business needs to make, usually on a daily basis. The data warehouse collects data, consolidates the data for reporting purposes. Data warehouses are accompanied by analytical tools that accommodate forecasting as part of the decision support system. The purpose of this paper is to explore the creation of a data warehouse. Since the specifics of creating the data warehouse are determined by the database system, this paper will devote its discussion to the design or layout of the data warehouse. Before discussion of the layout of the data ware house proceeds, the basics about a data warehouse need to be discussed. Then the elements of the data ware house will be covered. What is a Data Warehouse? A data warehouse is a warehouse full of data, an electronic warehouse. In a manner of speaking this is true. Don Awalt describes it as follows, “A data warehouse is the cohesive data model that defines the central data repository for an organization. “ He also further stated that “we consider it a complete, integrated data model of the enterprise, regardless of how of where the data is stored.” Thus we can see that the data warehouse collects and......

Words: 3953 - Pages: 16

Data Warehouse can data warehousing, data mining & predictive analytics improve a business. Would it be applicable to all types of business or a particular business only? Information Technology develops rapidly, because changes in these technologies are making the people’s lives easier. There’s a growing need for information in market and the competition of handling information. Some businesses needs to improve their ability and capability to handle big data or information. Data warehousing evolved and plays a big or essential role in the storage, information management and to support strategic reporting and analytics of companies. Businesses are investing to integrate their daily operations to be contained in their data warehouse. Businesses aims for a growth to their competitive advantage compared to other organizations. Some of these competitive advantages includes data warehousing, data mining and predictive analytics to be applied with effective use of Information Technology. Data warehouse is designed to support decision making for leaders or owners of an organization. Data warehouse is truly important for which it gives or share all data by every department of an organization that allows decision making in order to achieve good analysis which will help better the organization’s business situation to improve their current operational processes. Data mining is a process that assists data warehouse to dig and analyze big sets of data and extracting the data. It......

Words: 564 - Pages: 3

Data Warehouse-Rei

...Data Warehouse is an application that collects data information to assist marketing and financial improvements through sales transactions and other dealings. This storage system holds large data files of consumers and other dealings within a company. The data collected from transactions assists companies with making decision that can better serve consumers as well as company reports. This stored information is more reliable because of its day-to- day transactions reports. Utilizing this type of system can be cost effective for storing large information for various companies. Once data is stored, the information is available to anyone, however it cannot be altered (Laudon & Laudon, 2013, p. 160). REI is building a data warehousing system, in order for the organization to have a better method to recognize each consumer’s interactions with the company. Information collected such as purchases and transactions through online, catalogs, stores and websites browsing is stored within the system. This will enhance REI’s customer service by allowing them to track the interest of co-ops, send notifications of recalls for particular items, and make it easier to search or query items up with a specific product number. REI had a vision of being connected with its consumers so they could better serve them. They also wanted to tailor the products to the needs of the consumer, while also being user-friendly. Although the data warehouse is good for business there are various concerns for...

Words: 350 - Pages: 2

Data Warehouse

...understand what is happening from the customer’s perspective will real competitive differentiation take place. Providers must realize that they do not drive the networking and telecom environment; the customers’ strategic and tactical objectives drive it. If service providers wish to position at higher levels in the corporation, they must change the way they communicate. Such communication should not only show an understanding of the enterprise applications themselves but also an understanding of how the applications relate to the service providers’ product set. This paper will outline three (of the many) enterprise applications and business drivers service providers can use to differentiate themselves. We will examine the concepts of data warehousing and data mining for the purpose of effective enterprise resource planning (ERP), customer relationship management (CRM), and supply chain management (SCM). We will define the major aspects of each, examine the drivers and impacts of each, and consider how each relates to the service providers’ product sets. Ah, the good old days… A little over three years ago, I was at an industry tradeshow, attending a one-day tutorial on optical networking. During a break, the woman sitting next to me struck up a conversation, and after the initial pleasantries, I asked her what she did for a living. She told me she was a manager at a venture capital firm. Figuring that she was more interested in financials than the current quantum......

Words: 5142 - Pages: 21

Data Warehouse

...It is common for facilities of an activity center like those in Larry’s Leisure Center to have peak time. When the number of people using a facility exceeds its capacity, there will be peak time. Too many customers using the facility at the same time can ruin activity experience, and the bad experience can lead to customer loss. Therefore, business intelligence can be used to explore the existence of peak time and to find out matching solutions to make customers remain. In this report, the swimming pool and exercise class are taken as examples which are assumed to have peak time. All the numbers in the report are not real and just given as examples to show how to use the data recorded. In the Pool table, each record means one entry into the swimming pool. Each record includes the exact date and time when the person uses the pool. It needs to count how many customers enter the swimming pool every three hours, and then divide the result by the capacity of the facility to calculate the ratio. When the ratio is far beyond one, it indicates this time period is the peak time and solutions are needed to solve the problem. The figure 1 shows the pool usage on a typical Friday and Saturday. Since the pool capacity is assumed to be 150 people, the 18:00 to 21:00 time period on Friday and 18:00 to 21:00 time period on Saturday are peak time. The ratio of the two time periods are 1.47 and 1.42 respectively, which are far beyond one and show too many people are sharing the crowded pool...

Words: 862 - Pages: 4

Data Warehouse

...Double-click the This PC icon on the vWorkstation desktop and navigate to the Security_Strategies folder (Local Disk (C:) > Security_Strategies). Figure 24 Saved scans in the Security_Strategies folder Double-click the first Nmap scan in the folder to open it. If prompted, click Allow Blocked Content to dismiss the popup window. The scan report will open in Internet Explorer. Each host appears as a link in the header of the report. Click the host IP to navigate to the discovery data for that machine. Figure 25 Nmap scan viewed in Internet Explorer Repeat step 2 for each Nmap scan in the folder. In the This PC folder, double-click the yourname_VulnerabilityScan.pdf file to open the file in Adobe Reader. When prompted, click Accept to acknowledge the license agreement. The OpenVAS report includes a report overview and the details for each host. The navigation pane list each host scanned by OpenVAS, the vulnerabilities identified, and log data. Figure 26 OpenVAS vulnerability scan From the navigation pane, click the High vulnerability identified for the host to open that page of the report. Figure 27 High risk vulnerability details Review the summary describing the vulnerability and then review the References section at the bottom of the vulnerability table. Figure 28 CVE references Note: Most of the vulnerabilities identified in the report will include a corresponding CVE......

Words: 1764 - Pages: 8

Data Warehouse

...WHAT IS DATA WAREHOUSE AND WHY IS REI BUILDING ONE? A data warehouse can be described as a “database that stores current and historical data of potential interest to decision makers throughout a company. The data originate in many core operational transaction systems, such as systems for sales, customer accounts, and manufacturing, and may include data from Web site transactions. REI is building a data warehouse to improve the company and to meet the needs of the customers. The data warehouse will allow the company to view current and past data on sales, products, and customer information and also allow for the company to get to know the customers better and help in seeing which products are selling and become closer to the consumer and tailor goods to the needs of the consumer. WHAT ARE SOME OF THE DISADVANTAGES OF CONSUMER COOPERATIVES COMPARED TO TRADITIONAL FIRMS? Consumer cooperatives have some disadvantages in comparison to traditional firms. Consumer cooperatives require a high level of organization. Because the consumers are helping to make many decisions there are more legal responsibilities for the company. The company must listen to the consumers and also provide rules that the consumer cooperative must follow as a whole. While it is great for the consumers to be so involved, traditional firms have less of a hassle and don’t need to take so many extra steps when making decisions. DESCRIBE SOME OF THE MARKETING STRATEGIES THAT REI’S DATA WAREHOUSE WILL......

Words: 314 - Pages: 2

Databases vs Data Warehouses

...DIFFERENCE BETWEEN DATABASE AND DATA WAREHOUSE 1 Database vs Data Warehouse Patricta Eric Doller Prudue University Relation Database Management Systems Bob Estein March 14, 2015 DIFFERENCES BETWEEN DATABASE AND DATA WAREHOUSE Relational database versus a data warehouse Businesses use new technology in many aspect of running everyday duties, like record keeping. To keep these records organized, companies have separate database and data warehouses. A database is used for a single application, mostly for transactions. These transactions can range from payroll, inventory to sales and any other transaction the company needs on a daily bases. A data warehouse is used for multiple domains running simultaneously. A company should use a data warehouse to show how they are doing, in whole, rather than just in certain areas. The warehouse can also track business trends. Companies do not usually do not put all their information into one database because of the possibility of being hacked into easily by a Hacker and used for the wrong intent. Although, it 2 would be cheaper to have just one database the security risks are too high. These problems would lead to dissatisfied customers, lack of business and lawsuits. So how is a data warehouse different from your regular database? After all, both of these are database, and they tend to function the same way. If you look deeper into them, you will find that they both have tables and they contain data. They both have indexes,......

Words: 1271 - Pages: 6

Business Data Warehouse

...diagram, the following: Primary Data Warehouse and Data Mart. In this connection, explain the difference between ROLAP and MOLAP. A Primary Data Warehouse is a central repository of a database of a complete organization. It holds multiple subject areas and very detailed information. A Data Mart is a subset or an aggregation of the data stored to a primary data warehouse. It often holds only one subject area – for example, a specific department, finance or sales. It may hold more summaried data, and is typically smaller than a warehouse because of its employment on a different grain. Figure 1.1 illustrates the difference between data mart and a primary data warehouse. Since the data mart typically holds one subject area, it is much smaller than a primary data warehouse. These data marts can be viewed as small, local data warehouses replicating the part of primary data warehouse which is required by a specific domain or department. Data Warehouse Data Mart Data Warehouse Data Mart Figure 1.1 A data warehouse does not necessarily use a dimensional model, since it is partly normalized RDBMS, but data marts are multidimensional cubes. This connection gives arise to two concepts, ROLAP and MOLAP. ROLAP is an implementation based on a relational database, in our case which is a primary data warehouse, and MOLAP is an implementation based on a multidimensional database which are data marts. ROLAP tools use the relational database to access the data and generate SQL queries......

Words: 685 - Pages: 3

Data Warehouse

...What is a Data Warehouse • A data warehouse is a relational database that is designed for query and analysis. • It usually contains historical data derived from transaction data, but it can include data from other sources. Finance, Marketing, • Data warehouse can be:  Subject Oriented  Integrated  Nonvolatile  Time Variant Inventory SAP, Weblogs, Legacy Identical reports produce same data for different period. daily/monthly/quarterly basis Why Data Warehouse • • • • Provide a consistent information of various cross functional activity. Historical Data. Access, Analyze and Report Information. Augment the Business Processes Why is BI so Important Information Maturity Model Return on Information BI Solution for Everyone BI Framework Business Layer Business goals are met and business value is realized Administration & Operation Layer Business Intelligence and Data Warehousing programs are sustainable Implementation Layer Useful, reliable, and relevant data is used to deliver meaningful, actionable information BI Framework Business Requirements Data Sources Data Sources Data Acquisition, Cleansing,& Integration Data Acquisition, Cleansing, & Integration Data Stores Data Stores Information Services Information Delivery Information Delivery Business Analytics Business Analytics Business Applications Business Applications Business Value Business Value Development Data Resource......

Words: 3637 - Pages: 15

Data Warehouse

...Proposal – Data Warehouse Inventory What is data warehouse? It’s a simple assembling of data gathered from various sources and available to the global customers in a way they can understand to their business level. Statement of Problem: Our intention is to develop inventory application (User interface) so that client can easily track their warehouse. For creating interface we are using ETL and IBM Cognos. Methods to solve problem: * Creating Database for customer * Extract transform and loading the data * Data Mapping * Creating Package from Framework Manager using IBM Cognos * Developing Interface using IBM Cognos Report Studio Tools: IBM DB2, Informatica Power center, IBM Cognos 10.2 Resources: 3 Client: Volvo Trucks. Software Development Life Cycle 1. Requirements 2. Design 3. Development 4. Testing 5. User Signoff Requirements for data warehouse design: A. Goals: 1. To design the flexible data warehouse as per the client requirements. 2. Get the raw data into the centralized repository so that the users can access it in a flexible manner. 3. We should make sure the data cannot be edited by the users. B. Clients Requirements: 1. We need to get all the details of the client products available in their inventory. 2. We need to study the client environment and take down the end to end process. C. Business Questions: 1. Need to discuss about the design duration. 2. Number of resource required for the...

Words: 316 - Pages: 2

Modeling Data Warehouse

...Question: 1. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? Data warehouse projects have many risks. Most of them are also found in other IT projects, but data warehousing risks are more serious because data warehouses are expensive, time-and-resource demanding, large-scale projects. Each risk should be assessed at the inception of the project. When developing a successful data warehouse, it is important to carefully consider various risks and avoid the following issues: • Starting with the wrong sponsorship chain. You need an executive sponsor who has influence over the necessary resources to support and invest in the data warehouse. You also need an executive project driver, someone who has earned the respect of other executives, has a healthy skepticism about technology, and is decisive but flexible. You also need an IS/IT manager to head up the project. • Setting expectations that you cannot meet. You do not want to frustrate executives at the moment of truth. Every data warehousing project has two phases: Phase 1 is the selling phase, in which you internally market the project by selling the benefits to those who have access to needed resources. Phase 2 is the struggle to meet the expectations described in Phase 1. For a mere $1 to $7 million, hopefully, you can deliver. • Engaging in politically naive behavior. Do not simply state that a data warehouse will help managers make better......

Words: 2805 - Pages: 12

MAX Security v1.1.2 APK modded | 127 pc Heat Shrink Wire Wrap Assortment Set Tubing Electrical Connection Cable $5.37 25d left | BBC 39368