Record Retrievals on Millions of records

[jestrada101]

A couple questions:

1) Any got a huge warehouse (365 days with approx 8 million records per day) that have some GUI record retrieval built around it?

2) Is there a method to retrieve records from a binary file loaded into database, if so, is there a way to do even a query into that file?

Thanks for any feedback!

 

[Thargy]

Jestrada,

If you have a table with 365 x 8,000,000 records (which if my mental arithmetic serves is approximately 3 billion records), the kind of GUI you're using is irrelevant. Such a monster table needs some serious partitioning and dividing. The response of any GUI will be governed by the ability of Oracle to get data out of such a huge table. Concentrate on Oracle, and not the GUI.

In the second part of your query, the answer is 'no' and 'no'. The whole point of bfiles is that they are binary images written by a different application, and can only be meaningfully interpreted and manipulated by that application. Oracle can have no knowledge of the internal structure of such files, and therefore cannot query them. If you think about it, how do you know whether or not a binary file contains data which it's possible to query? Cleary one cannot know, ergo, neither can Oracle.

Regards

Tharg

Grinding away at things Oracular