hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Hive 2 database Entity-Relationship Diagram
Date Thu, 19 May 2016 17:03:49 GMT
Attachement

Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 19 May 2016 at 18:02, Mich Talebzadeh <mich.talebzadeh@gmail.com> wrote:

> Hi All,
>
> I use Hive 2 with metastore created for Oracle Database with
> hive-txn-schema-2.0.0.oracle.sql.
>
> It already includes concurrency stuff added into metastore
>
> The RDBMS is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
>
>  I created an Entity-Relationship (ER) diagram from the physical model.
> There are 194 tables, 127 views and 38 relationships. The relationship
> notation is Bachman
> <https://www.google.co.uk/search?q=bachman+notation&biw=1920&bih=883&tbm=isch&tbo=u&source=univ&sa=X&sqi=2&ved=0ahUKEwjUx4e2zebMAhVMBsAKHTvOAcwQsAQILQ&dpr=1>
>
> Fairly big diagram in PDF format. However, you can zoom into it.
>
>
> Please have a kook and appreciate comments to me and if it is useful we
> can load it into wiki.
>
>
> HTH
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>

Mime
View raw message