[LMG S7] Issue 90: Using a database
Previously: Graph databases treat the details of things as secondary, and optimise for managing the network of relationships. A graph database can quickly...
![[LMG S7] Issue 89: Graph Databases](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue089/issue089_01.png)
[LMG S7] Issue 89: Graph Databases
Previously: Document databases organise data into documents, each containing a number of field-value pairs. each value can itself be a document, and multiple...
[LMG S7] Issue 88: Document Databases
Previously: Relational databases are designed to maintain a well-structured set of data tables through constraint rules. This makes them very useful for...
![[LMG S7] Issue 87: Relational Databases](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue084/issue084_04.png)
[LMG S7] Issue 87: Relational Databases
Previously: To increase the performance of a distributed database, we can scale up/scale vertically by increasing the computers’ performance, or scale...
[LMG S7] Issue 86: Distributed databases
Previously: Forms that naïvely inject user-submitted data into a SQL query template may end up sending valid SQL commands to the database, with disastrous...
![[LMG S7] Issue 85: SQL Injections](https://imgs.xkcd.com/comics/exploits_of_a_mom.png)
[LMG S7] Issue 85: SQL Injections
Previously: SQL queries let you join multiple tables based on specified conditions using the JOIN keyword. This enables crafting complex queries to return...
![[LMG S7] Issue 84: JOIN – supercharged VLOOKUP](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season7/issue084/issue084_01.png)
[LMG S7] Issue 84: JOIN – supercharged VLOOKUP
Previously: Structured Query Language (SQL) is a computer language for managing data in databases. It has keywords and keyphrases that let you filter rows...
[LMG S7] Issue 83: Structured Query Language
Previously: A database system follows rules that enable multiple users to send commands to the database at the same time. The system attempts to execute each...
[LMG S7] Issue 82: Multiplayer databases
Previously: Putting all data into one table results in unnecessary duplication of data. Making data atomic by splitting it up into multiple tables makes the...
[LMG S7] Issue 81: Data Normalisation
Previously: An index is a separate table containing key terms in the database (usually names, IDs, or some other key identifier), alongside the row numbers...
[LMG S7] Issue 80: Indexing
Previously: Comma-separated value (CSV) files store all data in text form. Within each row, a separator divides each chunk of data, and rows are separated by...
[LMG S7] Issue 79: A Base for Data
Previously: Modern webpages rely on many third-party resources for their functionality. Blocking access to some domains may cause these webpages to break and...
![[LMG S6] Issue 78: uMatrix: voyuering the voyeurs](https://github.com/ngjunsiang/laymansguide/blob/release/season6/issue078/issue078_01.png?raw=true)
[LMG S6] Issue 78: uMatrix: voyuering the voyeurs
I belatedly realised that this issue was mis-scheduled, which is why there wasn’t an issue last week. My apologies! Previously: The default settings of most...
[LMG S6] Issue 77: Wearing clothes on the Internet
Previously: Cookies with the same domain as the site are first-party cookies, while cookies with domains different from the site are third-party cookies....
[LMG S6] Issue 76: Third-parties and cross-site resources
Previously: By not enforcing strict cookie policies on their own sites, publishers allowed advertisers to sneakily set cookies on their site audience. This...
[LMG S6] Issue 75: The Costs of Data Leakage
Previously: Data companies use the data they have gathered to determine what ads to serve you when you visit sites that load their cookie-setting scripts....
![[LMG S6] Issue 74: The Walls Have Pixels](https://raw.githubusercontent.com/ngjunsiang/laymansguide/release/season6/issue074/issue074_01.png)
[LMG S6] Issue 74: The Walls Have Pixels
Previously: When a page loads advertisements through header bidding, it sends your cookie along with other information to an ad exchange. The ad exchange...
[LMG S6] Issue 73: The Heart of Darkness (Header Bidding)
Previously: QuantCast gathers a large amount of data on internet users directly through its cookie (which other publishers serve through their websites), and...
[LMG S6] Issue 72: The Data Brokers
Previously: In 2006, Quantcast offered complete audience analytics for any site that puts their cookie on the site. In this way, they managed to gather...
[LMG S6] Issue 71: The Rise of Audience Analytics
Previously: A tracking script retrieves the existing cookie on a web domain if there is one, or sets a cookie on a webpage if there isn’t an existing one....