Introduction Ever wanted to connect to a relational database using Java and didn’t know the URL connection string? Then, this article is surely going to help you from now on. Oracle The JDBC connection properties look as follows: JDBC Driver oracle.jdbc.OracleDriver JDBC Url jdbc:oracle:thin:@localhost:1521/orclpdb1 Hibernate Dialect org.hibernate.dialect.Oracle12cDialect And, if you want to connect using a … Continue reading JDBC Driver Connection URL strings →
10 Older Entries »
The SQL language has one great advantage over procedural, object oriented, and “ordinary” functional programming languages. The fact that it is truly declarative (i.e. a 4GL / fourth generation programming language) means that a sophisticated optimiser can easily transform one SQL expression into another, equivalent SQL expression, which might be faster to execute.
How does this work?
Expression Tree Equivalence
Here’s an introduction to equivalent expression trees from my SQL Masterclass: Let’s assume we want to evaluate the following expression:
A + (A - B)
Now in maths, it can be proven trivially that by the laws of associativity, the above expression …[Read more]
“Many tools now exist to run database software without installing software. From vagrant boxes, to one click cloud install, to a cloud service that doesn’t require any installation, developer ease of use has always been a path to storage platform success.”–Brian Bulkowski.
The fifth interview in the “Big Data: three questions to “ series of interviews, is with Brian Bulkowski, Aerospike co-founder and CTO.
Q1. What is your current product offering?
Brian Bulkowski: Aerospike
is the first in-memory NoSQL database optimized for flash or
solid state drives (SSDs).
In-memory for speed and NoSQL for scale. Our approach to memory is unique – we have built our own file system to access …
One of the most complicated aspects of putting together our database landscape map was dealing with the growing number of (particularly NoSQL) databases that refuse to be pigeon-holed in any of the primary databases categories.
I have begun to refer to these as “multi-model databases” in recognition of the fact that they are able to take on the characteristics of multiple databases. In truth though there are probably two different groups of products that could be considered “multi-model”:
True multi-model databases that have been designed specifically to serve multiple data models and use-cases
FoundationDB, which is being designed to support ACID and NoSQL, but more to the point …
451 Research’s 2013 Database survey is now live at http://bit.ly/451db13 investigating the current use of database technologies, including MySQL, NoSQL and NewSQL, as well as traditional relation and non-relational databases.
The aim of this survey is to identify trends in database usage, as well as changing attitudes to MySQL following its acquisition by Oracle, and the competitive dynamic between MySQL and other databases, including NoSQL and NewSQL technologies.
There are just 15 questions to answer, spread over five pages, and the entire survey should take less than ten minutes to complete.
All individual responses are of course confidential. The results will be published as part of a major research report due during Q2.
The full …[Read more]
One of the leading performance gurus, Kellyn Pederson is letting us know how she is finding the initial months at Pythian and she rightly praises her fabulous team mates Mark Brinsmead, Paul Logan, and Andy Klock.
The famous Oracle Database Junkie – Arup Nanda, blogs more about Interested Transaction Lists.
Universal Connection Pool, Oracle’s next generation …[Read more]
Brief pause of that Sudoku series : I’m working on my object-relational mapping framework code-named Eth.
It’s vaguely similar to Glorp but much simpler and not as intelligent as Glorp. This time, the resurrection of my framework is more like… a rewrite from scratch. It all started on VAST, then I ported it to Dolphin then Squeak and now Pharo. Hopefully, now I will spend more time writing it than porting it! Also, it will exclusively support Pharo. I also decided to write some SUnit tests to make sure I can properly handle PostgreSQL, MySQL and Interbase for the first version. But I am also planning on supporting SQL Server, Oracle, DB2, Access and Firebird. Eventually!
Besides, I’m also …[Read more]
Welcome to Log Buffer, the weekly news update of happenings in the database world.
A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.
Christian …[Read more]
I’m back in the blogosphere!
This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools. I’ll throw in some literature, music and mathematics occasionally.
Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!
10 Older Entries »