Re: Variable tables
From: Mladen Gogala <gogala.mladen_at_bogus.email.invalid>
Date: Mon, 7 Sep 2009 07:00:38 +0000 (UTC)
Message-ID: <h82b2l$3cm$1_at_solani.org>
Na Fri, 04 Sep 2009 17:37:01 -0700, Google Poster napisao:
> > like it could be solved by a database.
>
> You are close, but my problem is not exactly as described. First of all,
> along the years I have made a heavy of investment on Oracle. Not
> necessarily in money terms, but the really valuable resources: time,
> knowledge, access programs, reading this NG :-) etc.
>
> Initially it was not too hard to design simplistic tables and write
> access programs. As time goes by, those schemas need to be more complex,
> and I start having doubts of whether there are other approaches and
> solutions.
>
> I guess I need to hire a real DBA, but can't afford it now...
>
> -GP
Date: Mon, 7 Sep 2009 07:00:38 +0000 (UTC)
Message-ID: <h82b2l$3cm$1_at_solani.org>
Na Fri, 04 Sep 2009 17:37:01 -0700, Google Poster napisao:
> On Sep 4, 6:33 pm, Mladen Gogala <mla..._at_bogus.email.invalid> wrote:
>> On Fri, 04 Sep 2009 04:14:38 -0700, Google Poster wrote: >> > - I am referring to the table structure changing from a millisecond >> > to the next. In a tight loop, the table is seen as having certain >> > structure, and next iteration it is seen as different. That is a >> > technical issue. >> >>> > it. If all you have is a relational theory, then every problem looks
> > Here is how things work: you pick a programming paradigm and then use
> > like it could be solved by a database.
>
> You are close, but my problem is not exactly as described. First of all,
> along the years I have made a heavy of investment on Oracle. Not
> necessarily in money terms, but the really valuable resources: time,
> knowledge, access programs, reading this NG :-) etc.
>
> Initially it was not too hard to design simplistic tables and write
> access programs. As time goes by, those schemas need to be more complex,
> and I start having doubts of whether there are other approaches and
> solutions.
>
> I guess I need to hire a real DBA, but can't afford it now...
>
> -GP
A DBA might not be what you need. An experienced application designer with plenty of experience with Oracle RDBMS sounds more like it. A variability can be achieved by creating an additional object, but I don't pretend to be one of those.
-- http://mgogala.freehostia.comReceived on Mon Sep 07 2009 - 02:00:38 CDT