of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Finding overlapping time periods - suggestions please
Also check out
http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-28
.pdf
by Richard Snodgrass.
Henry
-Original Message--
Also check out
http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-28
.pdf
by Richard Snodgrass.
Henry
-Original Message-
Mladen Gogala
Sent: Friday, October 31, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L
Ron, it's not as stupid as you might think. Of c
Mladen,
Unfortunately, the density of your proposed option has warped the space continuum
around us and made this option unusable...
That and the fact I would have to take two years of University Mathematics to fully
comprehend and appreciate the theory, makes this less than optimal in terms of
Title: Finding overlapping time periods - suggestions please
Easy, this should
do it:
Create
a time dimensions--drop table
test_date_dim;create table test_date_dim (time_dt
date
Mladen,
If you suggest a convoluted solution like this takes water when you
have several million rows I fully agree :-). Funny enough, because it
really looks like a purely relational problem, and yet it requires
bending backwards. My feeling (and it definitely would deserve time to
prove) is th
Stephane, my solution was suggested because the client was a telco which was
offering each client billing period of their own choosing (weekly, bi-weekly,
monthly) starting whenever the client wanted. Finding which calls fall in the
certain period was a major hassle. Of course, the solution
> [EMAIL PROTECTED] wrote:
>
> I was wondering if anyone had the need to find overlapping time
> periods and how to identify them efficiently.
>
> Here is the scenario:
>
> Elapsed minutes refer to the actual "clock" time either
> spent on a given task. Thus an activity that
Here's a simple programmatic method (careful, I haven't tested it).
declare
v_activity_count number := 0;
begin
for rec in (
select start_time event_time, 'start' event_type from some_table
union
select end_time event_time, 'end' event_type from some_table order by
1
) l
Title: Finding overlapping time periods - suggestions please
Hi,
I
remember reading a similar problem in 'Joe Celko's SQL Puzzles & Answers'.
The solution he provided was excellent and very innovative, but I can't
recollect the method right now. See if you can fin
Ron, it's not as stupid as you might think. Of course, you can use SQL to find
all overlaping time periods, but for a large number of intervals, it's not
going to be very efficient and it's going to take a very long time. In other
words, it's not practical. Spatial option, on the other hand,
On 2003.10.31 16:14, Govindan K wrote:
volume it consumes?
No. Refer to "Hawking Radiation".
Or Peter Dyer's "Chickenhawk Blues".
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services
>there has to be an "guess work theory" about where the stuff the black hole consumes
>ends up
Part of what is consumed is returned back to the universe in the form of X-Rays.
> and does it have the ability the grow at a rate proportional the the volume it consumes?
No. Refer to "Hawking Radia
Mladen,
The information might be excellent for the "lecture on the Space and
Time Continuum" but a "black hole" will destroy all theories of anything
overlapping when they are on the same plain. Of course there has to be
an "guess work theory" about where the stuff the black hole consumes
ends up,
I have once been asked to suggest the solution for the same problem, and I have
suggested a solution which was out of this world, but completely in line with
my education of a mathematician. The project was scrapped and I didn't have an
opportunity to apply the solution.
To start describing the s
Title: Message
Reformating chart as came out really bad in
e-mail
ActivityStart---End---Elapsed---ElapsedElapsed--Prorated--Prorated
TimeTime--Minutes---Mutlitask--Single---Multi-Minutes
MinutesMinutes--Minutes
1-
Title: Finding overlapping time periods - suggestions please
I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently.
Here is the scenario:
Elapsed minutes refer to the actual “clock” time either spent on a given task. Thus an
16 matches
Mail list logo