mysql - InnoDB, Innobase

Innobase Oy was a Finnish company headquartered in Helsinki, Finland. Innobase is best known for being the developer of the InnoDB transactional storage engine for the MySQL open source database system. From 2005 on, Innobase Oy was a subsidiary of Oracle Corporation, which acquired Innobase.^[1] It has been fully merged into Oracle and terminated all business activities as of July 8, 2013.^[2]

History[edit]

In 1995 Heikki Tuuri founded Innobase Oy to develop InnoDB. In September 2000 Innobase Oy started collaboration with MySQL AB, which resulted in the release of MySQL that incorporated InnoDB in March 2001.

InnoDB was originally closed source, but was released to open source after Innobase failed to find a buyer for InnoDB and started collaboration with MySQL. MySQL tried to close a deal with Innobase in the following years, but eventually Oracle acquired Innobase in October, 2005. Oracle eventually also acquired Sun Microsystems, owner of MySQL AB, in January 2010.

External links[edit]

• Innobase Oy on cnet.com,

References[edit]

1. Jump up^ Oracle Announces the Acquisition of Open Source Software Company, Innobase. Retrieved 6 May 2013
2. Jump up^ Innobase Oy historical information in the Finnish Business Information System. Retrieved 28 Aug 2013

출처 - http://en.wikipedia.org/wiki/Innobase

---

InnoDB

Developer(s)	Oracle Corporation
Operating system	Cross-platform
Type	Database engine
License	GNU GPL v2 or proprietary
Website	www.innodb.com

InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign keysupport (Declarative Referential Integrity). It is included as standard in most binaries distributed by MySQL AB, the exception being some OEM versions.

InnoDB became a product of Oracle Corporation after its acquisition of Innobase Oy in October 2005.^[1] The software is dual licensed; it is distributed under the GNU General Public License, but can also be licensed to parties wishing to combine InnoDB in proprietary software.^[2]

MariaDB and Percona Server use a fork of InnoDB called XtraDB by default. XtraDB is maintained by Percona. Oracle InnoDB's changes are regularly imported into XtraDB, and some bug fixes and extra features are added.

Contents

  [hide] 

• 1 Features
• 2 See also
• 3 References
• 4 External links

Features[edit]

InnoDB supports:

• Both SQL and XA transactions
• Tablespaces
• Foreign keys
• FULLTEXT indexes, since MySQL 5.6 and MariaDB 10.0
• Spatial operations, following the OpenGIS standard
• Virtual columns, only in MariaDB^{[citation needed]}

See also[edit]

• Comparison of MySQL database engines

References[edit]

1. Jump up^ "Oracle Announces the Acquisition of Open Source Software Company, Innobase". Oracle. Retrieved 2012-01-30.
2. Jump up^ "Licensing MySQL and InnoDB". InnoDB.com. Retrieved 2008-07-31.

External links[edit]

• Mysqltutorial.org, InnoDB and other table types in MySQL
• Not-so-well-known differences between MyISAM and InnoDB MySQL server storage engines
• The InnoDB Storage Engine, in the MySQL manual.

출처 - http://en.wikipedia.org/wiki/InnoDB