Sweet Dreams at the EyeO Festival

 

cherryjohn-at-eyeO


I often tell people that you need both a left brain and a right brain to be a software designer: a left brain to analyze and understand, a right brain to dream and wonder. The EyeO Festival which Thao and I just attended in Minneapolis, was food for our right brains.

EyeO is about the intersection of art and code: generative artists (who use data and algorithms to produce works of art), art installations (more...)

Asteroid Explorer Launched

On Monday, we launched Asteroid Explorer at the Harvard-Smithsonian Center for Astrophysics.

Jeremy (@jrwashley), DJ, Kris Robison and I attended the launch event, which you can watch here. My part of the presentation begins at 36:36.

This event was the culmination of NASA’s Asteroid Hackathon event back in October. Remember that?

Here’s the event abstract:

Abstract: In October 2014, NASA’s Asteroid Hackathon event was hosted (with several other NASA partners) at the SETI (more...)

Google IO with User Experience

Google I/O 2015 has just ended.  There are lots of aspects regarding to Google IO.  Lets have a taste of it regarding to user experience.  Hope this is what you would expect from a user experience team.

There are lots of features announced in Google I/O, and you may find a lot of focus have been around user experience this year.

First, for the pre-show, there were planets and a whale flying across multiple screens surrounding (more...)

Kscope15 Scavenger Hunt

