MySQL HeatWave airportdb Quickstart 实验过程

最新推荐文章于 2024-07-22 03:06:29 发布
最新推荐文章于 2024-07-22 03:06:29 发布
阅读量798 收藏 1
点赞数
分类专栏： MySQL Oracle Cloud OCI 文章标签： 数据库 mysql HeatWave AirportDB Autopilot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/stevensxiao/article/details/120244009
版权

本实验参考此文档。

这个实验可以了解以下知识点：

  1. 如何从对象存储倒入数据库到MySQL
  2. 如何使用Autopilot中的Auto Parallel Load特性加载数据到HeatWave

在这里提供了很多MySQL的示例数据库。我们需要的airport DB从这里下载，约640MB。

下载并解压：

$ wget https://downloads.mysql.com/docs/airport-db.zip

$ ls -l airport-db.zip
-rw-rw-r--. 1 opc opc 655695008 Sep 10 17:26 airport-db.zip

$ unzip airport-db.zip

$ ls -l airport-db
total 641612
-rwxr-xr-x. 1 opc opc     1589 Sep 10 17:25 airportdb@airline@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airline@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      627 Sep 10 17:25 airportdb@airline.json
-rwxr-xr-x. 1 opc opc     1259 Sep 10 17:25 airportdb@airline.sql
-rwxr-xr-x. 1 opc opc    24022 Sep 10 17:25 airportdb@airplane@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airplane@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      628 Sep 10 17:25 airportdb@airplane.json
-rwxr-xr-x. 1 opc opc     1105 Sep 10 17:25 airportdb@airplane.sql
-rwxr-xr-x. 1 opc opc   181412 Sep 10 17:25 airportdb@airplane_type@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airplane_type@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      605 Sep 10 17:25 airportdb@airplane_type.json
-rwxr-xr-x. 1 opc opc     1115 Sep 10 17:25 airportdb@airplane_type.sql
-rwxr-xr-x. 1 opc opc   142410 Sep 10 17:25 airportdb@airport@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airport@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc   408522 Sep 10 17:25 airportdb@airport_geo@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airport_geo@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      774 Sep 10 17:25 airportdb@airport_geo.json
-rwxr-xr-x. 1 opc opc     1366 Sep 10 17:25 airportdb@airport_geo.sql
-rwxr-xr-x. 1 opc opc      612 Sep 10 17:25 airportdb@airport.json
-rwxr-xr-x. 1 opc opc      582 Sep 10 17:25 airportdb@airport_reachable.json
-rwxr-xr-x. 1 opc opc     1010 Sep 10 17:25 airportdb@airport_reachable.sql
-rwxr-xr-x. 1 opc opc        9 Sep 10 17:25 airportdb@airport_reachable.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@airport_reachable.tsv.zst.idx
-rwxr-xr-x. 1 opc opc     1209 Sep 10 17:25 airportdb@airport.sql
-rwxr-xr-x. 1 opc opc 23990482 Sep 10 17:25 airportdb@booking@0.tsv.zst
-rwxr-xr-x. 1 opc opc      512 Sep 10 17:25 airportdb@booking@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24787816 Sep 10 17:25 airportdb@booking@10.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@10.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24605829 Sep 10 17:25 airportdb@booking@11.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@11.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24662300 Sep 10 17:25 airportdb@booking@12.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@12.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24598565 Sep 10 17:25 airportdb@booking@13.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@13.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24474339 Sep 10 17:25 airportdb@booking@14.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@14.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24659075 Sep 10 17:25 airportdb@booking@15.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@15.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24460743 Sep 10 17:25 airportdb@booking@16.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@16.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24872813 Sep 10 17:25 airportdb@booking@17.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@17.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24730510 Sep 10 17:25 airportdb@booking@18.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@18.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24664897 Sep 10 17:25 airportdb@booking@19.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@19.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 23821261 Sep 10 17:25 airportdb@booking@1.tsv.zst
-rwxr-xr-x. 1 opc opc      520 Sep 10 17:25 airportdb@booking@1.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24477378 Sep 10 17:25 airportdb@booking@20.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@20.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24603821 Sep 10 17:25 airportdb@booking@21.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@21.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24510521 Sep 10 17:25 airportdb@booking@22.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@22.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24492613 Sep 10 17:25 airportdb@booking@23.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@23.tsv.zst.idx
-rwxr-xr-x. 1 opc opc  7089904 Sep 10 17:25 airportdb@booking@@24.tsv.zst
-rwxr-xr-x. 1 opc opc      160 Sep 10 17:25 airportdb@booking@@24.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 29859055 Sep 10 17:25 airportdb@booking@2.tsv.zst
-rwxr-xr-x. 1 opc opc      648 Sep 10 17:25 airportdb@booking@2.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 22284735 Sep 10 17:25 airportdb@booking@3.tsv.zst
-rwxr-xr-x. 1 opc opc      488 Sep 10 17:25 airportdb@booking@3.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 28336025 Sep 10 17:25 airportdb@booking@4.tsv.zst
-rwxr-xr-x. 1 opc opc      616 Sep 10 17:25 airportdb@booking@4.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24829241 Sep 10 17:25 airportdb@booking@5.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@5.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24574052 Sep 10 17:25 airportdb@booking@6.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@6.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24435530 Sep 10 17:25 airportdb@booking@7.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@7.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24483962 Sep 10 17:25 airportdb@booking@8.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@8.tsv.zst.idx
-rwxr-xr-x. 1 opc opc 24687308 Sep 10 17:25 airportdb@booking@9.tsv.zst
-rwxr-xr-x. 1 opc opc      544 Sep 10 17:25 airportdb@booking@9.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      646 Sep 10 17:25 airportdb@booking.json
-rwxr-xr-x. 1 opc opc     1371 Sep 10 17:25 airportdb@booking.sql
-rwxr-xr-x. 1 opc opc    89932 Sep 10 17:25 airportdb@employee@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@employee@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      883 Sep 10 17:25 airportdb@employee.json
-rwxr-xr-x. 1 opc opc     2016 Sep 10 17:25 airportdb@employee.sql
-rwxr-xr-x. 1 opc opc 10133356 Sep 10 17:25 airportdb@flight@@0.tsv.zst
-rwxr-xr-x. 1 opc opc      256 Sep 10 17:25 airportdb@flight@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      712 Sep 10 17:25 airportdb@flight.json
-rwxr-xr-x. 1 opc opc     1035 Sep 10 17:25 airportdb@flight_log.json
-rwxr-xr-x. 1 opc opc     1827 Sep 10 17:25 airportdb@flight_log.sql
-rwxr-xr-x. 1 opc opc        9 Sep 10 17:25 airportdb@flight_log.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@flight_log.tsv.zst.idx
-rwxr-xr-x. 1 opc opc   172016 Sep 10 17:25 airportdb@flightschedule@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@flightschedule@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      829 Sep 10 17:25 airportdb@flightschedule.json
-rwxr-xr-x. 1 opc opc     1686 Sep 10 17:25 airportdb@flightschedule.sql
-rwxr-xr-x. 1 opc opc     1821 Sep 10 17:25 airportdb@flight.sql
-rwxr-xr-x. 1 opc opc     1199 Sep 10 17:25 airportdb.json
-rwxr-xr-x. 1 opc opc   494930 Sep 10 17:25 airportdb@passenger@@0.tsv.zst
-rwxr-xr-x. 1 opc opc        8 Sep 10 17:25 airportdb@passenger@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc  1672340 Sep 10 17:25 airportdb@passengerdetails@@0.tsv.zst
-rwxr-xr-x. 1 opc opc       32 Sep 10 17:25 airportdb@passengerdetails@@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      748 Sep 10 17:25 airportdb@passengerdetails.json
-rwxr-xr-x. 1 opc opc     1569 Sep 10 17:25 airportdb@passengerdetails.sql
-rwxr-xr-x. 1 opc opc      633 Sep 10 17:25 airportdb@passenger.json
-rwxr-xr-x. 1 opc opc     1183 Sep 10 17:25 airportdb@passenger.sql
-rwxr-xr-x. 1 opc opc      583 Sep 10 17:25 airportdb.sql
-rwxr-xr-x. 1 opc opc 35538282 Sep 10 17:25 airportdb@weatherdata@0.tsv.zst
-rwxr-xr-x. 1 opc opc     1752 Sep 10 17:25 airportdb@weatherdata@0.tsv.zst.idx
-rwxr-xr-x. 1 opc opc  4733492 Sep 10 17:25 airportdb@weatherdata@@1.tsv.zst
-rwxr-xr-x. 1 opc opc      240 Sep 10 17:25 airportdb@weatherdata@@1.tsv.zst.idx
-rwxr-xr-x. 1 opc opc      738 Sep 10 17:25 airportdb@weatherdata.json
-rwxr-xr-x. 1 opc opc     1310 Sep 10 17:25 airportdb@weatherdata.sql
-rwxr-xr-x. 1 opc opc     2586 Sep 10 17:25 @.done.json
-rwxr-xr-x. 1 opc opc      859 Sep 10 17:25 @.json
-rwxr-xr-x. 1 opc opc    46349 Sep 10 17:25 @.manifest.json
-rwxr-xr-x. 1 opc opc      240 Sep 10 17:25 @.post.sql
-rwxr-xr-x. 1 opc opc     4884 Sep 10 17:25 README.txt
-rwxr-xr-x. 1 opc opc      240 Sep 10 17:25 @.sql

