可以使用非模态的设计程序创建和删除数据库对象,例如表、视图、存储过程和函数。
You can create and delete database objects such as tables, view, stored procedures, and functions using non-modal designers.
要开始激活区分大小写查询程序的过程,首先要复审用户数据库的模式,并确定所有的多行文本域。
To begin the process of enabling case-insensitive queries, review the schema of the user database and identify all of the multiline text fields.
存储过程程序可以访问DB2数据和传统的非db2资源,比如QSAM和VSAM数据集、消息队列、CICS程序、IMS事务和数据库。
The stored procedure program can access DB2 data as well as traditional non-DB2 resources such as QSAM and VSAM data sets, message queues, CICS programs, IMS transactions and databases.
在该DB 2数据库项目的构建过程中,该项目程序集还将添加到必须部署到目标DB 2服务器上的程序集列表中。
The project assemblies are also added to the list of assemblies that must be deployed to the target DB2 server as part of the DB2 database project build process.
载入JDBC驱动程序的标准过程需要两项:驱动程序的类名和连接的目标数据库的JDBCURL。
The standard processing for loading a JDBC driver requires two items: the driver's class name and the JDBC URL of the database that's targeted for connection.
我们将从一个简单的任务入手:从数据库中选择一行数据放入一个Perl程序中;接着逐步介绍一些高级主题,包括处理大对象和调用存储过程。
You'll go from the simple task of selecting a row from a database into a Perl program to more advance topics, including dealing with large objects and invoking stored procedures.
如果您已经有一个存在的数据库,并需要使用该存储过程所提供的功能,就需要在安装db 2V8.2.2之后使用db2updv8实用程序更新您的数据库。
If you have an existing database and you want to use the function provided by this stored procedure, you need to update your databases after you install db2 V8.2.2 using the db2updv8 utility.
我向您展示了您如何能将数据载入此wekaAPI(并且建议您花些时间围绕您的数据库编写一个漂亮的包装程序以便让这个过于复杂的过程简单一些)。
I showed you how you can load data into the WEKA API (and recommended you spend some time to write a nice wrapper around your database, to make this overly complex process easier).
考虑应用程序和数据库的性能特性的时机是在那些应用程序和数据库的初期设计阶段,也就是开发过程的开始阶段。
The time to consider the performance characteristics of applications and databases is during the initial design of those applications and databases, at the beginning of the development process.
应用程序开发人员可能并不总是对所有默认数据库对象,例如表、视图、过程和函数感兴趣,而是对其中的一部分感兴趣。
Application developers may not always be interested in all the default database objects, such as tables, views, procedures, and functions, but rather just a few of them.
通常认为SQL查询的调优是程序员和开发人员的主要责任,但是数据库管理员也应积极参与该过程。
Tuning SQL query is often thought of as a major responsibility of programmers and developers, but database administrators should also be actively involved in this process.
在从数据库读取XML文档并传递给应用程序的过程中,可以在查询中使用转换表达式修改XML文档。
A transform expression can be used in a query to modify an XML document as it is read from the database and passed to the application.
应用程序开发人员可能不会始终对所有默认数据库对象,例如表、视图、过程和函数等感兴趣,但只会对其中几项感兴趣。
Application developers may not always be interested in all the default database objects, such as tables, views, procedures, and functions, but simply a few of them.
客户机应用程序调用存储过程,然后存储过程执行数据库访问,但不会跨网络返回不必要的数据。
A client application calls the stored procedure, which then performs the database accessing without returning unnecessary data across the network.
在数据库应用程序中使用存储过程有许多好处,包括减少对网络的使用、提高性能以及降低开发成本。
There are numerous advantages to using stored procedures for your database applications. Some of the benefits include reduced network usage, improved performance, and reduced development cost.
脱机备份要求所有应用程序断开与数据库的连接,联机备份允许在备份的过程中继续执行事务。
Offline backup requires that all applications disconnect from the database, whereas online backup allows transactions to carry on while backup is in progress.
要使用存储过程,仅需从客户机应用程序向数据库服务器发送参数值和存储过程本身的名称即可。
The use of this stored procedure required only the parameter value and the name of the stored procedure itself to be sent from the client application to the database server.
移动设备还管理与文件订阅相关的操作,以便方便地将移动应用程序发布到该设备,并且可以执行存储在DB 2数据库中的存储过程。
The mobile device also manages operations related to file subscriptions for easy distribution of mobile applications to the device and can execute stored procedures stored on a DB2 database.
在部署数据库池之后,应用程序模块可以使用在配置过程中指定的名称来引用它。
Once the database pool has been deployed, application modules can refer to it using the name specified during configuration.
当数据库性能成为开发过程中的焦点时,您的数据库设计使得为DB 2应用程序提供最佳性能有了更大的可能性。
When database performance is an important focus in the development process, your database design will result in a greater probability of delivering optimum performance for your DB2 applications.
打开和关闭连接的过程开销较大,会影响到应用程序或数据库的性能,而使用连接池就可以消除大部分这样的开销。
Opening and closing connections is an expensive process affecting application or database performance and the use of connection pooling helps eliminate most of that overhead.
客户端应用程序通过调用存储过程只需要访问数据库一次就可以执行一系列本地操作,而不用多次访问数据库服务器。
A client application can call on the stored procedure to perform a series of native operations in one trip to the database, rather than involving multiple trips to the database server.
当创建访问DB2数据的应用程序时,可以通过合并注册到数据库服务器的存储过程和UDF 来改进应用程序的性能。
When you create an application that accesses DB2 data, you can improve your application's performance by incorporating stored procedures and UDFs that are registered with the database server.
不同之处在于,用于存储过程的SQL代码定义并存储在数据库本身中,然后从应用程序中进行调用。
These elements differ in that the SQL code for a stored procedure is defined and stored in the database itself, then called from the application.
此外,在数据库端,在应用程序开发过程中会不断地更改模式。
In addition, on the database side, schemas are continuously changed as part of the application development process.
存储过程对于在服务器上封装应用程序逻辑和数据库访问很有价值。
Stored procedures are valuable for encapsulating application logic and database access on the server.
如今,很多应用程序的数据库层都设计为存储过程。
Many applications nowadays design their database layer as stored procedures.
如果您的JDBC程序使用已经准备好的语句和参数标志,并且如果在数据库语句缓存中找到了它们的话,查询过程将处理地更快。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
现在来看看DB 2数据库对象(比如模式、表、索引和存储过程)的实现以及这些对象的应用程序接口。
Now turn your attention to the implementation of the DB2 database objects (such as, schema, tables, indexes, and stored procedures) and the application interface to these objects.
考虑周详的数据库设计可以提供巨大的性能收益,但是这必须在应用程序开发过程的早期便开始着手。
Thoughtful database design can offer significant performance benefits, but it must begin early in the application development process.
应用推荐