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

[ggservice007]

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

[pyongjoo]

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]

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]

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 ***@***.***> 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 <#154 (comment)>, 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]

Nice, Thank a lot

[theseusyang]

Great!

[pyongjoo]

@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]

@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]

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