Database Reference
In-Depth Information
19.4.4 Other Limitations
There are other restrictions relating to stored procedures, functions, triggers and
XA transactions . (The acronym XA means extended architecture . The term XA transactions
is often used to describe transactions involving different systems or databases.
For instance, a client application program acting as a transaction manager in one system,
may request information from a database server acting as a resource manager in another
system.) These will not be discussed here; the interested reader is referred to the MySQL
AB Web site [MySQL AB, 2008].
19.5 Summary and Concluding Remarks
Let us summarize what has been discussed in this chapter:
MySQL is the most popular open source DBMS. It runs
on Windows and Unix platforms, and is marketed under
three editions: Standard Edition, Enterprise Edition, and Cluster
Edition.
The MySQL suite consists of a number of important component
programs, including but not confined to: mysqld , mysqld_safe ,
mysql.server , mysqlmanager , mysql_multi , etc.
The official MySQL Web site reports a number of shortcomings
that are being addressed. These include but are not confined to
limitations on joins, limitations on views, limitations on sub-
queries, limitations on server-side cursors, etc.
MySQL has made an impressive entry into the software engineering industry, and for
this reason, it is expected that the product will be around for the foreseeable future.
19.6 Review Questions
1.
Briefly account for the history of MySQL.
2.
Outline the characteristic features of MySQL.
3.
What are the main components of the MySQL suite? Briefly
discuss the functional responsibilities of each component.
4.
Discuss the benefits and shortcomings of MySQL.
 
Search WWH ::




Custom Search