Data Warehouse atau Gudang data merupakan suatu sistem manajemen basisdata relasional (RDMS) yang didesain khusus untuk memenuhi kebutuhan akan sistem pengolahan transaksi.
Pengertian OLTP pada Data Mining
Dikutip dari kompasiana.com yang ditulis pada artikel tanggal 14 Mei 2013 Online Transaction Processing atau sering dikenal dengan OLTP adalah sistem yang berorientasi proses yang memproses transaksi secara langsung melalui komputer yang terhubung dalam jaringan. Misalnya biasa digunakan pada sebuah supermarket, kasir menggunakan mesin dalam proses transaksinya.
Baca Juga: Proses Dalam Data Warehouse pada Data Mining
Sebuah basisdata yang dibangun untuk pengolahan transaksi secara online (OLTP), secara umum dipandang tidak cocok untuk data warehouse dikanenakan mereka didesain dengan suatu kumpulan kebutuhan yang berbeda, yaitu memaksimalkan kapasitas transaksi dan secara khusus mempunyai ratusan tabel dalam urutan yang tidak membatasi user, dsb. Data warehouse dipandang dalam proses query sebagai lawan dari proses transaksi.
Sistem OLTP tidak dapat menjadi tempat penyimpanan dari data fakta dan histori untuk analisa bisnis.Sistem ini tidak dapat menjawab secara cepat query dan pengambilan kembali secara cepat hampir tidak mungkin. Data yang tidak konsisten dan berubah, duplikasi masukan yang ada, masukan yang hi-lang dan tidak adanya data histori yang diperlukan untuk menganalisa trend.Pada dasarnya OLTP menawarkan sejumlah besar data mentah yang tidak mudah dipahami.Data warehouse menawarkan kemampuan untuk mengambil kembali dan menganalisa informasi secara cepat dan mudah. Data warehouse mempunyai kesamaan dengan OLTP‘seperti terlihat pada tabel berikut :
Baca Juga: Karakteristik Data Warehouse pada Data Mining
Data warehouse melayani tujuan yang berbeda dari sistem OLTP dengan memperbolehkan analisa query sebagai jawaban terhadap "simple aggregation" seperti “bagaimana catatan keuangan dari kastemer ini?" Query data warehouse khusus meliputi seperti "produk yang bagaimana yang paling laku di Amerika tengah dan bagaimana korelasi terhadap data demografis?"
21 Comments
Yet, as an entryway is shared by two compared rooms, we will think about that each room oversees just the entryways Down and Right that it contains (in light of the fact that they are at the down and right sides of the cells, in our drawings). ExcelR Data Science Courses
ReplyDeleteVery interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDeleteData Science In Banglore With Placements
Data Science Course In Bangalore
Data Science Training In Bangalore
Best Data Science Courses In Bangalore
Data Science Institute In Bangalore
Thank you..
I curious more interest in some of them hope you will give more information on this topics in your next articles.
ReplyDelete360digitmg artificial intelligence course
I am sure that this is going to help a lot of individuals. Keep up the good work. It is highly convincing and I enjoyed going through the entire blog.
ReplyDelete360digitmg ai courses
Attend The Artificial Intelligence course From ExcelR. Practical Artificial Intelligence course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Artificial Intelligence course.
ReplyDeleteArtificial Intelligence Course
Your article has all the necessary informative. It is a change of taste from other supposed informational content with some accurate points which needs to be focussed to get the details about the topic.
ReplyDeleteSAP training in Mumbai
SAP course in Mumbai
SAP training institute Mumbai
Indeed a great article! I am definitely going to bookmark it to go through it over again after work. It seems to cover the major information about the topic in points.
ReplyDeleteSAP training in Kolkata
SAP course in Kolkata
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. cloud computing course in jaipur
ReplyDeleteThanks for sharing this valuable information, we also provide instagram video download and,
ReplyDeletereally appreciate your hard work and good research that help us in for of your good valuable article. Keep updating us with your awesome content.
Thanks for sharing this valuable information, we also provide instagram video download and,
ReplyDeletereally appreciate your hard work and good research that help us in for of your good valuable article. Keep updating us with your awesome content.
With decision making becoming more and more data-driven, learn the skills necessary to unveil patterns useful to make valuable decisions from the data collected. Also, get a chance to work with various datasets that are collected from various sources and discover the relationships between them. Ace all the skills and tools of Data Science and step into the world of opportunities with the Best Data Science training institutes in Bangalore.data analytics courses in hyderabad
ReplyDeleteThis is an awesome motivational article. I am practically satisfied with your excellent work. You put really extremely useful data. Keep it up like this. Keep blogging. Looking forward to reading your next post
ReplyDeleteData science course in mangalore
This is an awesome motivational article. I am practically satisfied with your excellent work. You put really extremely useful data. Keep it up like this. Keep blogging. Looking forward to reading your next post
ReplyDeleteData science course in mangalore
You have amazing writing skills and you display them in every article. Keep it going!
ReplyDeleteChoose our Online Course Visit Best Cyber Security Training Online
You have amazing writing skills and you display them in every article. Keep it going!
ReplyDeleteChoose our Online Course Visit cyber security Training
It's late finding this act. At least, it's a thing to be familiar with that there are such events exist.
ReplyDeleteI agree with your Blog and I will be back to inspect it more in the future so please keep up your act.
360DigiTMG data science course
Hi I have read a lot from this blog thank you for sharing this information. We Provide all the essential topics in data science like,Python, Machine Learning,AI and Deep Learning, Tableau, etc.
ReplyDeleteFor more information just log in to our website :- Data Science course in Mumbai
The data presented is both structured and unstructured. As mentioned above,
ReplyDeleteit is the analysis of all these kinds of raw data from the past to the future; the reader sees the predictive analysis. The evidence of the history used to predict a possible future is what data science is about.
data analytics courses pune
The data presented is both structured and unstructured. As mentioned above,
ReplyDeleteit is the analysis of all these kinds of raw data from the past to the future; the reader sees the predictive analysis. The evidence of the history used to predict a possible future is what data science is about.
data analytics courses pune
https://muse.union.edu/2020-isc080-roprif/2020/05/20/caring-for-terminally-ill-patients-and-their-caregivers/comment-page-93/#comment-133868
ReplyDeletehttps://www.ottawaks.gov/profile/kousalya-k288/profile
http://sites.gsu.edu/jsalters2/1-problem-definition/comment-page-2397/#comment-181878
https://www.climatehistorylab.sites.tau.ac.il/profile/kousalya-k288/profile
https://www.nhat.thanhdong.edu.vn/profile/kousalya-k288/profile
https://sites.suffolk.edu/connormulcahy/2014/03/31/keystone-xl-pipeline/comment-page-207/#comment-233821
https://muse.union.edu/2020-isc080-roprif/2020/05/20/caring-for-terminally-ill-patients-and-their-caregivers/comment-page-93/#comment-133966
https://blogs.memphis.edu/padm3601/2016/02/04/the-link-between-mental-health-and-crime/comment-page-464/#comment-75933
Memperkenalkan Pengunduh Reel Instagram kami! Simpan dan nikmati IG Reels favorit Anda secara offline dengan mudah. Salin, tempel, dan unduh. Nikmati akses instan kapan saja, di mana saja.
ReplyDeletePengunduh Reel Instagram