Summary of MongoDB learning notes (including errors, problems, techniques)

Environmental Science OS: Ubuntu20.04 MongoDB: v5.0.2 Introduction to MongoDB MongoDB is an open source document database that provides high performance, high availability, and automatic scaling to provide scalable high performance data storage solutions for WEB applications. MongoDB is a product between relational and non-relational datab ...

Posted on Fri, 26 Nov 2021 15:12:50 -0500 by Cugel

Wu Yiji's counting Guide_ 5.1 dimension modeling skills: SCD2 type slow change dimension construction

0. Introduction Slow Changing Dimension (SCD) is a technology used almost all the time in dimension modeling. It provides the ability of slicing and chunking dimensions based on historical data. 1.SCD type According to master kimball's theory, there are seven types of SCD, but SCD2 is the most commonly used in daily warehouse development ...

Posted on Sun, 21 Nov 2021 03:45:10 -0500 by cstevio

DWD layer (user behavior log)

Data warehouse construction - DWD floor 1) Analyze user behavior data. 2) Re model the business data using the dimension model. Log parsing idea 1) Log structure review (1) Page buried point log (2) Startup log 2) Log parsing idea get_ json_ Use of object function 1) Data [{"name":"Dalang","sex":"male","age":"25"},{"name":"ximen q ...

Posted on Mon, 01 Nov 2021 02:23:54 -0400 by canabatz