Planning for Repository Database Growth
Go Up to Repository Installation
Regardless of the platform, allocate at least 300 MB of space to the database and implement auto extend so that the database can accommodate increases in the size and number of models. Also, allocate 50 MB of space to the database log file.
The table below describes the initial size of some sample Repository databases before any diagrams are added, and the approximate database sizing for sample small, medium, and large diagrams.
RDBMS |
Initial Size (MB) |
Small Diagram (MB) |
Medium Diagram (MB) |
Large Diagram (MB) |
---|---|---|---|---|
Oracle 8 |
6 |
0.5 |
14 |
64 |
Microsoft SQL Server 7 |
7.8 |
0.7 |
14.7 |
40.9 |
IBM DB2 UDB |
3.2 |
0.8 |
14.6 |
50 |
The table below describes the characteristics of small, medium, and large sample diagrams:
Sample Diagrams |
Entities |
Attributes |
Views |
Relationships |
DM1 File Size (KB) |
---|---|---|---|---|---|
Small |
22 |
125 |
2 |
20 |
184 |
Medium |
302 |
2516 |
32 |
606 |
2153 |
Large |
722 |
10629 |
0 |
1542 |
6967 |
Note: If you are installing ER/Studio Repository 6.x, install ER/Studio Data Architect 9.x or later. Previous versions of ER/Studio Data Architect are not compatible with ER/Studio Repository 6.x.