Data is always structure and content, syntax and semantics. In the context of database tables, relationship between tables, queries and their results. Not to say that the dominant idea of relational databases - ideal, but practical, comfortable and allows to describe any scope.
If the database is a collection of tables, the database management system (DBMS) is to support several databases and giving each of them proper functionality in terms of administration, work and reading. Over time, database found a lot of very specific functions that are considered to be the de facto standard, and received its own description language, the work and sampling.
Databases allow us to represent the data set through the system tables, specify relationships between tables, define queries, and form of desired results, and provide two options:
Actually, from the DBMS more is required, you need to provide access code for the purposes of administration or operation (change or read). The user has direct access to the data, but after a certain code available to him a wide spectrum of functions implemented by the DBMS.
The Format, Protocol and General algorithm using a database always known, although the current classification system DBMS demonstrates the great diversity of concepts and options for implementation.
The Basic concept, which, of course, leads from the moment of birth and perfected to this day, represents the Foundation of the design of database management systems - relational model. A database is a set of tables and relationships between them. So it was, is, but it's still not too long.
How to get out of "Skype" "Android"? This question bothers many users. The thing is that the messenger is not so difficult. But there are features that are only for mobile versions. To log out of Skype in this case more difficult than it seems. But i...
The Gadgets on the platform Android regained the lion's share of the market. Developers are continually perfecting the OS, trying to fit the needs of the users, but from year to year admit palpable mistake: forbid the owner to "stuffing" of his gadge...
World of Warcraft is an iconic MMORPG, uniting millions of players around the world. There are many locations and puzzles, secret trails and larger, but rather dangerous paths. Sooner or later, every player chose the side of the Alliance, we have to ...
The Rest of the data model:
They have their niche but in each of them the fundamentals are all the same relational model. In fact, different concepts of data organized in a data system, no doubt, and obviously only one thing: all the data always makes sense.
How to reflect the meaning in formal computer database model? Judging by the few names of the models in the database, a special problem here, but still “pure relational model" of the find the most that neither is practical application: how to call a solved problem processing what adjective to attach to the name of its database - it doesn't matter, it is important that the problem is solved.
The Most basic category, which has important practical significance: the applicability of the system to solve the problem. Here you can all DBMS fall into four main groups:
This is a General classification of modern DBMS.
The Concept of distribution is important, although from a semantic point of view, no matter how distributed database, it is important that it is the correct version of access.
Methods access to data is also important: a site may require. from the database managed by Oracle, but getting/writing here will be not so constructed, as when using MySQL.
Flexibility - the criterion is relative, but in most cases it should be considered. Not every project requires a dynamics and ensure a high level of security access, secure storage and so Many tasks need to be developed accordingly to the application. Selecting a database with limited functionality can lead in the future to unnecessary spending on replacement system which has limited capabilities.
Following tradition, the classification and the functions of the database play a significant role in the development of technical specifications or it project involving large amounts of data. The term “large” may mean specific level of this (image processing) or number of records (text processing).
The functionality of the tasks and expected solutions may exhibit distinct requirements. In particular, the choice of DBMS (classification data):
This issue affects only part of the highlights for the preference of one DBMS to another. There are many applications where the choice of DBMS classification by any criterion is irrelevant. For example, the choice of content management system for the development of the site will put the developer in front of an unambiguous selection of only one specific database.
Modern information DBMS level (classification according to importance and responsibilities):
But the significance and the responsibility is always great not only in the first case. There are many important projects, when there are small amounts of information contribute to the decision-taking.
Usually the first criterion defines as the absolute leader of the Oracle, second MySQL. They have a lot in common, but there are many fundamental differences. When there is a task to connect the web resource to the Oracle database without the use of her own instruments and technologies, many questions arise. Complex connect - not a rarity, and often a simple condition for achieving a solution.
No less number of problems with the delivery of the data occurs at their location in a LAN server MS SQL Server to which a connection is available through several hardware routers.
In fact, in actual practice, all important components: architecture of DBMS, classification of DBMS functionality, variability of the connectivity and bandwidth of communication channels.
Knowledge of DBMS, classification, theory of databases in General, practical experience and other conceptual issues undoubtedly are important. The reliability of the hardware component is very high today, but the question of code quality, and especially its semantics, relevant to this day.
To Provide secure access to the database all DBMS, but what about the common practice of copying databases to backup?
This flawed idea characteristic of the database, located in one file or in multiple files. In the first case, the loss of a single byte or bit will ruin the whole file, and in the second case a shallow copy of the description of a database or files containing the data will lead to unpredictable consequences.
Strangely, the developers of the DBMS is not concerned about these facts, but if they have taken the necessary steps and closed once and for all the question of data availability outside of the system controls them, then there'd be the dilemma for DBMS classification is simplified to a limit:
It is Impossible to control everything, the more experienced the programmer, the more options it leaves to the customer. Close data for external control and changes - so ensure the problem is not solved for a long life.
The Issue of security and availability of data lies beyond any solution. It belongs to the company infrastructure, local area networks, perimeter security, etc.
By itself, data, databases and their management should be as open and accessible while respecting the established, tested by long practice and natural rules requirements.
Considering the different ways of classifying a DBMS, you should pay special attention to the social component in the context of the theory and its applicability in practice.
When there was a LAN and the database is on the server, and DBMS gave access to many users, it was only just: the architecture of the file server is very practical, today is:
Three sides of the same coin. No matter where the database itself, not matter what the chosen DBMS. It is important that the data and code using them should be as mobile and accessible, but to be within the perimeter of the total safety under the watchful protection not only from technological factors (attacks, threats, destructive interference), but also from the behavioral point in the sense of employees developing code or using the data.
Article in other languages:
Alin Trodden - author of the article, editor
"Hi, I'm Alin Trodden. I write texts, read books, and look for impressions. And I'm not bad at telling you about it. I am always happy to participate in interesting projects."
Most popular video is undoubtedly YouTube. On this site you can find videos in almost any category, listen to music, chat (it's sort of social network).you can Also earn, but this requires that you know how to upload videos on You...
Quite often the General impression from the pictures spoil the fine details. It is especially annoying when a good overall portrait shot is ruined facial deformities or signs of fatigue.Modern graphical application allows you to q...
the Procedure for cleaning the print head is required when the paint and dust clog the nozzles from which ink is received. This usually occurs after prolonged inactivity of the equipment – toners there is dust, and they with...
Active work with the device quickly discharges the battery. Many people are faced with a “dead” batteries at the most inopportune moment. Unfortunately, do not always have access to a power outlet or charger. How to so...
the Readability of any test very often to a great degree is determined by the font which is used for his writing. Many users do not want to settle for the ones offered by modern text editors, and try to create your own fonts. Howe...
the Internet is an indispensable condition for comfortable existence of each and every modern person. Today online you can work, shop, communicate with friends and watch TV. To find a person who would not need the Internet, almost...