Stock Exchange Example Database

mokhtar · April 2015

Dear Vertica comunity,

I use vertica 7 and i need to use a Stock Exchange Example Database for demonstration

However on example folder i find just VMart ?

where I can find this database?

thanks on advanced for help,

kind regards,

Adrian_Oprea_1 · April 2015

Hi mokhtar,

Take a look at this link Stock Schema Example.

I hope this was helpfull

mokhtar · May 2015

Hi adrian,

Thanks for respond you have been really helpful,

However after loading the database I dont find it using admintools !!

Thanks on advanced,

kind regards

Adrian_Oprea_1 · May 2015

You are not going to see it ! becouse is not a database is a schema.

Login to you database using vsql and run the command \dn to see your schemas

(dbadmin@:5433) [dbadmin] *> \dn
         List of schemas
     Name     |  Owner  | Comment
--------------+---------+---------
 v_internal   | dbadmin |
 v_catalog    | dbadmin |
 v_monitor    | dbadmin |
 public       | dbadmin |
 TxtIndex     | dbadmin |
 v_demo       | dbadmin |
 store        | dbadmin |
 online_sales | dbadmin |
 dba          | dbadmin |

- using the admintools you will only get information about your database and not your schemas.

Stock Exchange Example Database

Comments

Leave a Comment