SelecTViews Artificial Intelligence….how close have we come and what does it take? Check out Watson! You may have seen him on Jeopardy! – Stephen Baker is on the show talking about what was learned with the project. Stephen Baker wrote the book (literally) on the Watson project and all that it entailed – do not miss this show… Watch the […]
Other News
MapReduce
MapReduce MapReduce is a buzzword that has been hard to miss for the last few years. The Google approach to scale has made the concept famous; a fact which they have even patented. This is one of the more interesting data storage techniques where a software development pattern and data persistence have in a sense merged into a single concept. […]
MySQL: GROUP BY in UNION
(Quassnoi) I have a query where I have a custom developed UDF that is used to calculate whether or not certain points are within a polygon (first query in UNION) or circular (second query in UNION) shape.
Get the hint: How to enable support for Oracle-style hints in DB2
(Henrik Loeser) One of the more frequently asked question of DBAs coming from Oracle to DB2 is about how optimizer hints work in DB2. The standard answer we give is that there are no hints of that kind in DB2 and that a cost-based optimizer is used.
All About IDUG – New Discounts – VIP PASS – Recommended LUW Sessions
(Scott Hayes) I have attended EVERY North American IDUG Conference since the first in Chicago in 1988. IMHO, there is simply no better forum for learning about DB2. This year DBI is a GOLD Sponsor of the Anaheim Conference and we’ll be showcasing our newest releases of the DBI Performance Tools for
Housekeeping for ADF Security TEST-ALL Role
(Andrejus Baranovskis) During early development phases of ADF applications, developers tend to use built-in ADF Security role – TEST-ALL. While we can argue if its good or bad practice (myself I would think its bad practice), I will show you today one security related risky scenario, if you forget t
Troubleshooting ORA-12514
(Michael McLaughlin) A student encountered a connection problem with a PHP application that failed to resolve to the database. The steps to validate this are to check the PHP credentials, which are in this older post. Once you’ve done that, you should do:
How to un-confuse SQL Developer with ORA-00932
(Gary Myers) Sometimes SQL Developer will throw back a message like “ORA-00932: inconsistent datatypes: expected NUMBER got -“. One way to get this is to try to execute
All the Pieces: Microsoft Cloud BI Pieces, Part 1
(Mark Kromer) I’m going to try to expand a bit on the posting that I did last month describing different definitions of “Cloud BI” and what that means in Microsoft-speak.
Database Design Example: Curriculum Vitae
(Buck Woody) I’ve explained the database design process in a series of articles that you can find here. In this tutorial, I’ll put that information to good use and design a database from the start of the process to the finish. To keep this example to a single article, I’ll not repeat the information