Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Data Modeling > Understanding the Physical Database Model >

Knowing the Contents of the Physical Database

---

The Administration Tool provides an interface to map logical tables to the underlying physical tables in the database. To do this correctly, you need to understand the contents of the physical database. You need to know:

• The contents of each table
• The detail level for each table
• The contents of each column
• How each measure is calculated
• The table definition for each aggregate table
• The joins defined in the database

To acquire this information about the data, you could refer to any available documentation that describes the data elements created when the database was implemented, or you might need to spend some time with the DBA for each database to get this information. To fully understand all the data elements, you might also need to ask people in the organization who are users of the data, owners of the data, or application developers of the applications that create the data.

Bookshelf Home | Contents | Index | Search | PDF