About Data Warehousing (part 2.1) When participating in the ETL efforts associat
ID: 3716595 • Letter: A
Question
About Data Warehousing (part 2.1)
When participating in the ETL efforts associated with Data Warehouse System development, a typical step is to develop the Logical Data Map. What is a Logical Data Map, and list the steps involved in the creation of a Logical Data Map.
List just five of the many Critical Success Factors that are associated with a Data Warehouse Project.
When a typical Data Warehouse System is launched into Production, there are four types of users that are normally associated with it. List the four types of users.
During a Data Warehousing Project, list the high level activities that would take place during the Deployment Phase.
During a Data Warehousing Project, list the high level activities that would take place during the Construction Phase.
During a Data Warehousing Project, list the high level activities that would take place during the Design Phase.
What is Force Field Analysis diagram? Give an example in which you might use a Force Field Analysis diagram.
What is Use Case Analysis? What is a Use Case Analysis Diagram? Give an Example of why you would use a Use Case Analysis process during system development. What is an Alistair Cockburn Template?
List four Data Modeling considerations when design a Data Warehouse.
When participating in the ETL efforts associated with Data Warehouse System development, a typical step is to develop the Logical Data Map. What is a Logical Data Map, and list the steps involved in the creation of a Logical Data Map.
List just five of the many Critical Success Factors that are associated with a Data Warehouse Project.
When a typical Data Warehouse System is launched into Production, there are four types of users that are normally associated with it. List the four types of users.
During a Data Warehousing Project, list the high level activities that would take place during the Deployment Phase.
During a Data Warehousing Project, list the high level activities that would take place during the Construction Phase.
During a Data Warehousing Project, list the high level activities that would take place during the Design Phase.
What is Force Field Analysis diagram? Give an example in which you might use a Force Field Analysis diagram.
What is Use Case Analysis? What is a Use Case Analysis Diagram? Give an Example of why you would use a Use Case Analysis process during system development. What is an Alistair Cockburn Template?
List four Data Modeling considerations when design a Data Warehouse.
Explanation / Answer
Cloud Computing Deployment Models:-
1. PUBLIC CLOUD : Features--> Reasonable level of Security, easy to implement, low operational cost.
2. PRIVATE CLOUD: Features--> Maximum level of reliability and scalability, users get both computational resources and network access.
3.HYBRID CLOUD: Features:--> Manage the vulnerabilities found in critical data applications.
Security Issues and Threat :
Data Breach: It might be targeted attack,application vulnerabilities,poor security practices.
Insecure Interfaces and APIs : Provisioning management and monitoring are done with these interfaces and security and availability of cloud services depend on the security of APIs. So these should be designed well to protect against malicious attempts.
System vulnerabilities: Vulnerabilities within the components of OS(Operating System) put the services and all data at risk.
Account hijacking : Attackers can misuse the user's information by hacking him.
Data Loss: Data can be lost for reasons other than malicious attacks. Data deletion by cloud service provider, a physical catastrophe like earthquake can lead to loss of data.
PaaS : It targets towards the developer as it allows them to build applications and services over the internet.
It is hosted over the cloud, and their users can access it through a web browser. The highlight of PaaS is that it can support the entire web app development cycle, right from building and testing to final deploying, managing and updating. Businesses can requisition resources for scaling as their demand grows, so they don’t have to invest in hardware anymore.
Example: Windows Azure,
SaaS : Software as a Service (SaaS) is perhaps the most commonly used cloud deployment model.
The vendors themselves manage the service, including applications, data, middleware, runtime, server, storage, virtualization, networking and even the Operating systems.
Examples: Google Apps
IaaS:
Infrastructure as a Service or Cloud Infrastructure is a self-service codes that aims to manage and monitor remote datacenter infrastructure for the following functions: compute, storage and networking.
The cloud service provider delivers the infrastructure while the clients get to decide on the operating system of their choice. They scale and spin virtual machines of their choice.
Example: Google Compute Engine.
DRaaS: Disaster recovery as a service (DRaaS) is a cloud computing and backup service model that uses cloud resources to protect applications and data from disruption caused by disaster. It gives an organization a total system backup that allows for business continuity in the event of system failure.
Economic Benefits Of Cloud Computing:
1: Elimination of CAPEX and improvements in agility: migrating to the cloud eliminates CAPEX and replaces these major up-front costs with predictable and manageable OPEX. This transition is crucial as it lowers the risk associated with strategic IT projects, so keeping business agile by allowing for more experimentation and entrepreneurship.
2: Scale as Needed – As your applications grow, you can add storage, RAM and CPU capacity as needed.
3: Resiliency and Redundancy – One of the benefits of a private cloud deployment is that you can get automatic failover between hardware platforms and disaster recovery services to bring up your server set in a separate data center should your primary data center experience an outage.
4: Lower Maintenance Costs driven by 2 factors: Less hardware and outsourced, shared IT staff. Because cloud computing uses fewer physical resources, there is less hardware to power and maintain. With an outsourced cloud, you don’t need to keep server, storage, network, and virtualization experts on staff full time.
5:Lower Costs – Cloud computing pools all of the computing resources that can be distributed to applications as needed – optimizing the use of the sum of the computing resources and delivering better efficiency and utilization of the entire shared infrastructure.
Cloud Computing Definition: Cloud computing is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction. This cloud model is composed of five essential characteristics, three service models, and four deployment models.
Enabling Technologies that have given rise to Cloud Computing:
1: Service Oriented Architecture (SOA) and Web Services SOA provides a general model for services interaction. It was invented to allow systems to interact with each other via services, even if the underlying implementations are very different. For example, the SOA interfaces in a system built on top of Microsoft .NET expose identical interface mechanisms and semantics as for example a J2EE implementation
2: Web Services Architecture and Main Actors In Web Services there are three main actors –a Service Consumer (seeking to use a service), a Service Registry (which will help the Service Consumer find a fulfilling Service), and a Service Provider, who has the service which the Service Consumer wants.
3: SOAP and Web Services Web Services can be implemented with a variety of service description languages and with a variety of communications protocols and conventions. The standards for Web Services call for specific implementations of this things.
Web Services Description Language (WSDL) provides platform independent description of services functionality. ? SOAP (Simple Object Access Protocol) is an XML protocol for Web Services. ? SOAP Message structure contains Message Header and Message Body
4: Representative State Transfer (REST) protocol REST is an Alternative for SOAP in Web Services. REST describes a set of architectural principles by which data can be transmitted over a standardized interface (such as HTTP). REST does not contain an additional messaging layer and focuses on design rules for creating stateless services.
5: Cloud Properties Enabled by Virtualization Virtualization is the catalytic element which enables much of breakthroughs attributed to Cloud Computing, In the following slides we are going to to speak about Cloud Properties Enabled by Virtualization ? Scalability--Virtual machine system automatic scale up ? Availability --Fault tolerant of hardware and software ? Manageability--Automatic physical to virtual system transformation ? Performance--Dynamically virtual machine level load balancing
Characteristics of Cloud Computing:
Critical Success Factors related to the evaluation of a Data Warehouse Project.
Sponsorship and Involovement.
Enterprise Architecture
Datawarehouse Technology