Home About Opportunities Clients Contact us Knowledgebase
 
Reliance Business Solutions - Consultant Knowledgebase

This knowledge base will continuously evolve to keep itself relevant to current problems. This knowledge base not merely addresses technology but also touches sciences, business and finance. Information Technology draws its relevance from its ability to enhance the results of human endeavor at tremendous pace. So, this knowledge base also dwells upon areas like Finance, Health Care, Medicine, Education. Our strategy is to start humble and grow relentlessly in quality and quantity.

Information Technology
Database Capacity Planning

Basic capacity planning should take into account the following:

  • 1. Table structures and the max length of each row. You can use the average length of each row, if you have sufficient data populated.
  • 2. Determine maximunum number of rows per table (aka Table growth) over a fixed period of time (e.g. 1 day, 1 month, 1 year, etc.) [If you have indexes there is an overhead of about 5-15% more on this later ...]
  • 3. Determine how many tablespaces you will have, and the approximate sizeand content in each tablespace.
  • 4. Determine how much data you wish to keep (if you have a process to purge data, how much data will be removed from the database) over a fixed period.
  • 5. How much system resources (RAM, Disk, SGA, etc.) are you allocating the database?
  • 6. Oracle overhead. Oracle typically incurrs a small overhead. Depending on the complexity (i.e. lots of PL/SQL, triggers, blobs, etc.) it can vary between 5-15% conservatively.
  • 7. Growth factor. The completed sizing (1-6) would cover your data for a fixed period. Assume that this total represents a percentage of your total database, e.g. 70%. Thus you need to ensure that there's 30% left for growth(70-30 rule). In the case of a large Data warehouse, you may opt for the 20-80 rule (20% used, 80% space for growth).

Finance
LIBOR Rates Historical Data