Search

Top 60 Oracle Blogs

Recent comments

collection

Amazon DynamoDB: a r(el)ational Glossary

By Franck Pachot

.
There are many NoSQL databases. And, because SQL is an ISO standard, “No SQL” also means “No Standard”. Many have a similar API and similar objects, but with completely different names. Today, NoSQL databases are used as an additional datastore for some well-defined use cases for which a hashed key-value store fits better than a relational table. And it quickly became “Not Only SQL” as it is complementary to RDBMS databases using SQL. But at the origin, the idea was to replace the RDBMS databases, refusing the SQL API, and then inventing a “No SQL” data store. When you want to replace something rather than proposing something new, you often adopt the same language to make it look similar. And this why, in my opinion we find some relational database terms like “Table” and “Index”. But they have a different meaning. Here is a dictionary where I try to explain the DynamoDB artifacts and differentiate from their Relational and SQL meaning.

EM12c Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting

This is the first of two posts in the area of compliance management that has been previously published by a colleague of mine, Dave Wolf. Dave has moved to another part of Oracle now, and I’ve inherited some of his reponsibilities as product manager, including change management, compliance management and configuration management, so I wanted to copy his material to my blog so it’s not lost. Thanks Dave, for putting this material together originally!