Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!lll-winken!uunet!ncrlnk!ncrwic!cetc!sjohnson From: sjohnson@cetc.Wichita.NCR.COM (Steve Johnson) Newsgroups: comp.databases Subject: Sequencing Test Steps in Oracle Keywords: sequencing ordering Oracle Message-ID: <1016@cetc.Wichita.NCR.COM> Date: 13 Apr 89 19:33:34 GMT References: <1015@cetc.Wichita.NCR.COM> Reply-To: sjohnson@cetc.UUCP (Steve Johnson) Organization: NCR Corporation, Wichita, Kansas Lines: 52 I've got a question that maybe someone has encountered and can give a few insights. I'm using Oracle to develop a relational database system. I have a series of TEST STEPS that need to be performed in sequence. The problem I have is when inserting or deleting a test step to keep the sequencing in order to know what step is to be processed next. To the user I only want to display the TEST STEPS in the order that they are to be performed. 1,2,3,...,N The user must also be able to insert a step and delete a step. Assuming you have an initial TEST STEPS 1,2,3,...,N Step 1 occurs before step 2, 2 before 3, N-1 before N. 4 Possible Sequencing schemas for TEST STEPS.: 1. Adding a step after step 2. 2.1 inserting 2.1 after 2 2. Linking TEST STEPS. 1 --> 2 ----> 3 ... ----> N 1 --> N+1 ---> 2 ---> 3 ... inserting N+1 1 --> N+1 ---> 3 ... deleting 3 3. Creating large increments between step numbers to allow for insertions: step 1, step 100, step 200, ... 4. Resequence all the test steps when inserting/deleting. Is there another sequencing schema? What are the advantages/disadvantages of the methods? What is the 'Best' way to do this? How to do this in Oracle? -- Steve Johnson | Information Systems & Services, NCR-CETC 530-4726 (316)636-4726 | Component Evaluation Technology Center 3450 N. Rock Rd. | Wichita, KS 67226 |