Tag: transactions

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

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

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

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

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

Feed: Planet PostgreSQL. Logical Replication was introduced in PostgreSQL-10 and since then it is being improved with each version. Logical Replication is a method to replicate the data selectively unlike physical replication where the data of the entire cluster is copied. This can be used to build a multi-master or bi-directional replication solution. One of the main differences as compared with physical replication was that it allows replicating the transaction only at commit time. This leads to apply lag for large transactions where we need to wait to transfer the data till the transaction is finished. In the upcoming PostgreSQL-14 ... Read More

Feed: R-bloggers. Author: R on Thomas Roh. [This article was first published on R on Thomas Roh, 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. An important aspect of maintaining databases with an application interface is to ensure atomicity. When performing multiple writes on a database, any failures that occur during the operations should not violate any logical rules. The most common analogy is a financial transaction. If person A withdraws X dollars ... Read More

Feed: AWS Big Data Blog. Data lakes on Amazon Simple Storage Service (Amazon S3) have become the default repository for all enterprise data and serve as common choice for a large number of users querying from a variety of analytics and ML tools. Often times you want to ingest data continuously into the data lake from multiple sources and query against the data lake from many analytics tools concurrently. Previously, getting consistent results meant that you had to build custom pipelines to keep data consistent and resulted in delays before the data became available to the consuming tools. We announced AWS Lake Formation transactions, row-level ... Read More

Feed: Planet MySQL; Author: Mirko Ortensi; While testing a XA transactions based workload, I noticed in the output of SHOW ENGINE INNODB STATUS; ---TRANSACTION 108674, ACTIVE (PREPARED) 35 sec 4 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 2 So far, so good. A XA transaction has been PREPARED, and reported as such. But after a while (and I was not really looking at the session), I repeated the command and the output turned to: ---TRANSACTION 108674, ACTIVE (PREPARED) 91 sec recovered trx 4 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 2 I ... Read More

Feed: Planet MySQL; Author: Codership; A significant improvement has come to Galera Cluster 4 for MySQL, in the form of streaming replication. When you are dealing with large (greater than 2GB in size) or long running transactions, previous releases of Galera Cluster would reject the transaction; in the current release transactions can be split into fragmented chunks and those rows can be replicated in chunks to the other nodes even before commit. This is the feature that will remove you from all cluster stall issues due to large transaction processing! While disabled by default, you can use it and configure ... Read More