当您单击格式化查询中任意一行时,其他包含来自同一张表的列或表引用的查询的行也会高亮显示。
When you click any line in the formatted query, other lines of the query that contain column or table references from the same table are also highlighted.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成,那么数据库优化则必须包含实体化。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
查询这样的数据库最有效的一种方式是编写一个XSLT样式表来格式化结果。
One of the most effective ways to query such a database is to write an XSLT stylesheet that formats the results.
接下来根(反)序列化器将在类型映射注册表中查询下一个要调用的常规(反)序列化器。
The root (DE) serializer in turn will query the type mapping registry for the next normal (DE) serializer to be called.
设计器同时也产生一个填充查询,它封装了查询相关表的Select语句并且在类型化数据集中以同名方法实现。
The designer also generates a Fill query, which wraps the table's SELECT statement and is implemented as a method of the same name on the typed DataSet.
您使用 MYSQL_QUERY()对您的表执行SQL查询,然后您使用WHILE 重新格式化结果来预排将得到的对象,并将数据重新格式化为新的简单阵列。
You execute an SQL query against your table with MYSQL_QUERY() and with the result, you reformat using WHILE to walk through the resulting object, and reformat the data into a new simple array.
可以使用这个特性查询一个常规表并返回经过格式化的XML(在这里,使用人口普查数据和模式)。
It allows for a query that returns formatted XML, based on a regular table (in our case, with our Census data and schema).
现在我们看一下cust_customer表中的谓词,它是从图3中的格式化查询中提取出来的。
Now let's look at the predicates for table CUST_CUSTOMER as extracted from the formatted query in Figure 3.
关系数据库使用结构化查询语言(Structured Query Language,SQL)以便从多个表和列中提取信息,但是键值存储仅限于对键列的操作。
Relational databases use Structured Query Language (SQL) to pull information from multiple tables and columns, but key-value stores are limited to operations on the key column.
此外,通过使用行业标准的“星型模式”(star schema)而不是更规范化的表结构,数据仓库经过了优化以实现高效的查询和快速的响应时间。
In addition, by using an industry standard "star schema", rather than a more normalized table structure, the data warehouse is optimized for efficient queries and quick response times.
对于每个参数,都查询类型映射注册表并在返回的序列化器上随后调用marshall方法。
For each parameter, the type mapping registry is queried and the Marshall method subsequently called on the returned serializer.
AdvancedDBA考试涉及到联邦数据库、分区、具体化的查询表和多维集群表。
The Advanced DBA exam gets into federated databases, partitioning, materialized query tables, and multidimensional clustering tables.
设计健全的查询模式。不要害怕表联合,通常它们比非范式化更快。
Design sane query schemas. don't be afraid of table joins, often they are faster than denormalization.
结合所提出的数据库表,探讨了模糊数据的归一化、排序、查询等处理方法与技术。
With connection to the proposed database table, the processing methods and techniques for normalization, ranking and inquiry on fuzzy information are also discussed.
为帮助您创建这些对象,可视化数据库工具提供三种设计器:数据库关系图设计器、表设计器及查询和视图设计器。
To help you create these objects, Visual Database Tools provides three designers: the Database Diagram, Table, and Query and View designers.
窗格会显示查询或检视表的资料表和其他表格化物件、可用的资料行以及表示资料行使用方式的图示。
The Diagram pane displays the tables and other table-structured objects for the query or view, the available data columns, and icons indicating how the columns are used.
它包括一个可视化查询生成器,SQL编辑器与语法高亮和代码完成,可视化表和视图设计人员和强大的导入和导出功能。
It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities.
它包括一个可视化查询生成器,SQL编辑器与语法高亮和代码完成,可视化表和视图设计人员和强大的导入和导出功能。
It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities.
应用推荐