Toad World

Blogs

Iggy Fernandez
Follow /18 May 2016 at 2:00pm / Oracle Blog

The best idea since 1992: Putting the C into ACID (We need your vote)

Oracle Corporation is asking for community feedback on the SQL-92 CREATE ASSERTION feature. If you would like them implemented in Oracle Database, please vote at https://community.oracle.com/ideas/13028 (click on the up-arrow). Yuu need to log into your...
1630 0 /
Iggy Fernandez
Follow /1 May 2016 at 7:00am / Oracle Blog

When SQLT is not enough

When tuning a SQL query, I rely on a SQLT report because it has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, recently I came across a...
1836 0 /
Iggy Fernandez
Follow /30 Apr 2016 at 4:00am / Oracle Blog

How is data modeled in NoSQL?

The first question that you will have when you start your NoSQL journey is “How is data modeled in NoSQL?” The important thing to understand is the data does not change just because it is managed differently. If the data does not change, then...
1339 0 /
Iggy Fernandez
Follow /30 Apr 2016 at 2:00am / Oracle Blog

Why should Oracle Database professionals care about NoSQL and where to start?

Dr. Edgar Codd, the inventor of relational theory wrote in 1986 (thirty years ago): “Only if the performance requirements are extremely severe should buyers rule out present relational DBMS products on this basis.” Of course, he was comparing...
2397 0 /
Iggy Fernandez
Follow /29 Apr 2016 at 2:00pm / Oracle Blog

Why Brian Hitchcock and I (probably) know more about Oracle Database than you‏

Click on the picture to download the latest issue of the NoCOUG Journal Brian Hitchcock’s secret is simple. For twelve years, he has been reading books on Oracle Database. And taking extensive notes. And publishing them in the NoCOUG Journal...
1334 0 /
Iggy Fernandez
Follow /31 Mar 2016 at 11:30pm / Oracle Blog

NoCOUG changes its name (Happy April Fools Day)‏

Click here to register for the first-ever NoCOUG hike APRIL 1, 2016: The board members of NoCOUG met in closed session to discuss the continuing decline in memberships and conference attendance. “This is like global warming, only worse; much...
1357 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle Blog

The company that is most responsible for NoSQL is not Amazon

Surprise! The company most responsible for NoSQL is that relational behemoth Oracle Corporation itself by virtue of its purchase of Sleepycat Software in 2006. In the beginning, there was Berkeley DB: “Berkeley DB originated at the University...
806 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle Blog

Oracle has a complete family of data management products that solve all use cases

At YesSQL Summit 2016, Andy Mendelsohn—Executive Vice President of Database Server Technologies at Oracle Corporation—said “We want to have a complete family of data management products that solve all use cases.” ( http://www.toadworld...
723 0 /
Iggy Fernandez
Follow /30 Mar 2016 at 2:00pm / Oracle Blog

The First and Last Word on NoSQL

Amazon had the first word on NoSQL. In Dynamo: Amazon’s Highly Available Key-value Store published in 2007, Amazon said: “For many services, such as those that provide best seller lists, shopping carts, customer preferences, session management...
841 0 /
Iggy Fernandez
Follow /29 Feb 2016 at 2:00pm / Oracle Blog

Make SQL Great Again! (SQL is Huuuuuge) Part VII What is Oracle doing to fend off NoSQL and Hadoop?

Part VII of a lightly-edited partial transcript of a panel discussion titled “Making SQL Great Again (SQL is Huuuuuge)” at YesSQL Summit 2016 organized by the Northern California Oracle Users Group (NoCOUG) at Oracle Corporation’s headquarters...
786 0 /