...Recap of the BIW – ETL Process The most important part of any Business Information Warehouse (BIW) or Data Warehousing is a process of extraction, transformation and loading of the data from different source systems that are able to provide data which are relevant to a business organization. This data is mainly from its core applications that are used by the business units to execute the enterprise business processes across them. The ETL is also a Strategy about how data from different known source systems can be extracted, transformed and loaded into the BIW or data-warehouse system which then can be used for designing queries, reports and dashboards to enable the business to make decision at different level of the organization (Top Level, Middle Level and Operational Level). (a) extracting data from outside sources, (b) transforming it to fit business needs, and ultimately (c) loading it into the data warehouse Enterprise Data Warehouse (EDW) is mega data mart where all the data from various source systems get consolidated and let the other data marts within other systems use it by pushing the relevant into these data marts through ETL process. So EDW can be a data provider (like any other source system) to various data marts, decision support system applications, data-mining or exploration warehouse applications ETL Concept: Components: (a) (b) (c) (d) Source Systems Data Source (PSA – Persistent Staging Area) Transformation Loading Source Systems can be one or more...
Words: 1990 - Pages: 8
...Virtualization Project Jonathan Sullivan DeVry University’s Keller Graduate School of Management Project Cost & Schedule Control Professor Tony Kapsak March 30, 2014 Contents Refresh Telecom PBX Virtualization Project 3 Executive Summary 3 Project Scope Statement 3 Description 3 Acceptance Criteria 4 Deliverables 4 Exclusions 4 Constraints 5 Assumptions 5 Technical Requirements 5 Work Breakdown Structure (WBS) 5 Cost Estimates 6 Cost Assumptions 7 Refresh Telecom PBX Virtualization Project Executive Summary This project is expected to take six months to complete with an estimated budget of $500,000. Upon completion the consolidated virtual environment will save an estimated $2,900 in monthly operational costs. The virtual environment will allow for a scalability of up to 24 additional virtual PBX servers (total capacity: 32 virtual machines) with no additional hardware costs needed. Valuable datacenter rack space will be conserved through the consolidation. Project Scope Statement Description The PBX Virtualization project will involve taking eight physical in production PBX (Private Branch Exchange) servers and putting them into a redundant virtual environment. The virtual environment will consist of four physical nodes and two redundant iSCSI SAN’s (Storage Servers) each holding a capacity of seven terabytes. The virtual environment will be powered by VMWare’s virtualization software. Acceptance Criteria The project will be...
Words: 821 - Pages: 4
.............................................................................................................. 3 Completed Work ........................................................................................................................ 3 1. Gain clear understanding of Virtual Desktop Infrastructure (VDI) ............................... 3 2. Find out which VDI solution(s) is cost effective for APA .............................................. 5 3. Identify applications that will not function with VDI .................................................... 5 4. Investigate required VDI training ................................................................................. 6 Conclusion ...................................................................................................................................... 7 References ...................................................................................................................................... 7 Executive Summary In 2012, an Information Technology Services (ITS) project was opened to complete a Virtual desktop infrastructure (VDI) proof of concept (POC). The VDI POC project was opened to investigate how VDI...
Words: 2645 - Pages: 11
...As a result, this generated less sales tax revenue. To offset the budget deficit, the California Legislature passed a bill requiring cities to transfer 20% of their gross property tax revenues to the state. The city is looking for ways to save money and one of those areas is technology. It is impossible to eliminate technology such as computers all together because it’s a big part of the city daily operations. One of the potential options is virtualization of city’s physical servers, storage devices, and end user computers would result in significant savings in cost to the city of Seabreeze. Benefits of Virtualization Virtualization is defined as a technology that uses software to run multiple applications and operating systems on one or more physical host servers all at the same time. Within the host server is comprised virtual computers known as VM (Virtual Machines) are running the operating systems and applications similar to a physical PC. VM are setup as virtual servers and virtual desktops. Below is an example how a virtualization server operates. Example of Virtualization Server One of the benefits of virtualization is consolidation of servers since the city has 72 physical servers. The physical servers could be reduced from 72 to 4 host servers due to virtualization. By consolidating the physical servers, it will reduce cost of maintenance, software licenses, and hardware. One example of cost savings, in 2009, Landmark Healthcare had 63 physical...
Words: 2736 - Pages: 11
...systems. Training programs are coordinated with the Training Officer for all personnel. Daily support is provided for basic PC operation, system usage, network management, and database management. The Section works closely with OIT to improve areas of operation which may be lacking, and provides input for future Campus IT initiatives. The current network includes 125+ PCs and 35 printers which all tie into the University backbone. Current projects include TimeTracker, an electronic interface allowing card swipe time to be recorded in both Peoplesoft and the internal Plant work management system EMPAC Echelon Services If you need a flexible, cost-effective cloud for delivering computing power, cloud services from Echelon can be your ideal solution. Let Echelon Synaptic Compute as a Service help you, we are able to build your virtual private cloud in a highly secure network. We’ve designed synaptic compute as a service with Vmware, vCloud, and Datacenter Service for you. Providing quick, secure access to virtual infrastructure, servers and storage; all while reducing cost, delays, and the hassles of adding physical hardware. Echelon offer unlimited computing capacity; allowing you provide and manage the operating system, database and application. To manage your service, choose either Graphical User Interface...
Words: 599 - Pages: 3
...city’s use of information technology. Technology investments cannot simply be eliminated, as they are a critical component of the city’s infrastructure on which key city services rely upon. Therefore it is necessary to identify technologies which can produce a greater return on investment (ROI) through reductions in the total cost of ownership (TCO) of the city’s technology assets. One approach that would meet this need that has been identified is the adoption of server, storage and desktop virtualization technology. These technologies not only represent a significant opportunity for the City of Seabreeze to reduce costs, but it will also enable the city to reduce its greenhouse gas emissions, raise IT staff efficiency, and improve disaster recovery capabilities. 1. Virtualization benefits The term “virtualization” refers to technology that enables a single physical device, such as a server with a large pool of resources (CPU, memory, disk, etc.), to be logically segregated into smaller separate “virtual machines”, or “VMs” that are each given their own subset of resources based on their actual utilization requirements. According to IT-Online (2008) a Gartner white paper found that the average server uses less than 10% of its available computing capacity in a 24 hour period. This trend will continue to grow as advances in the speed of server hardware outpaces the resource requirements of the city’s applications. Without virtualization, whenever there is a need for a new...
Words: 3157 - Pages: 13
...city’s use of information technology. Technology investments cannot simply be eliminated, as they are a critical component of the city’s infrastructure on which key city services rely upon. Therefore it is necessary to identify technologies which can produce a greater return on investment (ROI) through reductions in the total cost of ownership (TCO) of the city’s technology assets. One approach that would meet this need that has been identified is the adoption of server, storage and desktop virtualization technology. These technologies not only represent a significant opportunity for the City of Seabreeze to reduce costs, but it will also enable the city to reduce its greenhouse gas emissions, raise IT staff efficiency, and improve disaster recovery capabilities.! 1. Virtualization benefits The term “virtualization” refers to technology that enables a single physical device, such as a server with a large pool of resources (CPU, memory, disk, etc.), to be logically segregated into smaller separate “virtual machines”, or “VMs” that are each given their own subset of resources based on their actual utilization requirements. According to IT-Online (2008) a Gartner white paper found that the average server uses less than 10% of its available computing capacity in a 24 hour period. This trend will continue to grow...
Words: 3221 - Pages: 13
...Evaluate Virtual Work Software Virtual Desktop Infrastructure Jeanette Johnson Lawrence Technological University MIS 7463 – Virtual Work Environments – Spring 2013 Dr. Anne Kohnke, Assistant Professor of IT, College of Management April 13, 2013 Contents Product Description and Application 3 Major Issues 4 Why the Need for VDI? 4 Is VDI for Everyone? 5 Successful Application of VDI 5 What Exactly Does VDI Offer Organizations? 5 Oracle Virtual Desktop Infrastructure Specifications….at a Glance 7 Reviews 8 What Oral Roberts University has to say about VDI 8 Scripps Networks’ Review of VDI 10 What Small Business Computing Reviewer, Joe Moran, Thinks of VDI 10 Summary and Interpretation of Reviews 11 Implementation 12 VDI Project Plan: Start with Using the Proper Apps and Utilize Pilot Program 13 VDI Licensing: Be Wary about Going for the $40 (or less) per Desktop Guarantee 13 Ensure you Tackle VDI Storage Challenge with Network-Attached Storage (NAS) System and Data Deduplication 14 Factors to Consider When Considering Whether or Not to Implement VDI 15 Conclusion 16 VDI offers Better Support 16 VDI Helps Strengthen Security 16 The BYOD Crowd will Be Happier with VDI 17 Product Description and Application Virtual Desktop Infrastructure (VDI) is simply the practice of hosting desktop operating systems (OS) in a virtual machine (also...
Words: 4825 - Pages: 20
...briefing on two companies that offer Virtual management software to improve process and manage communications and documents in the workplace. Meta Communications (www.metacommunications.com) Meta Communications provides workflow and automation software to improve processes, workflows and communications. They provide service to large corporation around the word like Sony, Staples and Merck. Virtual ticket, Approval manager, Digital Storage Manager and Job Manager are the four products they provide to manage communications and efficiency in the business. Virtual Ticket allows users through out the company to bring together emails, files, project into one location to bring quick easy access to the whole company. It has workflow and scheduling software to track projects with to do list, Gantt charts and customized reports and dashboards. Approval Manager manages files for approval in the workplace. Files are easy uploaded and maintain through the approval process and reviewers can provide feedback. Digital Storage organizes file, emails and documents. It provides easy access with drag and drop capabilities. It allows users to quickly search and access information from anywhere. Job Manager is a financial management tool to manage production. It manages estimates, proposals and expenses along with analyzing productivity. VPMi (www.vcsonline.com) VPMi provides solutions for managing projects, financials and timesheets. They provide...
Words: 377 - Pages: 2
...competitive segment of the electronics industry. Keeping close to customers in this fastmoving business is critical, and this means that Molex has 39 offices, product development sites and manufacturing operations in the Americas region. Its regional business applications are supported from a data center in Lisle, Illinois, where a multi-year server virtualization project is addressing the challenges of fulfilling service requirements, while meeting corporate goals for environmental responsibility. The Molex Americas infrastructure team in Lisle maintains an application server farm and is responsible for specifying and maintaining network equipment and computing systems at 39 separate locations within North and South America. The data center installed a storage area network (SAN) in 2003, and today has several Terabytes of both live and archived data residing on EMC arrays. Emulex host bus adapters (HBAs) were selected as the SAN connectivity solution based on ease of administration, performance and reliability. Virtualization Planning When Molex began planning a server consolidation and virtualization project, evaluation of SAN connectivity requirements was part of the infrastructure team’s due diligence....
Words: 1351 - Pages: 6
...oracle databases in a virtual world and out sourcing the cloud storage. Our current data warehouse is at ten terabytes. This is expected to increase by twenty percent a year therefore this must also be taken into account when searching for a provider of cloud storage. This will save on cost of equipment and also space. This savings of cost and space will be used to hire more technical personnel such as an oracle database administrator and a JavaScript programmer. We currently are running windows 7 but will be upgrading to windows 8 because it is better suited to the virtual world than windows 7. In regards to infrastructure and security, right now we have a basic to average network set up with a DMZ for our clients and intranet with a few firewalls. Not much can be done since we are running a SQL database. This will change when we upgrade to oracle. More security on the network and our client’s information will now be able to be applied. We will also create and maintain a backup center located off site. This center will not be cloud based but an actual server room. We will have to address that privacy issues associated with using a JavaScript method instead of log files to maintain the sites. This is because JavaScript relies on the placing of cookies on a visitor’s computer usually without them knowing. By doing this we are allowing an independent company to store and review that data. The IT department will be responsible for this project with a time line of...
Words: 1621 - Pages: 7
...on the use of IT to provide government services elimination of existing infrastructure is not an option. An alternate solution is essential in order to reduce the total cost of ownership (TCO) of the city’s IT equipment by providing newer technology that will have a higher return on investment (ROI). The option identified to fulfill this need is the adoption of virtualized servers, storage devices, and desktop computers. The conversion to virtualized environments will result in substantial cost savings as well as providing enhanced security, greatly improved disaster recovery, a more competent IT staff, and a smaller carbon footprint. 1. Benefits of Virtualization Virtualization is “the process of creating a virtual, rather than physical, version of something” (Virtualization, 2015). In the IT industry this refers to technology that utilizes software to imitate hardware and create virtual computer systems. One example of this is to use a single physical device such as a server and logically divide up its resources (Processor, memory, and storage) to create smaller , separate “virtual machines” (VM), each with their own tailored set of reserved resources . Most servers in use today are not designed to run more than one operating system (OS) or application at a time. These restrictions typically equate to the need for the deployment of multiple servers for even small data...
Words: 2656 - Pages: 11
...Second International Symposium on Information Science and Engineering Comparison of Several Cloud Computing Platforms Junjie Peng Xuejun Zhang Zhou Lei, Bofeng Zhang, Wu Zhang, Qing Li School of computer science & High performance computing center Shanghai University Shanghai, 200072 P.R. China School of computer science & High Qinghua machinery factory at Changzhi performance computing center Changzhi, 046012 P.R China Shanghai University Shanghai, 200072 P.R. China Abstract—Cloud computing is the development of parallel computing, distributed computing and grid computing. It has been one of the most hot research topics. Now many corporations have involved in the cloud computing related techniques and many cloud computing platforms have been put forward. This is a favorable situation to study and application of cloud computing related techniques. Though interesting, there are also some problems for so many flatforms. For to a novice or user with little knowledge about cloud computing, it is still very hard to make a reasonable choice. What differences are there for different cloud computing platforms and what characteristics and advantages each has? To answer these problems, the characteristics, architectures and applications of several popular cloud computing platforms are analyzed and discussed in detail. From the comparison of these platforms, users can better understand the different cloud platforms and more reasonablely choose what they want. Keywords-cloud computing;...
Words: 3393 - Pages: 14
...Cloud computing promises to increase the velocity with which applications are deployed, increase innovation, and lower costs, all while increasing business agility. Sun takes an inclusive view of cloud computing that allows it to support every facet, including the server, storage, network, and virtualization technology that drives cloud computing environments to the software that runs in virtual appliances that can be used to assemble applications in minimal time. This white paper discusses how cloud computing transforms the way we design, build, and deliver applications, and the architectural considerations that enterprises must make when adopting and using cloud computing technology. This page intentionally left blank. Sun Microsystems, Inc. Table of Contents Introduction................................................................................................... 1 Sun’s perspective ................................................................................................ 1 The Nature of Cloud Computing ....................................................................... 3 Building on established trends............................................................................. 3 Virtual machines as the standard deployment object ........................................ 3 The on-demand, self-service, pay-by-use model ................................................. 4 Services are delivered over the network................................................
Words: 11952 - Pages: 48
... greener IT with less power consumption, better management through central environment control, more availability, reduced project timelines by eliminating hardware procurement, improved disaster recovery capability, more central control of the desktop, and improved outsourcing services. With these benefits, it is no wonder that virtualization has had a meteoric rise to the 2008 Top 10 IT Projects! This white paper presents a brief look at virtualization, its benefits and weaknesses, and today’s “best practices” regarding virtualization. The Association of Information Technology Professionals (AITP) recommends these “best practices” to obtain the benefits that virtualization offers. Copyright 2008, Association of Information Technology Professionals. Permission to copy for personal non-commercial use granted. When the paper is referenced or quoted, direct the reader to www.aitp.org. Special thanks to the following editor: Mike Hinton, Southwestern Illinois College AITP Research and Strategy Advisory Group October 14, 2008 Page 1 of 40 Virtualization and Its Benefits Executive Summary Virtualization has quickly evolved from concept to reality. The technologies that are used for servers, clients, storage, and networks are being virtualized to create flexible and cost effective IT infrastructures. The focus of this paper is the use of virtual technology for data center systems with management best practices. Given today‘s emphasis on Total Cost of Ownership (TCO) and...
Words: 16382 - Pages: 66
