Member Avatar for scope_creep

Hi

This may be one for the gurus, or it could be big standard. Don't know.

I'm looking for some help in designing a database. The problem I have is related to data aging on Oracle instances. I can't find any help on it.

The problem I have is that I've got 3 categories of data, which is new/warm/old. Essentially, new is data which is 1 hour old. Warm is data which is kept for 24 hours, old is kept for 6-8 weeks.

So the data needs to age. I think obviously the mechanics of it, Is that I need to partition the data in 1 hour range perhaps, and have a pl/sql package to run every hour, that moves partitions about from new to old, like a sliding window mechanism.

Thanks for your help.
Bob

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

In this case important question is what are going to do with all those data .

Edited by debasisdas because: typo
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.