1089 Insert or Merge

According to Wikipedia:

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

解题思路:对输入的数组进行插入排序或者是归并排序,中间过程中对数据进行比较,如果与评判数组一致则记录下,下一次排序的结果,若到最终都不一致,则进行另一种排序方式。我是先进行归并排序,在中间过程中寻找是否一致,若没有找到,则进行插入排序。
做这道题的时候傻逼了,一看到归并排序直接上手就写,写了个二分的归并,看结果一直不对,才发现题目中的归并并不是二分的。
编号为2的测试点是个坑,是经过别人提醒才知道的,这道题的插入排序默认一个数字算是属于有序的序列,所以要从两个数字楷开始进行插入排序。

#include<iostream>
#include<stdio.h>
#include<algorithm>
#include<vector>
using namespace std;
vector<int> inVec(105);
vector<int> judgeVec(105);
vector<int> outArr(105);
int n= 0;
//type = 1 merger type = 2 insert
int type = 0;
bool isMerger(vector<int>tempVec){
    int step = 2;
    while (step <= n){
        int flag = 0;
        int begin = 0;
        int end = step;
        while (end < n){
            sort(tempVec.begin() + begin, tempVec.begin() + end);
            begin = end;
            end += step;
        }
        sort(tempVec.begin() + begin, tempVec.begin() + n );

        step *= 2;

        if (type == 1){
            for (int i = 0; i < n; i++){
                outArr[i] = tempVec[i];
            }
            return true;
        }

        for (int i = 0; i < n; i++){
            if (tempVec[i] != judgeVec[i]){
                flag = 1;
                break;
            }
        }
        if (!flag){
            type = 1;
        }
    }
    return false;
}
void insert(vector<int>tempVec){
    //两个数字开始
    for (int i = 2; i <= n; i++){
        int flag = 0;
        sort(tempVec.begin(), tempVec.begin() + i);
        if (type == 2){
            for (int i = 0; i < n; i++){
                outArr[i] = tempVec[i];
            }
            return;
        }
        for (int i = 0; i < n; i++){
            if (tempVec[i] != judgeVec[i]){
                flag = 1;
            }
        }
        if (!flag){
            type = 2;
        }
    }
}
int main(){
    for (; scanf("%d", &n) != EOF;){
        type = 0;
        int temp[100] = { 0 };
        for (int i = 0; i < n; i++){
            scanf("%d", &inVec[i]);
        }
        for (int i = 0; i < n; i++){
            scanf("%d", &judgeVec[i]);
        }
        vector<int>tempVec(inVec);
        if (isMerger(tempVec)){
            cout << "Merge Sort" << endl;
        }
        else{
            cout << "Insertion Sort" << endl;
            insert(tempVec);
        }
        cout << outArr[0];
        for (int i = 1; i < n; i++){
            cout << " " << outArr[i];
        }
        cout << endl;
    }
    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、付费专栏及课程。

余额充值