managing test data with optim l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Managing Test Data With Optim PowerPoint Presentation
Download Presentation
Managing Test Data With Optim

Loading in 2 Seconds...

  share
play fullscreen
1 / 23
kimberly

Managing Test Data With Optim - PowerPoint PPT Presentation

159 Views
Download Presentation
Managing Test Data With Optim
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Managing Test Data WithOptim Lauri Pietarinen Relational Consulting SAST-Meeting 20.9.2007 Lauri Pietarinen/Relational Consulting Oy

  2. Agenda • My Background and services • Test material handling dilemma • Optim (formerly Relational Tools) • Overview of functions • Sample scenarios Lauri Pietarinen/Relational Consulting Oy

  3. My Background • Tietokonepalvelu (Pension Insurance) 85-97 • Mainframe development in PLI/DL/I environment • Support department 87-95 • DB2-training etc... • AtBusiness Communications 97-04 • Internet applications • Database design, DW-implementations, Java-programming, Project management etc... • Relational Consulting (own company) 04  • Independent database consultant • Specialising in test data management • Lauri.pietarinen (at) relational-consulting.com Lauri Pietarinen/Relational Consulting Oy

  4. Optim -consulting Test cycle management (data) Test data management Environment setup Installation Consulting Training Lauri Pietarinen/Relational Consulting Oy

  5. Finland Ilmarinen (Insurance) Arek (Insurance) TietoEnator Area (Travel agency) + many others… Sweden BGC Alecta Customers Lauri Pietarinen/Relational Consulting Oy

  6. Status of Test Data • When talking about testing the issues discussed are test cases and testing scenarios • Data and it's management is often conveniently "forgotten" • why? Lauri Pietarinen/Relational Consulting Oy

  7. Two Different Disciplines TESTING DATABASES Lauri Pietarinen/Relational Consulting Oy

  8. Optim • Formerly Relational Tools • Built by Princeton Softech • www.princetonsoftech.com • DB2-version came out in early 90's • Oracle version came out in mid 90's • Additional DBMS support includes SQLServer, DB2/UDB, Informix and Sybase • Represented in the Nordic by Mainsoft International A/S Lauri Pietarinen/Relational Consulting Oy

  9. Optim Users • Used by all z/OS sites in Finland • Ilmarinen, Pohjola, OKO, Nordea, Sampo, Iff, Kela, Comptel, Tapiola etc... • Swedish users include BGC, Alecta, Nordea • Other customers include BT, EBay, etc... • In total over 2000 customers world wide • Has been designed from the start with large volumes in mind Lauri Pietarinen/Relational Consulting Oy

  10. Scenario C4 C4 Production Test Lauri Pietarinen/Relational Consulting Oy

  11. Sample Database CUSTOMERS RCO ORDERS ROD DETAILS ITEMS RID Lauri Pietarinen/Relational Consulting Oy

  12. Sample Values Lauri Pietarinen/Relational Consulting Oy

  13. Specifying the Tables Lauri Pietarinen/Relational Consulting Oy

  14. Controlling the Relationships Lauri Pietarinen/Relational Consulting Oy

  15. Specifying the Key List Lauri Pietarinen/Relational Consulting Oy

  16. Checking the Steps Lauri Pietarinen/Relational Consulting Oy

  17. Report Extract Process Report Request Name (Untitled) Server Name (Local) Extract File c:\rtools\data\mycompanies.xf Access Definition LAURI.MYTEST File Attachments Processed Client User ID k87376 Server User ID k87376 Time Started 2007-09-19 20:37:28 Time Finished 2007-09-19 20:37:28 Elapsed Time 00:00:00 Process Status no errors, no warnings Process Summary: Tables Processed 3 Rows Extracted 15 Rows with Errors 0 First Pass Table Rows 1 Row Details: ExtractedFailedTable Name 1 0 PSTALECTA.dbo.customers 4 0 PSTALECTA.dbo.orders 10 0 PSTALECTA.dbo.details Lauri Pietarinen/Relational Consulting Oy

  18. Extract File Lauri Pietarinen/Relational Consulting Oy

  19. Other Functions • INSERT • Insert data from extract file into target database • CONVERT • Convert data in extract file using functions and/or lookup tables • DELETE • Delete rows that were extracted • COMPARE • Compare two extract files Lauri Pietarinen/Relational Consulting Oy

  20. 5 2 4 1 3 6 Delete Run Program Extract before Extract after Insert original Compare Subsetting Scenario C2 C5 PROGRAM C4 C4 C4 C4 Compare C2 C7 C3 C9 Test database Lauri Pietarinen/Relational Consulting Oy

  21. Extract Regression Test Monday Tuesday Insert Insert Prog V1 Prog V2 Compare Extract Lauri Pietarinen/Relational Consulting Oy

  22. Sample Compare Lauri Pietarinen/Relational Consulting Oy

  23. No Silver Bullet! Lauri Pietarinen/Relational Consulting Oy