As quick as you think!

06

Paul Landucci Stéphane Coez

Our Job

Applications deployed through the WEB and Windows

Analysis and reports for developers & expert users

HARRYSoftware, Our Clients

The company asset!

HARRY Foundations

• Designed for business user requirements • Powerful and complete vs. competitors • One single interface to Relational and OLAP environments • Consistent, fast and customized deployment

The HARRY Suite

Version 7

HARRYPilot, Version 7

One single GUI interface to relational, multidimensional and vector DB:

• Accessing ORACLE, ESSBASE, MS-SQL Server, MS OLAP, HARRYVS… from your dictionary • Design parameterized queries, through the same GUI interface and automatisms, • Navigate within OLAP environments, • Transform any query to an application page or broadcast it…

HARRYPilot To structure & display information

HReport, powerful & pertinent presentation

HARRY

DataWEB

• To design the application pages and dynamics, and run it on your Intranet, • To broadcast results and information, • To deploy according to your user domains, groups and profiles.

A 4 step process

•

Step 1: Create your report at the detail level

•

Step 2: Replace pertinent values by parameters

•

Step 3: Insert and design within a WEB application page

•

Step 4: Deploy to the intranet.

HARRY Manager, HAS HCube HARRYDataWEB Interactive reporting, HARRYNetServer HARRYDashboard HReport HARRYPilot Dictionary

HARRYVectorServers

Very fast datamarts: HARRY 2: IBM Z90 HARRY-X: AIX, SUN, HP HARRY-NT: WINDOWS XP & 2003 HARRY-LINUX

Vector Architecture

Adapted to: • Marketing, • Sales, logistics, • WEB logging analysis, • … Any large database dedicated to intensive studies.

The VectorServers many benefits:

• Extremely fast on complex queries, scan, calculations, • Unlimited number of columns or dimensions, • Boolean fields and bitmap indexing, • Dynamical functions and dimensions, – Ranging or intervals – IF(CONDITION;TRUE;FALSE), – Typologies or Segment • ...

Selection: Where and Count

Partition bitmap 1 1 1 0 0 0 VectorServer is working on partition and blocks. Block is the minimum read unit Active selection bitmap 0 1 0 0 0 1 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 Block 1 Block 2 Block 3 Block 4

As quick as you think!

Vector table Data

…

Vector index Code Addresses in vector table

74 5,15,194,2056,… 75 2,3,12,16,17,18,27,… 76 1,8,10,… … Bitmap creation  Index allows:   To create a selection bitmap from a matrix describing each value with addresse for a variable in table Without file reading

As quick as you think!

Selection bitmap 0 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

APL/M conversion

 APL/M Version 10 & 11…   Availability on WINDOWS, UNIX, LINUX

Version 7.1 de HVS, released



Overpasses the 4 Giga Bytes file limit



UNIX, LINUX et WINDOWS files directly compatible As quick as you think!

Nouveau look & feel XP pour la console et le monitoring As quick as you think!

Performances: 6.5 M Rec, 315 cols As quick as you think!

HARRYVectorServer, next…

 64 bit full version  Administration module as a ‘console’  Stored relational views ‘join-like’  Parallelization, multi-processing & clustering     Vector loaded in // on several instances Dispatch one query on several servers Load balancing Dynamical profile session update

As quick as you think!

The fashion show room



JAVA…!

A alternative new architecture

HCube HARRYDataWEB Interactive reporting, Ad hoc queries, Mutidimensional

WEB

navigation

Application (Java)

HReport HARRYPilot & Dictionary

HARRY JAVA Classes HARRY Workspace VectorServer Oracle Auxiliary processors HARRY Vector As quick as you think!

XX DB

The HNS JAVA interface

 To give to developers a total and accurate control on HARRYVS at the appropriate level for their application.

 Access to every command or function and parameters of HARRYVectorServer. Example: HARRY « SEL: FAMILY =702 »  Loads the selection bitmap in WS  Returns the count to application 

Access to every HARRYVectorServer features or facility As quick as you think!

Auxiliary processors

Goals : To create a dynamic link between an external server (Oracle, SQLServer, DB2/U, etc.) and the HARRYVectorServer WS through this server native middleware.

  Runs a query and sends the result to WS.

Notice: Query is only checked by the remote remote server.



Example: SQLORACLE

  Syntax: SQLORACLE:SQL_QUERY Example : SQLORACLE:SELECT NAME,FISRT,SALARY

FROM PERSO WHERE DIV=‘MFG'

As quick as you think!

Example: a two server query Client Application

code & count Select the customers who have today receivable for more than 1,500 Euros 1 – ORACLE Query Cust_ID list + return code

Workspace HVS ORACLE

SELECT CUSTID,COUNT LIST WHERE account >= 1500

As quick as you think!

Example: a two server query

Selected customers number

Client Application

Select the customers who have today receivable 2 – for more than 1,500 Euros Key selection within vector table Cust_Id vector HARRY_EXEC « CSEL:LIST1 IN Cust_ID Customer list

S1 Workspace HVS ORACLE Load vector As quick as you think!

HARRYVectorServer

HARRYSoftware

www.harrysoftware.com

 Stéphane Coez, R&D [email protected]

 Paul Landucci, CEO [email protected]

As quick as you think!