Database Security and Encryption: Encoding Techniques

Administrations are progressively trusting on the distributed information systems to derive productiveness and efficiency advantages, but at the same clip are going more vulnerable to security menaces. Database systems are an built-in constituent of this distributed information system and keep all the information which enables the whole system to work. A database can be defined as a shared aggregation of logically related informations and a description of this information, designed to run into the information demands of an organisation.

A database system is considered as a aggregation of related informations, database direction system ( DBMS ) – a package that manages ( define, create and maintain ) and controls the entree to the database, and a aggregation of database application ( s ) – a plan that interacts with the database at some point in its executing ( typical illustration is a SQL statement ) along with the DBMS and the database itself.

Administrations have adopted database systems as the key informations direction engineering for decision-making and daily operations. Databases are designed to keep big sums of informations and direction of information involves both specifying constructions for storage of information and providing mechanisms for use of information.

As the information is to be shared among several users the system must avoid anomalous consequences and guarantee the safety of the information stored despite system clangs and efforts at unauthorised entree.

The informations involved here can be extremely sensitive or confidential, therefore doing the security of the informations managed by these systems even more important as any security breach does non impact merely a individual application or user but can hold black effects on the full administration.

Get quality help now
Sweet V

Proficient in: Computer Science

4.9 (984)

“ Ok, let me say I’m extremely satisfy with the result while it was a last minute thing. I really enjoy the effort put in. ”

+84 relevant experts are online
Hire writer

A figure of security techniques have been suggested over the period of clip to undertake the security issues. These can be classified as entree control, illation control, flux control, and encoding.

A Short History

Get downing from the twenty-four hours one when database applications were build utilizing hierarchal and web systems to today ‘s day of the month when we have so many different database systems like relational databases ( RDBMS ) , object-oriented databases ( OODBMS ) , object-relational databases ( ORDBMS ) , eXtended Query ( XQUERY ) ; one factor which was, is, and will be of the extreme importance is the security of the informations involved. Data ever has been a valuable plus for companies and must be protected. Organizations spend 1000000s these yearss in order to accomplish the best security criterions for the DBMS.

Most of an organisations sensitive and proprietary informations resides in a DBMS, therefore the security of the DBMS is a primary concern. When we talk of procuring a DBMS, this is with regard to both the internal and the external users. The internal users are the organisation employees like database decision makers, application developers, and terminal users who merely use the application interface, which fetch its informations from one of the databasesand the external users can be the employees who do non hold entree to the database or an foreigner who has nil to make with the organisation. The other factors which has made informations security more important is the recent rapid growing of the web based information systems and applications and the construct of nomadic databases.

Any knowing or inadvertent event that can adversely impact a database system is considered as a menace to database and database security can be defined as a mechanism that protects the database against such knowing or inadvertent menaces. Security breaches can be classified as unauthorised informations observation, wrong information alteration, and informations inaccessibility, which can take to loss of confidentiality, handiness, unity, privateness, and larceny and fraud. Unauthorized informations observation consequences in revelation of information to users who might non be entitled to hold entree to such sort of information.

A Incorrect data alteration intentional or unwilled leaves the database in an wrong province. Datas can halter the functionality of an full organisation in a proper manner if non available when needed. Thus the security in footings of databases can be loosely classified into entree security and internal security. Access security refers to the mechanisms implemented to curtail any kind of unauthorised entree to the database ; illustrations can be authorization methods such as every user has a alone username and watchword to set up him as a legitimate user when seeking to link to the database. When the user tries to link to the database the login certificates will be checked against a set of usernames and watchword combinations setup under a security regulation by a security decision maker

. Internal security can be referred to as an excess degree of security, which comes into image if person has already breached the entree security such as acquiring clasp of a valid username and watchword, which can assist acquiring entree to the database. So the security mechanism implemented within the database such as coding the informations inside the database can be classed as internal security, which prevents the information to be compromised even if person has got unauthorised entree to the database.

