Results: Help with Database Design - Ratebooks 

Voters
1 You may not vote on this poll

  • 1111
    0%
  • 1111
    100.00%
    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Posts
    1
    Rep Power
    0

    Database Design - Ratebooks


    We are undertaking a project where we utilise a quotation system for Contract Hire, Hire Purchase etc.

    In the past we have constructed 'ratebooks' or a table that pre calculates all possible results, ready to be called. Based on a number of variables but including Term of Contract & Mileage driven.

    We present the visitor with a list of items and the appropriate Monthly figure. This is very quick but it relies on the pre-built info.

    We are looking for possible alteratives for a more flexible approach.

    Any ideas?
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    I don't understand how this is a problem. Any modern DBMS can do on-the-fly calculations in a query. So, if you have a formula that you use to populate your static lookup table, just translate that into the SQL query. The output can look identical to the end user, (make the Rates table a VIEW, instead of a static table). Now you don't have to update your Rates table every time you change a parameter.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    On a side note, what's the poll for?

IMN logo majestic logo threadwatch logo seochat tools logo