https://docs.telcobridges.com/mediawiki/index.php?action=history&feed=atom&title=Application_database 2026-07-11T10:41:30Z Revision history for this page on the wiki MediaWiki 1.18.1 https://docs.telcobridges.com/mediawiki/index.php?title=Application_database&diff=110&oldid=prev 2009-05-07T19:56:14Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:56, 7 May 2009</td> </tr><tr><td colspan="2" class="diff-lineno">Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>application database since the performance/reliability requirements vary depending on the application. Frequently it</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>application database since the performance/reliability requirements vary depending on the application. Frequently it</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>will be used to store:</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>will be used to store:</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">• </del>Customer data records<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>Customer data records</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">• </del>Routing information (dial plans)<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>Routing information (dial plans)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">• </del>Client accounts (subscribed features)<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>Client accounts (subscribed features)</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">• </del>Prompts<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>Prompts</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">• </del>Call states for HA switchover<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>Call states for HA switchover</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td colspan="2" class="diff-lineno">Line 15:</td> <td colspan="2" class="diff-lineno">Line 15:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Database access are usually synchronous, this is not a problem but it should not be overlooked when designing the</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Database access are usually synchronous, this is not a problem but it should not be overlooked when designing the</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>application database. A lot of synchronous access to a slow database (or on a slow link) can cause <del class="diffchange diffchange-inline">signigicant </del>call</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>application database. A lot of synchronous access to a slow database (or on a slow link) can cause <ins class="diffchange diffchange-inline">significant </ins>call</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>delays (not in the data path but in the control path). Using the multi-threaded feature of the CMC library, we can</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>delays (not in the data path but in the control path). Using the multi-threaded feature of the CMC library, we can</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>protect a call from another call’s <del class="diffchange diffchange-inline">asychronous </del>operations but we cannot protect it from himself. This can be prevented</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>protect a call from another call’s <ins class="diffchange diffchange-inline">asynchronous </ins>operations but we cannot protect it from himself. This can be prevented</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>with good database <del class="diffchange diffchange-inline">desing</del>.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>with good database <ins class="diffchange diffchange-inline">design</ins>.</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">----</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Return to the Toolpack [[User Guide]]</ins></div></td></tr> <!-- diff cache key wikidb:diff:version:1.11a:oldid:109:newid:110 --> </table>

Ktrueman https://docs.telcobridges.com/mediawiki/index.php?title=Application_database&diff=109&oldid=prev 2009-05-07T19:55:14Z

<p>New page: The client’s database is called the application database and is not required even though it is doubtful that large systems will do without one. There is no restriction on the the DBMS of...</p> <p><b>New page</b></p><div>The client’s database is called the application database and is not required even though it is doubtful that large systems<br /> will do without one. There is no restriction on the the DBMS of the application. It is up to the client to design the<br /> application database since the performance/reliability requirements vary depending on the application. Frequently it<br /> will be used to store:<br /> • Customer data records.<br /> • Routing information (dial plans).<br /> • Client accounts (subscribed features).<br /> • Prompts.<br /> • Call states for HA switchover.<br /> <br /> <br /> <br /> == Caveats ==<br /> <br /> <br /> Database access are usually synchronous, this is not a problem but it should not be overlooked when designing the<br /> application database. A lot of synchronous access to a slow database (or on a slow link) can cause signigicant call<br /> delays (not in the data path but in the control path). Using the multi-threaded feature of the CMC library, we can<br /> protect a call from another call’s asychronous operations but we cannot protect it from himself. This can be prevented<br /> with good database desing.</div>

Ktrueman