Every organisation needs to place the menaces they might be subjected to and the later appropriate security programs and countermeasures should be taken, taking into consideration their execution costs and effects on public presentation. Addressing these menaces helps the endeavor to run into the conformity and hazard extenuation demands of the most regulated industries in the universe.

How Databases are Vulnerable

Harmonizing to David Knox “Procuring the Database may be the individual biggest action an organisation can take, to protect its assets ” . Most normally used database in an endeavor organisation is relational database. Data is a valuable resource in an endeavor organisation. Therefore they have a really strong demand of purely commanding and pull offing it. As discussed earlier it is the duty of the DBMS to do certain that the information is unbroken secure and confidential as it the component which controls the entree to the database. Enterprise database substructure is capable to an overpowering scope of menaces most of the times. The most common menaces which an Enterprise Database is exposed to are:

  • Excessive Privilege Abuse – when a user or an application has been granted database entree privileges which exceeds the demands of their occupation maps. For illustration an academic institute employee whose occupation merely requires merely the ability to alter the contact information for a pupil can besides alter the classs for the pupil.
  • Legitimate Privilege Abuse – legitimate database entree privileges can besides be abused for malicious intents. We have two hazards to see in this state of affairs. The first 1 is confidential/sensitive information can be copied utilizing the legitimate database entree privilege and so sold for money. The 2nd one and possibly the more common is recovering and hive awaying big sums of information on client machine for no malicious ground, but when the information is available on an end point machine instead than the database itself, it is more susceptible to Trojans, laptop larceny, etc.
  • Privilege Elevation – package exposures which can be found in stored processs, constitutional maps, protocol executions or even SQL statements. For illustration, a package developer can derive the database administrative privileges by working the exposures in a constitutional map.
  • Database Platform Vulnerabilities – any extra services or the operating system installed on the database waiter can take to an authorised entree, informations corruptness, or denial of service. For illustration the Blaster Worm which took advantage of exposure in Windows 2000 to make denial of service.
  • SQL Injection – the most common onslaught technique. In a SQL injection onslaught, the aggressor typically inserts unauthorised questions into the database utilizing the vulnerable web application input signifiers and they get executed with the privileges of the application. This can be done in the internal applications or the stored processs by internal users. Access to full database can be gained utilizing SQL injectionA A
  • Weak Audit – a strong database audit is indispensable in an endeavor organisation as it helps them to carry through the authorities regulative demands, provides research workers with forensics link interlopers to a offense discouraging the aggressors. Database Audit is considered as the last line of database defence. Audit informations can place the being of a misdemeanor after the fact and can be used to associate it to a peculiar user and mend the system in instance corruptness or a denial of service onslaught has occurred. The chief grounds for a weak audit are: it degrades the public presentation by devouring the CPU and disk resources, decision makers can turn off audit to conceal an onslaught, organisations with assorted database environments can non hold a uniform, scalable audit procedure over the endeavor as the audit procedures are alone to database waiter platform
  • Denial of Service – entree to web applications or informations is denied to the intended users. A simple illustration can be crashing a database waiter by working exposure in the database platform. Other common denial of service techniques are data corruptness, web implosion therapy, server resource overload ( common in database environments ) .
  • Database Protocol Vulnerabilities – SQL Slammer worm took advantage of a defect in the Microsoft SQL Server protocol to coerce denial of service conditions. It affected 75,000 victims merely over 30 proceedingss dramatically decelerating down general cyberspace traffic. [ Analysis of BGP Update Surge during Slammer Worm Attack ]
  • Weak Authentication – obtaining legitimate login certificates by improper manner contributes to weak hallmark strategies. The aggressors can derive entree to a legitimate users login inside informations by assorted ways: by repeatedly come ining the username/password combination until he finds the one which works ( common or weak watchwords can be guessed easy ) , by converting person to portion their login certificates, by stealing the login certificates by copying the watchword files or notes.
  • Backup Data Exposure – there are several instances of security breaches affecting larceny of database backup tapes and difficult discs as this media is thought of as least prone to onslaught and is frequently wholly unprotected signifier onslaught [ 3 ] .

