Re: Design Issue - Quick response appreciated

Rao ,
Does it mean you want all the transaction in that session .If yes then , Do you keep
session_id somewhere ?
 
-BigP
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A title=Maheswara.Rao_at_Sungardp3.com
  href="mailto:Maheswara.Rao_at_Sungardp3.com">Rao, Maheswara To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Friday, September 21, 2001 9:35   AM
  Subject: Design Issue - Quick response   appreciated   

<SPAN

  class=103311115-21092001>List,
<SPAN

  class=103311115-21092001> 
  OLTP
  application with 24x7 requirement. 300,000 records per day are inserted   into the transaction table. Environment: Solari 7. Oracle   817.
<SPAN

  class=103311115-21092001> 
  The
  transaction table layout.
<SPAN

  class=103311115-21092001> 
<SPAN

  class=103311115-21092001>Security ID 
<SPAN

  class=103311115-21092001><FONT face=Arial color=#0000ff   size=2>Account ID
<SPAN

  class=103311115-21092001>Account Type
<SPAN

  class=103311115-21092001>Trade Date
  And
  other columns in this table.
<SPAN

  class=103311115-21092001> 
  In
  the above table, the primary key is -- Security ID + Account ID + Account Type   + Trade Date
<SPAN

  class=103311115-21092001> 
<SPAN

  class=103311115-21092001>There are many to one   relationships built to other child tables from   Transaction Table
<SPAN

  class=103311115-21092001> 
<SPAN

  class=103311115-21092001>Scenario:
<SPAN

  class=103311115-21092001> 
  User
  inserts a record into transaction table.  In the first record, Account ID   value is "HP" and he might insert a record into the child table (Or this   transaction may not insert a record into a child table). After some time, the   user queries the original record with the primary key and then changes the   value in the column - Account ID to  "IBM".  Now, the original   transaction record is NOT UPDATED.  A record IS INSERTED with the new   values.  Also, he might or might not insert a record into a child table   with this new values of primary key.
<SPAN

  class=103311115-21092001> 
  Now
  the user would query the transaction table with Account ID = IBM.    But, the user wants to get all the previous records also; in this case,   he want to see the record with Account ID = "HP" also. Also, he want to see   the related records from the child tables.
<SPAN

  class=103311115-21092001> 
  I
  tried with the idea of sequence number generation but it was   failing.
<SPAN

  class=103311115-21092001> 
  Any
  ideas or suggestions are much appreciated.
<SPAN

  class=103311115-21092001> 
<SPAN

  class=103311115-21092001>Thanks,
<SPAN

  class=103311115-21092001> 
<SPAN

  class=103311115-21092001>Rao
<SPAN

  class=103311115-21092001>Maheswara Rao,
<SPAN

  class=103311115-21092001>Oracle DBA
<SPAN

  class=103311115-21092001>SunGard
Securities  Received on Fri Sep 21 2001 - 13:08:38 CDT