In last blog we have understood the features of SQL 2014 and one of the main feature is "In Memory OLTP". It is advisable to know first what is OLTP and then proceed for "In Memory OLTP"
OLTP is a popular data processing system in today's enterprises. The main usage of OLTP is in Retail / Gaming Industry and Financial Transaction Systems. OLTP requires support for transaction that span a network and may include more than one company. For this reason , the modern OLTP software use client or server processing and brokering software that allow transactions to run on different platform in a network.
The design of OLTP should follow the discipline of data modelling and should follow the Codd rules of data normalization. Using these rules, complex information is broken down into its most simple structure where all the individual atomic level elements relate to each other and satisfy the rule of normalization.
The industry which have a large numbers of users who conduct short transactions uses OLTP. In OLTP concept database queries are simple but require sub second responses times and return relatively few records.
Below Attributes are basic attributes which SQL Developer should know about OLTP
OLTP is a popular data processing system in today's enterprises. The main usage of OLTP is in Retail / Gaming Industry and Financial Transaction Systems. OLTP requires support for transaction that span a network and may include more than one company. For this reason , the modern OLTP software use client or server processing and brokering software that allow transactions to run on different platform in a network.
The design of OLTP should follow the discipline of data modelling and should follow the Codd rules of data normalization. Using these rules, complex information is broken down into its most simple structure where all the individual atomic level elements relate to each other and satisfy the rule of normalization.
The industry which have a large numbers of users who conduct short transactions uses OLTP. In OLTP concept database queries are simple but require sub second responses times and return relatively few records.
Objective of OLTP
- Fast Transactions
- Maximizing CPU Resource
- Maximizing IO Resources
Below Attributes are basic attributes which SQL Developer should know about OLTP
- Holds Current Data
- Store Detailed Data
- Enable a snap shot of business data
- Short and fast Insert/Update
- Handle large number of short on line transactions
- Involves standardized and simple queries that return relatively few records hence is faster
OLTP helps simplify a business operation by reducing paper trails and helping draw faster and accurate information.
Today with the ubiquity of the Internet, more and more people are doing on line transactions through e commerce environment. During the process of online transactions a merchant system will automatically connect to the bank or credit card company of the customer and carry out security and other fraud check and make decision of payment. In these kind of transactions it is advisable to have a robust, secure and reliable infrastructure that gives customer fast, seamless and secure check point.
Sanjay Bakshi
mesanjaybakshi@gmailcom
Sanjay Bakshi
mesanjaybakshi@gmailcom
(Keep Calm & Keep Learning)
No comments:
Post a Comment