What is Sentiment Analysis ?

Sentiment analysis (SA) in the context of Data Science is analysis of text to define the customer sentiment on a topic or product. Broadly speaking sentiment analysis extracts information on Polarity (Feels Good/ No Thankyou/ Umm ok!) & Context — Subjectivity (Influenced by a personal opinion/feeling) or Objectivity (without being influenced by a personal opinion/feeling). Definition of ‘Sentiment Analysis’ according to the Data Science website towardsdatascience.com is as below :

“Sentiment analysis is contextual mining of text which identifies and extracts subjective information in source material, and helping a business to understand the social sentiment…

Oracle’s Autonomous Database recently scored highest in all four Use Cases in the 2020 Gartner “Critical Capabilities for Cloud Database Management Systems for Operational Use Cases” report. Oracle’s fully cloud native Autonomous Database comes in three flavours — Autonomous Transaction Processing (ATP), Autonomous Datawarehouse (ADW) & Autonomous JSON Database (AJD). With ATP being the database of choice for transactional OLTP like systems.

In this blog post we will test the Transaction Processing Autonomous instance using a PL/SQL loop of inserting 1 Billion rows by selecting records from ALL_OBJECTS table. Our test will be inserting about half a terabyte of transactional…

Oracle Autonomous Database now supports capturing of Data as Source using an Extract and applying it to another Autonomous Database in another region. Previously with Goldengate you could only replicate to an Autonomous Database as a target Database but with the recently released feature you can now capture transactions at Source and replicate it to another Autonomous Database. So Autonomous DB’s can now act as Upstream Databases.

This is useful in scenarios where you need to build Geographically distributed Apps using Autonomous database and Goldengate. …

Update : 03 April 2021

_________________________
The Oracle Database Migration Tools Image is now available in OCI Sydney, Ashburn and Mumbai region as a Community Marketplace Image with ZDM upgraded to Version 21c.

To deploy go to OCI Console > Create Compute Instance > Image & Shape, Change Shape > Select “Community Images” > App Name ‘Oracle Database Migration Tools Image : ZDM 21c + Many Other Tools’. Make sure the hostname is always ‘zdm-migrate-v3’ and launch the Instance.

Problem Statement:

If you are a DBA, Cloud Engineer or Consultant who works regularly on migration of Oracle Database to OCI…