Qpr Software Oyj · OMXHEX:QPR1V
Qpr Software Oyj — Technical Presentation (December 2010)
11 slides from Qpr Software Oyj's technical presentation, December 2010
Slide 1: QPR FactView – Technology & Security
QPR FactView – Technology & Security 1 © QPR Software Plc
Slide 2: QPR FactView Architecture
QPR FactView Architecture 2 © QPR Software Plc
Slide 3: Data
Data Loads data directly from most data sources and formats SQL SQL .xml .xml Loads data from Data Warehouses .qvd .qvd and Data Marts but these are not Web Web required Services Services .txt .txt Extremely fast load times from .xls .xls native QVD file format (up to 4 million records per second) D
Slide 4: Loading Data
Loading Data Loads data from ODBC and OLEDB sources using vendor ODBC ODBC specific drivers OLEDB OLEDB Loads data from any text or table data file (delimited text files, Excel files, XML files, etc.) File File Plug-in model for loading custom Custom Custom data sources (web services) Data Data 4 ©
Slide 5: Load Script
Load Script Editor for writing instructions to retrieve data from one or many data sources Script and table wizards for intuitive script generation Load Load Script Script 100’s of functions for data manipulation and cleansing 5 © QPR Software Plc
Slide 6: In Memory Data Model
In Memory Data Model The data structure which is the analysis basis for every QPR FactView application Holds all data loaded down In In Memory on a transaction level Memory Data Data Model Model Part of the qvw file which is loaded into RAM 6 © QPR Software Plc
Slide 7: Platform Optimizations
Platform Optimizations Optimized to run on every available Windows platform Optimized to make use of all available processing 32-bit 32-bit power for each specific Optimi- Optimi- zation zation platform Optimized to make use of all available RAM on each specific platform 7 © QPR Software Plc
Slide 8: Selection Engine
Selection Engine Processes the user ”point-and-click” and return the associated values to that query Selection Selection Provides sub-second response Engine Engine times on queries made to the In Memory Data Model 8 © QPR Software Plc
Slide 9: Chart & Table Engine
Chart & Table Engine Handles the calculations and graphic display of the charts in the user interface Calculates multiple cubes in Chart Chart & & real time (one cube for Table Table Engine Engine each graph in application) Promotes user selections directly in graphs 9 © QPR Software Plc
Slide 10: Automation API Clients
Clients Installed Windows EXE Windows Windows Client Client client for connecting to QPR FactView Server Automation Automation API Installed Installed EXE EXE ActiveX component for integration in other API ActiveX ActiveX software QPR QPR Plugin (ActiveX) for Ms Collaboration Collaboration Portal Po
Slide 11: Security
Security Security on multiple levels QPR FactView Security in Section Access Module Using Windows File Security 11 © QPR Software Plc
QPR Software — Technical Presentation (December 2010) on 6ix