安装OCI CLI，OCI Linux 7中居然已经安装好了，还是最新版本。

使用OCI CLI将目录中的数据库文件批量上传到对象存储：

$ oci os object bulk-upload -ns ocichina001 -bn airport --src-dir ~/airport-db

然后将数据库从对象存储导入，并不需要事先建库，会自动建库：

$ mysqlsh root@10.0.1.233
MySQL  10.0.1.233:33060+ ssl  JS > util.loadDump("", {threads: 16, loadIndexes: "false", osBucketName: "airport", osNamespace: "ocichina001", ignoreVersion: true})
Loading DDL and Data from OCI ObjectStorage bucket=airport, prefix='' using 16 threads.
Opening dump...
Target is MySQL 8.0.26-u1-cloud (MySQL Database Service). Dump was produced from MySQL 8.0.26-cloud
Fetching dump data from remote location...
Fetching 14 table metadata files for schema `airportdb`...
Checking for pre-existing objects...
Executing common preamble SQL
Executing DDL script for schema `airportdb`
[Worker005] Executing DDL script for `airportdb`.`flight`
[Worker003] Executing DDL script for `airportdb`.`employee`
[Worker011] Executing DDL script for `airportdb`.`weatherdata`
[Worker012] Executing DDL script for `airportdb`.`booking`
[Worker014] Executing DDL script for `airportdb`.`flight_log`
[Worker006] Executing DDL script for `airportdb`.`passengerdetails`
[Worker010] Executing DDL script for `airportdb`.`flightschedule`
[Worker002] Executing DDL script for `airportdb`.`airport_reachable`
[Worker013] Executing DDL script for `airportdb`.`airplane_type` (indexes removed for deferred creation)
[Worker009] Executing DDL script for `airportdb`.`airplane`
[Worker015] Executing DDL script for `airportdb`.`airline`
[Worker008] Executing DDL script for `airportdb`.`passenger`
[Worker007] Executing DDL script for `airportdb`.`airport`
[Worker000] Executing DDL script for `airportdb`.`airport_geo`
NOTE: [Worker007] Error processing table `airportdb`.`airport`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
[Worker013] airportdb@airplane_type@@0.tsv.zst: Records: 342  Deleted: 0  Skipped: 0  Warnings: 0
[Worker008] airportdb@airline@@0.tsv.zst: Records: 113  Deleted: 0  Skipped: 0  Warnings: 0
[Worker000] airportdb@employee@@0.tsv.zst: Records: 1000  Deleted: 0  Skipped: 0  Warnings: 0
[Worker014] airportdb@airplane@@0.tsv.zst: Records: 5583  Deleted: 0  Skipped: 0  Warnings: 0
[Worker012] airportdb@airport@@0.tsv.zst: Records: 9854  Deleted: 0  Skipped: 0  Warnings: 0
[Worker002] airportdb@flightschedule@@0.tsv.zst: Records: 9881  Deleted: 0  Skipped: 0  Warnings: 0
[Worker006] airportdb@passenger@@0.tsv.zst: Records: 36095  Deleted: 0  Skipped: 0  Warnings: 0
[Worker003] airportdb@airport_geo@@0.tsv.zst: Records: 9854  Deleted: 0  Skipped: 0  Warnings: 0
[Worker005] airportdb@passengerdetails@@0.tsv.zst: Records: 36095  Deleted: 0  Skipped: 0  Warnings: 0
[Worker011] airportdb@flight@@0.tsv.zst: Records: 462553  Deleted: 0  Skipped: 0  Warnings: 0
[Worker004] airportdb@weatherdata@0.tsv.zst: Records: 4082688  Deleted: 0  Skipped: 0  Warnings: 0
[Worker004] airportdb@weatherdata@@1.tsv.zst: Records: 543744  Deleted: 0  Skipped: 0  Warnings: 0
[Worker010] airportdb@booking@3.tsv.zst: Records: 2024926  Deleted: 0  Skipped: 0  Warnings: 0
[Worker001] airportdb@booking@0.tsv.zst: Records: 2160442  Deleted: 0  Skipped: 0  Warnings: 0
[Worker009] airportdb@booking@1.tsv.zst: Records: 2159969  Deleted: 0  Skipped: 0  Warnings: 0
[Worker008] airportdb@booking@6.tsv.zst: Records: 2214973  Deleted: 0  Skipped: 0  Warnings: 0
[Worker002] airportdb@booking@10.tsv.zst: Records: 2214991  Deleted: 0  Skipped: 0  Warnings: 0
[Worker003] airportdb@booking@12.tsv.zst: Records: 2214478  Deleted: 0  Skipped: 0  Warnings: 0
[Worker013] airportdb@booking@5.tsv.zst: Records: 2215073  Deleted: 0  Skipped: 0  Warnings: 0
[Worker012] airportdb@booking@9.tsv.zst: Records: 2214959  Deleted: 0  Skipped: 0  Warnings: 0
[Worker000] airportdb@booking@7.tsv.zst: Records: 2214707  Deleted: 0  Skipped: 0  Warnings: 0
[Worker014] airportdb@booking@8.tsv.zst: Records: 2214781  Deleted: 0  Skipped: 0  Warnings: 0
[Worker005] airportdb@booking@13.tsv.zst: Records: 2215250  Deleted: 0  Skipped: 0  Warnings: 0
[Worker006] airportdb@booking@11.tsv.zst: Records: 2215122  Deleted: 0  Skipped: 0  Warnings: 0
[Worker007] airportdb@booking@4.tsv.zst: Records: 2531382  Deleted: 0  Skipped: 0  Warnings: 0
[Worker015] airportdb@booking@2.tsv.zst: Records: 2699650  Deleted: 0  Skipped: 0  Warnings: 0
[Worker011] airportdb@booking@14.tsv.zst: Records: 2215310  Deleted: 0  Skipped: 0  Warnings: 0
[Worker000] airportdb@booking@@24.tsv.zst: Records: 644485  Deleted: 0  Skipped: 0  Warnings: 0
[Worker004] airportdb@booking@15.tsv.zst: Records: 2215229  Deleted: 0  Skipped: 0  Warnings: 0
[Worker010] airportdb@booking@16.tsv.zst: Records: 2215038  Deleted: 0  Skipped: 0  Warnings: 0
[Worker001] airportdb@booking@17.tsv.zst: Records: 2214973  Deleted: 0  Skipped: 0  Warnings: 0
[Worker009] airportdb@booking@18.tsv.zst: Records: 2215177  Deleted: 0  Skipped: 0  Warnings: 0
[Worker002] airportdb@booking@20.tsv.zst: Records: 2214883  Deleted: 0  Skipped: 0  Warnings: 0
[Worker012] airportdb@booking@23.tsv.zst: Records: 2215175  Deleted: 0  Skipped: 0  Warnings: 0
[Worker008] airportdb@booking@19.tsv.zst: Records: 2214884  Deleted: 0  Skipped: 0  Warnings: 0
[Worker003] airportdb@booking@21.tsv.zst: Records: 2214070  Deleted: 0  Skipped: 0  Warnings: 0
[Worker013] airportdb@booking@22.tsv.zst: Records: 2214692  Deleted: 0  Skipped: 0  Warnings: 0
Executing common postamble SQL

