In the next article, I'll write about some tricks that we use to do database optimization for another example of real world Rails.
在下一篇文章中,我将介绍一些实用技巧,您可以使用这些技巧来为另一个真实世界中的Rails示例进行数据库优化。
You can do a quick test to confirm this in any database by opening a view and then pressing the down arrow.
您可以在任何数据库中进行快速测试来确认这一点,方法是打开一个视图,然后按向下箭头键。
"Hold on," I suggested. "Do we need a database table yet?"
“等一等,”我建议他,“我们现在就需要数据库表么?”
If there is an acting primary server, then the primary server will do nothing with that database.
如果有一个代理主服务器,那么主服务器将不会对数据库做任何事情。
No need to do anything if the database is not catalogued with authentication client.
如果没有用身份验证客户机编目数据库,则不需要做任何事情。
Apply the template to the user database and do some presets.
将模板应用于用户数据库,并做一些事先调整。
You can do this by using the common database mechanism.
这可以使用通用的数据库机制来完成。
So what changes to the database do you need to make to syndicate its contents?
那么,需要对此数据库做些什么更改,才能聚合其内容呢?
Use the appropriate validation technique supported by your database to do this.
使用您的数据库支持的适当验证技术来做到这一点。
However, if you decide to do a database level backup, which is ideal for a smaller size database, you will do the following.
如果您决定执行数据库级备份(对于大小有限的数据库,这是理想的),那么您需要执行以下操作。
This enables DBAs to do everything to the database that they would ordinarily do-perform regular administration tasks, load data, use utilities-but not see or alter the data.
这让 DBA 能够对数据库执行他们原来所做的所有操作(执行日常管理任务、装载数据、使用实用程序等等),但是不会看到或修改数据。
First, the database can do all sorts of indexing tricks to operate quickly.
首先,数据库可以建立各种索引提高操作的速度。
The only sensible approach is to let the database do the filtering.
唯一合理的方法是让数据库进行筛选。
To do an offline database backup, follow the steps below.
为进行离线数据库备份,需要执行以下步骤。
Optimal database performance requires the database optimizer to do its job well.
最优数据库性能还需要数据库优化器很好地发挥作用。
This is all that you have to do to create a database business metric.
以上是创建数据库业务规格的全过程。
Do not cache database rows or files
不要缓存数据库行或文件
Calling all developers! Do you have Oracle database skills?
各位开发人员!您拥有Oracle数据库技能吗?
You can do additional database management, such as performing a reorg on Tivoli Enterprise Console tables, when the tables undergo numerous changes.
还可以进行其他数据库管理,如在对表进行了大量更改时对TivoliEnterpriseconsole表执行reorg命令。
That should do it for your database schema.
对于您的数据库模式,应当那样做。
How do you then profile your system and database performance?
那么您又该如何配置系统和数据库性能呢?
All threads that access the database do so through the database engine.
访问该数据库的所有线程都是通过该数据库引擎来进行的。
Some relational database management systems do not allow the registration of multiple databases per instance.
有些关系数据库管理系统不允许每个实例注册多个数据库。
Master replicates provide the template the capability to do complete database replication including automatic creation of tables on target nodes.
主复制为模板提供了完全数据库复制,包括在目标节点上自动创建表的能力。
Database tables, unlike objects, do not have a concept of inheritance.
与对象不同,数据库表没有继承的概念。
The cost could add up, and many applications do not need a dedicated database server.
成本可以积累,且许多应用程序不需要专用数据库服务器。
This is accomplished by placing user tables in database partition groups that do not include the database partition in the IBMCATGROUP database partition group.
为此,可以将用户表放在不包括IBMCATGROUP数据库分区组中的数据库分区的数据库分区组中。
Refer to the steps above to do a database level recovery.
请参阅上面的步骤来执行数据库级恢复。
This helps lock down your system and ensures only users who are supposed to access the database actually do.
这可以保护系统,确保只有应该访问数据库的用户才能这么做。
This helps lock down your system and ensures only users who are supposed to access the database actually do.
这可以保护系统,确保只有应该访问数据库的用户才能这么做。
应用推荐