Results 1 to 12 of 12
  1. #1
    Join Date
    Aug 2007
    Posts
    6

    Unanswered: Datadesign - help request

    HI There,

    Im now working on a assignment where i have hierarchial tree structure arrangement for representing an health care. This is supported by SQL DB 2005.One of the node in the tree is dissolved and all it functionality have to ported to the other tree node which share the similar structure.
    Problem in porting is complex due to the following things

    1. There are capabilities and permission associated with the each node.

    2.each node has a unique identifier across the three (note: though this seems to be of no problem it might become issue when search occurs for eg. a->b->c search now becomes a->b->x->n ->?).

    3.Already there are messages left in the DB.
    Please can anyone help me how can i initiate this migration. Im very new to the design and im just started "ABCD" of it.

    Thanks in advance.

    Cheers,
    Vidhya Rao

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    could you please script the table, i.e. show us the CREATE TABLE statement
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2007
    Posts
    6

    hi

    Hi There,

    Please can you tell me in detail what u require.

    Cheers,
    Vidhya

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    why don't you start with the CREATE TABLE statement

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Aug 2007
    Posts
    6

    hi

    Hello,


    it is not a data design, it is refactoring a database design which has a hierarchial relationship.

    Cheers,
    Vidhya

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    okay, then

    you can start by explaining what you mean by "refactoring"

    and i will ask you for the 3rd time, would you please show us your CREATE TABLE statement so that we can see what kind of a hierarchy you have
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Aug 2007
    Posts
    6
    Hello,

    IF you are available online please do let me know i can send you the DB diagrams. There are many tables and they exhibit strong relationship.
    DB structure is not hierarchial but way the directory which im trying to port is the hierarchical.

    Please provide me your mail id if possible!!1

    Cheers,
    Vidhya

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sorry, i don't provide private support for free!!!111
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Aug 2007
    Posts
    6
    hi yeh,

    Im actually looking for a good mentor to help out i this project.

    Im very new to design and started learning now. If you are really an experieced designer please let me know.

    if you need contact let me know. Im planning to pay for the service.


    Cheers,
    Vidhya

  10. #10
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Did someone fib on their resume, and now they have to pay the piper ?

    Not a fun situation to be in.

  11. #11
    Join Date
    Nov 2005
    Location
    Honolulu HI
    Posts
    119
    you mentioned medical data and hierarchial tree structure...

    are you converting a mumps hierarchial database to a SQL database ?
    .
    .
    http://www.HawaiianHope.org
    Providing Technology services to non profit orgs, Homeless Shelters, Food Pantries, Clean And Sober Houses and more.
    To date we have given away over 900 free computers !
    __________________________
    caeli enarrant gloriam Dei !

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by kropes2001
    are you converting a mumps hierarchial database to a SQL database ?
    * Ouch *
    George
    Home | Blog

Posting Permissions

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