SETI - the Search for Extra-Terrestrial Intelligence
I used to be big into sci-fi. I read lots of fascinating stories involving ingeniously crafted aliens. It was very entertaining and thought-provoking.
Like many humans, I looked on with awe as humans found their way into space, peered ever deeper into space (and the universe as it existed long ago), and searched avidly for life on other planets.
In addition to SQL I love games of all kinds. Scrabble is one of my favourite games, so I thought I’d combine these passions and build a scrabble word finder using just SQL!
First up, we need to create a table holding all the letters and the points values for each (adjust the points values accordingly if not using the English edition):
Something a bit different this time. Here’s some formulas relating to databases I’ve learned over the years:
Here's why FIJI Water thinks we should buy "their" water:
In Fiji, rainfall filters through volcanic rock over hundreds of years, adding vital minerals that give FIJI Water its unique and refreshing taste. The water collects in an ancient artesian aquifer deep within the earth, where it is protected from external elements. It's the way nature intended water to be. Untouched.
Here's why I think we should NOT buy this water:
A recurring theme of this blog is that there is more to a relation than being merely a set of tuples. First, a relation is an object which obeys certain rules. The structure of this object is less important as long as it satisfies relational algebra axioms. Second, in previous post we have learned that relations are systems of constraints. The idea that a relation can be viewed as a set of constraints has been promoted in the 90s by Paris Kanellakis. Our intuition, however, is that by narrowing scope to equalities we can leverage powerful machinery of algebraic geometry.
It is common wisdom that database field is firmly grounded in the two math disciplines: predicate logic and set theory. However, neither logic nor set theory are dominant math subjects. Just counting tags at mathoverflow.net can give rough idea of the importance of an individual math topic, and it is evident that algebraic geometry governs the math world. This field is so rich that it spawned new sub-fields, such as category theory.
Oracle Database 12c provides a limit syntax in SQL for a query with the following clause:
I’ve worked with every release of Microsoft Excel, and I know it takes effort to keep up to date with certain releases. Clearly, the Data Analysis eXpression (DAX) Language introduced in Excel 2010 went unnoticed by many, which was sad. DAX is truly a powerful extension to the analytical and modeling approaches in Microsoft Excel.