materials

Report
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
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.
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.
HARRYDataWEB
Interactive reporting,
Ad hoc queries,
HARRYNetServer
Mutidimensional
navigation
HARRY
Manager,
HAS
HARRYDashboard
HReport
HCube
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
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
Active selection
bitmap
VectorServer is
working on partition
and blocks. Block is
the minimum read unit
Block 3
Block 4
As quick as you think!
Etc.
Unit Price
Quantity
Product
Block 2
ID #
1
1
1
0
0
0
Data
Block 1
Date
Partition
bitmap
0
1
0
0
0
1
1
0
1
1
0
1
0
0
0
0
0
0
0
0
0
0
Vector table
…
Vector index
Selection
bitmap
Addresses in
vector table
Code
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!
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
1
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
HARRYDataWEB
Interactive reporting,
WEB
Ad hoc queries,
Mutidimensional navigation
HCube
Application (Java)
HReport
HARRYPilot
& Dictionary
HARRY JAVA Classes
HARRY Workspace
VectorServer
Auxiliary processors
HARRY
Vector
Oracle
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
code
& count
Select the customers who have today receivable
for more than 1,500 Euros
Client
Application
1 – ORACLE Query
HARRY_EXECCust_ID
« SQLORACLE:SELECT
CUSTID,COUNT
+ return
LIST
list
code
WHERE account >= 1500»
ORACLE
SELECT CUSTID,COUNT
LIST
WHERE account >= 1500
As quick as you think!
Workspace
HVS
Example: a two server query
Selected customers
number
Client
Application
Select the customers who have today receivable
for more than 1,500 Euros
2 – Key selection within vector table
Cust_Id
vector
HARRY_EXEC « CSEL:LIST1 IN Cust_ID
Customer
list
S1
Workspace
HVS
ORACLE
Load vector
HARRYVectorServer
As quick as you think!
HARRYSoftware
www.harrysoftware.com
 Stéphane Coez, R&D
[email protected]
 Paul Landucci, CEO
[email protected]
As quick as you think!

similar documents