Post reply

Universal table schema

  • October 9, 2011 at 12:26 pm

    #246270

    HI

    I want to design universal schema in database where any end user can dump any type of data into database coming from any type of source for e.g. excel, csv or any table.

    Any ideas will be highly appreciated.

  • October 9, 2011 at 1:35 pm

    #1392212

    Can you explain a bit more about what you want to acheive?

  • October 9, 2011 at 6:50 pm

    #1392243

    meghna.bhargav (10/9/2011)

    HI

    I want to design universal schema in database where any end user can dump any type of data into database coming from any type of source for e.g. excel, csv or any table.

    Any ideas will be highly appreciated.

    That type of table is known by many names... OTLT (One True Lookup Table), EAV (Entity, Attribute, Value), User-Definable Table, performance problem, maintenance nightmare, Death by SQL, and several other flattering terms. 😀 I'd strongly recommend against such a thing but now you know what they're called if you want to Google for some suggestions. Make sure you read the parts as to why this is such a terrible idea.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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