Stack Overflow
Stack Overflow

Questions tagged [transactional-database]

A Transactional Database is a database in which CRUD operations must be done within an atomic, consistent, isolated and durable(ACID) processing model.

Transactional databases exhibit the following behavior:

  • Transactions are the only operation
  • Data-access and data-modification operations are scoped
  • Scopes determine which object stores the transaction access
  • Asynchronous write transactions cannot have overlapping scopes
  • Commands cannot be executed outside of a transaction

References

15 questions
6
votes
2 answers

@Transactional spring JPA .save() not necessary?

I understand that if we use annotation @Transactional. "save()" method is not necessary. Is it exact? And for my example: @Transactional void methodA() { ... ObjectEntity objectEntity = objectRepository.find(); …
YannaY
  • 105
  • 2
  • 9
6
votes
1 answer

Design of snapshots in a transactional database along with versioning of reference data

Disclaimer: I have read everything that I can read on the topic of snapshots and versioning on both stack overflow and on internet. My requirement is not version tracking for audit trail or the database-level snapshots. I have spent more than 1…
Siraj Samsudeen
  • 1,624
  • 7
  • 26
  • 35
3
votes
3 answers

how to store deleted rows in a transactional database

This is a follow-up to the comment raised by heximal on one of my other posts. I want to have a deleted_on column to detect deleted records to which heximal suggested that this column is redundant. Here is his comment: You're going to use…
Siraj Samsudeen
  • 1,624
  • 7
  • 26
  • 35
3
votes
5 answers

Undo in a transactional database

I do not know how to implement undo property of user-friendly interfaces using a transactional database. On one hand it is advisable that the user has multilevel (infinite) undoing possibility as it is stated here in the answer. Patterns that may…
rics
  • 5,494
  • 5
  • 33
  • 42
2
votes
1 answer

PostgreSQL transactional DDL and to_regclass

Following the suggestion at this question, I'm using the to_regclass function to check if a table exists, creating it if it doesn't. However, it appears that if the table was created in the current transaction, to_regclass still returns null. Is…
Tom
  • 7,269
  • 1
  • 42
  • 69
2
votes
1 answer

Perform transactional database operations asynchronously in .NET 4.5.1

I have written a program to perform database operations in asynchronous fashion. I try to run it in a database transaction using BeginTransaction() or TransactionScope but have no luck. I stepped through the code in VS2012 and noticed the…
Tony
  • 1,827
  • 1
  • 22
  • 23
1
vote
1 answer

Repository pattern with transactional query

I am writing a service that can make a transactional query, (in this question I will be using GORM) UserService type userService struct { UserRepository repository.IUserRepository TokenRepository repository.ITokenRepository } type…
Fajar Sidiq Salviro
  • 15
  • 2
  • 10
1
vote
0 answers

What's the best way to have a calculated column that involves multiple tables in a transactional database?

What's the best way to have a calculated column that involves multiple tables in a transactional database? Background Our transactional MySQL database includes the fact tables like the following simplified model: CREATE TABLE LU_PROJECT( …
Max Heiber
  • 14,346
  • 12
  • 59
  • 97
0
votes
1 answer

Transactional Database Replication over an unreliable channel

I wanted to set up database replication (transactional) between 2 offices and I was wondering if it's advised to do so over an unreliable channel? I plan to set up this transactional replication on a VPN over the internet, and I'm trying to account…
Mohammad Sepahvand
  • 17,364
  • 22
  • 81
  • 122
0
votes
0 answers

Spring boot @Transactional annotation commits before method ends, only with Sql Server

I have a spring boot application that connects on two databases (oracle and sql server), but my @Transactional method commits the transaction before returning to the caller. I launch my app in debug mode and realized that just after calling the…
Natan Cabral
  • 1
  • 1
0
votes
1 answer

Rolling 12 months count of unique id displayed monthly

I am working with transaction data and would like to get past 12 months rolling Active Customer Base but on monthly level. Below is an example of transaction data i have - Transaction Data Cust-ID Date-of-Purchase Quantity Customer-Tag N01847…
kassandra martin
  • 3
  • 2
0
votes
1 answer

Manage Transactions in Spring Applications

I'm using springboot to develop my application, In the service I'm calling a method by the name submitPostDetails() --> This method sends request to method - X() the Dao along with some parameters and inserts the post details into the system. Once,…
prateek kapoor
  • 25
  • 7
0
votes
2 answers

How do I select only one column result based on its value from a transnational table?

I have a number of items that are for rent in an item table. I have a transnational table that shows the rental history on each item in my item table. If the item is currently not being rented then all entries in the "Availability Status" column…
Craig Zirnheld
  • 139
  • 1
  • 2
  • 13
0
votes
2 answers

Performance hit on DB2 transactional database after linking to SQL Server 2005

We have an AS400 mainframe running our DB2 transactional database. We also have a SQL Server setup that gets loaded nightly with data from the AS400. The SQL Server setup is for reporting. I can link the two database servers, BUT, there's concern…
sothatswhereitgoes
  • 23
  • 5
-1
votes
1 answer

What mysql extension to use on transactional database

I'm currently using the ezsql library. Now I want to learn another method of interacting to a mysql database using php. What extension should I use if I'm connecting to a database which is used for different transactions. Should I use pdo or mysqli…
Wern Ancheta
  • 22,397
  • 38
  • 100
  • 139