Siebel Deployment Planning Guide > Siebel Infrastructure Planning >

Determining Database Requirements

This topic is a step in Process of Infrastructure Planning.

This infrastructure planning step identifies database requirements for the Siebel deployment.

You should have already identified the types of data that will be stored in the Siebel Database. This step maps that data to key database characteristics. Doing this step helps you estimate database size requirements and expected growth. Begin by defining general requirements:

  • What are the types of records that will be stored? What specific fields will each record contain?
  • What is the volume of each record? How many records of each type will be processed each hour? Each day? Each year? Group this information by business location.
  • Determine how record volumes map to specific Siebel tables. For help with mapping records to Siebel tables, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.
  • How much space will database indexes occupy? Typically, indexes require as much space as the data. For example, 50 GB of data will require about 50 GB of indexes.
  • What is the expected annual growth rate of the database by record type and location?

Include the following information in your analysis of records:

  • Number of addresses that will be assigned to each customer account
  • Number of employees that will be assigned to each account
  • Number of contacts that will be assigned to each account
  • Number of attachments that will be assigned to a record
  • Number of activities that will be associated with each account
  • Whether or not opportunities, quotes, or orders will be stored
  • Whether or not product data will be stored
  • Whether or not Siebel Remote will be used

Include temporary table space, log files, and space required for loading data.

Siebel Deployment Planning Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.