All these security menaces can be accounted for unauthorised informations observation, wrong informations alteration and informations inaccessibility. A complete information security solution must take into consideration the secrecy/confidentiality, unity and handiness of informations. Secrecy or confidentiality refers to the protection of informations against unauthorised revelation, unity refers to bar of wrong informations alteration and handiness refers to bar of hardware/software mistakes and malicious informations entree denials doing the database unavailable.

Security Techniques

As organisations increase their acceptance of database systems as the key informations direction engineering for daily operations and decision-making, the security of informations managed by these systems has become important. Damage and abuse of informations affect non merely a individual user or application, but may hold black effects on the full organisation. There are four chief control steps which can be used to supply security of informations in databases. These are:

  • Access Control
  • Inference Control
  • Flow Control
  • Data Encoding

Literature Review

Secure and secret agencies of communicating has been ever desired for in the field of database systems. There is ever a possibility of interception by a party outside of the sender-receiver sphere when information is transmitted. Modern digital-based encoding methods form the footing of today ‘s universe database security. Encoding in its earlier yearss was used by military and authorities organisations to ease secret information but in present times it is used for protecting information within many sorts of civilian systems. In 2007 the U.S. authorities reported that 71 % of companies surveyed utilised encoding or some of their informations in theodolite.


Encoding is defined as the procedure of transforming information ( plaintext ) utilizing an encoding algorithm ( cypher ) into indecipherable signifier ( encrypted information called as ciphertext ) doing it unaccessible to anyone without possessing particular cognition to decode the information. ” The encryption of the informations by a particular algorithm that renders the informations indecipherable by any plan without the decoding key ” , is called encoding.

The codification and cypher are the two methods of coding informations. The encoding of informations or a message is accomplished by one, or both, of the methods of encoding or coding. Each involves distinguishable methodological analysiss and the two are differentiated by the degree at which they are carried out. Encoding is performed at the word or block degree and trades with the use of groups of characters. Coding plants at the character degree. This includes scrambling single characters in a message, referred to as heterotaxy, and permutation, or replacing characters with others.

Codes by and large are designed to replace full words or blocks of informations in a message with other words or blocks of informations. Languages can be considered codifications, since words and phrases represent thoughts, objects, and actions. There are codifications that replacement full phrases or groups of Numberss or symbols with others. A individual system may use both degrees of encoding.

For illustration, see a codification encoding strategy as follows: the = jam, adult male = barn, is = fly, unsafe = remainder.

Then the message, the adult male is unsafe, would read in encrypted signifier, jam barn fly remainder. Although overly-simplistic, this illustration illustrates the footing of codifications. With the coming of electrical-based communications, codifications became more sophisticated in reply to the demands of the systems. For illustration, the innovations of Morse codification and the telegraph dictated a demand for unafraid transmittal that was more sophisticated. Codes are really susceptible to interrupting and possess a big exposure surface with respect to interception and decoding via analysis. Besides, there are no easily-implemented agencies by which to observe breaches in the system.

The other method of encoding is the cypher. Alternatively of replacing words or blocks of Numberss or symbols with others, as does the codification, the cypher replaces single or smaller sets of letters, Numberss, or characters with others, based on a certain algorithm and key. Digital information and information, including picture, sound, and text, can be separated into groups, or blocks, of spots, and so manipulated for encoding by such methods as XOR ( sole OR ) , encoding-decoding, and rotary motion. As an illustration, allow us analyze the rudimentss of the XOR method. Here, a group of spots ( e.g. , a byte ) of the information is compared to a digital key, and the exclusive-or operation is performed on the two to bring forth an encrypted consequence. Figure 2 illustrates the procedure.

When the exclusive-or operation is performed on the plaintext and key, the ciphertext emerges and is sent. The receiving system performs the exclusive-or operation on the ciphertext and the same key, and the original plaintext is reproduced.

