- Home
- Tag: transactions
Posts tagged transactions
Tag: transactions
Use the AWS Glue connector to read and write Apache Iceberg tables with ACID transactions and perform time travel

Feed: AWS Big Data Blog. Nowadays, many customers have built their data lakes as the core of their data analytic systems. In a typical use case of data lakes, many concurrent queries run to retrieve consistent snapshots of business insights by aggregating query results. A large volume of data constantly comes from different data sources into the data lakes. There is also a common demand to reflect the changes occurring in the data sources into the data lakes. This means that not only inserts but also updates and deletes need to be replicated into the data lakes. Apache Iceberg provides ... Read More
Amazon Redshift launches new Snapshot Isolation level support for concurrent transactions
Feed: Recent Announcements. Amazon Redshift has launched support for Snapshot Isolation for concurrent transactions. Amazon Redshift prevents dirty reads, non-repeatable reads, and phantom reads according to the SQL standards. The two options that Amazon Redshift offers to serialize transactions are SERIALIZABLE and SNAPSHOT ISOLATION. The SERIALIZABLE option will implement strict serializability, where a transaction could fail if the result could not be mapped to a serial order of the concurrently running transactions. The SNAPSHOT ISOLATION option will allow higher concurrency, where concurrent modifications to different rows in the same table would complete successfully. Under both options, transactions will continue to operate ... Read More
Announcing general availability of Amazon Athena ACID transactions, powered by Apache Iceberg
Feed: Recent Announcements. We are excited to announce the general availability of Amazon Athena ACID transactions, a new capability that adds insert, update, delete, and time travel operations to Athena's SQL data manipulation language (DML). Athena ACID transactions enable multiple concurrent users to make reliable, row-level modifications to their Amazon S3 data from Athena's console, API, and ODBC and JDBC drivers. Built on the Apache Iceberg table format, Athena ACID transactions are optimized for Amazon S3 storage, support seamless schema evolution, and ensure atomic operations across other services and engines that support the Iceberg table format such as Amazon EMR, ... Read More
Shaun M. Thomas: PG Phriday: Wrapping Transactions Right Round
Feed: Planet PostgreSQL. One of the more prominent limitations of the Postgres database storage engine is the fact that it utilizes a 32-bit integer to track the current transaction identifier (XID). For the more uninformed Postgres users, this means there’s a hard limit of roughly 2-billion transactions hard-coded into the system before maintenance is necessary. Failure to perform this maintenance means that the global transaction ID wraps around back to zero, essentially invalidating any past transactions as the counter continues to advance.When a Postgres cluster outage hits the news, or a critic outlines their dislikes regarding the database engine, there’s ... Read More
Introduction to Couchbase for Oracle Developers and Experts: Part 8: Transactions
Feed: Planet NoSQL. Author: Keshav Murthy. Six thousand years ago, the Sumerians invented writing for transaction processing - Gray and ReuterTransaction is a set of read and write actions consisting ofUnprotected actions on the transient state outside the transaction statement scope and state (e.g. storage allocations, dictionary management)Protected change the persisted data, actions must be reflected in transaction outcomeReal actions using sensors and actuators, once done, cannot be undone.Transaction ExamplesORACLECouchbaseOracle automatically starts a multi-statement transaction for every new statement. So, issuing BEGIN WORK or START TRANSACTION is unnecessaryBEGIN WORK, START TRANSACTION are all synonymous and start a multi statement transaction. – Transaction ... Read More
Announcing Amazon Athena ACID transactions, powered by Apache Iceberg (Preview)
Feed: Recent Announcements. We are excited to announce the public preview of Amazon Athena ACID transactions, a new capability that adds write, delete, update, and time travel operations to Athena's SQL data manipulation language (DML). Athena ACID transactions enables multiple concurrent users to make reliable, row-level modifications to their Amazon S3 data from Athena's console, API, and ODBC and JDBC drivers. Built on the Apache Iceberg table format, Athena ACID transactions are compatible with other services and engines such as Amazon EMR and Apache Spark that support the Iceberg table format. Using Athena ACID transactions, you can now make business- ... Read More
Laurenz Albe: WITH HOLD cursors and transactions in PostgreSQL

Feed: Planet PostgreSQL. © Laurenz Albe 2021Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions interact and how WITH HOLD can work around their limitations. We will also see the dangers involved and how to properly use WITH HOLD cursors in a PL/pgSQL procedure.Cursors in PostgreSQLWhen a query is ready for execution, PostgreSQL creates a portal from which the result rows can be fetched. During normal query execution, you receive the whole result set in one step. In contrast, a cursor allows you to fetch the result rows one by ... Read More
Deliver Search and Analytics at the Speed of Transactions

Feed: Redis. Author: Steve Naventi. Redis sponsored this post. Ashish Sahu Ashish is head of Product and Solution Marketing at Redis. He has broad experience with launching in-memory databases, big data, analytics and AI products. Disruptive forces are changing the speed of business. The combination of a data-driven culture, customer expectations and digital disruptors is forcing businesses to move fast and be more agile or risk losing customers. It’s not enough to play catch-up. Companies need to overtake digital disruptors. At the same time, digitization, the Internet of Things, social media and mobile devices are creating a flood of data ... Read More
Cloudera’s HBase PaaS offering now supports Complex Transactions

Feed: DB-Engines.com Blog. Author: Krishna Maheshwari. Blog > Postby , 11 August 2021Tags: Apache Phoenix, DBaaS, HBaseCloudera announced the general availability of the CDP Operational Database Experience (COD) on both AWS & Azure in February and recently announced support of full ACID capabilities within the relational mode of the Operational Database. CDP Operational Database is a fully managed cloud-native transactional database with unparalleled scale, performance, and reliability. Optimized to be deployed anywhere, on any cloud platform, CDP Operational Database aligns with the cloud infrastructure strategy best suited for the business. It enables application developers to deliver prototypes in under an ... Read More
Analyze Fraud Transactions using Amazon Fraud Detector and Amazon Athena

Feed: AWS Architecture Blog. Organizations with online businesses have to be on guard constantly for fraudulent activity, such as fake accounts or payments made with stolen credit cards. One way they try to identify fraudsters is by using fraud detection applications. Some of these applications use machine learning (ML). A common challenge with ML is the need for a large, labeled dataset to create ML models to detect fraud. You will also need the skill set and infrastructure to build, train, deploy, and scale your ML model. In this post, I discuss how to perform fraud detection on a batch ... Read More
Recent Comments