37 chunks (59.50M rows, 2.03 GB) for 12 tables in 1 schemas were loaded in 2 min 6 sec (avg throughput 16.15 MB/s)
0 warnings were reported during the load.

验证数据库已创建，表已导入：

 MySQL  10.0.1.233:33060+ ssl  JS > \sql
Switching to SQL mode... Commands end with ;
 MySQL  10.0.1.233:33060+ ssl  SQL > use airportdb;
Default schema set to `airportdb`.
Fetching table and column names from `airportdb` for auto-completion... Press ^C to stop.

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > select count(*) from flight;
+----------+
| count(*) |
+----------+
|   462553 |
+----------+
1 row in set (0.0134 sec)

添加HeatWave Cluster，默认的2个节点即可。

加载数据到HeatWave，这是Autopilot的特性：

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > CALL sys.heatwave_load(JSON_ARRAY('airportdb'), NULL);
+------------------------------------------+
| INITIALIZING HEATWAVE AUTO LOAD          |
+------------------------------------------+
| Version: 1.15                            |
|                                          |
| Load Mode: normal                        |
| Load Policy: disable_unsupported_columns |
| Output Mode: normal                      |
|                                          |
+------------------------------------------+
6 rows in set (5.2867 sec)

+-----------------------------------------------------------------------------------------------+
| OFFLOAD ANALYSIS                                                                              |
+-----------------------------------------------------------------------------------------------+
| Verifying input schemas: 1                                                                    |
| User excluded items: 0                                                                        |
|                                                                                               |
| SCHEMA                       OFFLOADABLE    OFFLOADABLE     SUMMARY OF                        |
| NAME                              TABLES        COLUMNS     ISSUES                            |
| ------                       -----------    -----------     ----------                        |
| `airportdb`                           14            104     2 table(s) are partially loadable |
|                                                                                               |
| Total offloadable schemas: 1                                                                  |
|                                                                                               |
+-----------------------------------------------------------------------------------------------+
10 rows in set (5.2867 sec)