Are you attending Kscope15 (#kscope15)?

If yes, then you should join the Kscope15 Scavenger Hunt. We have partnered with the Oracle Development Tools User Group (aka @odtug) and created a fun way to get points and win prizes!

Visit http://kscope15.com/scavenger and register now!

poster_bluebg

Stay tuned to hear more on how we built this and how we are leveraging mobile, IoT and wearable technologies for this fun activity.Possibly Related Posts:

Busy Times Are Afoot

Lots going on here in AppsLab land and in Oracle Applications User Experience (@usableapps). This here is a recap post.

Showing the Oracle Applications User Experience Roadmap to Oracle’s Asia Partners

At the beginning of May, Anthony (@anthonyslai) and Raymond joined a large contingent of the OAUX team in an two-stop tour of Asia. The first stop was Singapore.

Here’s the dynamic duo in action, setting up our demos to show (more...)

Stop That!


"It seems to me that almost everything is a waste of time."
- Norton Juster, The Phantom Tollbooth 

Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:



Stoptimisation - the art of optimisation by not doing the things you don't need to do.

It’s a term we’ve needed for some time now, given the pendulum swing back to the days of yore (meaning pre-9i) with (more...)

That Depends

In every universe there are questions that either:

Have no answer
or
Have an answer that is situation-dependent

and that includes the Oracle universe. Sometimes it’s difficult to get that concept across to the less knowledgeable. Let’s go back to a simple example from a previous post to illustrate this.

In Resurrecting The Dead flashback operations were discussed as an option to restore table data to before an errant update. The post started with this:

 (more...)

Perception Is Everything


"There is much worth noticing that often escapes the eye."
- Norton Juster, The Phantom Tollbooth

Using BULK COLLECT in PL/SQL blocks and procedures can drmatically speed array processing, but it can, if the DBA isn’t prepared, ‘hide’ any errors that occur in the bulk processing list. A ‘plain vanilla’ EXCEPTION handler may not report all errors that are thrown. Let’s look at an example intentionally set up to fail inserts based on data (more...)

Some People’s Kids


"Expectations is the place you must always go to before you get to where you're going. Of course, 
some people never go beyond Expectations, but my job is to hurry them along whether they like it or not."
- Norton Juster, The Phantom Tollbooth

From time to time I find a situation where a developer believes that:


	He or she believes referential integrity is not necessary

or


	He or she is better at enforcing  (more...)

Installing Oracle 12c Client

It's very important to have your SQL client to take full advantage of your local PeopleSoft installation. In this step-by-step tutorial, I will show you how to get your SQL Developer up and running in minutes.

How to Install PeopleSoft on Your Laptop

If you want to have your own local PeopleSoft installation, look no further. This post shows you exactly what I did to install PeopleSoft 9.2 / PeopleTools 8.54 on my Windows 8.1 laptop using Oracle VM Virtualbox.

Too Much Time

SQL> CREATE TABLE EMP
"It's bad enough wasting time without killing it." 
 Norton Juster, The Phantom Tollbooth 

AWR reports were a tremendous improvement over Statspack reports, primarily due to the depth and breadth of the sample data collected. A more detailed report, with extended metrics, provides a better look at what the database is doing during a given interval. Unfortunately this detail can create unusual information, especially in the SQL Elapsed Time section. For (more...)

Columns, Columns Everywhere


"Many of the things which can never be, often are."
- Norton Juster, The Phantom Tollbooth 

Oracle’s most recent database release has an interesting problem involving ANSI joins and tables having 500 or more columns. Yes, this is likely a rare situation in OLTP systems but it exists, nonetheless. [Data warehouses are different and it’s likely that tables of 500 columns or more could exist.] It was brought to light in a forum (more...)

Complex UI’s versus Simple UI’s

A few days ago I attended the AMIS UX & UI event.

During this interesting event, Niels Mansveld from AMIS presented about UX Frameworks. And he started off his presentation with an illustration about how user interfaces can create an “experience”, so to say. This illustration was a movie clip by Pixar, taken from the movie “Lifted”. It was so funny and, if you would watch it, you immediately know what Niels meant!

lifted uiThe day (more...)

Updating SQL Developer to use newer Java version

I was being teased by SQL Developer.

Everytime I started it came nagging about that it was being forced to live in an old Java version called jdk1.7.0_45 and that is was not feeling happy about it.
So, I should remedy this, I thought to myself.

First visit was, inspired by some search-work on the WWW, a file called product.conf. Which offered two possiblities:

java

SetJavaHome to some logical location
or
SetJavaHome to (more...)

Setting up SQL Instant Client on MAC

In doing more work directly from my Macbook Air, I ran into a situation where native connectivity to an Oracle environment was needed.Connectivity over Oracle Instant Client
From experience I have always been a big fan of the Full Oracle client, just because it comes with a lot of tools and utilities for troubleshooting, which makes the actual experience a bit more pleasant.
Looking & asking around, though, I learned fairly quickly that this client is just not (more...)

Extra-cost Option?


"Just because you have a choice, it doesn't mean that any of them 'has' to be right."
 Norton Juster, The Phantom Tollbooth 

In an Oracle forum that I frequent a user posted that he found cardinality values to be severely inflated when using an analytic function. This user posted an example that will be used here to demonstrate the problem. It will also be used to demonstrate another issue that can make this problem (more...)

NoSQL Joke and DBA humor

Once, a very long time ago, I told an old joke about SQL and it was a huge success (not really).
This week I heard a joke that is slightly related to that joke and it made me giggle for a couple of minutes.
Those who know me, knows that I really like to hear jokes but I’m really terrible at telling them – but let’s go for it anyway.

2 DBAs NoSQL walk into (more...)

Learn how free new tool sqld360 can tell you so much about your favorite SQL!

New tool sqld360 is now available! Mauro Pagano released this cool new tool a few hours ago. And yes, it is free for all!

So, what is sqld360? Well, it is an install-nothing free software that tells you a lot about one SQL statement. And if your site has an Oracle Tuning Pack or Diagnostics Pack license, then you get a lot more from sqld360. Sample snapshot below shows you the dynamic menu for a (more...)

How to Open an Email Client with PeopleCode

When there's an email id displayed on a page, wouldn't it be cool for your users to be able click on it and have their email client (like Microsoft Outlook) open up a blank mail with the email id and subject line filled in? Here's how to do it in PeopleCode.