InInformaticsbyM. Ramadhan·Aug 11Selection Operations: A Deep Dive into WHERE vs. HAVING in SQLUnlocking query performance: why execution order, indexing, and aggregation matter
InInformaticsbyM. Ramadhan·Aug 10The Projection Operation in Relational Algebra and SQL: Bridging Theory and PracticeWhy do database textbooks demand duplicate removal while your SQL code doesn’t? Let’s unmask the biggest compromise between pure…
Jeremy Miller·Jul 27Building a Safe Data Terminal for Enterprise AIQueryBuilder, DataSets and the framework behind an AI investigator
Stephan Bökelmann·Apr 24The Recursion Problem in Relational AlgebraRelational algebra is the theoretical backbone of every query you will ever write against a relational database. Selection, projection…
Tejus Chandrashekar·Sep 28, 2025Towards Hidden Query Extraction(HQE) for Negation Operators — Part 3(Building Context)How UNMASQUE Detects EquiJoin Predicates
Kaytchjam·Mar 17, 2025CS373 Spring 2025 Blog #9: Kaylan TchamdjouWhat did you think of Paper 9. The Dependency Inversion Principle and what would make it better? Very much enjoyed this paper in…
Jordi Weber·Mar 17, 2025CS373 Spring 2025: Jordi WeberWhat did you think of Paper 9. The Dependency Inversion Principle and what would make it better?
Kaytchjam·Mar 9, 2025CS373 Spring 2025 Blog #8: Kaylan TchamdjouWhat did you think of Paper 8. The Integration Segregation Principle and what would make it better? I found paper 8, the Integration…
Ajay Kumar Mahto·Dec 27, 2024Design Process for Database SystemsER Model for real world representation with entities, entity sets, attributes, and relationship
