Tag: SQL

Categories
Java

High Performance JDBC

High Performance JDBC

vlad_mihalcea High Performance JDBC

Vlad is a software architect, passionate about enterprise systems, high scalability and all sorts of concurrency challenges. He has a gold badge on StackOverflow for Hibernate and Java and his blog features a Hibernate tutorial section with over 60 articles. He is currently writing the High-Performance Java Persistence book.

JDBC has been around for a long time but because the database interaction happens through higher abstraction API (such as JPA/Hibernate or jOOQ), it’s easy to forget that the actual communication plays by the database driver and the database engine rules. This presentation goes through the most common sources of performance bottlenecks: database connection management, batch updates, statement caching, result set fetching and concurrency control mechanisms with practical references for the most common database systems: Oracle, SQL Server, PostgreSQL and MySQL.

Categories
Cloud & Big Data

ToroDB: NoSQL & relational Java database with SQL analytics

ToroDB: NoSQL & relational Java database with SQL analytics

alvaro ToroDB: NoSQL & relational Java database with SQL analytics

Álvaro Hernandez is a 36 year-old IT entrepreneur, based in Madrid, Spain. Founder and CTO at 8Kdata, a database R&D company, he spends most of his time working on the ToroDB project, the first NoSQL-on-SQL database, a MongoDB-compatible database that runs on top of PostgreSQL. He is a passionate software developer and open source advocate. Álvaro is a Java software developer, member of JavaSpecialists.eu, but also a DBA, trainer and frequent lecturer at international conferences. He also founded the PostgreSQL Spanish User Group, one of the largest PUGs in the world, with more than 500 members.

How do you cope with the rise of unstructured data? Do you have different systems for your NoSQL and your SQL databases? How do you perform analytics of NoSQL data? ToroDB is an open-source NoSQL & relational database written in Java. ToroDB transforms NoSQL documents to relational structures and stores them in relational databases like PostgreSQL. ToroDB speaks the MongoDB protocol, being compatible with MongoDB programs and tools. With ToroDB, you can use either SQL or the MongoDB API for queries. ToroDB automatically structures and partitions your NoSQL data. ToroDB also speaks the MongoDB protocol and can replicate live from it. And you can do analytics in pure SQL against Massively Parallel Databases like Greenplum or CitusDB. Join this talk to understand how ToroDB works, what advantages it may bring to your Big Data architecture, and how to hack ToroDB’s Java open source code.