文本教案讲稿qlikview scalability overview presentation-for sales

1、QlikView Scalability OverviewApril 2011QlikView is a Platform That Scales25X10,000XSingle User:QlikView Local Client (Personal Use License)Small Workgroup:QlikView Local ClientDepartmental:QlikView Local ClientQlikView ServerQlikView PublisherEnterprise:QlikView Local Client Clustered QlikView Serve

2、rsClustered QlikView Publishers10X1XNUMBER OF USERSDEPLOYMENT TYPEIE plug-inAJAXiPadiPhoneAndroidBlackberryQlikView Scales to thousands of users and huge data volumesData from thousands of customers support the fact that QlikViewdeployments can handle many thousands of users and can address huge dat

3、a quantities Large Manufacturer in the US 8000+ usersLarge retailer in the US70+ GB dataCan I ensure that users will have consistent performance as the user population, data or the number of application grows?Can I easily scale up or out my QlikView deployment? Is it linear?How many servers will I n

4、eed to handle the expected # of data and users?How do I test for performance?What are the attributes that factor into the performance and scalability of an application?Common questions from IT Professionals about scaling capabilitiesKey Points about QlikView ScalabilityQlikView scales uniformly with

5、 user loads and data sizesQlikView is no different than other accepted enterprise software applicationsWhen more users and/or data are added, end-user performance scales consistently and proportionallyQlikView end-user performance responds predictably when adding more RAM and CPU capacityQlikView ha

6、s been proven to handle very large data AND thousands of usersBoth horizontal and vertical scaling are possibleScalability Center exists to provide test results and advise on hardware requirementsUniform, consistent performanceData from thousands of implementations support the fact that QlikView sca

7、lesuniformly and predictably as data and users are addedScale up by adding more memoryScaling out by adding more serversAdding extra web servers in the presentation tier creating a QlikView Web Server clusterUse a load balancer on top to balance HTTP/HTTPS traffic to the nodesAdding extra QlikView S

8、ervers in the Application tierCreating QlikView Server cluster or two separate QlikView ServersQlikView Server Scaling TechniquesFour aspects to QlikView ScalabilitySize of DataNumber of UsersNumber of ApplicationsApplication Designlets cover each in turnSize of Data“How much data can QlikView handl

9、e?”There is no exact answer to this general question, however:QlikView has been proven in deployments that handle TB of dataDeployment architectures and application design are critical elements in determining actual hardware requirements for large dataWork with technical consultants for each individ

10、ual projectQlikView easily supports horizontal and vertical scaling needs (i.e. clustering and adding RAM/CPU capacity)Initial RAM calculation for initial hardware sizing exerciseClustering with Large Data Volumes 70GB Large apparel retailer in the US midwest 70GB data 5 qvd files, largest is 60GB 4

11、 clustered QVSs 3x 64CPU cores, 256GB 1x 32 CPU cores, 128GBNumber of (concurrent) Users“Does QlikView scale to handle thousands of users?”Yes:QlikView has many proven deployments that can handle 000s of usersQlikView deployments will scale uniformly with more usersPriority is maintaining end-user p

12、erformanceDeployment architectures and application design are critical elements in determining actual hardware requirements for large dataWork with technical consultants for each individual projectQlikView easily supports horizontal and vertical scaling needs (i.e. clustering and adding RAM/CPU capa

13、city)Examples of large user scaling 8000 usersGiant manufacturer, HQ in the US MidwestTwo master QlikView documents in the 500 MB range (on high compression), loads 500 million rows, 300 columns of data and creates 1,800 user documents through QlikView Publisher during the weekend, with 400 document

14、s run daily, the largest of which is 1.1GB on disk and contains roughly 40MM rows.Number of Applications“Can QlikView scale to handle the growing number of QV applications?”Yes:QlikView has many proven deployments that can handle 000s of applicationsQlikView Server/Publisher designed to handle large

15、 #s of applicationsBest Practices approach to handling large deploymentsQlikView easily supports horizontal and vertical scaling needs (i.e. clustering and adding RAM/CPU capacity)Scaling QlikView applicationsApplication DesignCritical element to determine performance (and scalability) characteristi

16、cs of any QlikView deploymentDiscussion:Like all software applications, there is a good and bad approach to design. QlikView is no differentA poor (i.e. inefficient) data model and/or a poor UI design can cause performance issuesKey reason why there is no exact answer to data size and user volume qu

17、estions upfrontOnce a design has been implemented, QlikView scales uniformly with data and user loadsWhy Application Architecture MattersYou have 800 million rows of data and a total user audience of 500 users. A max concurrency of around 10%, gives you 50 max users at any given time. 1 QlikView app

18、lication has been identified to meet the needs. Scenario:Option #2 is: The same solution Less than half the hardware needed Average 300% improvement in response times for usersWhy Application Architecture MattersMidwest Mfg Client - limited architecture - reactive - struggling to fund scaling Southeast