Interview Questions for Business Analysts and Systems Analysts

Recent Interview Questions | Search | Subscribe (RSS)


What are OLTP systems?

Posted by Chris Adams

Article Rating // 22727 Views // 0 Additional Answers & Comments

Categories: Systems Analysis, Data Analysis & Modeling


OLTP or On-Line Transaction Processing systems are a class of systems which contain current, operational data used to control and run fundamental business tasks.  OLTP systems are typically characterized by their ability to complete many concurrent database transactions and are designed for optimal database transaction speed. Additions and changes to data are user initiated (rather than scheduled) and conducted via short, atomic transactions.

Queries of OLTP systems are typically simple and return relatively few records.  The structure of OLTP databases are highly normalized which means tables and fields are organized to minimize data redundancy and dependency.  But this doesn’t lend itself to efficient processing of complex queries. More complex querying is typically run against historical data stores which are classified as OLAP systems (On-Line Analytical Processing) or Data Warehouses.

Transaction and data recovery is paramount for OLTP systems since they deal with current business data used to conduct real-time business operations. Similarly, OLTP systems are often decentralized to avoid single points of failure.  This can also help spread volume over multiple servers to maximum the volume transaction processing possible and minimize response times.



Only registered users may post comments.

Do your homework prior to the business analysis interview!

Having an idea of the type of questions you might be asked during a business analyst interview will not only give you confidence but it will also help you to formulate your thoughts and to be better prepared to answer the interview questions you might get during the interview for a business analyst position.  Of course, just memorizing a list of business analyst interview questions will not make you a great business analyst but it might just help you get that next job.



Select ModernAnalyst Content

Register | Login

Copyright 2006-2023 by Modern Analyst Media LLC