1 / 23

Managing Test Data With Optim

Managing Test Data With Optim. Lauri Pietarinen Relational Consulting. SAST-Meeting 20.9.2007. Agenda. My Background and services Test material handling dilemma Optim (formerly Relational Tools) Overview of functions Sample scenarios. My Background.

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

More Related