prathap chowdaryprathap.tech·Nov 2, 2023Scaling PostgreSQL for analytics data worldAuthor: @Potturi Prathap Chowdary Introduction One of the true pillars of the tech revolution, PostgreSQL is an OLTP database designed primarily to handle transactional workloads. The technology has been around for over 25 years and, nevertheless, cl...DiscussPostgreSQL
Kareem Olawaledatabasemonk.hashnode.dev·Jul 28, 2023Understanding Facts, Dimensions, and Attributes in Business Intelligence (2/2)Sales Analysis Eample In the example below, Table 1 represents the sales facts, including the date, product, quantity sold, and revenue. The facts represent the measurable metrics of the business. Table 2 represents the dimension of time, which provi...DiscussBUSINESS INTELLIGENCE
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·33 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
Swapna Kumar PandaProswapnakpanda.hashnode.dev·Mar 26, 2023Introduction to esProc SPLBefore we discuss esProc SPL, it's important to understand what a database language is and why SQL is so commonly used. Once we understand the problem statement, we will travel to the world of esProc SPL. Objective of database language To clarify thi...Discuss·3 likes·273 readsDatabases
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·602 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·226 readsDatabasedatabase
