You are here: Chapter 10: Database Administration > Database Administration

Database Administration

The FootPrints database design is optimized to work with the most popular relational databases for efficient and fast performance. This chapter covers the following topics:

System Architecture—The general architecture of FootPrints.
Database Design—Design of the FootPrints database, including table structure and connection types.
Services—FootPrints services for connecting to the database.
Database Maintenance—Purging and archiving Workspace data
Backups and Disaster Recovery—Information about backing upFootPrints and creating a disaster recovery plan.
Upgrades—About upgrades to FootPrints.
Performance—Guidelines and troubleshooting system performance.
Field Limit Specifications—Rules regarding the number of Workspace fields allowed based on database used.
Security—About security in FootPrints.

Restrictions

With respect to limits for the number of fields in an individual workspace, there is very little danger of exceeding the limits of most databases. Nevertheless, administrators should be aware that when the number of fields in an individual workspace grow into the hundreds, performance may begin to degrade or data may be truncated.

There are two ways in which field proliferation might become a problem. One is through using field dependencies and the other is by using field-level permissions to combine multiple workspaces into a single workspace. Administrators should not in any way avoid using these features. They are mentioned here only because of the slim chance that they could cause a problem through field proliferation.

©Copyright 1999, 2009 BMC Software, Inc. © Copyright 1996 - 2017 BladeLogic, Inc. BMC, BMC Software, and the BMC Software logo are the exclusive properties of BMC Software, Inc., are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BMC trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners. FootPrints is the exclusive property of BladeLogic, Inc. and is registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BladeLogic trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners.BladeLogic, Inc. and BMC Software, Inc. Confidential. Click here for the installation guide which includes the provisions described in the BMC License Agreement and Order related to third party products or technologies included in the BMC Product.