Friday, February 18, 2022

OAC―Editions of Oracle Analytics Cloud

Figure 1.  Provisioning an OAC instance

Subjects of Learning OAC

  • Describe the editions of Oracle Analytics Cloud
  • Describe the solutions applicable for each OAC edition
  • Identify the pre-requisites for OAC
  • Explain the concept of a compute shape

Video 1. Create a Service with Oracle Analytics Cloud (YouTube link)

Oracle Analytics Cloud Products 


Oracle Analytics Cloud offers you three product options:[4]


Differences Between Products


The main difference between Oracle Analytics Cloud, Oracle Analytics Cloud Subscription, and Oracle Analytics Cloud - Classic is the way you deploy and manage your services on Oracle Cloud.
  • Editions
  • Service Management
  • Infrastructure

Editions


Several editions are currently available: Professional and Enterprise. The features available with each edition depend on the product option and regions accessible to you.  Read [4] for details especially for the availability of different products based on dates and regions.

Service Management


Service ManagementOracle Analytics CloudOracle Analytics CloudSubscriptionOracle Analytics Cloud - Classic
Managed by You (Oracle User)
Check mark
You manage the service lifecycle and configuration, and have SSH access to the compute node VM.
Oracle–Managed
Check mark
Oracle provides you with lifecycle management and configuration. You can log service requests to Oracle Cloud support to request service updates.
Check mark
Customer Responsibility
Manage users and roles
Check mark
Check mark
Check mark
Create and size service
Check mark
Check mark
Check mark
Create database cloud service
Check mark
Administer database cloud service
Check mark
Back up and restore servicesOracle schedules and manages backupsOracle schedules and manages backups
Check mark
Patch servicesOracle schedules and applies patchesOracle schedules and applies patches
Check mark
Patch operating systemOracle schedules and applies patchesOracle schedules and applies patches
Check mark
Start and stop services
Check mark
Pause and resume services
Check mark
Monitor servicesOracle has direct access to diagnostic logs for troubleshooting issuesOracle has direct access to diagnostic logs for troubleshooting issues
Check mark

Infrastructure

InfrastructureOracle Analytics CloudOracle Analytics CloudSubscriptionOracle Analytics Cloud - Classic
Oracle Cloud Infrastructure (Gen 2)
Check mark

Oracle Cloud Infrastructure (Gen 1)
Check mark
Check mark
Oracle Cloud Infrastructure Classic
Check mark
Oracle Cloud Infrastructure Identity and Access Management- Identity Domains
Check mark
Available on Oracle Cloud Infrastructure (Gen 2) to new customers in some Oracle Cloud regions.


Oracle Identity Cloud Service
Check mark
Check mark
Check mark
Load Balancer
Check mark
An Oracle-managed load balancer is automatically created and configured for your service.
Check mark
An Oracle-managed load balancer is automatically created and configured for your service.
Check mark
When you enable Oracle Identity Cloud Service as the identity provider, an Oracle-managed load balancer is created and configured automatically for your service.
Cloud Storage Required
Check mark
Uses Oracle Cloud Infrastructure Object Storage— A storage bucket is automatically created for your service.
Check mark
Uses Oracle Cloud Infrastructure Object Storage— A storage bucket is automatically created for your service.
Check mark
Uses Oracle Cloud Infrastructure Object Storage Classic — You can create the object storage container either before or while you set up your service.
Oracle Database Cloud Service Required
Check mark
You must set up a database service for Oracle Analytics Cloud - Classic schemas and organize a back up schedule.
Size Deployment by Shape
Check mark
Various Oracle Compute Unit (OCPU) sizing options.
Check mark
Various Oracle Compute Unit (OCPU) sizing options.
Check mark
Standard and high memory shapes.
The list of available shapes may vary by region.
Size Deployment by Number of Users
Check mark
Only on Oracle Cloud Infrastructure (Gen 2).
Check mark



Scale Up and Scale Down
Check mark
Check mark
Availability Domains
Check mark
Each region has multiple isolated availability domains, with separate power and cooling. The availability domains within a region are interconnected using a low-latency network. When you create a service, you can select the region where you want to deploy the service and Oracle automatically selects an availability domain.
Check mark
Each region has multiple isolated availability domains, with separate power and cooling. The availability domains within a region are interconnected using a low-latency network. When you create a service, you can select the region where you want to deploy the service and Oracle automatically selects an availability domain.


Oracle Analytics Cloud - Professional Edition


With Professional Edition, you can:
  • Take control of your data
  • Create processes for business analytics application and data collection
  • Discover insights on the data that you provide
  • Prepare data through interactive data flows
  • Explore data through grammar-based visualization
  • Coordinate business analytics within your department or organization
  • Use the Oracle Analytics Day by Day mobile application

Oracle Analytics Cloud - Enterprise Edition


Enterprise Edition offers all the features in Professional Edition and in addition, you can:
  • Build data models, reports, and analytic dashboards in an enterprise business intelligence environment
  • Design and publish pixel-perfect reports from your enterprise data
  • Migrate content from your existing on-premises environment
  • Perform a sensitivity analysis to test various data scenarios
  • Use the Oracle Analytics Day by Day mobile application
  • Maintain live and optimized connectivity to on-premises data warehouses

References

Wednesday, June 30, 2021

Windows—Want to Sort Files by Type and Date Modified

Recently, I need to retire a Windows 10 laptop and migrate its contents to a new one. Then the below question was asked in my mind:
Can I do a 2-tiered sort of files: sort by type then by Date modified?
In this article, we will demonstrate how to achieve that.

Figure 1.  File Explorer with View tab selected in Windows 10 


Sorting Files and Folders


"Sorting files and folders" reorders them in File Explorer based on the criteria you prefer. There are over 300 criteria available, and you can apply whichever you prefer. 
Open a File Explorer (see Figure 1)
  1. To open File Explorer, click on the File Explorer icon located in the taskbar.
  2. Alternatively, you can open File Explorer by clicking on the Start button and then clicking on File Explorer.
By default, in Windows 10, your files and folders are sorted in Ascending order by Name - or alphabetically - except for the Downloads folder, which is sorted in Descending order by Date modified - newest downloads are displayed on top.

Figure 2.  Sort by Date modified in Descending order


How to Cleanup Old Files in a Folder?


To figure out which file needs to be kept and which not during a laptop migration, it will be nice to sort files first by Type and then by Date modified.

Here is how you can achieve that in Windows 10:

  1. Click View, and select Details
  2. Click Group by, and select Type (default: Ascending
  3. Click Sort by, and select Date modified (default: Descending
    • You can also click on Date modified column header to change its sort order (note that it's a toggle).

Figure 3.  Final result (2-tiered sort of files: sort by type and then by Date modified)