Category: Oracle Database

Feed: Planet NoSQL. Author: Keshav Murthy. Oracle DBAs work with physical clusters, machines, instances, storage systems, disks, etc. All of Oracles users, developers and their applications work with logical entities: databases, tables, rows, columns, partitions, users, data types.  There are a lot of similarities and some differences.  Let’s compare and contrast how this is done on Couchbase.Here’s the home page for the series: http://blog.planetnosql.com/2022/01/introduction-to-couchbase-for-oracle.htmlORACLE OrganizationFull list of Oracle schema objects are listed here. A database instance can have many databases; A databases many schema; A schema many tables, indexes, functions, etc.COUCHBASE OrganizationA Couchbase instance can have many buckets; A bucket can ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. INTRODUCTIONYou know Oracle, but need to a good overview of Couchbase, a modern NoSQL database? You're in the right place. This will speed up your understanding of Couchbase.  It’s not intended to evaluate all the features or performance.  Since Oracle is a relational database with SQL as the main query language, it's normal for developers to view other databases from SQL point of view. In this article, we'll compare and contrast Oracle with Couchbase from SQL point of view.  You'll get a good feel for the architecture and capabilities of Couchbase. We won't do ... Read More

Feed: SingleStore Blog. Author: . SingleStore’s growth is on fire — globally — and a big reason why is that our technology has strong appeal for both developers and business leaders. Akmal Chaudhri, our London-based Developer Advocate, has a deep understanding of the conversations that take place on both sides of, and across, the table. I recently spoke with Akmal about why he’s excited to be at SingleStore, and why he thinks “the best kept secret '' of the database world (that’s us) is about to turn up the heat even more. Q: OK tell me, what drew you to SingleStore?A: ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL is a proven, reliable database that is quick to set up easy to maintain, and has outstanding performance. However, that performance can usually be improved with the judicious use of the following tips that are all easy to implement ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL Database Service with HeatWave is now available globally in 30 regions Oracle Cloud Infrastructure commercial regions. The most recent addition is Johannesburg in South Africa.  ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things ... Read More

Feed: The Information Lab. Author: Iwona Fredouelle. 19 January, 2022 | Iwona Fredouelle Restoring a backup from a regular Tableau environment to an external file store Tableau server/cluster If you don’t know how backup with external file store works, this page explains it quite well. This blog post describes how to restore a backup from a normal Tableau server without any add-ons to Tableau server with external file store (with Server Management Add-on). There is no official description on how this works, so this is based purely on my experience. Also this is a pg-only restore, which means it restores ... Read More

Feed: Planet PostgreSQL. A common spatial need is to find a polygon that accurately represents a set of points.  The convex hull of the points often does not provide this, since it can enclose large areas which contain no points.  What is required is a non-convex hull, often termed the concave hull.  The Convex Hull and a Concave Hull of a point setA concave hull is generally considered to have some or all of the following properties:The hull is a simply connected polygonIt contains all the input pointsThe vertices in the hull polygon boundary are all input pointsThe hull may or ... Read More

Feed: Planet MySQL; Author: Chandan Kumar; Let's walk through on how to migrate sakila database from Azure for MySQL into Oracle Cloud MySQL Database Service(MDS). For the migration ,let's use MySQL Shell Utility features 1.       Dump Schema Utility a.       This will help us to take the backup from Azure for MySQL's database and export  to Oracle Cloud Object Storage. 2.       Load Dump Utility a.       This is help us to Import the schema from Object Storage to MySQL Database Service(MDS) at Oracle Cloud . More info:- https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html How does Migration Work ? Suppose you wanted to do lift-shift of database called ... Read More