Advantages of database management

Welcome to my “Advantages of database management.” 

Currently, the most popular approach to the organization of information systems is client-server applications, which are based on interaction with the database. For the most part, relational databases are used as a data warehouse, and applications that provide an interface to the database are implemented on the basis of object-oriented programming. This reveals a discrepancy due to the fact that data models used in programming differ from DBMS data models, which entails the need to maintain relationships and correlations between database gambling and objects in programming. The need for such approvals, or impedance, was adopted as a payment for the performance provided by the relational data organization. But is it possible to find another variant of constructing a system in which such a board will be avoided?https://www.blogger.com

Object-oriented databases were the result of combining the principles of object-oriented programming and principles of database management. In one system, the concepts of encapsulation, polymorphism, the inheritance from object-oriented programming and atomicity, integrity, isolation from databases are combined. As a result, we are able to manage large amounts of information using an object-oriented approach.

Object-oriented database (OODB) is able to store objects in the same form in which they will be available for the programming language. This is ensured by the fact that the objects in the OODB belong to a class that includes a set of attributes expressed by simple data types or other classes. Classes are subject to inheritance rules that carry all the benefits: polymorphism, redefining inherited methods, and the ability to dynamically bind.

Each object in the class has an object identifier that is used to uniquely identify this object in the system. The identifier is assigned by the system and does not depend on the state of the object.

In the object model, the storage of references to other objects looks quite convenient, but here there may be other problems associated with referential integrity. For example, when an object is deleted, other objects may have a reference to its identifier. Therefore, the management system of object-oriented databases (DBMS) should not only be a system focused on the software development environment, but also a data management system. There are many features characteristic of relational DBMSs, such as transactions, indexes, detection, and resolution of deadlock, data recovery mechanisms.

The main advantage of the DBMS is that the access to the database objects is organized fairly transparently and the interaction with the database object does not differ from the interaction with the object in memory. This is the main advantage over RDBMS - there is no need to use the query language or CLI interfaces, such as ODBC or ADO.

In the relational model, there are concepts similar to the concept of the object-oriented model, whereby the table in the relational database can be placed in an analogy to the class, the column in the carte is similar to the class attribute, except that the column can contain only simple data types, and the attribute class can contain data of any type. In the SUO-DBA classes have methods that provide the functionality of objects, in relational databases, the functionality is not related to the data. Stored procedures, although they make it possible to bind the behavior of the system to a database, still they are far from an object-oriented approach.

Below is a list of advantages and disadvantages when using a bundle of DBMS or RDBMS with object-oriented programming.

Benefits:

1. Objects in an OO-DBMS can store an arbitrary number of simple types and other objects. Therefore, you can organize a data model as a large class that contains a subset of smaller classes that contain other subsets of classes in turn, and so on. Using the relational model will lead to the creation of numerous tables when working with which you will have to constantly organize joinings of tables. The object is the best model for mapping the real world, rather than relational carts. This is especially true for complex and multifaceted objects. The DBMS is more suitable for processing complex, complex interrelated data and, depending on the complexity of the data, it can exceed the RDBMS by a factor of tens or even thousands of times.

2. Data in the real world usually have hierarchical characteristics. A well-known example with Employees, used in most RDBMSs, is much easier to describe in the DBMS. To determine for the employee whether he is a manager or not, the RDBMS usually introduces an additional field in the Employees table that refers to the employee manager ID or creates a separate table to determine the relationship between the Cells

MySQL database is based on the Linux operating system to develop the database, because Linux is open source, then MySQL is also a free open source database, compared with other large databases such as Oracle, DB2, SQL Server compared to some of the features and stability if, But still many users are still using.

Although MySQL is not the most powerful features, there are many advantages:

1. C and C + + programming language used to prepare, and can use a variety of compilers to test, to ensure the portability of the source code, installation is simple and compact.

2. Support AIX, FreeBSD, HP-UX, Linux, Mac OS, Novell NetWare, OpenBSD, OS / 2 Wrap, Solaris, Windows and other operating systems.

3. Can provide a variety of programming languages API. The programming languages include C, C ++, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.

4. Support multi-threading, so that CPU resources are fully utilized.

5. Optimized SQL query algorithm, effectively improves the query rate.

6.MySQL can not only be used as a standalone application in a client-server network environment, but also as a library embedded in other software.

7. Multi-language support, common encoding such as Japanese Shift_JIS, Chinese GB 2312, BIG5, etc. can be used as the data table name and data column names.

8. Provide TCP / IP, JDBC, and ODBC and other database connections.

9. Provide management tools for managing, checking, optimizing database operations.

10. Support for large databases. Can handle large databases with tens of millions of records.

11. Support a variety of storage engine.

12.Mysql is open source, that is free, you do not need to pay an extra fee.

13.MySQL uses the standard SQL data language form.

14.Mysql has good support for PHP, PHP is the current Web development language.

15.Mysql can be customized, using the GPL protocol, you can modify the source to develop their own Mysql system.

MySQL database also has many advantages, not one by one out, waiting for you to learn in the process of discovery. MySQL can be loved by a large number of small and medium enterprises, I think it is inseparable from these advantages, which not only to meet the needs of small and medium-sized enterprises database, and free open source, making it a place in the database industry. Any kind of product cannot be perfect, users can choose their own needs.

Learning MySQL friends do you also know what are the advantages of it? May wish to tell Xiaobian! And more practical online video tutorials home education platform, please login!