+-----------------------------------------------------------------------------------------------------------------------------+
| CAPACITY ESTIMATION                                                                                                         |
+-----------------------------------------------------------------------------------------------------------------------------+
| Default load pool for tables: TRANSACTIONAL                                                                                 |
| Default encoding for string columns: VARLEN (unless specified in the schema)                                                |
| Estimating memory footprint for 1 schema(s)                                                                                 |
|                                                                                                                             |
|                                TOTAL       ESTIMATED       ESTIMATED       TOTAL     DICTIONARY      VARLEN       ESTIMATED |
| SCHEMA                   OFFLOADABLE   HEATWAVE NODE      MYSQL NODE      STRING        ENCODED     ENCODED            LOAD |
| NAME                          TABLES       FOOTPRINT       FOOTPRINT     COLUMNS        COLUMNS     COLUMNS            TIME |
| ------                   -----------       ---------       ---------     -------     ----------     -------       --------- |
| `airportdb`                       14        4.16 GiB       56.00 MiB          35              0          35         17.00 s |
|                                                                                                                             |
| Sufficient MySQL host memory available to load all tables.                                                                  |
| Sufficient HeatWave cluster memory available to load all tables.                                                            |
|                                                                                                                             |
+-----------------------------------------------------------------------------------------------------------------------------+
13 rows in set (5.2867 sec)

+---------------------------------------------------------------------------------------------------------------------------------------+
| EXECUTING LOAD                                                                                                                        |
+---------------------------------------------------------------------------------------------------------------------------------------+
| HeatWave Load script generated                                                                                                        |
|   Retrieve load script containing 46 generated DDL command(s) using the query below:                                                  |
|   SELECT log->>"$.sql" AS "Load Script" FROM sys.heatwave_load_report WHERE type = "sql" ORDER BY id;                                 |
|                                                                                                                                       |
| Adjusting load parallelism dynamically per table                                                                                      |
| Using current parallelism of 32 thread(s) as maximum                                                                                  |
|                                                                                                                                       |
| Using SQL_MODE: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
|                                                                                                                                       |
| Proceeding to load 14 tables into HeatWave                                                                                            |
|                                                                                                                                       |
| Applying changes will take approximately 16.97 s                                                                                      |
|                                                                                                                                       |
+---------------------------------------------------------------------------------------------------------------------------------------+
13 rows in set (5.2867 sec)

+----------------------------------------+
| LOADING TABLE                          |
+----------------------------------------+
| TABLE (1 of 14): `airportdb`.`airline` |
| Commands executed successfully: 3 of 3 |
| Warnings encountered: 0                |
| Table loaded successfully!             |
|   Total columns loaded: 4              |
|   Table loaded using 1 thread(s)       |
|                                        |
+----------------------------------------+
7 rows in set (5.2867 sec)

+-----------------------------------------+
| LOADING TABLE                           |
+-----------------------------------------+
| TABLE (2 of 14): `airportdb`.`airplane` |
| Commands executed successfully: 3 of 3  |
| Warnings encountered: 0                 |
| Table loaded successfully!              |
|   Total columns loaded: 4               |
|   Table loaded using 1 thread(s)        |
|                                         |
+-----------------------------------------+
7 rows in set (5.2867 sec)

+----------------------------------------------+
| LOADING TABLE                                |
+----------------------------------------------+
| TABLE (3 of 14): `airportdb`.`airplane_type` |
| Commands executed successfully: 5 of 5       |
| Warnings encountered: 0                      |
| Table loaded successfully!                   |
|   Total columns loaded: 2                    |
|   Table loaded using 1 thread(s)             |
|                                              |
+----------------------------------------------+
7 rows in set (5.2867 sec)

+----------------------------------------+
| LOADING TABLE                          |
+----------------------------------------+
| TABLE (4 of 14): `airportdb`.`airport` |
| Commands executed successfully: 3 of 3 |
| Warnings encountered: 0                |
| Table loaded successfully!             |
|   Total columns loaded: 4              |
|   Table loaded using 1 thread(s)       |
|                                        |
+----------------------------------------+
7 rows in set (5.2867 sec)

+--------------------------------------------+
| LOADING TABLE                              |
+--------------------------------------------+
| TABLE (5 of 14): `airportdb`.`airport_geo` |
| Commands executed successfully: 5 of 5     |
| Warnings encountered: 0                    |
| Table loaded successfully!                 |
|   Total columns loaded: 6                  |
|   Table loaded using 1 thread(s)           |
|                                            |
+--------------------------------------------+
7 rows in set (5.2867 sec)

