Friday, January 3, 2014

Business Intelligence - OLTP vs OLAP (Differences)

Before I go to bed, I would like to share about OLTP and OLAP. This article is taken from 2 source: MicroStrategy and Datawarehouse4u. I think this article will be useful for us in order to understand more about the foundation of Business Intelligence. Enjoy. :)


---MicroStrategy---

#Source Systems (OLTP)

Source systems are typically databases, file sources, web sources or mainframes that store transaction processing data. As such, they are an OnLine Transaction Processing System (OLTP). Transaction processing involves simple recording of transaction like sales, inventory, withdrawals, deposits, and so forth.

The data in source systems have the following characteristics:
  • Data access is read/write (numerous selects, inserts, updates, and deletes).
  • Data is aligned by application (business activities and workflow).
  • Data formats are not necessarily uniform across different source systems.
  • Data history is typically limited to recent or current data.
A bank is one example of a business with many different types of source systems. The average bank offers their customers a variety of services and, therefore, needs these different type of source systems to support their services, each of which has a different workflow.

For example, consider the Automated Teller Machine (ATM) and the bank teller. At an ATM, you can withdraw or deposit money as well as check your account balance. However, if you need a money order, you have to go inside and speak with a bank teller. The bank has different operational system, each design to perform tasks that are specific to the service.

To take our example further, if a bank wanted to see a unified view of a particular customer - such as a customer's ATM activity, loan status, account balances, money market account information, and so forth - all of the customer's information from each of the different source systems would have to be collected. After this data is collected, it is stored in a centralized data warehouse.

#Data Warehouse (OLAP)

A well-designed and robust data warehouse lies at the heart of the business intelligence system and enables its users to leverage the competitive advantage that business intelligence provides. A data warehouse is an example of an OnLine Analytical Processing System (OLAP).

While source systems are designed and optimized for transaction processing, data warehouses are designed and optimized for analytical

processing. Analytical processing involves manipulating transaction records to calculate sales trends, growth patterns, percent to total contribution, trend report, profit analysis and so forth.

The data in a data warehouse have the following characteristics:
  • Data access is typically read-only (IN-SQL, mostly selects are used. Generally very few inserts, updates, or deletes are used).
  • Data is aligned by business subjects.
  • Data format are uniformly integrated.
  • Data history extends long term, usually 2 to 5 years.
A data warehouse is populated with data from the existing operational systems with an ETL process.

#Summary of Differences - OLTP VS OLAP

The following table summarizes the differences between OLTP and OLAP systems:


#ETL Process

The extraction, transformation, and loading (ETL) process contains information that facilitates the transfer of the data from the source systems to the data data warehouse.

Specifically, the ETL Process does the following:
  • Store information about the source system structure and content
  • Store information about the data warehouse structure and content
  • Correlates source system structure and content to that of the data warehouse
  • Provides information to the data extraction tools that physically execute the transfer of data from the source systems to the data warehouse




---Datawarehouse4u---

#OLTP vs. OLAP

We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.



OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).

OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).


The following table summarizes the major differences between OLTP and OLAP system design.



