【C#】SM2C多云平台安全数据库应用

清疚 2022-07-16 04:00 114阅读 0赞

下文为论文中的程序实现进行了英文描述,在此做备份，该应用上传在Github上https://github.com/qqxx6661/SMC\_Yang，欢迎fork。

This is an application for my paper Secure Model based on Multi-cloud for Big Data Storage and Query, published on CBD2016.

It is written by C\# and Mysql UDF.

It mainly realized an prototype with a secure cloud database model based on multi-cloud and consists of all the functions below:

1. Create one/two encrypted databases with Mysql on the server.

2. Support four different operators(+/-/\*/=><).

3. Multithreading.

Other functions are on our agenda.

Runtime environment:

1. Mysql5.6

2. Visual studio 2012

Here we begin (use single cloud database for the example),

Step1: Build the database

Create 2 databases for the client and the server called keystore and serverdatabase seperately.

Key store has two tables and six UDFs: Global\_info, Secret\_column; Add\_cal\_p, Add\_cal\_q, gen\_ck\_m, gen\_ck\_x, mul\_cal\_m, mul\_cal\_x;

![20161003175252491][]

Serverdatabase has two tables and three UDFs: Operator\_result, test; Add\_cal\_ce, Mul\_cal\_ce, Sub\_cal\_ce;

![20161003175258335][]

All the protocols based on UDFs are provided in our code.

Step2: Configure the C\# application

In ConnectToMysql.cs, we can set the Mysql settings.

string clientMysql = "Database=keystore;Data Source=127.0.0.1;User Id=root;Password=root;CharSet=utf8;port=3306";

string serverMysql = "Database=serverdatabase;Data Source=127.0.0.1;User Id=root;Password=root;CharSet=utf8;port=3306"

Step3: Run the application

You can use the visual stuio to run it.

Enjoy!

![20161003180215503][]

![20161003180218871][]

![20161003180222207][]

[20161003175252491]: /images/20220716/c3820ced55a8449f81e0101cf0a6b5a8.png
[20161003175258335]: /images/20220716/bfc8927da91247bc9ce6cd292d6c6419.png
[20161003180215503]: /images/20220716/17891b6a7bb7478c8a0c71e8d726fb74.png
[20161003180218871]: /images/20220716/59686fb7a8df4fefb7177925a3d93817.png
[20161003180222207]: /images/20220716/070bb0180d2d4bcc99f4fc04b1f9dd4e.png