因此,您如何根据搜索条件从数据库表中得到结果记录,并得到图1和图2那样的显示屏幕呢?
So how do you get from a database table to the search and display screens in Figures 1 and 2?
对于从数据库选择大量数据的情况,这可以是一个内部表,这有助于提高性能。
This can be an internal table for bulk selects from the database, which has performance advantages.
从最佳实践的角度来看,各个数据库分区上的表数据倾斜应该不多于10%。
From the best practices perspective, the table data skew on every individual database partition should be no more than 10%.
这说明您可以只提取感兴趣的三个列,还可以使用与数据库中的顺序不同的顺序从表中提取它们。
This demonstrates that you can pull out only those columns of interest, and you can also extract them from the table in a different order than they exist within the database.
通过本文提供的脚本,可以轻松地从拥有数千个表的大型数据库中发现适合值压缩的表。
With the provided scripts, it is easy to find candidates for value compression even in large databases with thousands of tables.
下一小节将针对此类集成给出一个逐步指导示例:文本分析被用于从包含非结构化信息的数据库表中提取结构化信息。
The next section gives you a step-by-step example for this kind of integration: text analysis is used to extract structured information from a database table containing unstructured information.
通常,这可以通过使用简单的查找表或从数据库表读取值来实现。
Often, this can be implemented by using a simple lookup table or reading values from a database table.
简单的答案是从数据库中删除表。而且,如果必要,再创建一个替代表。
The simple answer is to delete the table from the database and, if necessary, create a replacement table.
可以从模板创建新的词汇表数据库。
一个数据库选项,用来指定日期维度表在初次启动被创建时预填充的天数(从当前日期开始)。
A database option that specifies the number of days (starting from the current date) to pre-populate in the date dimension table when it creates it on first startup.
从表空间快照数据中可以看出,这些用过的页面对象可用于告知索引、表和数据库的总大小。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
访问方法是指优化器从数据库表中读取(更确切地说是检索)数据的方法。
Access methods refer to the ways that the optimizer reads (or rather retrieves) data from database tables.
LOAD_ONLY:将指定的所有表从源数据库装载到目标数据库中。
LOAD_ONLY: Loads all specified tables from the source database to the target database.
在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
The number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
它用了三条语句、不足20行的代码连接到了数据库,从表中选定了每一行,并将数据作为xml导出。
In three statements and fewer than 20 lines of code, it connects to the database, selects every row from the table, and exports the data as XML.
最终生成的数据库表不一定要包含从分析创建的列。
The resulting database table does not need to contain columns created just from the analysis.
这个JAR实用程序含有一个执行基于JPA 1.0的数据库交互的类,该数据库将用户从浏览器输入的数据写入数据库表。
This utility JAR contains a class that performs JPA 1.0 based interactions with a database that writes the data entered in a browser by the user to a database table.
最佳实践:为节省分析数据库的空间,应当从旧有运行中删除不需要的输出表。
Best practice: To save space in the analysis database, you should delete the output tables from older runs when they are no longer needed.
请注意,可以作为任何系统用户从应用程序连接DB2数据库,对其中的表有完全访问权。
Please note that you can connect and have full access to the tables in the DB2 database as any of the system users from within your application.
设计新数据库的物理布局应当从设计表空间的组织开始,步骤如下。
Start designing the physical layout of a new database by designing the table space organization, as shown in the following steps.
从数据源资源管理器,下钻到GSDB数据库中的GOSALESCT模式中的表。
From the data Source explorer, drill down to the tables in the GOSALESCT schema in the GSDB database.
从数据源资源管理器,下钻到GSDB数据库的GOSALES模式中的表。
From the data Source explorer, drill down to the tables in the GOSALES schema in the GSDB database.
XML精确度指的是数据库中保存的是XML数据的原始版本,而不是从保存XML数据的关系表大致重构的版本。
XML fidelity means that the original unchanged version of the XML data is retained in the database instead of approximately reconstructed from relational tables that are used to hold the XML data.
这种情况下,解析之需要将数据值从消息的映射数据结构复制到数据库表的INSERTsql语句。
In this case, the only parsing is copying the data values from the message's mapped data structure to the database table's INSERT SQL statement.
星型连接计划中,数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
传统的(SQL或其他)基于脚本的数据分析报告的构建方式常常是从两维关系数据库表中获取数据。
The traditional (SQL or other) script-based data analytical reports are usually built by pulling data from two-dimensional relational database tables.
它包括所使用的索引、从数据库表中检索字段的次数,以及执行查询的步骤的顺序。
It includes the indexes that are used, The Times at which fields are retrieved from the database tables, and the order of steps in which the query is executed.
它包括所使用的索引、从数据库表检索字段的时间和执行查询的步骤次序。
It includes the indexes that are used, The Times at which fields are retrieved from the database tables, and the order of the steps that execute the query.
甚至可以使用另一个xslt样式表处理从数据库查询获得的信息,并将信息转换为html页面。
Furthermore, you can even use another XSLT stylesheet to process the information retrieved from the database query and transform it into an HTML page to present to a specific user.
显示从数据库返回的结果的一个表。
应用推荐