Tag: transactions

Feed: Planet MySQL; Author: MC Brown; Clickhouse is a relatively new analytics and datawarehouse engine that provides for very quick insertion and analysing of data. Like most analytics platforms it’s built on a column-oriented storage basis and unlike many alternatives is completely open source. It’s also exceedingly fast, even on relatively modest platforms.Clickhouse does have some differences from some other environments, for example, data inserted cannot easily be updated, and it supports a number of different storage and table engine formats that are used to store and index the information. So how do we get into that from our MySQL transactional ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Packt Publishing. Tokenomics is the economy of this new world. This is a no-holds-barred, in-depth exploration of the way in which we can participate in the blockchain economy. The following is an excerpt from the book, Tokenomics by Thomas Power and Sean Au and published by Packt. One of the biggest challenges of playing in the ICO space is trying to understand the rules to play by. Regardless of what anyone says, we all live in a world bound by rules. We always have and always will, yet technology knows no ... Read More

Feed: Planet PostgreSQL. PREVIOUS POST PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive procedure. In this article, you will see how to use replication with slots and understand what problems it could solve. Introduction PostgreSQL physical replication is based on WAL. Th Write Ahead Log contains all database changes, saved in 16MB segment files. Normally postgres tries to keep segments between checkpoints. So with default settings, just 1GB of WAL segment files is ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL CEO Nikita Shamgunov was featured recently on the Data Engineering Podcast with host Tobias Macey. Tobias drew out Nikita on MemSQL’s origins, our exciting present, and where we’re going in the future. We share a few highlights here, but we also urge you to listen to the full episode. The podcast covered a wide variety of topics. In this blog post, we’ll highlight Nikita’s comments on MemSQL’s origins; setting up and running the MemSQL database; typical use cases; and the future of MemSQL. How MemSQL Started Nikita grew up and was educated in ... Read More

Feed: Big Data Made Simple. Author: Baiju NT. We recently interviewed Pankaj Rai, a well-known expert in analytics and banking and is currently the Senior Vice President Strategy at Wells Fargo. The former Analytics Director at Dell International Services, Pankaj shared his views on some of the hot topics in the financial & banking sector right now – digital transformation, innovation in fintech, new regulations, and blockchain to name a few. Read the complete interview below: What does your day typically look like at Wells Fargo? How do you start and end your day? (Laughs) My days are quite straightforward ... Read More

Feed: Planet PostgreSQL. Prepared transactions are disabled in PostgreSQL by default, since the parameter max_prepared_transactions has the default value 0.You don’t need prepared transactions in most cases. However, they can cause nasty problems, so I think that everybody who runs a PostgreSQL database should understand them.To illustrate these problems, I’ll show you how to use prepared transactions to get a PostgreSQL into an inaccessible state.What are prepared transactions?Normally, a database transaction that spans multiple statements is ended with COMMIT or ROLLBACK. With prepared transactions, another step is added:BEGIN or START TRANSACTION: starts a transaction as usual.PREPARE TRANSACTION 'name': prepares the ... Read More

Feed: Neo4j Graph Database Platform. Author: Bryce Merkl Sasaki. Back in the day (when Prussia was still a thing), Königsberg must have been a really boring place.That’s because the definition of fun in Königsberg was to walk around the city’s seven bridges and find a path that only crossed each bridge once. (This was before Netflix.)This isn’t that complex of a problem, but the people in Königsberg also weren’t that good at math. So they asked their math “friend” (not their friend), Leonhard Euler to figure it out. Euler had way more important shit to figure out at the time ... Read More

Feed: Teradata Blog. Optimizing customer experience with precision, scale and in an economically feasible way is a struggle. However, with the right data, analytics and interaction capabilities, customer journeys can be mapped, significant events can be predicted, and interactions can be poised and used to guide each customer to the optimal destination in an automated, "always on" system. When done right, customer satisfaction and revenue go up, while marketing and customer care costs go down.At this year’s Teradata Analytics Universe event, I held a session explaining the value of mapping customer journeys and how it’s possible to do so accurately ... Read More

Feed: Microsoft Azure Blog. Author: Christine Alford.   1-Day Big Data Cloud Migration Workshop: This one-day workshop from Hashmap is for business and technical leaders and key stakeholders, and it's held at the client's facility. Receive guidance and assistance in defining services and the overall solution.   2-Week Azure Assessment: Assess your current datacenter environment (up to 100 VMs) and receive optimization recommendations for a cloud migration. An Azure architect from Catapult Systems will review the results of an assessment tool and provide recommendations.   3 Day Cloud Adoption Workshop: Black Marble's on-site cloud adoption workshop is free-form and wide-ranging, ... Read More

Feed: Microsoft Azure Blog. Author: Kate Baroni. Although it’s not a typical use case for Azure Functions, a single Azure function is all it took to fully implement an end-to-end, real-time, mission-critical data pipeline for a fraud detection scenario. And it was done with a serverless architecture. Two blogs recently described this use case, “Considering Azure Functions for a serverless data streaming scenario,” and “A fast, serverless, big data pipeline powered by a single Azure Function.” Pipeline requirements A large bank wanted to build a solution to detect fraudulent transactions. The solution was built on an architectural pattern common for ... Read More