Query-by-example - a familiar pattern popularized by the object-database community.
根据例子进行查询—数据库社区熟悉的模式。
Figure 2 shows the BaseDao interface, which has been extended to support query-by-example functionality.
图2给出扩展的BaseDao接口,它支持按示例查询功能。
Another useful facility in a dynamic query API is that it can support query-by-example with relative ease.
动态查询API中的另一个有用特性就是它能够轻松地支持根据例子进行查询。
The idea of query-by-example is that instead of specifying the exact predicates for a query, a template instance is presented.
根据例子进行查询的理念使用模板实例,而不是为查询指定精确的谓词。
For example, when you apply one of the standard templates to administer your change management processes, all team members can by default query all records in the database.
举例来说,当你应用其中一个标准模板来管理你的变更管理过程时,所有的团队成员缺省可以查询数据库中的所有记录。
To see an example, create a query that returns a list department Numbers and names, filtered by their locations.
为了查看一个范例,创建一个返回部门号以及部门名,由部门所在地过滤结果的查询。
For example, you can minimize the rows read by having predicates in the query that can determine the needed rows from just the index alone.
例如,您可以通过把可以仅从索引就确定需要的行的谓词放到查询中来将行读取降到最低。
In the next example, the previous query is modified, by adding an ORDER by siblings clause to get the siblings in the result sorted by NAME.
在下一个示例中,会修改以前的查询,添加一个ORDERBYsiblings子句,从按照NAME排序的结果中获取同级查询结果。
We now take you though a step-by-step example showing how to create a DB2 database and how to create your own Query Views.
现在我们将带领您一步步地完成一个示例,该示例展示了如何创建DB 2数据库,以及如何创建您自己的查询视图。
Consider an example where a DBA knows the problem is a poor-performing query, but that query was generated by a framework, using an object-relational mapping technology.
考虑这样一个示例:DBA知道问题根源是查询的性能较差,但此查询是由框架生成的,使用了对象关系映射技术。
For example, if you build an application to sell video tapes, you might expect a user to query for all the videos that have a certain keyword in the title and that were directed by a given person.
例如,如果构建一个用于销售录像带的应用程序,您可能预期用户会查询标题中包含某个关键字并且由某个导演执导的所有视频。
Start by generating the query using the first aggregation function (SUM in the example) in the measure's list of aggregations to aggregate the template expression.
先使用度量的聚合列表中的第一个聚合函数(在这个示例中是SUM)对表达式模板进行聚合,产生一个查询。
However, every time the user asked for a system refresh by sorting her tasks by due date, for example, the portal application had to issue a new query to WPS to repopulate the task list.
不过,每次用户要求系统刷新(例如,按照结束日期对任务进行排序)时,门户应用程序必须向WPS 发送新查询,以重新填充任务列表。
For example, some business requirements are generated by analyzing existing report query workflows and interpreting current business data analytic structures.
例如,某些业务需求是通过分析现有报表查询工作流和解释当前业务数据分析结构而生成的。
If you have a long-running database query for example that's triggered by a button press, you can simply increase the time paused after the button event has been issued.
如果你有一个运行时间很长的数据库查询(比如由按钮点击所触发),那么在按钮事件产生后你可以增加延迟时间。
A few of these (smart query rewriting, for example) are available to tools that aren't backed by a database.
其中少数(如智能查询改写)可用于没有数据库支持的工具。
In the above example, performance of the federated query could be improved by executing all three remote legs of the UNION at the same time.
在上面的例子中,可以通过同时执行union的所有三条分支来提高联邦查询的性能。
For example the context will be built using who the query was executed by, which cube was queried, which particular year was used for filtering, etc.
例如,使用执行查询的主体、查询了哪个多维数据集、特别使用了哪一年进行过滤等来构建上下文。
The plug-in can even change the query result type by returning, for example, a group name instead of the original set of users.
该插件甚至可以通过返回组名称(而不是原始用户集)来更改查询结果类型。
For example, you can easily search for the applications consuming the highest amount of CPU by simply adding a WHERE clause to a query that lists application data from a monitoring table function.
例如,只需在列出监控表函数返回的应用程序数据的查询中添加where子句,就可以搜索CPU消耗量最大的应用程序。
For example, you can get a count out of the database for the number of respondents who have stated that their favorite color (question 2) is red by using the following query shown in Listing 10.
例如,使用下面的清单10中的查询,您可以从数据库中查询最喜欢的颜色是红色(问题2)的回答者的数目。
The client can request (query) different views by interacting with the Web page (for example, by navigating to a new page).
客户机可以通过与网页交互(例如,通过导航到新页面)请求(查询)不同的视图。
For example, whether ORDER BY or GROUP BY clauses are needed in the query, or if they can be resolved via index access.
例如,查询中需要ORDERBY或GROUPBY语句,或者它们能通过指数访问解决。
The example in Listing 21 creates a query that orders its result by name and then edits the query to order also by ZIP code.
清单21中的例子创建了一个根据名称对结果进行排序的查询,然后编辑该查询以根据邮政编码进行查询。
Our next example, shown in Figure 2, is a query with an ORDER BY clause using the code below.
我们的下一个例子,如图2所示,是一个含有ORDERBY子句的查询,它使用了下面的代码。
Query by example: Query the database by creating a sample object of the type you want to retrieve and setting its properties to specify selection criteria.
Query by example:通过创建一个你想要遍历类型的对象,设置它的属性来指定某个criteria来查询数据库。
For example, a view based on a very complex query that returns only five rows (for example, a GROUP BY query) is costly to evaluate at the remote source.
例如,基于一个非常复杂的、只返回5行的查询(例如一个GROUPBY查询)的视图在远程数据源上计算起来代价较高。
For example, the following query returns a result by limiting search to the document part identified by name "description" in the document model of Figure 5.
例如,以下查询将搜索限制到图5的文档模型中名称“description”所标识的文档部分,从而返回一个结果。
This means you need to first process a query result completely before reusing a JDBC Statement — for example, by reissuing a database query — or you will lose any results from the previous query.
这意味着您必须先处理完查询结果,然后再重用JDBCStatement——例如,重新发出数据库查询——否则将丢失上一次查询到的所有结果。
The lists returned can be filtered according to a Notes Formula language query, a query by example, or a view.
返回的列表可以根据Notesformula语言查询、示例查询或视图进行过滤。
应用推荐