我要感谢IBM多伦多实验室的数据库顾问PaulYip,因为他提供了很有价值的帮助和设计建议。
I would like to thank Paul Yip, database consultant with the IBM Toronto Lab, for the much-valued help and design suggestions
本文说明了数据库设计和访问数据库的PHP代码中出现的五个常见问题,以及在遇到这些问题时如何修复它们。
This article illustrates five common problems in database design, in the PHP code that accesses databases, and how to fix these problems when you see them.
当您设计缓冲池时,您应该考虑数据库的内存需求。
When you design buffer pools, you should consider the database memory requirements.
另一个DPF设计决定是数据库分区的数量。
Another DPF design decision is the number of database partitions.
在应用程序开发阶段,使用这个数据库服务器实例进行数据库设计、开发和调优。
During the application development phase, you will use this database server instance to design, develop, and tune the databases.
此工具帮助管理程序设计数据库中的数据。
This tool helps manage data within the program design database.
也许是图像处理,也许是数据库设计,等等。
It might be image manipulation or maybe database design or whatever.
例如,它讨论逻辑和物理数据库设计。
For example, it discusses logical and physical database design.
应当采取哪些方法来进行数据库设计?
What approach should you take in relation to database design?
最后一个数据库设计问题是比萨和浇头。
到这个学期的期末,我们会讨论数据库的设计。
Toward the end of the semester, we'll talk about database design.
本文的范围是数据库设计性能。
它具有星形或雪花形的维数据库模式设计。
It has a star or snowflake-like dimensional database schema design.
要实现这个目标,应当全面了解数据库设计和应用程序。
To achieve that goal, you need a thorough understanding of the database design and applications.
该信息转换成逻辑的(或物理的)数据库设计。
This information gets transformed into a logical (or physical) database design.
数据仓库数据库设计的重点在于查询性能。
The design of a data warehouse database is focused on query performance.
应该先进行数据库的规划和设计,然后才能实际创建数据库和表。
You want to plan and design for your database before you actually go ahead and create the tables.
这简化了存储估算,进而简化了物理数据库设计。
This simplifies the storage estimate that eases the physical database design.
非模态设计程序提供了同时设计多个数据库对象的灵活性。
Non-modal designers allow you the flexibility to simultaneously work on designing several database objects.
设计是与数据库无关的。
这个数据库的设计如下所示。
他们还需要掌握数据库的概念或具有DBA的经验,以便在设计解决方案时能够理解源和目标数据库之间的蕴涵关系。
They also need to have knowledge of database concepts or DBA experience in order to understand the implications for the source and target database when designing this solution.
数据库设计的起点很简单。
前一节所描述的数据库设计决策的益处。
The benefit of the database design decisions described in the previous sections.
所有这些功能共同允许您通过调整数据库来配合业务环境,而不是牺牲您的设计来适应数据库。
All these features allow you to adapt the database to your business environment instead of compromising your design to fit the database.
许多因素都可以影响数据库服务器的性能,例如硬件系统的设计、数据库对象的设计、数据存储器的管理、应用程序的设计等等。
Many factors can affect the performance of a database server, such as hardware system design, database object design, data storage management, application design, and so forth.
本节介绍了一组数据库设计建议,可为存储和分析PDB数据提供一种简单而高效的数据库支持。
This section describes a set of database design recommendations that lead to simple and efficient database support for storing and analyzing PDB data.
当包含数据库时,此项活动识别出要在数据库中保存的设计元素,并设计相应的数据库。
When databases are involved, this activity identifies the design elements to be saved in a database and designs the corresponding database.
数据库开发人员——负责实际运行的数据库,包括设计数据库、模式、表、表关系、索引,以及对查询进行优化。
Database developer — Responsible for the actual databases in operation, including designing databases, schemas, tables, table relationships, and indexes as well as optimizing queries.
虽然数据库应用程序的性能会受许多因素影响,但是我们着重讨论配置而不是诸如容量规划、数据库设计或应用程序设计之类的因素。
Although performance of a database application can influenced by many factors, we focus on configuration rather than on such things as capacity planning, database design, or application design.
应用推荐