1 / 30

As quick as you think!

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

arion
Download Presentation

As quick as you think!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


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

  7. The HARRY Suite Version 7

  8. 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…

  9. HARRYPilotTo structure & display information

  10. HReport,powerful & pertinent presentation

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

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

  13. HARRYDataWEB Interactive reporting, Ad hoc queries,Mutidimensional navigation HARRYNetServer HARRYManager,HAS HARRYDashboard HCube HReport HARRYPilot Dictionary

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

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

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

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

  18. Vector index Selectionbitmap • Index allows: • To create a selection bitmap from a matrix describing each value with addresse for a variable in table • Without file reading 0 1 1000000 000010001000 0 0 0 0000000 000000000000 0 Bitmap creation

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

  20. Nouveau look & feel XP pour la console et le monitoring

  21. Performances: 6.5 M Rec, 315 cols

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

  23. The fashion show room JAVA…!

  24. WEB A alternative new architecture HARRYDataWEB Interactive reporting, Ad hoc queries,Mutidimensional navigation HCube HReport Application (Java) HARRYPilot & Dictionary HARRY JAVA Classes HARRYWorkspace VectorServer Auxiliary processors HARRYVector Oracle XX DB

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

  26. 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'

  27. Cust_IDlist 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 « SQLORACLE:SELECT CUSTID,COUNTLISTWHERE account >= 1500» + return code Workspace HVS ORACLE SELECT CUSTID,COUNTLISTWHERE account >= 1500

  28. Customerlist 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 « CSEL:LIST1 IN Cust_ID Workspace HVS S1 ORACLE Load vector HARRYVectorServer

  29. HARRYSoftware www.harrysoftware.com • Stéphane Coez, R&Dscoez@harrysoftware.com • Paul Landucci, CEOplanducci@harrysoftware.com

More Related