Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2014
    Posts
    2

    Unanswered: Suggestion for database design

    I need suggestion on designing the database.

    My requirement is Processing 2 million records using batch process.

    Table Name: Workarea_tmp
    Request_No:Number
    col1,col2,col3 : BLOB
    Status_Cd: Varchar2(10);

    First Process will insert values for Request_NO, col1 and status as "Start"

    Second Process will update the Col2 with BLOB (PDF DATA)then update the status as "Formatted" ;

    Third Process will update the Col3 with BLOB (PDF) then update the status as
    "Generated" ;

    Then the Col3 value has to be fetched for the given request NO ;

    Update the status as "Completed";

    Once the status is completed the records are no more needed in the table;

    The Completed records has to be archived in another table;

    Can anyone Please suggest me to design the database to process this 2 million records that too with BLOB Datatypes (the size in the column would be 200 to 1000 KB).

    Also please suggest me will it enhance the performance if we delete the "completed" records from the table;

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    design to Third Normal Form

    In a well designed application records that are rarely or never selected, should not have a negative impact on performance (assuming you can avoid Full Table Scans).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •