Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    12

    Unanswered: Multiple database access problem

    Hi ,

    Im developing a web application which would make access to multiple distributive databases. The problem is....the database from all the third parties may have different standard.
    For instance....a user wish to retrive a record from many databases, he input "Pentium 4" .....but some database may have different standard, they may have a record with name "P4" instead of "Pentium 4"....so my question is , how should i make it standard ?? thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Either use translation tables or enforce standard values through the use of foreign keys to static lookup lists.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2003
    Posts
    12
    Great, would appreciate if you could describe more in detail ...thanks a lot

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    A translation table is a table in a central database that contains the datasource, foreignvalue, and commonvalue for all the elements that need to be combined across databases.

    Lookup tables are tables within each database that limit the user's choices to a selection of consistent values.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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