Category: Oracle Database

Feed: AWS Compute Blog. Author: Sheila Busser. This post is written by Benjamin Meyer, Sr. Solutions Architect, and Pascal Vogel, Associate Solutions Architect. Amazon Elastic Compute Cloud (Amazon EC2) Dedicated Hosts enable you to run software on dedicated physical servers. This lets you comply with corporate compliance requirements or per-socket, per-core, or per-VM licensing agreements by vendors, such as Microsoft, Oracle, and Red Hat. Dedicated Hosts are also required to run Amazon EC2 Mac Instances. The lifecycles and states of Amazon EC2 Dedicated Hosts and Amazon EC2 instances are closely connected and dependent on each other. To operate Dedicated Hosts ... Read More

Feed: Cloudera Blog. Author: Bill Zhang. Posted in Technical | June 30, 2022 5 min read We are excited to announce the general availability of Apache Iceberg in Cloudera Data Platform (CDP). Iceberg is a 100% open table format, developed through the Apache Software Foundation, and helps users avoid vendor lock-in. Today’s general availability announcement covers Iceberg running within key data services in the Cloudera Data Platform (CDP)—including Cloudera Data Warehousing (CDW), Cloudera Data Engineering (CDE), and Cloudera Machine Learning (CML). These tools empower analysts and data scientists to easily collaborate on the same data, with their choice of tools ... Read More

Feed: Planet MySQL; Author: Kyle Hailey; Sure, wait event times in any database will include some CPU time, though ideally it should be minimal. Waits should be instrumented as close to the off CPU wait event as possible, i.e. if I’m doing an IO, then I want the wait to cover just the read call: start_wait('my_read_wait'); pread( ... ); end_wait('my_read_wait'); So my function that sets up the read will do some CPU that could get caught under the cover of the wait itself and the call to pread will use some CPU but most of the time should be ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2022I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction anomalies. This article will explain how that happens and how you can cope with the problem. Be ready to learn some PostgreSQL implementation details!The exampleSetting the stageWe have a table of bills and a table of items on a bill: CREATE TABLE bill ( bill_id bigint PRIMARY KEY, total numeric(15,2) DEFAULT 0 NOT NULL ); CREATE TABLE item ( item_id bigint PRIMARY KEY, bill_id bigint REFERENCES bill NOT NULL, amount numeric(15,2) NOT NULL ); Let’s ... Read More

Feed: Recent Announcements. Amazon RDS now allows you to have up to 20 concurrent snapshot copy requests per destination region per account, an increase from the former limit of five concurrent copies per destination region per account. The new limit applies to snapshots of Microsoft SQL Server, Oracle engines, Amazon RDS for PostgreSQL, Amazon RDS for MySQL, and Amazon RDS for MariaDB engines in AWS Regions where Amazon RDS is available. This feature has been enabled on your account and no further action is needed from you. For more information on copying RDS snapshots, please refer to the documentation guide ... Read More

Feed: Matillion. Author: Ashley Lozito; As enterprises strive to become data-driven, choosing a cloud data environment is an important strategic decision. The Databricks Lakehouse Platform combines the data structure and data management features of a data warehouse with the low-cost storage of data lakes. Delta Lake on Databricks builds a Databricks Lakehouse architecture on top of existing cloud storage. Delta Lake provides a reliable, performant, and secure data storage and management system that is now used by thousands of organizations to process exabytes of data on a monthly basis.Once the data environment is chosen, filling it with data is the ... Read More

Feed: Planet PostgreSQL. Date: 27.06.2022 Reading time: 7 minutes Tags:   postgresql (119)   pgdayit (1)   backup (1)   wal (1)   pg_rewind (1)   migration (3)   gdpr (1)   running (2)   Category:   Interviews    Interview conducted by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I was born in Pula, a small city on the Croatian coast (~50K inhabitants) and I am 41 years old. My ... Read More

Feed: R-bloggers. Author: morphoscape. [This article was first published on R – Myscape, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Overview This walkthrough of the fundamentals of shell programming with Z shell (Zsh) and Bourne Again SHell (BASH) includes a comparison of similar components and features in R and RStudio. An alternate perspective from R is provided for you to leverage while learning the fundamentals of shell programming. It is important to ... Read More

Feed: Planet PostgreSQL. While this post is not going to be about pulsars, black holes or any other form of astrological phenomenon…It still is going to cover one of the most exciting and fundamental shifts in the IT industry today. This tale is discussing convergence.To understand the significance of any convergence, it is necessary to understand the lines that are coming together. Please indulge me when I review these.The challenging bit is the fact that inside both of the lines there are only the very early glimpses of this new era. They are still very much busy with the day-to-day ... Read More

Feed: AWS Big Data Blog. In this post, we discuss how to use AWS Database Migration Service (AWS DMS) native change data capture (CDC) capabilities to stream changes into Amazon Kinesis Data Streams. AWS DMS is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud or between combinations of cloud and on-premises setups. AWS DMS also helps you replicate ongoing changes to keep sources and targets in sync. CDC refers to the process of identifying ... Read More