ITPub博客

首页 > 数据库 > 数据库开发技术 > Tasks of a Database Administrator : Plan the Database (9)

Tasks of a Database Administrator : Plan the Database (9)

原创 数据库开发技术 作者:tsinglee 时间:2007-12-16 10:25:51 0 删除 编辑

As the database administrator, you must plan:
■ The logical storage structure of the database
■ The overall database design
■ A backup strategy for the database
It is important to plan how the logical storage structure of the database will affect
system performance and various database management operations. For example,
before creating any tablespaces for your database, you should know how many
datafiles will make up the tablespace, what type of information will be stored in each
tablespace, and on which disk drives the datafiles will be physically stored. When
planning the overall logical storage of the database structure, take into account the
effects that this structure will have when the database is actually created and running.
Consider how the logical storage structure of the database will affect:
■ The performance of the computer executing running Oracle Database
■ The performance of the database during data access operations
■ The efficiency of backup and recovery procedures for the database
Plan the relational design of the database objects and the storage characteristics for
each of these objects. By planning the relationship between each object and its physical
storage before creating it, you can directly affect the performance of the database as a
unit. Be sure to plan for the growth of the database.
In distributed database environments, this planning stage is extremely important. The
physical location of frequently accessed data dramatically affects application
performance.
During the planning stage, develop a backup strategy for the database. You can alter
the logical storage structure or design of the database to improve backup efficiency.
It is beyond the scope of this book to discuss relational and distributed database
design. If you are not familiar with such design issues, please refer to accepted
industry-standard documentation.

数据库管理员职责之 : 计划数据库
需要计划如下事情:
1. 数据库的逻辑存储结构 : 影响数据库的系统性能和数据库管理操作
2. 全面的数据库设计
3. 数据库的备份策略

数据库的逻辑存储结构将影响
1. 运行Oracle数据库主机的性能
2. 数据操作时的性能
3. 备份与恢复数据库程序的效率

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10599713/viewspace-993989/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    2002869