Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing scikit model in DB

IronScott-OracleFeb 27 2020 — edited Feb 27 2020

I’m running a scikit model on an Oracle Cloud environment. My final output is a Pipeline object. I need to be able to store this in a DB for a separate Python script to use later. I’ve been able to test the theory using pickle but storing the object on the file system isn’t going to be allowed once the code goes live. I thought a good approach would be to store the object as a blob in an Oracle DB. I can’t seem to find anything that works. The examples I’ve found have cx_Oracle error out with something like Pipeline object not supported.

Is this approach possible? Or some other approach recommended? Or am I just out of luck?

I’d like to be able to do the same thing with dataframe and objects as well, meaning storing objects as objects versus writing data to tables as columns and rows.

Sqlalchemy seems to be the route most people have success with but I don’t have access to it and cannot get it installed.
This post has been answered by Anthony Tuininga-Oracle on Feb 27 2020
Jump to Answer

Comments

Peter Gjelstrup
Answer
1. What is the difference between the below 2 index usage scenarios:
/*+ index(a index_name) parallel(a,4)*/
/*+ parallel_index(a,index_name,4)*/
Are both these same?
No,
First are two hints, one to use index and one to instruct the optimizer to use 4 concurrent servers for a parallel operation

The second is just one hint. it tells optimizer to use 4 concurrent servers on partitioned indexes.
2. What is full index scan and fast full index scan?
Full index scan do single block reads.
Fast full scan do multi block reads.

3. I have a table created in database and it has a few indexes on some columns. How can I check whether the index is Bitmap or B-Tree ?
In user_|all_dba_indexes. Index_type will be BITMAP or NORMAL

Regards
Peter


P.S: Speaking of hints. Bookmark this, can answer most of such questions much better than I can:
http://www.oracle.com/pls/db112/homepage

Edited by: Peter on Mar 26, 2013 1:47 PM
Marked as Answer by AB312062 · Sep 27 2020
AB312062
Thanks Peter !

Can you tell more about the difference in using index and parallel_index. I din't fully understand. If you could explain with some example or provide some link where I can find more information, that would be helpful.

Regards
AB
1 - 2

Post Details

Added on Feb 27 2020
#python
2 comments
1,097 views