Create secure and Fast Application Data Programs Based on Access

Source: Internet
Author: User
For general desktop software, using Access for engineering data or other data storage is a very common way of processing, and then the Access encryption and cracking technology is everywhere, how to protect your data? There are two ways to encrypt Access: 1) Add a password and 2) Authorize Access. Here we will not describe the content of the explanation, because the two methods are used.

For general desktop software, using Access for engineering data or other data storage is a very common way of processing, and then the Access encryption and cracking technology is everywhere, how to protect your data? There are two ways to encrypt Access: 1) Add a password and 2) Authorize Access. Here we will not describe the content of the explanation, because the two methods are used.

For general desktop software, using Access for engineering data or other data storage is a very common way of processing, and then the Access encryption and cracking technology is everywhere, how to protect your data?

There are two ways to encrypt Access: 1) Add a password and 2) Authorize Access, which is not described here, because the two methods can be easily cracked. Here is a simple and practical method.

First, locate the problem to be solved?

Using Access to store data to solve data security issues, you must be able to support fast data query and SQL query.

For example, the score of the students in the class:

John 99

Li Si 100

I want to be able to query the score between 60 and 60 ~ The list of students between 100 points, but I don't want this data to be directly seen by others without passing through my system (this is required for practical applications). What should I do?

There are two requirements: Fuzzy names, which are not visible to the other party.

I think of how the telegraph was cracked during the Second World War. The Outsiders counted the letters in common articles and obtained the ratio of letters a, B, and c, replace the encrypted power according to the high proportion to obtain the plain text. In the early days, it was really a pair of accuracy. This method is quite good. You may wish to give yourself a comparison table and confuse it so that the hacker can have a dessert first, which is easy to understand. In this way, if you use SQL queries, you only need to convert them. Your data layer can be abstracted and completely transparent to the application.

Then, just in the above method, I believe it cannot meet many requirements. We know that in many cases, the importance of information is different. For example, in the above example, I think the score is important, so hide the score. Even if someone gets the score, it will be depressing if they don't see the score.

How to hide it? Encryption? Yes, encryption is adopted. Encrypt Key Fields by using algorithms such as DES and RES.

But how can I support SQL queries after encryption?

We can use extended functions for processing. Here we will introduce it.

Another method is introduced: I call it "dark data warehouse". For example, if I encrypt the score Using DES, the encrypted data of this algorithm has no rules and is not likely to be queried, I cannot decrypt the data one by one. Can I compare the data?

This is too slow. If you have less data or have less time requirements, you can also. But for analysis, we can consider sacrificing space and adding an Ord field to sort scores before encryption, in this way, you can use binary search to locate your data location and solve your data security problems in a simple and efficient manner.

The key is the idea. It is easy to figure out the implementation.

Based on this idea, I can build a data Schema layer on this layer to encapsulate data access, completely transparent to upper-layer applications, and complete encryption and decryption completely automatically.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.