1089. Insert or Merge (25)【排序】——PAT (Advanced Level) Practise

本文介绍了一个算法问题,通过给定的初始整数序列和部分排序后的序列,判断使用了插入排序还是归并排序,并演示下一迭代步骤。

题目信息

1089. Insert or Merge (25)

时间限制200 ms
内存限制65536 kB
代码长度限制16000 B

Insertion sort iterates, consuming one input element each repetition, and growing a sorted output list. Each iteration, insertion sort removes one element from the input data, finds the location it belongs within the sorted list, and inserts it there. It repeats until no input elements remain.

Merge sort works as follows: Divide the unsorted list into N sublists, each containing 1 element (a list of 1 element is considered sorted). Then repeatedly merge two adjacent sublists to produce new sorted sublists until there is only 1 sublist remaining.

Now given the initial sequence of integers, together with a sequence which is a result of several iterations of some sorting method, can you tell which sorting method we are using?

Input Specification:

Each input file contains one test case. For each case, the first line gives a positive integer N (<=100). Then in the next line, N integers are given as the initial sequence. The last line contains the partially sorted sequence of the N numbers. It is assumed that the target sequence is always ascending. All the numbers in a line are separated by a space.

Output Specification:

For each test case, print in the first line either “Insertion Sort” or “Merge Sort” to indicate the method used to obtain the partial result. Then run this method for one more iteration and output in the second line the resulting sequence. It is guaranteed that the answer is unique for each test case. All the numbers in a line must be separated by a space, and there must be no extra space at the end of the line.

Sample Input 1:
10
3 1 2 8 7 5 9 4 6 0
1 2 3 7 8 5 9 4 6 0
Sample Output 1:
Insertion Sort
1 2 3 5 7 8 9 4 6 0
Sample Input 2:
10
3 1 2 8 7 5 9 4 0 6
1 3 2 8 5 7 4 9 0 6
Sample Output 2:
Merge Sort
1 2 3 8 4 5 7 9 0 6

解题思路

单步验证排序方式即可

AC代码

#include <cstdio>
#include <algorithm>
#include <vector>
using namespace std;
vector<int> a, b, c;
void merge_sort(vector<int>& a, int b, int e, int step){
    for (int i = b; i < e; i += step + step){
        inplace_merge(a.begin() + i, a.begin() + min(e, i + step), a.begin() + min(e, i + step + step));
    }
}
void insert_sort(vector<int>& a, int b, int e){
    while (b + 1 < e && a[b] <= a[b + 1]) ++b;
    if (++b < e){
        while (b > 0 && a[b] < a[b - 1]) {
            swap(a[b], a[b - 1]);
            --b;
        }
    }
}
int main()
{
    int n;
    scanf("%d", &n);
    c.resize(n);
    b.resize(n);
    for (int i = 0; i < n; ++i){
        scanf("%d", &c[i]);
    }
    for (int i = 0; i < n; ++i){
        scanf("%d", &b[i]);
    }
    a = c;
    bool flag = false;
    for (int i = 0; i < n; ++i){
        if (a == b){
            printf("Insertion Sort\n");
            insert_sort(a, 0, n);
            flag = true;
            break;
        }
        insert_sort(a, 0, n);
    }
    if (!flag){
        a = c;
        printf("Merge Sort\n");
        for (int step = 1; step <= n; step += step){
            merge_sort(a, 0, n, step);
            if (a == b){
                merge_sort(a, 0, n, step + step);
                break;
            }
        }
    }
    printf("%d", a[0]);
    for (int i = 1; i < n; ++i){
        printf(" %d", a[i]);
    }
    printf("\n");
    return 0;
}
Oracle中`MERGE INTO`语句和`INSERT OR UPDATE`(通常通过存储过程或条件逻辑实现)存在多方面区别: ### 语法结构 - **MERGE INTO**:是一条独立的SQL语句,其语法为`MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...) WHEN MATCHED THEN [UPDATE sql] WHEN NOT MATCHED THEN [INSERT sql]` ,可以简洁地实现根据匹配条件执行更新或插入操作[^3]。 - **INSERT OR UPDATE**:并非标准的SQL语句,通常需要编写多条SQL语句结合条件判断逻辑来实现。例如,可以先尝试`SELECT`查询记录是否存在,若存在则执行`UPDATE`,不存在则执行`INSERT`。 ### 执行效率 - **MERGE INTO**:在处理批量数据时效率较高。如在对比测试中,`UPDATE`和`MERGE INTO`都更新11522条记录,`UPDATE`耗时5.235分钟,而`MERGE INTO`仅耗时0.234秒钟,性能优势明显[^4]。 - **INSERT OR UPDATE**:由于要多次与数据库交互,需要执行多个SQL语句,在处理大量数据时效率较低。 ### 功能特性 - **MERGE INTO**:是Oracle 9i新增的语法,将`UPDATE`和`INSERT`语句合并为一个操作,通过一张表或子查询的连接条件对另一张表进行操作,匹配上执行`UPDATE`,无法匹配执行`INSERT`,可以更方便地处理数据同步和合并[^1][2]。 - **INSERT OR UPDATE**:需要手动编写条件判断逻辑来决定执行插入还是更新,灵活性较高,但代码复杂度也相应增加。 ### 事务处理 - **MERGE INTO**:作为一个原子操作,整个`MERGE`过程在一个事务中完成,保证数据的一致性。 - **INSERT OR UPDATE**:由于是多条SQL语句,若处理不当,可能会出现部分操作成功、部分失败的情况,需要更细致的事务管理。 ### 示例代码 ```sql -- MERGE INTO示例 MERGE INTO target_table t USING source_table s ON (t.id = s.id) WHEN MATCHED THEN UPDATE SET t.name = s.name WHEN NOT MATCHED THEN INSERT (id, name) VALUES (s.id, s.name); -- INSERT OR UPDATE示例(伪代码) DECLARE v_count NUMBER; BEGIN SELECT COUNT(*) INTO v_count FROM target_table WHERE id = :input_id; IF v_count > 0 THEN UPDATE target_table SET name = :input_name WHERE id = :input_id; ELSE INSERT INTO target_table (id, name) VALUES (:input_id, :input_name); END IF; END; ```
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值