Darsh Pateldarsh-patel.hashnode.dev·Aug 13, 2023OLTP vs Data AnalyticsData is everywhere, and it is the fuel that drives many businesses and organizations. But how do we make sense of the vast amounts of data that are generated every day? How do we use data to improve our products, services, and processes? How do we le...Discuss·27 readsDBMSDBMS
Ahmad Ateyablog.ahmadateya.com·Jun 4, 2023Columnar Databases & CompressionIntroduction In the previous article, we delved into the world of database storage, specifically focusing on disk-oriented DBMS and how tuples are stored within pages using different approaches such as the Tuple Oriented Approach, Slotted Pages Appro...Discuss·17 likes·32 readsCMU's Intro to DBMSDatabases
Saumya Guptasaumyagupta.hashnode.dev·May 29, 2023OLAP vs. OLTP - Which One's Your Data's Ally?Introduction In today's fast-paced business world, data processing holds tremendous significance. It acts as a powerful tool for organizations to extract valuable insights from their data and make informed decisions that drive success. Amidst the vas...Discuss·10 likesOLAP
Rajanand Ilangovanblog.rajanand.org·Apr 2, 2023OLAP vs OLTPIf you're new to databases, you may have come across the terms OLAP and OLTP. In this blog post, we'll explain what they mean, and the differences between them, and provide real-life examples to help you understand these concepts. OLAP and OLTP are t...DiscussOLAP
Sanket Singhsanketsingh.hashnode.dev·Mar 31, 2023Getting Started With Data EngineeringWhat is Data Engineering? It is a type of software engineering that focuses on designing, developing, testing and maintaining architectures such as databases and large-scale processing systems. It is a process of storing, processing and extracting in...Discuss·103 readsdata-engineering
Samuel Sorialsamuel-sorial.hashnode.dev·Oct 16, 2022Storage Models for DatabasesIntroduction Different applications have different requirements, as discussed in What the heck is OLTP, OLAP?, it depends on business rules to define the workload of our database. Therefore, we need different storage models for the database in order ...Discuss·368 readsDatabaseDatabases
Samuel Sorialsamuel-sorial.hashnode.dev·Jul 14, 2022What the heck is OLTP, OLAP?What's OLTP? OLTP stands for Online Transaction Processing, in which a database is used to execute huge amounts of transactions. Transaction means to change data, either by inserting, updating, or deleting small amounts of data. It's usually used at ...Discuss·206 readsDatabasedatabase