[jira] [Commented] (HIVE-14870) OracleStore: RawStore implementation optimized for Oracle

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-14870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15537157#comment-15537157 ] 

Sergey Shelukhin commented on HIVE-14870:
-----------------------------------------

Hmm.. is there significant obstacle to making it work on other RDBMS-es, or if Oracle-specific things are critical to perf, at least isolating them into a plugin of some sort? ACID implementation already uses DN-less SQL for all operations and works on all RDBMS-es.
I am afraid having a separate store potentially for each database, and another arbitration layer in RawStore, will make it even more unmanageable than it already is.
If it's not DB specific, we can ditch ORM altogether.

> OracleStore: RawStore implementation optimized for Oracle
> ---------------------------------------------------------
>
>                 Key: HIVE-14870
>                 URL: https://issues.apache.org/jira/browse/HIVE-14870
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore
>            Reporter: Chris Drome
>            Assignee: Chris Drome
>         Attachments: OracleStoreDesignProposal.pdf
>
>
> The attached document is a proposal for a RawStore implementation which is optimized for Oracle and replaces DataNucleus. The document outlines schema changes, OracleStore implementation details, and performance tests against ObjectStore, ObjectStore+DirectSQL, and OracleStore.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)