SQL chip can optimize MySQL Data Warehouse can alleviate I/O bottleneck most mainly

Each MySQL database server is equipped with a SQL chip, this is the Kickfire company began to look at the Data Warehouse market a vision.

Kickfire launched the Kickfire Database Appliance beta, which incorporates new SQL chips on April 14. The company says the SQL chip can extract data directly from memory without the need for registers or caches, thus easing the I/O bottleneck that causes slow data queries. The product is scheduled to be put on the market this fall.

By adopting Kickfire technology, a SQL query can be split into a parallel query plan and transmitted to the SQL chip to enable it to process data in parallel. When the queried data is returned in a compressed format from memory, the data flows into the SQL chip and is processed during the inflow.

Steve Dille, vice president of marketing at Kickfire, says the way SQL chips access to existing hardware is similar to how graphics chips connect to the primary server. The SQL chip is like a secondary processor on the primary server. The SQL chip has built-in parallelism to enable applications to meet the load speed of multiple CPUs. In addition, Kickfire provides MySQL with an incremental load feature that enables it to track changes to the source database and then automatically passes these changes to the Kickfire application.

Optimizing query processing and data warehousing

While the Data warehouse market is now dominated by vendors such as IBM, Oracle, and Teradata, open source databases are Greenplum (PostgreSQL based) and Infobright (in collaboration with MySQL) and other companies under the leadership has opened up a territory of their own. TDWI's research director Wayne Eckerson believes Kickfire's technology will help speed MySQL's application in the Data Warehouse market. MySQL has never previously been optimized for query processing and data warehousing, so this is a big step forward. Over the past 1.5 years, we've seen a lot of query accelerators go into the market and quietly retire, trying to improve the query performance of the Data warehouse in a way that is now proving sloppy. Whether Kickfire can break the spell of ups and downs, we still need to take some time to verify.

Dille said Kickfire's decision to focus on the MySQL market has technical and commercial reasons. Most business database applications actually start with open source databases like PostgreSQL, and then modify their code until it essentially becomes another private database that is completely unlike the original database. MySQL supports plug-in storage engines within MySQL's standard. Kickfire can become an integral part of the standard database, so it is still up and down in MySQL's SQL chips and database cores to keep technological innovation. And in business, MySQL is the world's most popular open source database, and most users have not been exposed to such as Kickfire high-performance database applications, so the market potential is still huge.

IDC analyst Henry Morris argues that targeting the target market to customers who have adopted MySQL as a data warehousing solution gives Kickfire a good opportunity to develop. The combination of integrated software and the most popular open source database will undoubtedly attract a lot of market attention.