MySQL Point

Introduction
A database is a collection of documents or data, stored in a computer system. For a database to be functional, it must not only large amounts of data well but are easily accessible. In addition, new information and changes should be relatively easy entry. A highly effective database, you must follow a program that requests and information stored on the system maintained. This is referred to as DBMS or management system database. In addition to these functions, all databases have been created, should be constructed from the data integrity of data and high capacity to recover if the equipment fails.
Here are some actions you can perform on a database that contains difficult or impossible to perform at a table.
Call all records that meet certain criteria
Update entry bulk
Cross-reference records in different tables
Perform complex aggregate calculations.
The types of database There are several types of databases, each type of database has its own data model or structure. They are
Flat model: This is a two-dimensional array of data
Hierarchical Model: The model database is like a hierarchical tree like structure
Network Model: This is a file that is stored with a link to other files
Relational Model: The relational model is the most popular type of database and an extremely powerful tool not only to store information, but they also have access. Relational databases are organized in tables. The beauty of a painting, that information can be accessed or added without reorganizing the tables
Relational databases use a program called SQL interface, or Standard Query Language.
Organization / Save normalization Database Database is the process of organizing data in different and unique sets.
For purposes of standardization are:
Reduce or eliminate duplicate data storage, data organization in an efficient structure and logic, the normalization process is to determine which data in each database table to store data. The standardization process is to work with well-defined steps, called normal forms.

Databases may be less than 1 MB or extremely large and complex that can be terabytes, but all databases are typically stored on hard drives or other types of storage and is accessible by a computer.
Accessing information using a DatabaseWhile data storage is a major feature database, users of databases for many of the most important aspect is a quick and easy retrieval of information. In a relational database, it is very easy to take, information on an employee, but also relational databases, add the query performance. Inquiries Inquiries should be established for certain types of information and displays it either in their natural state, or register with data.
Ensure DatabaseObviously, many databases store important and confidential information that should be accessible not only to everyone. Many databases require passwords and other security features to enable them to access information. While some databases via the Internet can be accessed over a network, are closed systems and other databases can be accessed on the spot. Backing up the database has been simplified. Some simple steps can greatly improve security, usually by locking all users except applications and DBA.
But even this restriction does not completely protect your data. The experience of one of the main reasons for breaches security organizations today with applications that connect to databases. Applications do not use security database natively. Instead, they access the database as user "root" and thus constitute a threat to security could.
Some of the best known examples of the use of this risk is that the injection into SQL database, denial of service, buffer overflow known.
SQL injection is not a direct attack on the database. Instead, it benefits from the way many Web applications database access are developed. SQL injection attempts to change the parameters of a web application via a Web form to the SQL statements that are reflected in the database and change compromise its security. If successful, an attacker can hijack the server database and the same privileges to add, delete and modify users who demand. From this point of the database is fully exposed.
Unfortunately, the practice of SQL injection is easy to learn. Fortunately, with a little thought, you can prevent it. The best way to know if you're at risk of a SQL injection attack is to give a single quotation mark in each box on each form in your application and check the results. Some applications will return a message claiming to be a syntax error. Some applications of capture of the error and therefore not all. In both cases, your site to offer some protection against SQL injection is to take, but it is not safe. You can change your level of protection by clicking on the source code of the application
The future security SecurityA new trend is to offer multiple levels of security in a computing environment. These layers can protect multiple firewalls between the Internet and the organization and the firewall of an organization's asset quality.
No Better Time security considerations that go far beyond the database. But the database if any of the protected environment of the whole business, after all, it is usually the most valuable and mission critical knowledge. With a few simple tasks that you can reduce your risk of safety at a reasonable level:
Be aware of safety deficiencies database, such as stored procedures integrated predefined tables, and so on. High stored procedures that can come with the standard database to keep track of weaknesses by intruders. Restrict access and permission to "none", unless the liquidation. Check your applications for holes. Maximize the layers of protection to your database. Journal analysis of your files. Adopting a proactive risk management tools and vulnerability assessment.
ConclusionCompanies with over 50 employees should also consider a practical real security. A real security practice includes a security specialist certified by a reputable organization, and at least partial security manager's time. Depending on the size of your company, a full-time director of security and a security chief may also be the case.