Does IDA rolled-up size estimation numbers across a database? I see that you can type in volumetrics and it will print these out in various points, but does it provide any intelligence besides just printing what you've directly typed in?
Thanks in advance.
Re: Size estimation?2013-02-01T18:59:24ZThis is the accepted answer. This is the accepted answer.Hi Brendan,
Our volumetrics basically consists of the following:
1. The ability to model volumetrics information for entities within a Logical Data Model and/or Physical Data Model
2. The ability to transform volumetrics information from a Logical Data Model into a Physical Data Model.
(Note: transformations between Models of different domains are key use-cases for IDA)
3. The ability to generate default tablespaces based on volumetrics information entered
4. The ability to validate (and subsequently recommend) mismatch between your volumetrics information entered and your storage elements
Hope this helps,
bmccar 270004NHQQ4 Posts
Re: Size estimation?2013-02-06T02:17:16ZThis is the accepted answer. This is the accepted answer.
- loicjulien 2700007DEB
Re: Size estimation?2013-02-06T20:25:32ZThis is the accepted answer. This is the accepted answer.
- bmccar 270004NHQQ
I am including 2 screencaps (in 2 posts) of how this may be used:
1/ If you select a TableSpace, you can leverage the menu: "Apply TableSpace" to add tables. As you do did, the option "Update table space design" will allow to update some of your tablespace properties based on the volumetrics of the assigned tables: extent size, page size, prefetch...
== Screencap 1 ==
2/ If you select a schema (for instance) you can leverage the menu called "Analyze Model" and select: Physical Data Model section / Index and Storage / Tablespace design check. We may then report validation problems based on your tablespace definition and the volumetrics of assigned tables.
== Screencap 2 ==
Let me know if this helps,