search

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing
http://verdictdb.org
Apache License 2.0
249 stars 66 forks source link

When to add the JDBC driver for Oracle and MS SQL Server. #154

Open ggservice007 opened 6 years ago

ggservice007 commented 6 years ago

When to add the JDBC driver for Oracle and MS SQL Server.

pyongjoo commented 6 years ago

I apologize for a late response. We are currently focusing on changing some of the internal architecture, so are not planning to add more JDBC drivers in a few months.

However, I will keep this issue open to track your request. Also, let me know if you plan to try our system for any commercial needs so that we can add those drivers first. Otherwise, we will first focus on MySQL, Hive, etc. because they are simply free and we can cheaply (and more frequently) test our integration with them.

ggservice007 commented 6 years ago

Many users want to quey the Oracle table with 100 million rows, but it is too slow.

They want to query quickly. How to do with verdictdb?

pyongjoo commented 6 years ago

VerdictDB simply processes a fewer number of rows (100M -> 1M) relying on that in many cases, sample-based answers of aggregate functions (e.g., avg, count, ...) converge fast to the exact aggregates.

We will add drivers for Oracle (or the interface for generic JDBC) in a month or so as we release a major update. Then, you will be able to use VerdictDB against Oracle.

On Wed, Jun 27, 2018 at 9:48 AM, ggservice007 notifications@github.com wrote:

Many users want to quey the Oracle table with 100 million rows, but it is too slow.

They want to query quickly. How to do with verdicts?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/154#issuecomment-400677912, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQYCgKeWpnWCawssCBtGRd1emBHu6q5ks5uA40mgaJpZM4UPhQV .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com

ggservice007 commented 6 years ago

Nice, Thank a lot

theseusyang commented 6 years ago

Great!

pyongjoo commented 6 years ago

@dongyoungy Can you see if our university has any free installation of Oracle or MS SQL Server? If so, we should just use them. Otherwise, I have no idea right at the moment, but we will figure it out.

dongyoungy commented 6 years ago

@pyongjoo There is a service called MiDatabase provided by ITS, and they have both Oracle and MS SQL. Their 'shared database' seems free (not 100% sure), but to request a database instance, we need a shortcode nonetheless.

pyongjoo commented 6 years ago

I see. Can you send an email (cc me and Kristin) to Barzan for a shortcode, explaining the situation?