Post reply

Split single row to 3 tables

  • September 19, 2008 at 8:04 am

    #198259

    Hello,

    I am getting rows like this:

    Name-Date-Time-ValueA-ValueB-ValueC-ValueD-ValueE

    AAA-19Sep08-10:00-1-2-3-4-5

    BBB-19Sep08-10:00-1-2-3-4-5

    AAA-19Sep08-10:05-1-2-3-4-5

    BBB-19Sep08-10:05-1-2-3-4-5

    As can be seen, the column Name and Date is going to be repeated daily. I am planning to go the Master-Child-Grandchild style. So I want to create a table named tblName, tblDate and tblValues. I want to make a link between tblName, tblDate and tblValues. How can i achieve this? I am planning to use ADO.Net.

    Thanks for the replies.

    Senthil

  • October 8, 2008 at 8:57 pm

    #882678

    Senthil,

    Is your question:

    1) How do I set up the data model (tables, fields, relationships) to efficiently store (and retrieve) the incoming data? or

    2) How do I handle the incoming data and distribute it to the tables in the data model? or

    3) Both of the above

    I'm not sure you really need a hierarchical data model, unless there's more to the problem - otherwise, you can just store all the data in a table with Name, Date/Time, and Value fields and avoid all the overhead required to wire up the hierarchy. With some careful index design, you can retrieve the data very quickly.

    As for handling the incoming data, take a look at the "Split" function - that should let you quickly separate the data elements into an array that you can map to the data fields.

    Eric

    [font="Tahoma"]Eric Flamm, Flamm Consulting[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply