文件名称:实验任务3
介绍说明--下载内容均来自于网络,请自行研究使用
①. 列出2005-12-24日从North Pole出发的所有航班(dataQ1.xquery);
②. 查询2005-12-24日最繁忙(计算出发和到达航班)的机场、以及其进出航班总数(dataQ2.xquery);
③. 按照2005-12-24日机场繁忙程度(计算进出旅客总数)列出机场(忽略没有旅客进出的机场)、以及其进出旅客总数(dataQ3.xquery);
④. 查询所有名为Santa Claus的乘客的航班目的地(dataQ4.xquery);
在上述查询计划中,③相对比较复杂,需要使用一些嵌套查询,如果有必要,可以逐步编写子查询,通过调试或者执行观察结果,然后组合构成完整的查询计划;也可以将某些嵌套查询封装为函数(需要使用序列类型来自定义函数),以增加查询计划的可读性。(List all flights departing from North Pole on December 24, 2005 (dataQ1.xquery);
(2) Query the busiest airports (calculated departure and arrival flights) and the total number of incoming and outgoing flights (dataQ2.xquery) from December 2005 to 24;
(3) List the airports (ignoring airports without passengers) and the total number of passengers in and out (dataQ3.xquery) according to the busy degree of airports (calculating the total number of passengers in and out) from December to 24, 2005;
(4) Query the destination of all passengers named Santa Claus (dataQ4.xquery);
In the above query plan, 3. It is relatively complex and needs to use some nested queries. If necessary, sub-queries can be written step by step. By debugging or executing the observation results, a complete query plan can be formed. Some nested queries can also be encapsulated as functions (sequence types need to be used to define functions) to increase the readability of the query plan.)
②. 查询2005-12-24日最繁忙(计算出发和到达航班)的机场、以及其进出航班总数(dataQ2.xquery);
③. 按照2005-12-24日机场繁忙程度(计算进出旅客总数)列出机场(忽略没有旅客进出的机场)、以及其进出旅客总数(dataQ3.xquery);
④. 查询所有名为Santa Claus的乘客的航班目的地(dataQ4.xquery);
在上述查询计划中,③相对比较复杂,需要使用一些嵌套查询,如果有必要,可以逐步编写子查询,通过调试或者执行观察结果,然后组合构成完整的查询计划;也可以将某些嵌套查询封装为函数(需要使用序列类型来自定义函数),以增加查询计划的可读性。(List all flights departing from North Pole on December 24, 2005 (dataQ1.xquery);
(2) Query the busiest airports (calculated departure and arrival flights) and the total number of incoming and outgoing flights (dataQ2.xquery) from December 2005 to 24;
(3) List the airports (ignoring airports without passengers) and the total number of passengers in and out (dataQ3.xquery) according to the busy degree of airports (calculating the total number of passengers in and out) from December to 24, 2005;
(4) Query the destination of all passengers named Santa Claus (dataQ4.xquery);
In the above query plan, 3. It is relatively complex and needs to use some nested queries. If necessary, sub-queries can be written step by step. By debugging or executing the observation results, a complete query plan can be formed. Some nested queries can also be encapsulated as functions (sequence types need to be used to define functions) to increase the readability of the query plan.)
(系统自动生成,下载前可以参看下载内容)
下载文件列表
文件名 | 大小 | 更新时间 |
---|---|---|
dataQ2.xquery | 499 | 2019-04-01 |
dataQ4.xquery | 623 | 2019-03-28 |
dataQ1.xquery | 68 | 2019-03-28 |
dataQ3.xquery | 522 | 2019-03-28 |
Flights-Data.xml | 14573 | 2012-11-05 |
__MACOSX | 0 | 2019-04-19 |
__MACOSX\._Flights-Data.xml | 243 | 2012-11-05 |