Roshanmroshan.hashnode.dev·Dec 6, 2024Storing Prices in Your Database: The Right Way to Avoid Costly MistakesWhen building an e-commerce platform, a financial application, or any system that handles monetary transactions, one of the most critical components is how you store and calculate prices. Choosing the wrong data type for prices can lead to subtle yet...10 likes·35 readsDatabases
samhita sarkarsamhita-sarkar.hashnode.dev·Nov 11, 2024Deciding When to Normalize or Denormalize Data for Best ResultsNormalisation and denormalisation are essentially design patterns in databases that determine how data is stored and used. Storage pattern : The key difference between normalisation and denormalisation is their storage patterns, which are essentially...1 like·54 readsDatabases
Lara Leelaraaa.hashnode.dev·Oct 21, 2024Core Technology of PolarDB-X Storage Engine | Lizard Lock-free BackupBackup Background PolarDB-X distributed database adopts an integrated centralized-distributed architecture. As business development and expansion progress, the Data Node can be gradually expanded from centralized to distributed linearly, smoothly, an...Databases
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Oct 4, 2024Dimensional Data Model for App Help Center PageIntroduction The success of a digital product heavily depends on providing users with efficient support and guidance. One of the key tools for achieving this is a well-structured help center that users can navigate to find solutions to their problems...dimensional modelling
Shani Riversshanirivers.hashnode.dev·Oct 3, 2024How to Kickstart Your Career in DataWhy did I give you a roadmap instead of writing courses on the basics of SQL, HTML, CSS, and Javascript? Because, there are so many great and free stuff out there that I feel do more than a great job at getting a beginner up to speed, especially befo...Data Science
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Sep 27, 2024Dimensional Data Modeling for an E-Commerce StoreIntroduction: Understanding the Business Process In an online retail environment like Walmart, there are multiple critical processes involved in fulfilling customer orders. These include capturing customer details, managing product inventories, proce...data-engineering
Prajwal Urkudeprajwalurkude.hashnode.dev·Sep 22, 2024🚀 Boost Your Side Projects with These Free, Production-Level Databases:Whether you're building a hobby project or experimenting with new ideas, these free databases can provide the reliability and scalability you need: Neon Database Exploring Neon Database: Features, Usage, and Code Implementation Introduction Neon ...31 likes·112 readsneondatabase
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Sep 20, 2024Dimensional Data Model for Airbnb and VRBOUnderstanding the Business Domain Before diving into the data model, it's crucial to understand the key entities and relationships in an online marketplace for short-term homestays. Here are the primary entities: Users: Guests and hosts Properties:...analytics engineering
Saarthak Mainisaarthakmaini.hashnode.dev·Sep 14, 2024Indexing in DatabasesWhen working with databases, performance is often a key concern, especially as data grows in size. Efficient data retrieval becomes critical for applications that demand quick query results. One of the most effective ways to enhance database performa...Databases
Muhammad Abdiel Al Hafizabdiel.hashnode.dev·Sep 7, 2024Pentingnya Normalisasi Database untuk Konsistensi dan Integritas DataData yang konsisten dan akurat merupakan fondasi dalam pengambilan keputusan yang tepat. Untuk memastikan data tetap terstruktur dengan baik dan terhindar dari inkonsistensi, salah satu teknik penting yang digunakan adalah normalisasi. Teknik ini san...1 like2NF