RE: OLTP Design - SQL Server

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 26 Jul 2002 04:48:22 -0800
Message-ID: <F001.004A337D.20020726044822@fatcity.com>

Guys,

Having a design debate - probably not the first time in the industry - abstracting the data model into tables where a "SURVEY" can be many types but because the details on each type or so vastly different - basically storing those "QUESTIONS" and "ANSWERS" in a SURVEY_QUEST, SURVEY_ANSWER table. The front-end is ASP. The volume is 5M Question rows total 5 years and the Question rows are rather small. Any thoughts on abstracting the physical data model versus one table each SURVEY DETAIL? The Question/Answer method provides more flexibility.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 26 2002 - 07:48:22 CDT