93 comments:

  1. Nice post.Thanks for sharing this post. Pridesys Business Intelligence (BI) is offering you easy-to-use analytics and business intelligence tools. With these tools you can explore your data. Create new patterns, rich visual and insights. to know more information visit: Pridesys IT Ltd

    ReplyDelete
  2. Hi, thank you very much for new information, i learned something new. Very well written.It was so good to read and usefull to improve knowledge.Keep posting. If you are looking for any big data hadoop related information please visit our website.
    big data hadoop training in bangalore.

    ReplyDelete
  3. On the off chance that you had concluded that you'd needed to be a business examiner, it would have been impossible that you would have considered music, show, medication, or some other apparently irrelevant subjects.
    business analysis

    ReplyDelete
  4. Thanks for sharing useful information. I learned something new from your bog. Its very interesting and informative. keep updating. If you are looking for any apache spark scala related information, please visit our website apache spark scala training institute in bangalore

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!. 雅思代考

    ReplyDelete
  7. All the contents you mentioned in post is too good and can be very useful. I will keep it in mind, thanks for sharing the information keep updating, looking forward for more posts.Thanks Pakistan Stock Exchange

    ReplyDelete
  8. It defines the limits of computability (solvable problems) and computational complexity (resources required to solve these problems in terms of time and space). artificial intelligence course in hyderabad

    ReplyDelete
  9. When do you think this Real Estate market will go back right side up? Or is it still too early to tell? We are seeing a lot of housing foreclosures in Winter Springs Florida. What about you? Would love to get your feedback on this. Flow Meter LC

    ReplyDelete
  10. It is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog. Please, continue to give me such valuable posts.Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

    ReplyDelete
  11. Be that as it may, when they show up at the speculator's or loan specialist's table some remain where they are and others go to the "I'll read them later" heap or more terrible still the garbage bin! . Knowledge Leader

    ReplyDelete
  12. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this... text message marketing for small business

    ReplyDelete
  13. What a sensational blog! This blog is too much amazing in all aspects. Especially, it looks awesome and the content available on it is utmost qualitative. audit tracking software

    ReplyDelete
  14. Through receiving a filtering and work process answer for supplant manual cycles, improved perceivability, straightforwardness and efficiencies can be harvested. nyc budget

    ReplyDelete
  15. Despite your great business plan, you will fail to obtain a loan because of your nervousness and lack of confidence when it comes to acting like a clever salesperson. free email spider software full version

    ReplyDelete
  16. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! strongarticle

    ReplyDelete
  17. Impressive! I finally found great post here. Nice article on data science . It's really a nice experience to read your post. Thanks for sharing your innovative ideas to our vision.

    Data Science Training in Hyderabad
    Data Science course in Hyderabad
    Data Science coaching in Hyderabad
    Data Science Training institute in Hyderabad
    Data Science institute in Hyderabad

    ReplyDelete
  18. The essential explanations behind the low turnout are vulnerability on a use of web-based media, figuring rate of profitability and convince workers/partners to secure online media.CBT Bulk Email Sender Software

    ReplyDelete
  19. Many entrepreneurs begin with a lot of "strong domain" experience but nützlicher Inhalt little to no business experience. Being in business is about finding solutions. That is what sets the strong businesses apart from the others.

    ReplyDelete
  20. It is in this scenario, that we often see small businesses jumping the bandwagon and creating profiles on all the available platforms. Creating social profile doesn't hamper brand image, but aggressively promoting a brand on wrong platforms can lead to brand losing its potential customers.more to go

    ReplyDelete
  21. To start a business, you need to find out what it is that you are truly passionate about. "Why is that important", you say? The answer is simple. You really do not want to get yourself stuck into a kind of work that you hate. https://europa-road.eu/hu/transportation.php

    ReplyDelete
  22. For certain components of a good business succession plan to work, business opportunities funding is required. Some common ways of funding a succession plan include investments, internal reserves and bank loans.

    ReplyDelete
  23. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. reputation management services

    ReplyDelete
  24. Thanks for the blog post buddy! Keep them coming... Australian Domain Name Registration

    ReplyDelete
  25. Nice blog, I will keep visiting this blog very often. mastering chemistry

    ReplyDelete
  26. This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. sulopay

    ReplyDelete
  27. All business plans have pretty much similar areas some even have a similar substance. SEO optimalisatie

    ReplyDelete
  28. I was looking at some of your posts on this website and I conceive this web site is really instructive! Keep putting up.. 123movies

    ReplyDelete
  29. Thanks for sharing nice information with us. i like your post and all you share with us is uptodate and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job. Investment in Pakistan stock exchange PSX

    ReplyDelete
  30. Great tips and very easy to understand. This will definitely be very useful for me when I get a chance to start my blog. Detail

    ReplyDelete
  31. I read your blog frequently and I just thought I’d say keep up the amazing work! digital marketing agency for small businesses

    ReplyDelete
  32. Print Manufacturing is it's own sub-type, actually a type of either Job Shop or Production Manufacturing relying upon what they make. IT support Richmond Hill

    ReplyDelete
  33. Because of working with Susan and her group, customers feel sure and diminished realizing their internet showcasing is in dependable and caring hands so they can zero in on building their business with true serenity at having an ideal emotionally supportive network set up to direct them consistently. telemarketing

    ReplyDelete
  34. Or then again perhaps you would have objectives in care, however have you outlined how to accomplish them? What requirements to occur to understand those objectives? Fortune best cryptocurrency to invest

    ReplyDelete
  35. That is to say, who hasn't squandered cash while seeking after their fantasy business? I sure have!
    seo services in karachi

    ReplyDelete
  36. Utilize this manual for start your gold business in Dubai - the City of Gold. Dubai as a position of business for gold exchanging gives an ideal chance to business development. Gold exchanging is quite possibly the most well known business in Dubai, offering more prudent unfamiliar capital in the country. vcard

    ReplyDelete
  37. Eventually, you don't have the foggiest idea what you don't have a clue and that is OK. There's nothing amiss with you. You essentially need to figure out how to designate! Lenos check here
    Eventually, you don't have the foggiest idea what you don't have a clue and that is OK. There's nothing amiss with you. You essentially need to figure out how to designate! Lenos check here

    ReplyDelete
  38. Before you can financing a business, a task, a development or an exchange, you should build specifically what your finance wants are. https://www.accreditloan.com/

    ReplyDelete
  39. You can select which tires you get, so that you need Michelin tires. You can upload a radio, and determine to get the greater pricey however awe inspiring Bose Radio. They do not promote trainers, so that you purchase an Airstream.Business funding

    ReplyDelete
  40. On this subject internet page, you'll see my best information, be sure to look over this level of detail. Software

    ReplyDelete
  41. Since Dubai is a famous worldwide excursion objective, the deluge of the richest clients can be altogether thought of assuming you need to begin a gold business. Masterbatches Producer

    ReplyDelete
  42. I might want to thank you for the endeavors you have made recorded as a hard copy this article. I am trusting a similar best work from you later on also. Truth be told your exploratory writing capacities has motivated me to begin my very own BlogEngine blog now. Extremely the blogging is spreading its wings quickly. Your review is a fine case of it. Medicare Options

    ReplyDelete
  43. That is the reason businesses can't be worked with only one individual. They need a group. black leather jacket mens

    ReplyDelete
  44. Utilize this manual for start your gold business in Dubai - the City of Gold. Dubai as a position of business for gold exchanging gives an ideal chance to business development. Gold exchanging is quite possibly the most mainstream business in Dubai, offering more practical unfamiliar capital in the country. Top 10 Reasons Why You Should Get Salesforce Certified

    ReplyDelete
  45. Essentially offering the time period needed to make a specific assistance or to give the substance of the actual undertaking is the manner by which the expense factor is determined and the benefits are acquired in the help based business. original leather jackets

    ReplyDelete
  46. Analytical intelligence is the intelligence that you use to write analytical essays and the problem solving skills required for standardized tests. first time managers

    ReplyDelete
  47. We have a pool of gifted specialists that will assist you with beginning your gold business in Dubai or anyplace in the UAE. mens b3 bomber jacket

    ReplyDelete
  48. Incidentally, particularly us ladies, we got it into our heads that we should realize how to do all that includes building a business. money coach

    ReplyDelete
  49. You can see these indications and consequently keep yourself from creating non-useful and pointless job search standards of conduct before they dominate.look at here

    ReplyDelete
  50. I can’t believe focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material without a doubt. It is one of the greatest contents. Gisinsulation

    ReplyDelete
  51. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. Turmeric Facial Cleanser

    ReplyDelete

  52. This article was written by a real thinking writer without a doubt. I agree many of the with the solid points made by the writer. I’ll be back day in and day for further new updates.
    jeffrey leonard attorney

    ReplyDelete
  53. Sending messages likewise assists with keeping your business at the highest point of psyche of your eventual clients who are still fence-sitting thus when they are prepared they are probably going to figure: "Goodness I should contact (your realty organization); they have been sending me every one of those magnificent land related messages." background check

    ReplyDelete
  54. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. visit this link

    ReplyDelete
  55. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work check this out

    ReplyDelete
  56. Accounts address the arrangement of unified advertisement decentralized cash sources, conservative relations moderately with the appropriation and utilization read more

    ReplyDelete
  57. Taking everything into account, these administrations might appear as though something organizations shouldn't have to realize that much about. selling merchant services

    ReplyDelete
  58. Very nice article. This article gives a clear idea in favor of the new people. Please visit my website.

    Satta number
    Satta Bajar

    ReplyDelete
  59. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. Abu Dhabi Company Formation

    ReplyDelete
  60. "I burned through a ton of time and cash on end of the week classes that offered no worth, however I felt a feeling of "FOMO" on the off chance that I didn't join in. Each time I left inclination flattened the workshop didn't give what was guaranteed and was only an attempt to seal the deal for a greater program. Finance Hub SW London Birmingham Midshires

    ReplyDelete
  61. Nonetheless, it's significant for a dealer administrations supplier to realize that every business is extraordinary. Merchant Services Referral Program

    ReplyDelete
  62. Great Blog. I read your blog. It's very interesting. Thank you for sharing such useful information. I really appreciated your effort, Keep it up. Money Management Personal Finance Columbus Financial & Success Coach Financial Life Coach Click Here

    ReplyDelete
  63. Doing everything or potentially fussing over accompanies a sticker price, principally burnout and unexpectedly annoying individuals LOL. This was a hard example for me quite a while back, when I thought I was Superwoman and could do everything."buy cheap youtube views

    ReplyDelete
  64. To direct you, we have recorded a portion of the fundamental advances you ought to do to shape a gold business organization in Dubai..
    buy cheap youtube views

    ReplyDelete
  65. Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and linkto this instead if thats cool. Thanks. How to Become a Payment Processor

    ReplyDelete
  66. You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! Selling Merchant Services

    ReplyDelete
  67. If you hope to have success in selling your credit card processing business, then you need to be sure that you have your ducks in a row. This means doing the preparation work and familiarizing yourself with what is possible and what is not when it comes to your residuals portfolio. merchant services business for sale

    ReplyDelete
  68. Now i am definitely content to uncover this page in addition to performed delight in examining practical articles or blog posts placed in this article. This thoughts on the article author seemed to be brilliant, appreciate it with the write about. Credit Card Processing Residual Income

    ReplyDelete
  69. Good post. Thanks for the right unique information about this topic.my all curiosity on this topic now cleared. I am waiting for your next valuable, informative post.
    Satta king fast
    Satta result

    ReplyDelete
  70. Great information provided in the article. I like the information. Thanks For This Valuable Information. Your Information Is Very Useful For Everyone. Financial Advisors Financial Counseling Columbus Financial & Success Coach Money Coach Click Here

    ReplyDelete
  71. Superb publish, proceeded to go forward as well as saved your website. We can’t wait around to see much more through a person. credit card processing portfolios for sale

    ReplyDelete
  72. Best work you have done, this online website is cool with great facts and looks. I have stopped at this blog after viewing the excellent content. I will be back for more qualitative work. Abu Dhabi Foreign Company Registration

    ReplyDelete
  73. This one from Christine Awram, organizer of Woman of Worth, shares her important illustration on attempting to do everything herself:https://hostinglelo.in/

    ReplyDelete
  74. Whereas, the only disadvantage of purchasing at a local shop is that it is tiring and time consuming. go here now

    ReplyDelete
  75. Digital technology is transforming the way in which business and marketers perceive and approach their customers. new businesses

    ReplyDelete
  76. Watchwords are the words that individuals type into web crawlers to observe what they are searching for. On the off chance that you're a professional canine care organization in Boise, a portion of your catchphrases will be "Boise" and "professional canine care". World Wide Dream Builders

    ReplyDelete
  77. Businesses need to delegate to individuals who have ability in regions the author doesn't.. And negative, https://www.buyyoutubesubscribers.in/

    ReplyDelete
  78. I asked individual business proprietors in a Facebook bunch I have a place with what they tracked down inefficient in their business and all through this piece you will hear their reactions.credit repair services

    ReplyDelete
  79. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. this page

    ReplyDelete
  80. Many finance companies offer 100 percent financing for the cost of software and maintenance contracts, which requires no down payment. md credit repair

    ReplyDelete
  81. Microsoft Office is a family of client software, server software, and services which were developed by Microsoft. It was first announced by Microsoft Product Key Free

    ReplyDelete
  82. Recuva Pro Crack is a famous information the latest version software. It is the quality and feature improve generation. It's deep dependable information Recuva Cracked

    ReplyDelete
  83. Goodnight my sweet and lovely special older sister, I pray that you lay your head in a blissful passion of your soft pillow, and may tomorrow bring you much joy and delight. Sweet Dreams Good Night Sister

    ReplyDelete

  84. The UNICEF is one of the five conveners of the EFA and a critical donor in accomplishing the objectives; its liability covers youth care, training in crisis circumstances and giving strategy and technical support.allen bradley panelview 5310 front overlay

    ReplyDelete
  85. It is mandated by the law to have a different business represent all brokers.
    bavcars

    ReplyDelete
  86. DMCA ignored hosting services, often referred to as offshore hosting, prioritize user privacy and freedom by disregarding Digital Millennium Copyright Act (DMCA) takedown requests.

    ReplyDelete
  87. Thanks for sharing this information; it is useful to us. Data science training in Hyderabad

    ReplyDelete

Share Your Inspiration...