Encoding can be reversible and irreversible. Irreversible techniques do non let the encrypted informations to be decrypted, but at the same clip the encrypted informations can be used to obtain valid statistical information. Irreversible techniques are seldom used as compared to the reversible 1s. The whole procedure of conveying informations firmly over an insecure web system is called as cryptosystem that includes

  • An encoding key to code the information ( plaintext )
  • An encoding algorithm that transforms the plaintext into encrypted information ( ciphertext ) with the encoding key
  • A decoding key to decode the ciphertext
  • A decoding algorithm that transforms the ciphertext back into plaintext utilizing the decoding cardinal.

Encoding Techniques

The ends in digital encoding are no different than those of historical encoding strategies. The difference is found in the methods, non the aims. Secrecy of the message and keys are of paramount importance in any system, whether they are on parchment paper or in an electronic or optical format . Assorted encoding techniques are available and loosely can be classified into two classs ; asymmetric and symmetric encoding.

In symmetric encoding the transmitter and receiving system portion the same algorithm and key for encoding and decoding and depends on safe communicating web for encoding cardinal exchange whereas in asymmetric encoding uses different keys for encoding and decoding. Asymmetrical encoding gave birth to the construct of public and private keys and is preferred to symmetric encoding being more secure.

Symmetrical Encoding

Symmetrical encoding besides known as single-key encoding or conventional encoding was the lone encoding and by far the most widely used of the two types before the construct of public-key encoding came into image. The figure below illustrates the symmetric encoding procedure. The original message ( plaintext ) is converted into seemingly random information ( ciphertext ) utilizing an algorithm and a key. The key is a value independent of the plaintext. The algorithm produces different end products for specific keys used at the clip i.e. the end product of the algorithm alterations if the key is changed. The ciphertext produced is so transmitted and is transformed back to the original plaintext by utilizing a decoding algorithm and the same key that was used for encoding.

The theoretical account can be better understood by the undermentioned illustration. A beginning produces a message X = [ X1, X2, X3 XM ] in plaintext. The M elements of Ten are letters in some finite alphabet. The alphabet normally consisted of 26 capital letters traditionally but today ; binary alphabet { 0,1 } is used. An encoding key K = [ K1, K2, K3 KJ ] is generated and is shared between the transmitter and the receiving system utilizing a secure channel. Besides a 3rd party can bring forth the encoding key and firmly present it to both the transmitter and the receiving system. Using the plaintext Ten and the encoding cardinal K as input, the encoding algorithm produces the ciphertext Y = [ Y1, Y2, Y3 YN ] as

Y = EK ( X )

where Tocopherol is the encoding algorithm and the ciphertext Y is produced as the map of the plaintext X utilizing E. At the receiving system ‘s terminal the ciphertext is converted back to the plaintext as

Ten = DK ( Y )

where D is the decoding algorithm.

The common symmetric block cyphers are Data Encryption Standard ( DES ) , Triple DES, and Advanced Encryption Standard ( AES )

The Data Encryption Standard

Data Encryption Standard has been used in the most widely used encoding strategies including Kerberos 4.0. The National Bureau of Standards adopted it as a criterion in 1977 . DES operates on 64-bit blocks utilizing a 56-bit key. Like other encoding strategies, in DES there are two inputs to the encoding map, the plaintext to be encrypted and the key. The plaintext should be of 64 spots in length and the cardinal length is 56 spots obtained by depriving off the 8 para spots, disregarding every 8th spot from the given 64-bit key.

The end product from the algorithm after 16 unit of ammunitions of indistinguishable operations is the 64-bit block of ciphertext. A suited combination of substitutions and combinations ( 16 times ) on the plaintext is the basic edifice block of the DES. Same algorithm is used for both encoding and decoding except for treating the cardinal agenda in the contrary order.