+--------------------------------------------------+
| LOADING TABLE                                    |
+--------------------------------------------------+
| TABLE (6 of 14): `airportdb`.`airport_reachable` |
| Commands executed successfully: 3 of 3           |
| Warnings encountered: 0                          |
| Table loaded successfully!                       |
|   Total columns loaded: 2                        |
|   Table loaded using 1 thread(s)                 |
|                                                  |
+--------------------------------------------------+
7 rows in set (5.2867 sec)

+----------------------------------------+
| LOADING TABLE                          |
+----------------------------------------+
| TABLE (7 of 14): `airportdb`.`booking` |
| Commands executed successfully: 3 of 3 |
| Warnings encountered: 0                |
| Table loaded successfully!             |
|   Total columns loaded: 5              |
|   Table loaded using 32 thread(s)      |
|                                        |
+----------------------------------------+
7 rows in set (5.2867 sec)

+-----------------------------------------+
| LOADING TABLE                           |
+-----------------------------------------+
| TABLE (8 of 14): `airportdb`.`employee` |
| Commands executed successfully: 3 of 3  |
| Warnings encountered: 0                 |
| Table loaded successfully!              |
|   Total columns loaded: 15              |
|   Table loaded using 1 thread(s)        |
|                                         |
+-----------------------------------------+
7 rows in set (5.2867 sec)

+----------------------------------------+
| LOADING TABLE                          |
+----------------------------------------+
| TABLE (9 of 14): `airportdb`.`flight`  |
| Commands executed successfully: 3 of 3 |
| Warnings encountered: 0                |
| Table loaded successfully!             |
|   Total columns loaded: 8              |
|   Table loaded using 9 thread(s)       |
|                                        |
+----------------------------------------+
7 rows in set (5.2867 sec)

+--------------------------------------------+
| LOADING TABLE                              |
+--------------------------------------------+
| TABLE (10 of 14): `airportdb`.`flight_log` |
| Commands executed successfully: 3 of 3     |
| Warnings encountered: 0                    |
| Table loaded successfully!                 |
|   Total columns loaded: 19                 |
|   Table loaded using 1 thread(s)           |
|                                            |
+--------------------------------------------+
7 rows in set (5.2867 sec)

+------------------------------------------------+
| LOADING TABLE                                  |
+------------------------------------------------+
| TABLE (11 of 14): `airportdb`.`flightschedule` |
| Commands executed successfully: 3 of 3         |
| Warnings encountered: 0                        |
| Table loaded successfully!                     |
|   Total columns loaded: 13                     |
|   Table loaded using 1 thread(s)               |
|                                                |
+------------------------------------------------+
7 rows in set (5.2867 sec)

+-------------------------------------------+
| LOADING TABLE                             |
+-------------------------------------------+
| TABLE (12 of 14): `airportdb`.`passenger` |
| Commands executed successfully: 3 of 3    |
| Warnings encountered: 0                   |
| Table loaded successfully!                |
|   Total columns loaded: 4                 |
|   Table loaded using 1 thread(s)          |
|                                           |
+-------------------------------------------+
7 rows in set (5.2867 sec)

+--------------------------------------------------+
| LOADING TABLE                                    |
+--------------------------------------------------+
| TABLE (13 of 14): `airportdb`.`passengerdetails` |
| Commands executed successfully: 3 of 3           |
| Warnings encountered: 0                          |
| Table loaded successfully!                       |
|   Total columns loaded: 9                        |
|   Table loaded using 1 thread(s)                 |
|                                                  |
+--------------------------------------------------+
7 rows in set (5.2867 sec)

+---------------------------------------------+
| LOADING TABLE                               |
+---------------------------------------------+
| TABLE (14 of 14): `airportdb`.`weatherdata` |
| Commands executed successfully: 3 of 3      |
| Warnings encountered: 0                     |
| Table loaded successfully!                  |
|   Total columns loaded: 9                   |
|   Table loaded using 18 thread(s)           |
|                                             |
+---------------------------------------------+
7 rows in set (5.2867 sec)

+-------------------------------------------------------------------------------+
| LOAD SUMMARY                                                                  |
+-------------------------------------------------------------------------------+
|                                                                               |
| SCHEMA                          TABLES       TABLES      COLUMNS         LOAD |
| NAME                            LOADED       FAILED       LOADED     DURATION |
| ------                          ------       ------      -------     -------- |
| `airportdb`                         14            0          104       5.16 s |
|                                                                               |
+-------------------------------------------------------------------------------+
6 rows in set (5.2867 sec)

Query OK, 0 rows affected (5.2867 sec)

确认以下查询可以利用HeatWave能力（engine RAPID）：

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > EXPLAIN SELECT booking.price, count(*) FROM booking WHERE booking.price > 500 GROUP BY booking.price ORDER BY booking.price LIMIT 10 \G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: booking
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 51306483
     filtered: 33.32999801635742
        Extra: Using where; Using temporary; Using filesort; Using secondary engine RAPID
1 row in set, 1 warning (0.0054 sec)
Note (code 1003): /* select#1 */ select `airportdb`.`booking`.`price` AS `price`,count(0) AS `count(*)` from `airportdb`.`booking` where (`airportdb`.`booking`.`price` > 500.00) group by `airportdb`.`booking`.`price` order by `airportdb`.`booking`.`price` limit 10

