A transactional database, also known as an operational database, is a database optimized for running production systems and excels at storing, reading and writing individual rows of data very quickly while maintaining data integrity and data consistency.