The 64-bit plaintext is passed through an initial substitution ( IP ) that produces a permuted input by rearranging the spots. This is followed by16 unit of ammunitions of the same map, which involves both substitution and permutation functions.A The last unit of ammunition consequences in the end product dwelling of 64-bits that are a map of the input plaintext and the key. The left and the right halves of the end product are swapped to bring forth the preoutput. The preoutput is passed through a concluding substitution ( IP-1 ) , an opposite of the initial substitution map to accomplish the 64-bit ciphertext. The overall procedure for DES is explained in the diagram below

The right manus side of the diagram explains how the 56-bit key is used during the procedure. The key is passed through a substitution map ab initio and so for each of the 16 rounds a subkey ( Ki ) is generated, by uniting left round displacement and a substitution. For every unit of ammunition the substitution map is same, but the subkey is different because of the perennial loop of the cardinal spots.

Since the acceptance of DES as a criterion, there have ever been concerns about the degree of security provided by it. The two countries of concern in DES are the cardinal length and that the design standard for the internal construction of the DES, the S-boxes, were classified. The issue with the cardinal length was, it was reduced to 56 spots from 128 spots as in the LUCIFER algorithm [ add a new mention ] , which was the base for DES and everyone suspected that this is an tremendous lessening doing it excessively short to defy brute-force onslaughts. Besides the user could non be made certain of any weak points in the internal construction of DES that would let NSA to decode the messages without the benefit of the key. The recent work on differential cryptanalytics and subsequent events indicated that the internal construction of DES is really strong.

Triple DES

Triple DES was developed as an option to the possible exposure of the criterion DES to a brute-force onslaught. It became really popular in Internet-based applications. Triple DES uses multiple encodings with DES and multiple keys as shown in the figure [ below ] . Triple DES with two keys is comparatively preferable to DES but Triple DES with three keys is preferable overall. The plaintext P is encrypted with the first key K1, so decrypted with the 2nd cardinal K2 and so eventually encrypted once more with the 3rd cardinal K3.According to the figure the ciphertext C is produced as

