Diapositive 1

1
As quick as you think!
06
Paul Landucci Stéphane Coez
2
Our Job
3
Applications deployed through the WEB and Windows
4
Analysis and reports for developers expert
users
5
HARRYSoftware,Our Clients

• The company asset!

6
(No Transcript)
7
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

8
The HARRY Suite

• Version 7

9
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

10
HARRYPilotTo structure display information
11
HReport,powerful pertinent presentation
12
HARRYDataWEB

• 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.

13
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.

14
HARRYDataWEB Interactive reporting, Ad hoc
queries,Mutidimensional navigation
HARRYNetServer
HARRYManager,HAS
HARRYDashboard
HReport
HCube
HARRYPilot
Dictionary
15
HARRYVectorServers

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

16
Vector Architecture

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

17
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(CONDITIONTRUEFALSE),
• Typologies or Segment
• ...

18
Selection Where and Count
Active selectionbitmap
Vector table
0 1 0001101 101000000000 0
Data
Block 1
Partition bitmap
Product
1 1 1000
Etc.
ID
Unit Price
Date
Quantity
Block 2

Block 3
Block 4
VectorServer is working on partitionand blocks.
Block is the minimum read unit
19
Vector index
Selectionbitmap
0 1 1000000 000010001000 0
0 0 0000000 000000000000 0
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

20
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

21
Nouveau look feel XP pour la console et le
monitoring
22
Performances 6.5 M Rec, 315 cols
23
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
•  

24
The fashion show room

• JAVA!

25
A alternative new architecture
HARRYDataWEB Interactive reporting, Ad hoc
queries,Mutidimensional navigation
HReport
HCube
Application (Java)
HARRYPilot Dictionary
HARRY JAVA Classes
HARRY Workspace VectorServer
Auxiliary processors
HARRYVector
Oracle
XX DB
26
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
   SELFAMILY702 
• Loads the selection bitmap in WS
• Returns the count to application
• Access to every HARRYVectorServer features or
  facility

27
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 SQLORACLESQL_QUERY
• Example SQLORACLESELECT NAME,FISRT,SALARY F
  ROM PERSO WHERE DIVMFG'

28
Example a two server query
Select the customers who have today receivable
for more than 1,500 Euros
code count
Client Application
1 ORACLE Query
HARRY_EXEC  SQLORACLESELECT CUSTID,COUNTLISTWH
ERE account gt 1500
return code
Workspace HVS
ORACLE
SELECT CUSTID,COUNTLISTWHERE account gt 1500
29
Example a two server query
Select the customers who have today receivable
for more than 1,500 Euros
Selected customers number
2 Key selection within vector table
ClientApplication
Cust_Id vector
HARRY_EXEC  CSELLIST1 IN Cust_ID
Workspace HVS
S1
ORACLE
Load vector
HARRYVectorServer
30
HARRYSoftware

• www.harrysoftware.com
• Stéphane Coez, RDscoez_at_harrysoftware.com
• Paul Landucci, CEOplanducci_at_harrysoftware.com