topic Re: ABTs in Oracle in SAS Data Management

ABTs in Oracle

leogaller — Tue, 10 May 2016 20:58:20 GMT

Hi guys!

I´m working on a client where some ABTs are huge, 5Tb for example. Those ABTs are not disponible for users yet, but, our fear is that when they start to access that tables, all the querys start to get too* slow, and even not running or returning error.

My manager asked me if it is possible to move those abts that are in SAS environment to Oracle.

Is it possible? Move the abts to Oracle and continue using the scoring tools that we have?

How can I create a hardware requirement based in the size of the ABTs, quantity of users that will access it simultaneously?

I would love hear your opinions! \o/

SAS 9.4 - Credit Score for Banking

Leonardo Galler

Re: ABTs in Oracle

LinusH — Tue, 10 May 2016 17:34:03 GMT

Technically, definitely possible. But what's the use case?

It won't automatically go faster in Oracle, given that you don't have a large Exadata installation or similar in your wardrobe...

Perhaps you set up a internal project to look at your requirements, analyze the current environment, and evaluate alternatives - perhaps with a proof of concept.

Re: ABTs in Oracle

TomKari — Tue, 10 May 2016 17:48:34 GMT

You are absolutely correct to be concerned about your server slowing to a crawl, although without more information about number of users, typical queries, and server environment no predictions can be made.

Moving the data to a standard Oracle environment is likely to slow things down, if, as is frequently the case, many of your queries will result in full or close to full table scans.

I had some success with a similar environment, but I'd rather not get into discussing other products on this forum. If you'd like to discuss it further, contact me offline.

Tom

Re: ABTs in Oracle

leogaller — Tue, 10 May 2016 21:07:14 GMT

Thanks Tom, I will contact you! Best regards!

Re: ABTs in Oracle

leogaller — Tue, 10 May 2016 21:07:43 GMT

Thanks for your anwser LinusH!