Storing Binary datas in Database
What is meant by storing binaries in Database? Why it is not recommended to store binaries in Oracle Database of RTC? Is there any issues if Oracle DB size grows up? This question came up because many a times RTC is compared with Clearcase where they can check-in huge size of file at a time but in RTC we prefer limiting the size for check-in.
|
5 answers
Geoffrey Clemm (30.1k●3●30●35)
| answered Oct 27 '10, 1:37 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
ClearCase has mechanisms for deleting old versions, so you can clean up
those huge binaries, while RTC does not yet allow that (it is a high priority work item, but not scheduled for the next release). Cheers, Geoff On 10/26/2010 9:53 AM, kushsingh wrote: What is meant by storing binaries in Database? Why it is not |
|
Does that mean that if the binaries keep on growing in RTC Oracle Database, there are chances of slow server perforamnce? What are the impacts of growing sizes in RTC Oracle Database.
|
|
Geoffrey Clemm (30.1k●3●30●35)
| answered Oct 28 '10, 12:11 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
We need the repository folks to provide a definitive answer, but my
understanding is that it won't slow down the server performance ... it's primary affect is on disk storage required. It would also affect repository version upgrade time (e.g. upgrade from RTC-V2.0 to RTC-3.0). Repository folks: Other areas? For example, is backup time affected or does Oracle have an efficient incremental backup mechanism that only writes out changes since the last backup? Cheers, Geoff On 10/27/2010 2:52 AM, kushsingh wrote: Does that mean that if the binaries keep on growing in RTC Oracle |
|
Thanks for your reply. I would like to understand futher taking up a scenario: For e.g; I checked-in a file of 4 MB. Now because RTC doesn't allow checkout.....I have to modify the file locally...Suppose I made the changes and now again have to check-in the file. The file size grows by 1MB (4 MB + 1 MB changes I made). What is the disk space at the oracle DB for the same file which is getting occupied. Is it only 5 MB or (4MB (previous file) + 5MB) = 9MB. The file name is same.
2. Take the same case in Clearcase and please explain how does it work there... |
|
Geoffrey Clemm (30.1k●3●30●35)
| answered Nov 01 '10, 7:07 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
The exact value of the growth in the database depends on the content and
type of the file being checked in. In particular, some types of files are stored in delta-format, so the database growth depends on the delta between the old and the new. Other types of files are stored in compressed binary format, so the growth depends not on the size of the file, but rather on the size of the compressed file. The same is true for ClearCase, except that there are many types of "type managers" with different storage behaviors, and the user is allowed to contribute their own type managers, if they want to introduce some new kind of storage behavior. Cheers, Geoff On 11/1/2010 5:23 AM, kushsingh wrote: Thanks for your reply. I would like to understand futher taking up a |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.