Re: untypical problem

"Paul" <paul@xxxxxxxxxxxxxx> wrote in message news:2lfkd1t2if3kg6ml0bolvvji07a96qrkqn@xxxxxxxxxx
>
>
> "John Gilson" <jag@xxxxxxx> wrote:
>
>
> Wow, you sure put a lot of work in for that demo!

I've done a lot of work using SQL to find patterns in time series
stock data for automated trading strategies, e.g., using stock prices,
volumes, etc. It's a similar problem to this and one that's very
interesting but traditional Standard SQL doesn't make easy.

> To the original poster, I'd like to ask, what RDBMS do you use? Some
> (Oracle and PostgreSQL that I know of) natively support Regexps, so
> you wouldn't have to write fancy SQL.

Another suggestion to the original poster would be to look at the
OLAP facilities introduced by SQL:1999 should his DBMS
implement them. I believe Oracle and DB2 do.

> I studied genetics in university - I'd be interested to know what is
> the source of the data - i.e. what's the biological problem that
> you're working on?

Good question, I'd be interested as well. Though I do appeciate
the original poster coming up with a simplified analogous problem.

> Paul...

--
JAG


.

Relevant Pages

  • Re: SQL RPGLE cursor delete from view? -204
    ... Even if you could do the delete from the cursor, you wouldn't want to since as I read your post you simply want to remove a record from the current result set without affecting the actual data. ... a DELETE operation in SQL definitely is the wrong way to do it. ... Your suggestion below about populating a temporary table below, then working with its contents as the result set, possibly would work for the original poster. ... you'll need to do the same thing you'd need to do with RPG....build an actual temporary work file. ...
    (comp.sys.ibm.as400.misc)
  • Re: untypical problem
    ... I've done a lot of work using SQL to find patterns in time series ... stock data for automated trading strategies, e.g., using stock prices, ... > To the original poster, I'd like to ask, what RDBMS do you use? ... I believe Oracle and DB2 do. ...
    (comp.databases)
  • Re: user access to create tables
    ... > Original Poster wrote: ... >>I am very new to oracle and I am trying to give 7 users the ability to ... Could be an intro to SQL course. ...
    (comp.databases.oracle.server)
  • Re: multiple date params
    ... Well there is a certain presumption that the original poster has a ... rudimentary understanding of SQL, given that they apparently know how to use ... > Apostrophes or not, it's malformed SQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)