执行查询，使用和禁用HeatWave的查询时间为0.1596和9.0713秒，性能提升为56.8倍。

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT booking.price, count(*) FROM booking WHERE booking.price > 500 GROUP BY booking.price ORDER BY booking.price LIMIT 10;
+--------+----------+
| price  | count(*) |
+--------+----------+
| 500.01 |      860 |
| 500.02 |     1207 |
| 500.03 |     1135 |
| 500.04 |     1010 |
| 500.05 |     1016 |
| 500.06 |     1039 |
| 500.07 |     1002 |
| 500.08 |     1095 |
| 500.09 |     1117 |
| 500.10 |     1106 |
+--------+----------+
10 rows in set (0.1596 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SET SESSION use_secondary_engine=OFF;
Query OK, 0 rows affected (0.0004 sec)
 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT booking.price, count(*) FROM booking WHERE booking.price > 500 GROUP BY booking.price ORDER BY booking.price LIMIT 10;
+--------+----------+
| price  | count(*) |
+--------+----------+
| 500.01 |      860 |
| 500.02 |     1207 |
| 500.03 |     1135 |
| 500.04 |     1010 |
| 500.05 |     1016 |
| 500.06 |     1039 |
| 500.07 |     1002 |
| 500.08 |     1095 |
| 500.09 |     1117 |
| 500.10 |     1106 |
+--------+----------+
10 rows in set (9.0713 sec)

运行以下三个可选的查询，未使用HeatWave的查询时间为（9.0642，12.7548，23.3557 ），使用HeatWave的查询时间为（0.0800，2.2155，0.2260）。性能提升分别为（113.3，5.76，103.3）倍。

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
                                             ->     booking.price,
                                             ->     count(*)
                                             -> FROM
                                             ->     booking
                                             -> WHERE
                                             ->     booking.price > 500
                                             -> GROUP BY
                                             ->     booking.price
                                             -> ORDER BY
                                             ->     booking.price
                                             -> LIMIT
                                             ->     10;
+--------+----------+
| price  | count(*) |
+--------+----------+
| 500.01 |      860 |
| 500.02 |     1207 |
| 500.03 |     1135 |
| 500.04 |     1010 |
| 500.05 |     1016 |
| 500.06 |     1039 |
| 500.07 |     1002 |
| 500.08 |     1095 |
| 500.09 |     1117 |
| 500.10 |     1106 |
+--------+----------+
10 rows in set (9.0642 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
                                             ->     airline.airlinename,
                                             ->     AVG(datediff(departure,birthdate)/365.25) as avg_age,
                                             ->     count(*) as nb_people
                                             -> FROM
                                             ->     booking, flight, airline, passengerdetails
                                             -> WHERE
                                             ->     booking.flight_id=flight.flight_id AND
                                             ->     airline.airline_id=flight.airline_id AND
                                             ->     booking.passenger_id=passengerdetails.passenger_id AND
                                             ->     country IN ("SWITZERLAND", "FRANCE", "ITALY")
                                             -> GROUP BY
                                             ->     airline.airlinename
                                             -> ORDER BY
                                             ->     airline.airlinename, avg_age
                                             -> LIMIT 10;
+----------------------+-------------+-----------+
| airlinename          | avg_age     | nb_people |
+----------------------+-------------+-----------+
| Afghanistan Airlines | 45.92612137 |     20570 |
| Albania Airlines     | 46.02485633 |     21804 |
| American Samoa Airli | 46.10098466 |     15249 |
| Angola Airlines      | 45.97214161 |     18539 |
| Argentina Airlines   | 46.03115082 |     21298 |
| Australia Airlines   | 46.07925759 |     19986 |
| Azerbaijan Airlines  | 46.01659919 |     16011 |
| Bahamas Airlines     | 46.22542566 |     22564 |
| Belarus Airlines     | 46.10818585 |     18226 |
| Bhutan Airlines      | 46.13252703 |     22873 |
+----------------------+-------------+-----------+
10 rows in set (12.7548 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
    count(*) as nb_tickets
FROM
    booking, flight, airline, airport_geo
WHERE
    booking.flight_id=flight.flight_id AND
    airline.airline_id=flight.airline_id AND
    flight.from=airport_geo.airport_id AND
    airport_geo.country = "UNITED STATES"
GROUP BY
    airline.airlinename
ORDER BY
    nb_tickets desc, airline.airlinename
LIMIT 10;                                           airline.airlinename,
                                             ->     SUM(booking.price) as price_tickets,
                                             ->     count(*) as nb_tickets
                                             -> FROM
                                             ->     booking, flight, airline, airport_geo
                                             -> WHERE
                                             ->     booking.flight_id=flight.flight_id AND
                                             ->     airline.airline_id=flight.airline_id AND
                                             ->     flight.from=airport_geo.airport_id AND
                                             ->     airport_geo.country = "UNITED STATES"
                                             -> GROUP BY
                                             ->     airline.airlinename
                                             -> ORDER BY
                                             ->     nb_tickets desc, airline.airlinename
                                             -> LIMIT 10;
+----------------------+---------------+------------+
| airlinename          | price_tickets | nb_tickets |
+----------------------+---------------+------------+
| Falkland Is Airlines |   54329614.83 |     216237 |
| Micronesia Airlines  |   53875825.72 |     214275 |
| Brazil Airlines      |   50039222.97 |     199451 |
| Cyprus Airlines      |   47466718.63 |     189493 |
| Yugoslavia Airlines  |   46905122.48 |     186865 |
| Italy Airlines       |   45731672.06 |     182152 |
| Peru Airlines        |   45742817.89 |     182111 |
| Luxembourg Airlines  |   44537553.63 |     177952 |
| Chad Airlines        |   43162776.69 |     172159 |
| Australia Airlines   |   41201251.28 |     164501 |
+----------------------+---------------+------------+
10 rows in set (23.3557 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SET SESSION use_secondary_engine=ON ;
Query OK, 0 rows affected (0.0003 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
                                             ->     booking.price,
                                             ->     count(*)
                                             -> FROM
                                             ->     booking
                                             -> WHERE
                                             ->     booking.price > 500
                                             -> GROUP BY
                                             ->     booking.price
                                             -> ORDER BY
                                             ->     booking.price
                                             -> LIMIT
                                             ->     10;
+--------+----------+
| price  | count(*) |
+--------+----------+
| 500.01 |      860 |
| 500.02 |     1207 |
| 500.03 |     1135 |
| 500.04 |     1010 |
| 500.05 |     1016 |
| 500.06 |     1039 |
| 500.07 |     1002 |
| 500.08 |     1095 |
| 500.09 |     1117 |
| 500.10 |     1106 |
+--------+----------+
10 rows in set (0.0800 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
                                             ->     airline.airlinename,
                                             ->     AVG(datediff(departure,birthdate)/365.25) as avg_age,
                                             ->     count(*) as nb_people
                                             -> FROM
                                             ->     booking, flight, airline, passengerdetails
                                             -> WHERE
                                             ->     booking.flight_id=flight.flight_id AND
                                             ->     airline.airline_id=flight.airline_id AND
                                             ->     booking.passenger_id=passengerdetails.passenger_id AND
                                             ->     country IN ("SWITZERLAND", "FRANCE", "ITALY")
                                             -> GROUP BY
                                             ->     airline.airlinename
ORDER BY
    airline.airlinename, avg_age
LIMIT 10;                                       ORDER BY
                                             ->     airline.airlinename, avg_age
                                             -> LIMIT 10;
+----------------------+-------------+-----------+
| airlinename          | avg_age     | nb_people |
+----------------------+-------------+-----------+
| Afghanistan Airlines | 45.92607116 |     20570 |
| Albania Airlines     | 46.02480595 |     21804 |
| American Samoa Airli | 46.10093492 |     15249 |
| Angola Airlines      | 45.97209191 |     18539 |
| Argentina Airlines   | 46.03110048 |     21298 |
| Australia Airlines   | 46.07920841 |     19986 |
| Azerbaijan Airlines  | 46.01654847 |     16011 |
| Bahamas Airlines     | 46.22537506 |     22564 |
| Belarus Airlines     | 46.10813567 |     18226 |
| Bhutan Airlines      | 46.13247687 |     22873 |
+----------------------+-------------+-----------+
10 rows in set (2.2155 sec)

 MySQL  10.0.1.233:33060+ ssl  airportdb  SQL > SELECT
                                             ->     airline.airlinename,
                                             ->     SUM(booking.price) as price_tickets,
                                             ->     count(*) as nb_tickets
                                             -> FROM
                                             ->     booking, flight, airline, airport_geo
                                             -> WHERE
                                             ->     booking.flight_id=flight.flight_id AND
                                             ->     airline.airline_id=flight.airline_id AND
                                             ->     flight.from=airport_geo.airport_id AND
                                             ->     airport_geo.country = "UNITED STATES"
                                             -> GROUP BY
                                             ->     airline.airlinename
                                             -> ORDER BY
                                             ->     nb_tickets desc, airline.airlinename
                                             -> LIMIT 10;
+----------------------+---------------+------------+
| airlinename          | price_tickets | nb_tickets |
+----------------------+---------------+------------+
| Falkland Is Airlines |   54329614.83 |     216237 |
| Micronesia Airlines  |   53875825.72 |     214275 |
| Brazil Airlines      |   50039222.97 |     199451 |
| Cyprus Airlines      |   47466718.63 |     189493 |
| Yugoslavia Airlines  |   46905122.48 |     186865 |
| Italy Airlines       |   45731672.06 |     182152 |
| Peru Airlines        |   45742817.89 |     182111 |
| Luxembourg Airlines  |   44537553.63 |     177952 |
| Chad Airlines        |   43162776.69 |     172159 |
| Australia Airlines   |   41201251.28 |     164501 |
+----------------------+---------------+------------+
10 rows in set (0.2260 sec)
MySQL HeatWave ML 解决两大难题，应用程序添加机器学习功能难度和耗时问题
2202_75483062的博客
02-13 122
对许多开发人员来说，为 MySQL 应用程序添加机器学习功能困难且耗时。首先，开发人员需要将数据从数据库提取到另一个系统，以创建和部署机器学习模型。将机器学习用于应用程序数据会创建多个孤岛，并延迟数据移动。这还会导致数据库外的数据激增，使其更易受到安全威胁，并增加开发人员在多个环境中进行编程的复杂性。其次，现有服务期待开发人员为机器学习模型训练的专家；否则，模型是次优的，并会降低预测的准确性。最后，大多数现有的机器学习解决方案没有包括相应功能来解释开发人员构建的模型为何会提供某种特定预测。https://m
mysql 8.0一个简易的航班管理系统
weixin_43015673的博客
08-04 408
一 技能目标: 使用 JDBC 操作 MySql 数据库 MySql 数据库的使用 Sql 的使用 二 任务过程： 1、创建数据库表 airinfo 添加测试数据不少于 4 条。要求主键自增 2 创建实体类 AirInfo 根据业务提供需要的构造方法和 setter/getter方法。 3创建 DBUtils 类 实现数据库连接和关闭功能。 4、创建 DAO 接口 AirInfoDao 定义查询所有航班，按日期和目的地查
MySQL 示例数据库大全
MySQL技术
06-12 1304
学习下 MySQL 官方示例数据库
airport.sql
06-19
世界最全机场代码，三字码，四字码，国家，城市sql源码表，支持：案例所属城市 三字代码 所属国家 国家代码 四字代码 机场名称 英文名称  洛杉矶  LAX 美国 US KLAX  洛杉矶机场  LOS ANGELES  伦敦  LHR 英国 GB EGLL  伦敦希思罗机场  LONDON  纽约  JFK 美国 US KJFK  肯尼迪机场  NEW YORK
mysql 加载 airport数据库
weixin_40732161的博客
07-22 101
数据库相关学习资料：https://edu.51cto.com/video/655.htmlMySQL 加载 Airport 数据库 在本文中，我们将探讨如何在 MySQL 数据库中加载 Airport 数据库。Airport 数据库是一个示例数据库，通常用于展示数据库设计和查询技术。我们将通过以下步骤来完成这个任务： ...
Codeforces Round #134 (Div. 2)——B
Learn as if you were to live forever
12-23 494
B. Airport time limit per test 2 seconds memory limit per test 256 megabytes input standard input output standard output Lolek and Bolek are about to travel abroad by pl
mysql+HeatWave测试
qq_37135484的博客
12-18 2031
mysql结合HeatWave, HeatWave 是一种分布式、可扩展、无共享（ shared noting(SN)）、基于内存、混合列式查询处理引擎
airportdatabase:CS 166数据库管理系统| 加州大学河滨分校
04-28
机场数据库 加州大学河滨数据库最终项目（CS 166）
10、OCW_MySQL HeatWave Lakehouse.pdf
03-06
MYSQL生态大会文档
mysql heatwave
06-15
MySQL HeatWave是一个商业版的列式数据库系统（Column-Oriented Database System, COLDBS），它专为大规模数据处理和分析设计，特别是针对行数远大于列数（即宽表）的应用场景。HeatWave是MySQL企业版（MySQL ...
Oracle MySQL HeatWave Lakehouse：数据仓库与AI加速
"OCW_MySQL HeatWave Lakehouse.pdf" 是一份关于Oracle MySQL生态系统的会议文档，主要讨论了MySQL HeatWave Lakehouse这一产品的未来发展方向和特性。MySQL HeatWave是一款专为数据仓库、机器学习以及在线交易处理...
新引擎HeatWave将MySQL查询性能提升400倍
yanpeng_info的博客
01-10 2527
参考资料： https://www.oracle.com/a/ocom/docs/mysql/heatwave-technical-brief.pdf 我刚去MySQL官方文档查个函数，顺便发现一个新东西：HeatWave。 看起来很厉害的样子，貌似要参与OLAP架构的竞争。 我查了一下时间信息，应该是2020年底推出的新功能。 众所周知，MySQL主要是为OLTP场景设计的，OLAP一直是其短板，MySQL这次能否补足短板，在大数据时代巩固其最受欢迎开源数据库的地位？ 我们进一步..
中国机场信息
09-03
总计256机场，里面含有几个通用机场和均用机场，客户率。mysql的sql文件
机场管理系统.zip
最新发布
09-15
这是一个基于客户端-服务器架构的命令行应用程序，采用Flask Restful API、Flask SQLAlchemy和面向对象编程方法开发。程序包括管理员和用户两种角色，管理员可以获取、发布、更新和删除航班数据，而用户可以仅获取数据。通过git克隆项目并安装相关要求，可以下载此控制台应用程序。使用python3执行main.py文件以启动服务器端，然后使用insert_admin.py文件将管理员用户名和密码应用到数据库。对于客户端，管理员可以通过执行admin.py文件进行身份验证和授权后，输入相应的指令如添加、更新、删除、获取等。用户可以通过执行user.py文件并输入出发城市和目的地城市来查看这两个城市之间的单程航班信息。 1、资源项目源码均已通过严格测试验证，保证能够正常运行； 2、项目问题、技术讨论，可以给博主私信或留言，博主看到后会第一时间与您进行沟通； 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用，尤其对于人工智能、计算机科学与技术等相关专业，更为适合； 4、下载使用后，可先查看README.md文件（如有），本项目仅用作交流学习参考，请切勿用于商业用途。
基于php和mysql实现的简易民航订票系统实验
duyaqiong45677的博客
12-23 4661
基于PHP和MySQL实现的民航订票系统实验实验内容实验步骤结果展示 实验内容 实验简述: 民航订票系统主要分为机场、航空公司和客户三方的服务。航空公司提供航线和飞机的资料，机场则对在本机场起飞和降落的航班和机票进行管理，而客户能得到的服务应该有查询航班路线和剩余票数，以及网上订票等功能。客户又可以分为两类：一类是普通客户，对于普通客户只有普通的查询和订票功能，没有相应的机票优惠；另一类是经常旅客，需要办理注册手续，但增加了里程积分功能和积分优惠政策。机场还要有紧急应对措施，在航班出现延误时，要发送相应的信
MySQL示例数据库(MySQL Sample Databases) 之 sakila数据库
SQLplusDB的小院
05-03 7335
MySQL 官方提供了多个示例数据库，在MySQL的学习、开发和实践中具有非常重要的作用，能够帮助初学者更好地理解和应用MySQL的各种功能和特性。这些数据库都可以通过如下官方网址进行下载和安装。
MySQL 测试样例数据Employees
热门推荐
小青龍 的博客
03-24 4万+
MySQL 测试样例数据库 Employees， Employees Sample Database、datacharmer/test_db，airportdb Database
MySQL示例数据库(MySQL Sample Databases) 之 World数据库
SQLplusDB的小院
05-02 4418
MySQL 官方提供了多个示例数据库，在MySQL的学习、开发和实践中具有非常重要的作用，能够帮助初学者更好地理解和应用MySQL的各种功能和特性。这些数据库都可以通过如下官方网址进行下载和安装。
mysql笔记：18. 示例数据库
斌斌(Java)
03-14 1250
MySQL示例数据库是MySQL官方提供的开源项目，旨在帮助用户学习和实践MySQL数据库。一个示例数据库可以提供真实的数据库环境，一般包含了多个表格，每个表格都有不同的结构和数据。通过使用示例数据库，用户可以通过实际操作来学习和理解MySQL数据库的各种功能和特性。MySQL官方网站提供了以下几个示例数据库：employee、world、sakila、airportdb以及menagerie。这些数据库既可以用于日常学习和测试，也可以作为我们设计数据库时的一个参考。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值