Comments (4)
AntsDB 和 Phoenix 都是 HBase 上的 SQL 解决方案,但是针对不同的场景,有如下几点不同
-
AntsDB 和 MySQL 高度兼容,您可以使用任何 MySQL 在任何操作系统上,任何语言上的驱动程序连接 AntsDB. 我们支持 Windows, Linux, Mac, JDBC, ODBC, PHP, Python, C/C++ 等等。 Phoenix 使用的专门开发的 JDBC 驱动程序,接口的数量和 AntsDB 相差甚远
-
AntsDB 可以兼容诸多开源闭源的工具和开发框架,例如 MySQL 命令行, Navicat, DBeaver, Squirrel, Spring, SnoarQube, Mediawiki, Wordpress 等等。 相对而言,适用于 Phoenix 的工具和应用就少多了。
-
AntsDB 支持复杂事务,包括跨表跨行事务,事务回滚,表锁,行锁,可以用来实现复杂的应用逻辑,所以 AntsDB 和其他主流关系型数据库一样,能够通过 TPC-C 测试,这是 Phoenix 目前欠缺的.
-
AntsDB 支持全文检索,Phoneix 不能
-
AntsDB 的设计目标是低延迟和强一致事务,在大部份情况下,延迟比 Phoenix/HBase 快十倍,响应速度和并发和主流数据库例如 MySQL, PGSQL 处于同一水准。
-
但是 AntsDB 目前处理大批量数据和复杂查询的效率不够高,如果用户有此类需求,可以使用 Spark/SparkSQL 在 AntsDB 的数据上直接处理。而 Phoenix 在这方面做的很好,不论实时查询还是复杂查询都可以在 Phoenix 里面处理。
如果您还有疑问,请告诉我
from antsdb.
二级索引方面,希望您在给仔细对比下。
Sent with GitHawk
from antsdb.
还有大量数据bulkload方面,对比如何?
Sent with GitHawk
from antsdb.
二级索引两者区别不是很大,但是 AntsDB 的索引和表操作是又事务控制的,强一致。Phoenix 在极端情况下二级索引和数据会不一致。
bulkload 没有直接对比,您可以参考一下我们的数据载入测试 https://antsdb.com/en/blog/2018/05/03/353.
在小规模集群下,两者的瓶颈都在 HBase 层
from antsdb.
Related Issues (19)
- Add comparison with Phoenix to README HOT 4
- Tutorial and example wiki page
- 怎么安装使用antsdb HOT 4
- Projects Similar to Ants DB that might be useful HOT 2
- Requirement and Installation HOT 6
- Random error can not connect to antsbd HOT 5
- Fix images on YSCB benchmark page HOT 2
- DB_DATABASE Setting to Use on MySQL App Part HOT 3
- TPCC
- antsdb启动问题 HOT 1
- why can you archive High concurrency
- Part of the sql function does not support HOT 3
- Is there only one contributor working for antsdb? HOT 1
- Add a troubleshooting page in wiki
- Document the metadata table
- Document the table mapping
- Architecture page in wiki
- Configure HBase connection after initialization makes AntsDB out of sync of HBase HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from antsdb.