Database is an integral part of most Websites with dynamic content. The purpose of Database is well-ordered storing and processing information of all kinds. This information is mostly introduced as files in TXT, CSV, Excel, DBF or XML format. There are several types of Databases:
-Flat file Database
- Multidimensional Database
-Object-oriented Database (OODB)
- Deductive Database
One of the most important stages in Database Development is modeling of its structure.
Modeling data structure is a complex and responsible process. If the structure is modeled incorrectly or inaccurately, it may entail faulty operations in site’s work (site may work with delays or not process information flows). Today one may often observe such failures as: “The Server is temporary unavailable” or “The Server is busy”. These failures are the result of incorrect Database development. Properly modeled and well developed Database is the basis of effective Website. For processing information stored in a Database programmers use special program or rather program complex – Database Management System (DBMS). Many of Database Management Systems work on “Client- Server” principle, which is a part of “Client- Server” technology. This technology has been popular for a long time, but it is mostly used in the networks of large-scale enterprises. Nowadays, together with Internet evolution this technology becomes more and more popular among software developers. “Client- Server” technology can be introduced in this way:
• Client makes query to the Database of a Server, or rather to the program that process queries.
• This program operates with the Database stored on a Server, formulates an answer according to the query and sends it back to Client.
• Client gets the result, reflects it on display and waits for User’s further actions.
The cycle is being repeated until the User finishes working with Server.
In modeling DBMS it’s very important to secure Database so as to protect it from hackers or unintended deletion. To do this specialists use a complete program for working with DB which is called SQL version. Web-adapted SQL is called mySql. SQL program was developed at the beginning of 70-s by IBM company, based on SEQUEL (Structured English Query Language). Later, for legal reasons SEQUEL was renamed to SQL, when in 1986 the first SQL standard was accepted by ANSI (American National Standards Institute). The purpose of this working was to develop a simple nonprocedural language, available to any user. It’s significant that using SQL doesn’t guarantee Database security. Database should be secured by multimeter methods. IBM company investigated this issue. It was cleared up that most of the companies, worried about safety of the corporative information stored in their DB place high emphasis on Database security against external factors (hackers, unfair competitors etc.). But according to the findings of investigation, it was internal security that was mostly threatened, and internal breaches in particular resulted in corporative leak. It means that reasonably and correctly –modeled Database system is only half of the matter in Database protection. Complex measures on reinforcement of Database Security against external actions and data access restrictions among a company staff are the key to stability and security of this company.
To order Database development and integration.