Difference between revisions of "Template:SQWareRepositoryPresSgbd"
Expdbtools (talk | contribs) (→Presentation) |
Expdbtools (talk | contribs) (→Presentation) |
||
| Line 1: | Line 1: | ||
== Presentation == | == Presentation == | ||
It is the repository module, and stores rdbms indicators for {{{1}}}.<br> | It is the repository module, and stores rdbms indicators for {{{1}}}.<br> | ||
| − | It's a {{{1}}} {{{2}}}. It is currently the only type of supported RDBMS for | + | It's a {{{1}}} {{{2}}}. It is currently the only type of supported RDBMS for dbSQWare® repository for {{{1}}}.<br> |
Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.<br> | Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.<br> | ||
The first task is to insert the informations of {{{1}}} {{{3}}} in the repository. It's tsqw_Repository table which contain basic informations of {{{3}}} to manage.<br> | The first task is to insert the informations of {{{1}}} {{{3}}} in the repository. It's tsqw_Repository table which contain basic informations of {{{3}}} to manage.<br> | ||
Revision as of 06:13, 28 June 2011
Presentation
It is the repository module, and stores rdbms indicators for {{{1}}}.
It's a {{{1}}} {{{2}}}. It is currently the only type of supported RDBMS for dbSQWare® repository for {{{1}}}.
Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.
The first task is to insert the informations of {{{1}}} {{{3}}} in the repository. It's tsqw_Repository table which contain basic informations of {{{3}}} to manage.
[[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository™ for {{{1}}} ]]
Naming convention
All objects are named with prefixes:
- tsqw_% : for tables
- isqw_% : for index
- isqw_%_u : for uniques
- isqw_%_pk : for primary key
