RE: Question on views

> you mixed a lot of functional information in your question, so
> its difficult to follow the exact 'oracle' question you are asking.

Sorry, but I'm still learning.
>
> if you are using a 'materialized view' you will need to
> refresh the snapshot? this is used if you have
> calculations(like sums, etc...) that you want to pre-compute
> to speed things up and its easy to refresh.

Yes the contractor is using a 'materialized view', I have never heard of that kind
of view, is like a parameterized view with computed columns or what? Is the term 'materialized'
an Oracle specific term?

> see my embedded comments below... and you may want to
> question the 'consultant' about his level of experience. I've
> never heard of anyone using the term 'stale'.
> >
> > From: "Wolfe Stephen S GS-11 6 MDSS/SGSI"
> > <Stephen.Wolfe_at_macdill.af.mil>
> > Date: 2003/08/12 Tue AM 09:39:36 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Question on views
> >
> > I just had a contractor tell me that the problem with my Diabetic
> > detection and Listing 'feature' in their product
> (Integrated Clinical
> > Database, ICDB) is because the
> > 'view' crafted for that detection is going 'stale'.
> >
> << has your logic changed?>>

No, the view should return columns (existing and computed) of static data residing across three tables.

>
> > I admit that most my SQL design experience is in MSSQL's T-SQL
> > although I'm starting to come up to speed on SQL*Plus, anyway, the
> > above explanation provided to be from the TriCare guy seems bogus.
> >
> > Simply put there are four or five good Lab Chemistry parameters one
> > could use in a SQL select statement to determine if a patient is
> > diabetic or a diabetic candidate without having specific ICD9
> > diagnosis coding that declares the patient diabetic.
> >
> > A select statement returns a cursor of data that meets the
> selection
> > criteria and on MSSQL is a static snapshot of what is in
> the database
> > at the time the query was executed. Thus, if a patient had
> parameters
> > that
>
> << same thing happens in Oracle. Oracle uses rollbacks to
> achieve this, SQL Server locks the rows. Has the same effect
> in answering the question>>

Understood.

> > met diabetic conditions stored in the database over the
> past year, how
> > can a view go 'stale'? Is this just a Oracle peculiarity or am I
> > getting a smoke screen as I suspect?
> >
> << In oracle a standard view is a select statement. what is
> the background of this 'consultant'. Is he a vendor specific
> guy or is he an oracle guy?
>
> what does he mean by 'stale'? Its hard to judge what your
> asking. There is too much functional information in your
> question. Since Im not familiar with your system its hard for
> me to follow.

I have never heard of the term 'stale' either ...

I think they are just trying to buy time to fix the problem and I keep bugging them
with the 'how' type of questions.

Thanks, your response has been helpful.

>
> > v/r
> >
> > Stephen S. Wolfe, GS-11, DAFC
> > Data Services Manager
> > stephen.wolfe_at_macdill.af.mil
> > (813) 827-9974 DSN 651-9974
> > --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).