Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2012
    Posts
    33

    Unanswered: Distributed database

    Hello,

    I projecting distributed database. I did RMBD but i have doubt. If product is in shop in which we arecurrently - no problem ( seller click "sell" ) but if product is in shop about name "Shop 5" ( e.g in London ) seller click "Order" and application sends information about order for "Shop A". Is good idea create new table WatingOrders for every shop?

  2. #2
    Join Date
    Jan 2013
    Posts
    354
    Provided Answers: 1

    Occam's Razor

    No, "waiting" is an order_status (out of stock, discontinued, on back order, etc). Some orders have longer waiting times than others.

  3. #3
    Join Date
    Aug 2012
    Posts
    33
    Thanks. Which tables best fragmentation if database present shop?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by dexter90 View Post
    Thanks. Which tables best fragmentation if database present shop?
    Explain, please? We need more details.
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    Aug 2012
    Posts
    33
    Thanks for replay. This is my RMBD:

    http://postimage.org/image/w8mqb5lfb/

    First question: This diagram is ok?? ( RMBD for every PC in ditributed database ).

    Edit: Sorry for my english, but I am from Poland :-)
    Last edited by dexter90; 03-11-13 at 15:44.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Spróbuj użyć translatora google.
    Jego bardzo jasne, co jest Twoje pytanie. Nie możemy ocenić schemat jeśli nie wiemy, swoje wymagania.
    If it's not practically useful, then it's practically useless.

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

  7. #7
    Join Date
    Aug 2012
    Posts
    33
    My question: My diagram in post #5 is ok? ( Relational database model )

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Can't answer without knowing more specific requirements.
    You need to ask a more specific question to get a valuable reply.
    If it's not practically useful, then it's practically useless.

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

  9. #9
    Join Date
    Aug 2012
    Posts
    33
    This database is for shop with auto(car) parts. Shop's will be distributed in other location. Enough? :-)

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No.
    You need to ask a specific question.
    "Does my diagram look OK" is not something we can answer.
    If it's not practically useful, then it's practically useless.

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

  11. #11
    Join Date
    Aug 2012
    Posts
    33
    Thanks for replay.

    Between table Products and Stores is relation many - many - It is okay. Now, Clients may have many Orders and one order may have one list products, but one list products may have many Products ( foregin key with table Products_Stores ) it is okay?

Posting Permissions

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