C = EK3 [ DK2 [ EK1 [ P ] ]

These keys need to be applied in the contrary order while decoding. The ciphertext degree Celsius is decrypted with the 3rd key K3 foremost, so encrypted with the 2nd key K2, and so eventually decrypted once more with the first cardinal K1 ; besides called as Encrypt-Decrypt-Encrypt ( EDE ) manner, bring forthing the plaintext P as

P = DK1 [ EK2 [ DK3 [ C ] ]

Encoding in Database Security

Organizations are progressively trusting on, perchance distributed, information systems for day-to-day concern ; hence they become more vulnerable to security breaches even as they gain productiveness and efficiency advantages. Database security has gained a significant importance over the period of clip. Database security has ever been about protecting the information – information in the signifier of client information, rational belongings, fiscal assets, commercial minutess, and any figure of other records that are retained, managed and used on the systems.

The confidentiality and unity of this information needs to be protected as it is converted into information and cognition within the endeavor. Core endeavor informations is stored in relational databases and so offered up via applications to users. These databases typically store the most valuable information assets of an endeavor and are under changeless menace, non merely from the external users but besides from the legitimate users such as sure insiders, ace users, advisers and spouses – or possibly their unprotected user histories – that compromise the system and take or modify the information for some inappropriate intent.

To get down with, sorting the types of information in the database and the security needs associated with them is the first and of import measure. As databases are used in a battalion of ways, it is utile to hold some of the primary maps characterized in order to understand the different security demands. A figure of security techniques have been developed and are being developed for database security, encoding being one of them.

Encoding is defined as the procedure of transforming information ( plaintext ) utilizing an encoding algorithm ( cypher ) into indecipherable signifier ( encrypted information called as ciphertext ) doing it unaccessible to anyone without possessing particular cognition to decode the information. “The encryption of the informations by a particular algorithm that renders the informations indecipherable by any plan without the decoding key ” , is called encoding.

Access Encoding

There are multiple grounds for entree control to confidential information in endeavor computer science environments being disputing. Few of them are: First, the figure of information services in an endeavor computer science environment is immense which makes the direction of entree rights indispensable. Second, a client might non cognize which entree rights are necessary in order to be granted entree to the requested information before bespeaking entree. Third, flexible entree rights including context-sensitive restraints must be supported by entree control

Access control strategies can be loosely classified in two types: proof-based and encryption-based entree control schemes. In a proof-based strategy, “a client needs to piece some entree rights in a cogent evidence of entree, which demonstrates to a service that the client is authorized to entree the requested information ” . Proof-based entree control is preferred to be used for scenarios where client specific entree rights required are flexible.

It becomes easy to include support for restraints if the entree rights are flexible. However, it is non the same instance for covert entree demands. Harmonizing to the bing designs, it is assumed that a service can inform a client of the nature of the needed cogent evidence of entree. The service does non necessitate to turn up the needed entree rights, which can be an expensive undertaking, in proof-based entree control strategy.

In an encryption-based access-control strategy, confidential information is provided to any client in an encrypted signifier by the service. Clients who are authorized to entree the information have the corresponding decoding key. Encryption-based access-control strategy is attractive for scenarios where there are tonss of questions to a service screening the service from holding to run client-specific entree control. As compared to proof-based entree control it is straightforward to add support for covert entree demands to bing encryption-based architectures.

In peculiar, all the information is encrypted by the service as usual, but the client is non told about the corresponding decoding key to utilize. The client has a set of decoding keys, the client now needs to seek this set for a duplicate key. On the other manus, sing that cardinal direction should stay simple, it is less straightforward to add support for restraints on entree rights to the proposed architectures.

Encryption-Based Access Control

Encryption-based entree control is attractive, in instance there are tonss of petitions for the same information, as it is independent of the single clients publishing these petitions. For illustration, an information point can be encrypted one time and the service can utilize the ciphertext for replying multiple petitions. However, covering with restraints on entree rights and with coarseness cognizant entree rights becomes hard with the unvarying intervention of petitions. Further challenges are presented in instances of covert entree demands and service-independent entree rights. The chief demands for encoding based entree control are:

  • Any cognition about the used encoding key or the needed decoding key must non be revealed by the encrypted information.
  • For decoding encrypted information, each value of a restraint must necessitate a separate key that should be accessible merely under the given constraint/value combination and we want a strategy that supports hierarchal restraints to do cardinal direction simple.
  • The decoding key for farinaceous information should be derivable from the key for powdered information to further simplify cardinal direction.
  • A individual decoding key will be used to decode the same information offered by multiple services as implied by the service-independent entree rights. Because of this, same information can be accessed by a service coding information offered by other services in a symmetric cryptosystem. This job can be avoided by utilizing asymmetric cryptosystem.

Encryption-Based Access Control Techniques

An access-control architecture will be an ideal one if the entree rights are simple to pull off ; the system is constrainable and is cognizant of coarseness. The architecture besides has to be asymmetric, provide identity, and be personalizable in the instance of proof-based entree control. Some common encryption-based entree control techniques are:

  • Identity Based Encryption – An identity-based encoding strategy is specified by four randomised algorithms:
  • Apparatus: takes a security parametric quantity K and returns system parametric quantities and master-key. The system parametric quantities include a description of a finite message infinite m and a description of a finite ciphertext infinite c. Intuitively, the system parametric quantities will be publically known, while the master-key will be known merely to the “ Private Key Generator ” ( PKG ) .
  • Infusion: takes as input system parametric quantities, master-key, and an arbitrary ID Iµ { 0,1 } * , and returns a private key d. ID is an arbitrary twine which is so used as a public key, and vitamin D is the corresponding private decoding key. The Extract algorithm extracts a private key from the given public key.
  • Encrypt: takes as input system parametric quantities, ID, and M Iµ m. It returns a ciphertext C Iµ degree Celsius.
  • Decrypt: takes as input system parametric quantities, C Iµ degree Celsius, and a private key d. It returns M Iµ m.

Cite this page

Database Security and Encryption: Encoding Techniques. (2017, Sep 14). Retrieved from

Database Security and Encryption: Encoding Techniques
Let’s chat?  We're online 24/7