I just wonder if there are any JDBC implementations (in some extent, as much as possible) for any NoSql DB (opensource or proprietary)?
我只是想知道对于任何NoSql DB(开源或专有)是否有任何JDBC实现(在某种程度上,尽可能多)?
How do you think, is it possible that this implementation will show as good performance as raw API of correspondent NoSql DB?
您如何看待,该实现是否有可能表现出与通讯者NoSql DB的原始API一样出色的性能?
Which parts cannot be implemented (transactions? CallableStatements? etc)?
哪些部分无法实现(事务?CallableStatements?等)?
4 个解决方案
#1
13
SQL-based DBs have more in common than different. JDBC builds on those commonalities. If you take away SQL, most of the rationale for JDBC is gone! Also, NoSQL DBs have pretty widely varying APIs... there's hardly anything to capture under a common set of methods.
基于SQL的DB有许多共同点,而不是不同的。 JDBC建立在这些共性之上。如果你拿走SQL,JDBC的大部分理由都消失了!此外,NoSQL DB具有相当广泛的API ......在一组通用方法下几乎没有任何东西可以捕获。
Short answer: No.
简答:没有。
#2
4
Yes for MongoDB there are several lib available much like JDBC,JPA. use this link I did a test application and i found that performance of the MongoDB is much better than MySQL while performing bulk inserts and fetching large no of records.
对于MongoDB,有几个可用的库很像JDBC,JPA。使用此链接我做了一个测试应用程序,我发现在执行批量插入和获取大量记录时,MongoDB的性能比MySQL好得多。
If you are considering any NoSQL data store i would recommend MongoDB.
如果您正在考虑任何NoSQL数据存储,我会推荐MongoDB。
#3
2
What SUN did those days was to create abstract specifications for all relational database systems so that Java developers can work with them all easily provided the providers create implementations. That is what JDBC is. An abstract front for relational Databases.
SUN当时所做的是为所有关系数据库系统创建抽象规范,以便Java开发人员可以轻松地使用它们,前提是提供程序创建实现。这就是JDBC。关系数据库的抽象前沿。
NoSQl is not Relational and there will need to exists a kind of a NoSQL Connectivity Framework probably led by Oracle so that all NoSQL database providers can implement freely and allow Java Developers access via a common ground.
NoSQl不是关系型的,需要存在一种可能由Oracle领导的NoSQL连接框架,以便所有NoSQL数据库提供程序都可以*实现并允许Java开发人员通过共同点访问。
#4
0
There is a experimental try on this regard please find https://github.com/erh/mongo-jdbc
有关此方面的实验性尝试请访问https://github.com/erh/mongo-jdbc
#1
13
SQL-based DBs have more in common than different. JDBC builds on those commonalities. If you take away SQL, most of the rationale for JDBC is gone! Also, NoSQL DBs have pretty widely varying APIs... there's hardly anything to capture under a common set of methods.
基于SQL的DB有许多共同点,而不是不同的。 JDBC建立在这些共性之上。如果你拿走SQL,JDBC的大部分理由都消失了!此外,NoSQL DB具有相当广泛的API ......在一组通用方法下几乎没有任何东西可以捕获。
Short answer: No.
简答:没有。
#2
4
Yes for MongoDB there are several lib available much like JDBC,JPA. use this link I did a test application and i found that performance of the MongoDB is much better than MySQL while performing bulk inserts and fetching large no of records.
对于MongoDB,有几个可用的库很像JDBC,JPA。使用此链接我做了一个测试应用程序,我发现在执行批量插入和获取大量记录时,MongoDB的性能比MySQL好得多。
If you are considering any NoSQL data store i would recommend MongoDB.
如果您正在考虑任何NoSQL数据存储,我会推荐MongoDB。
#3
2
What SUN did those days was to create abstract specifications for all relational database systems so that Java developers can work with them all easily provided the providers create implementations. That is what JDBC is. An abstract front for relational Databases.
SUN当时所做的是为所有关系数据库系统创建抽象规范,以便Java开发人员可以轻松地使用它们,前提是提供程序创建实现。这就是JDBC。关系数据库的抽象前沿。
NoSQl is not Relational and there will need to exists a kind of a NoSQL Connectivity Framework probably led by Oracle so that all NoSQL database providers can implement freely and allow Java Developers access via a common ground.
NoSQl不是关系型的,需要存在一种可能由Oracle领导的NoSQL连接框架,以便所有NoSQL数据库提供程序都可以*实现并允许Java开发人员通过共同点访问。
#4
0
There is a experimental try on this regard please find https://github.com/erh/mongo-jdbc
有关此方面的实验性尝试请访问https://github.com/erh/mongo-jdbc