欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 robbin:开源的太晚了，不要说Hibernate早就成为事实标准了，连JPA标准都出台了。当然能促进一下竞争的。自从Red Hat收购JBoss，Oracle明显和Red Hat对着干呢。 ahuaxuan:Toplink是被迫才开源的，要
欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入
robbin:开源的太晚了，不要说Hibernate早就成为事实标准了，连JPA标准都出台了。当然能促进一下竞争的。自从Red Hat收购JBoss，Oracle明显和Red Hat对着干呢。
ahuaxuan:Toplink是被迫才开源的，要不实在混不下去了，呵呵，如果他早些开源，现在的orm界或者整个持久界的局面可能就不是现在这样的了
Allen:对于我来说，这意味着将来使用JPA的时候又多了一个非常精良的Provider，不错!
hantsy:要知道,JPA的标准实现是 TopLink，比Hibernate实现JPA早了半年。。。 toplink始于1994年，后来被oracle收购，比hibernate 有资历得多。。。
Arthas.Hui:当初通过Sun2Bin了解到，有TopLink这个东东，Java社区的标准实际上是取决于其用户的多少，东西再好，资历再多，没人用也是白搭。我感觉，从时间成本上来说，TopLink不值得一试，和Hibernate同样的功能，和Hibernate差不多的学习曲线，TopLink我也是大体地看了几眼，我觉得，要精通TopLink并不是一件很简单的事情吧。与其这样，不如就拿Hibernate当压寨夫人好了。TopLink是一个非常早期的产品，最初面向C++，后来也实现了Java的映射。TopLink性能优异，功能强大，并且提供了独特的查询过滤器机制，以及对关系的处理和查询都非常有效，于是，TopLink逐渐从商用化O/R Mapping产品中胜出，成为市场上的最出色的映射产品。也正因为这一点，最大的关系数据库厂商Oracle将其收购，成为提供最强数据库和最强对象映射中间件的厂商。
TopLink虽然强大，但太强大的东西免不了得意忘形，TopLink开始将用户锁死到自己的产品上，查询方式是最突出的。它的查询体系含有很多别扭的概念(在我看来是如此)，但为达到一般O/R产品不能达到的功能，开发者只能接受这些。慢慢地，也产生积怨，再加上其高昂的价格，让很多新老用户望而却步。于是，免费的产品开始崛起。
免费的O/R Mapping工具有很多种，这里只提其中最有影响力的两种：Castor和Hibernate。
Castor是Exolab组织开发的面向Java的包装工具，它最大的特色就是实现了大部分的ODMG OQL规范，在查询上，可以象完全使用一个对象数据库一样类图进行查询(后面会有介绍)。它的原理是通过Java反射API去实现属性的设置和读取。不过由于各种原因，Castor后来的版本更新越来越慢，最终停步在1.0之前，成为至今未出到1.0正式版的O/R Mapping产品。不管怎么样，它还是一个相当不错的产品。
Hibernate是一个现在很火热的O/R Mapping产品，目前已经出到2.0版，它功能一样强大，同样使用Java反射API进行对象的设置，但它的查询语言就是一套比较独特的体系，这一点有点类似TopLink，但Hibernate更具有亲和力，对关系的查询更方便，只不过比起Castor来，在方便性和规范性上还是稍逊一筹。就目前状况而言，Hibernate的用户量和技术支持要强一些。
What are stored procedures in MySQL?May 01, 2025 am 12:27 AMStored procedures are precompiled SQL statements in MySQL for improving performance and simplifying complex operations. 1. Improve performance: After the first compilation, subsequent calls do not need to be recompiled. 2. Improve security: Restrict data table access through permission control. 3. Simplify complex operations: combine multiple SQL statements to simplify application layer logic.
How does query caching work in MySQL?May 01, 2025 am 12:26 AMThe working principle of MySQL query cache is to store the results of SELECT query, and when the same query is executed again, the cached results are directly returned. 1) Query cache improves database reading performance and finds cached results through hash values. 2) Simple configuration, set query_cache_type and query_cache_size in MySQL configuration file. 3) Use the SQL_NO_CACHE keyword to disable the cache of specific queries. 4) In high-frequency update environments, query cache may cause performance bottlenecks and needs to be optimized for use through monitoring and adjustment of parameters.
What are the advantages of using MySQL over other relational databases?May 01, 2025 am 12:18 AMThe reasons why MySQL is widely used in various projects include: 1. High performance and scalability, supporting multiple storage engines; 2. Easy to use and maintain, simple configuration and rich tools; 3. Rich ecosystem, attracting a large number of community and third-party tool support; 4. Cross-platform support, suitable for multiple operating systems.
How do you handle database upgrades in MySQL?Apr 30, 2025 am 12:28 AMThe steps for upgrading MySQL database include: 1. Backup the database, 2. Stop the current MySQL service, 3. Install the new version of MySQL, 4. Start the new version of MySQL service, 5. Recover the database. Compatibility issues are required during the upgrade process, and advanced tools such as PerconaToolkit can be used for testing and optimization.
What are the different backup strategies you can use for MySQL?Apr 30, 2025 am 12:28 AMMySQL backup policies include logical backup, physical backup, incremental backup, replication-based backup, and cloud backup. 1. Logical backup uses mysqldump to export database structure and data, which is suitable for small databases and version migrations. 2. Physical backups are fast and comprehensive by copying data files, but require database consistency. 3. Incremental backup uses binary logging to record changes, which is suitable for large databases. 4. Replication-based backup reduces the impact on the production system by backing up from the server. 5. Cloud backups such as AmazonRDS provide automation solutions, but costs and control need to be considered. When selecting a policy, database size, downtime tolerance, recovery time, and recovery point goals should be considered.
What is MySQL clustering?Apr 30, 2025 am 12:28 AMMySQLclusteringenhancesdatabaserobustnessandscalabilitybydistributingdataacrossmultiplenodes.ItusestheNDBenginefordatareplicationandfaulttolerance,ensuringhighavailability.Setupinvolvesconfiguringmanagement,data,andSQLnodes,withcarefulmonitoringandpe
How do you optimize database schema design for performance in MySQL?Apr 30, 2025 am 12:27 AMOptimizing database schema design in MySQL can improve performance through the following steps: 1. Index optimization: Create indexes on common query columns, balancing the overhead of query and inserting updates. 2. Table structure optimization: Reduce data redundancy through normalization or anti-normalization and improve access efficiency. 3. Data type selection: Use appropriate data types, such as INT instead of VARCHAR, to reduce storage space. 4. Partitioning and sub-table: For large data volumes, use partitioning and sub-table to disperse data to improve query and maintenance efficiency.
How can you optimize MySQL performance?Apr 30, 2025 am 12:26 AMTooptimizeMySQLperformance,followthesesteps:1)Implementproperindexingtospeedupqueries,2)UseEXPLAINtoanalyzeandoptimizequeryperformance,3)Adjustserverconfigurationsettingslikeinnodb_buffer_pool_sizeandmax_connections,4)Usepartitioningforlargetablestoi
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
