Siebel Deployment Planning Guide > Siebel Infrastructure Planning >
Determining Database Requirements
This task is a step in Process of Infrastructure Planning. This infrastructure planning task identifies database requirements for the Siebel CRM deployment. You would have already identified the types of data that are stored in the Siebel database. This task maps that data to key database characteristics. Doing this task helps you to estimate database size requirements and expected growth. Begin by defining general requirements:
- What are the types of records that are stored? What specific fields does each record contain?
- What is the volume of each record? How many records of each type are 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 do database indexes occupy? Typically, indexes require as much space as the data. For example, 50 GB of data requires 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 are assigned to each customer account
- Number of employees that are assigned to each account
- Number of contacts that are assigned to each account
- Number of attachments that are assigned to a record
- Number of activities that are associated with each account
- Whether opportunities, quotes, or orders are stored
- Whether product data is stored
- Whether Siebel Remote is used
- Whether Siebel Mobile applications are used
Include the temporary table space, log files, and space required for loading data.
|