要根据前面创建的XML的关系视图创建报告，输入下面的查询语句。
To create a report based on the relational view of the XML created previously, enter the following query statement.
准备语句相比普通查询来说要快很多，当然跟使用的数据库有关系。
Prepared statements can be significantly faster than regular queries depending on the database being used.
现在您应该能够使用下列语句创建具有分层或双向关系的所有类型的递归查询
You should now be able to create all kinds of recursive queries with either hierarchical or bi-directional relationships using
按照持久化实体之间的关系执行查询，而不需要join语句(但是，如果您愿意，也可以使用join语句)。
Queries that traverse the relationships between persistent entities without requiring JOIN statements (though you can use JOIN statements if you prefer).
sql语句用来从关系数据库中交互式查询信息并为报表采集数据。
SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.
最后，由于数据是存储在关系数据库中，本文还以模板的形式，介绍了把物品追踪查询和面向路径查询转化成SQL语句的方法。
Finally, since the data is stored in a relational database, the paper describes the item tracking query and object-oriented path query into SQL statements as the template form.
另外，如果在“条件”窗格或“关系图”窗格中修改查询，可能会发现更改所得到的sql语句与所输入的语句不同。
In addition, if you modify your query in the Criteria pane or Diagram pane, you might find that your SQL statement has been changed from what you entered.
当移动到另一窗格时，查询和视图设计器会自动将语句格式化，然后更改“关系图”窗格和“条件”窗格以与该语句匹配。
When you move to another pane, the Query and View Designer automatically formats your statement, and then changes the Diagram and Criteria panes to match your statement.
为了加快查询的执行，我们对存放在关系库中的XML数据建立结构化映射，以减少SQL语句中连接操作的数目。
In order to speed up the query evaluation, we established the structured mapping for the XML data stored in RDB, and therefore, the frequency of join operations in SQL statement can be decreased.
为了加快查询的执行，我们对存放在关系库中的XML数据建立结构化映射，以减少SQL语句中连接操作的数目。
In order to speed up the query evaluation, we established the structured mapping for the XML data stored in RDB, and therefore, the frequency of join operations in SQL statement can be decreased.
应用推荐