Transaction processing

Durability (database systems)

In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes. Durability can be achieved by flushing the transaction's log records to non-volatile storage before acknowledging commitment. In distributed transactions, all participating servers must coordinate before commit can be acknowledged. This is usually done by a two-phase commit protocol. Many DBMSs implement durability by writing transactions into a transaction log that can be reprocessed to recreate the system state right before any later failure. A transaction is deemed committed only after it is entered in the log. (Wikipedia).

Video thumbnail

Relational Databases (part 1 of 6)

The essential concepts of relational databases. Part of a larger series teaching programming. Visit codeschool.org

From playlist Relational Databases

Video thumbnail

SQL

What is the structure of an SQL query? What logical operators and wildcards can be used in such queries?

From playlist Database Systems

Video thumbnail

Database as Filesystem

Most network file systems are either a layer over an existing filesystem (NFS, CIFS), or are developed from scratch to have separate, replicated, purpose-designed databases for metadata and object store (GFS, Glusterfs). At the same time, most database engines provide (or can be coerced i

From playlist Databases

Video thumbnail

Tree Indexing in DBMS

A #database #index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database

From playlist Database

Video thumbnail

Database Normalisation

The goals of normalising a database, along with a worked example. I'm Mr. Woo and my channel is all about learning - I love doing it, and I love helping others to do it too. I guess that's why I became a teacher! I hope you get something out of these videos - I upload almost every weekday

From playlist Database Systems

Video thumbnail

Relational Databases (part 6 of 6)

The essential concepts of relational databases. Part of a larger series teaching programming. Visit codeschool.org

From playlist Relational Databases

Video thumbnail

Ruby Midwest 2011 - Modern Databases

Modern Databases by: Eric Redmond Choosing a data storage engine is an important decision, but it doesn’t have to be painful if you know the landscape. We’ll look at several DBMSs (and a few you’ve never heard of), compare and contrast them based on use-cases, and how to plug each i

From playlist Ruby Midwest 2011

Video thumbnail

Modern Databases by Eric Redmond

Choosing a data storage engine is an important decision, but it doesn't have to be painful if you know the landscape. We'll look at several DBMSs (and a few you've never heard of), compare and contrast them based on use-cases, and how to plug each into Ruby. Authoring the book "Seven Datab

From playlist Ruby Midwest 2011

Video thumbnail

Clean Architectures in Python

Architectural considerations are often overlooked by developers or completely delegated to a framework. We should start once again discussing how applications are structured, how components are connected and how to lower coupling between different parts of a system, to avoid creating softw

From playlist Software Development

Video thumbnail

Stanford Seminar - Mind Your State for Your State of Mind

EE380: Computer Systems Colloquium Seminar "Mind Your State for Your State of Mind" Speaker: Pat Helland, Salesforce About the talk: Applications have had an interesting evolution as we've moved into the distributed and scalable world. Similarly, storage and its cousin databases have cha

From playlist Stanford EE380-Colloquium on Computer Systems - Seminar Series

Video thumbnail

What is Bitcoin and Blockchain (by Charles Hoskinson)

This video provides an introduction to Bitcoin and the Blockchain Industry PUBLICATION PERMISSIONS: The original video was published with the Creative Commons Attribution license (reuse allowed). Link: https://www.youtube.com/watch?v=EDyQEUZ0PlY

From playlist Blockchain

Video thumbnail

(Audio only) Wassup MOM? Owning the Message Oriented Middleware - Gursev Singh Kalra

(Audio only) Wassup MOM? Owning the Message Oriented Middleware - Gursev Singh Kalra Message Oriented Middleware (MOM) allows disparate applications to communicate with each other by exchanging information in the form of messages. A MOM and its clients create an enterprise messaging appli

From playlist AppSecUSA 2013

Video thumbnail

Lec 19 | MIT 6.033 Computer System Engineering, Spring 2005

Transactions and Consistency View the complete course at: http://ocw.mit.edu/6-033S05 License: Creative Commons BY-NC-SA More information at http://ocw.mit.edu/terms More courses at http://ocw.mit.edu

From playlist MIT 6.033 Computer System Engineering, Spring 2005

Video thumbnail

RailsConf 2018: Testing in Production by Aja Hammerly

RailsConf 2018: Testing in Production by Aja Hammerly Test All the F***ing Time is one of the values of the Ruby community. But how many of us test in production in addition to running our test suites as part of CI? This talk will discuss a variety of approaches to testing in prod includi

From playlist RailsConf 2018

Video thumbnail

Database Transactions, part 3: ACID and Isolation

Learn about ACID (Atomic, Consistent, Isolated, Durable). We focus on Isolation and see what happens when transactions overlap.

From playlist SQL Databases

Video thumbnail

SQL vs NoSQL - Difference B/W SQL & NoSQL Databases | MySQL vs MongoDB Tutorial | Edureka

🔥 MYSQL DBA Certification Training: https://www.edureka.co/mysql-dba This Edureka video on SQL vs NoSQL will discuss the differences between SQL and NoSQL. It also discusses the differences between MySQL and MongoDB. The following topics will be covered in this video: 1:11 What is SQL? 3:

From playlist MongoDB Dev & Admin Tutorial Videos

Related pages

Distributed transaction | Database transaction | Consistency (database systems) | ACID | Transaction log | Isolation (database systems) | Two-phase commit protocol | Atomicity (database systems)