Life and system database management

We used to live in a world where information about an object almost more important than the material object. When a new person is born, he immediately receives the name inherits the name and the patronymic (downright under the laws of object-oriented programming, whether it's wrong), it give birth to the first document-birth certificate, enter his fingernails in different registers. As it growth and development will multiply and grow the archives of information about it: history, documents in kindergarten and later in school, and later they will be interested in the military, and so throughout life. You may think that all human life is devoted only to various database management system (DBMS) could fill his insatiable information inside. Somehow, inexplicably, we continue to consider themselves – man – the crown of nature, although animals seem to be wiser than we are.

The Majority of people about all these intricacies of information is not particularly think. Just live in peace, occasionally fill in various questionnaires, consent to collect additional information about yourself (or even do not suspect about it). Someone that all the information processes, its functions include database management, including a variety of information. It may be Bank employees, personnel services, archivists, and many others. Even fewer people (programmers and system administrators) brought his own hands to configure and maintain the database management system and sometimes create them. The profession requires programmers to more clearly understand what is information, how to process it and what programs are suitable for this purpose.

Recommended

How to get out of "Skype" on the "Android" and not only

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...

Kingo ROOT: how to use the program to gain administrative rights on Android

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...

How to get from Stormwind to Tanaris: practical tips

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 ...

When teaching the profession of a programmer among other things studied and the database management system Access. Strictly speaking, this tuning is the most stupid, because it provides no real power full servers: concurrent work with one database start blocking the pieces of information and even entire tables with large amounts of data appear crashes and so on. It remains a mystery why all Access is included in the education system, because professional programmers to work with him will not be, and all the rest don't want to know what some of the database management system different from others. Would be better if instead Access’and students were given the skills to work with PostgreSQL and MySQL, along the way explaining the differences between them. However, both these DBMS are working only as a server, that is, to create a complete database will have to develop another client application – something that will work end users. But this path goes all the professional programming, and it is not necessary to invent your own bike.

And that generally includes the concept of professional database management system? First – the opportunity to work with very large volumes of information (electronic catalogue of large bookstores can count the millions of descriptions, each of which you can see the price, the number of available instances, and on which warehouses they are); second-work with many users simultaneously, each of which receives the relevant information (in other words, two sellers can't sell to different clients with a single instance of some rare books). A third option – information is protected from accidental damage in cases where the change started but was not completed correctly. Hypothetically, we can imagine the following situation: the store receives payment by Bank wire, the funds are debited from the buyer's account shall continue to be credited to the shop account, but because of the failure of the second part of the operation was not completed. Competent DBMS both parts of the operations are performed within a single transaction that either completely confirmed (in the case where everything went smoothly) or is countered (any failure). At the level of the buyer it gives you the confidence that if his account debited, the account of the store they are guaranteed to be received.