Difference between revisions of "SQWareRepository:general"
Expdbtools (talk | contribs) (→présentation) |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | == | + | == presentation == |
| − | + | It is the repository module, and rdbms indicators..<br> | |
| − | + | It manage the repository and the database indicators (this is actually a schema or database)..<br> | |
<br> | <br> | ||
| − | + | This module have one part per RDBMS managed. There is no 'core' part, each type of RDBMS is independent. | |
| − | + | There is still a consistency between all these MCD, you will find for example the referential table tsqw_Repository in each.<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> | |
| − | *[[SQWareRepository:oracle| | + | <br> |
| − | *[[SQWareRepository:sybase| | + | Links to different plugins of SQWareRepository® module : |
| − | *[[SQWareRepository:mysql| | + | *[[SQWareRepository:oracle|Oracle plugins]] |
| − | *[[SQWareRepository:mssql| | + | *[[SQWareRepository:sybase|Sybase plugins]] |
| − | [[Downloads| | + | *[[SQWareRepository:mysql|Mysql plugins]] |
| + | *[[SQWareRepository:mssql|Mssql plugins]] | ||
| + | *[[SQWareRepository:ingres|Ingres plugins]] | ||
| + | [[Downloads|Download the latest stable versions]]<br> | ||
<br> | <br> | ||
| − | == convention | + | == naming convention == |
| − | + | All objects are named with prefixes: | |
| − | * tsqw_% : | + | * tsqw_% : for tables |
| − | * isqw_% : | + | * isqw_% : for index |
| − | * isqw_%_u : | + | * isqw_%_u : for uniques |
| − | * isqw_%_pk : | + | * isqw_%_pk : for primary key |
{{Warning_objets}} | {{Warning_objets}} | ||
<br> | <br> | ||
Revision as of 11:47, 14 December 2010
presentation
It is the repository module, and rdbms indicators..
It manage the repository and the database indicators (this is actually a schema or database)..
This module have one part per RDBMS managed. There is no 'core' part, each type of RDBMS is independent.
There is still a consistency between all these MCD, you will find for example the referential table tsqw_Repository in each.
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.
Links to different plugins of SQWareRepository® module :
Download the latest stable versions
naming convention
All objects are named with prefixes:
- tsqw_% : for tables
- isqw_% : for index
- isqw_%_u : for uniques
- isqw_%_pk : for primary key
