Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: Opinions of high-volume DDL and data population

RE: Re: Opinions of high-volume DDL and data population

From: Mark Richard <mrichard_at_transurban.com.au>
Date: Mon, 16 Jun 2003 15:46:16 -0700
Message-ID: <F001.005B274D.20030616152436@fatcity.com>


Raj,

Thanks, however adding the attribute to this table is the correct thing to do - it's a historical table to supply "show me something as at x date/time for the particular record". Basically when originally created (years before my time) someone assumed that a record would never be updated more often than once per second - they were wrong. So, whilst the timestamp doesn't create uniqueness we will add a version attribute (which already exists and is maintained on the primary table).

Regards,

      Mark.

                                                                                       
                                                
                      "Jamadagni,                                                      
                                                
                      Rajendra"                 To:       Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>                  
                      <Rajendra.Jamadagn        cc:                                    
                                                
                      [EMAIL PROTECTED]>               Subject:  RE: Re: Opinions of 
high-volume DDL and data population                      
                      Sent by:                                                         
                                                
                      [EMAIL PROTECTED]                                                
                                               
                      com                                                              
                                                
                                                                                       
                                                
                                                                                       
                                                
                      17/06/2003 01:29                                                 
                                                
                      Please respond to                                                
                                                
                      ORACLE-L                                                         
                                                
                                                                                       
                                                
                                                                                       
                                                




... now from an entirely different angle ...

Mark,

It just _might_ be better if you create a separate table to store the pk from your students table and the total_attendance column. Why? Not only this column adding will be complicated, but maintaining this column in the same table would be very mutating-table-problem-friendly.

If you make it in a separate table (with PK from the original table), you can just create a trigger in the main table to maintain that value as well. Not to mention that this will be less of a problem in the future.

Raj


Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! (See attached file: ESPN_Disclaimer.txt)

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

   Privileged/Confidential information may be contained in this message.

          If you are not the addressee indicated in this message
       (or responsible for delivery of the message to such person),
            you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
           by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
                Internet e-mail for messages of this kind.
        Opinions, conclusions and other information in this message
              that do not relate to the official business of
                         Transurban City Link Ltd
         shall be understood as neither given nor endorsed by it.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


ESPN_Disclaimer.txt
Description: Binary data


Received on Mon Jun 16 2003 - 17:46:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US