r/compsci • u/tranquilinho • 6d ago

[ Removed by moderator ]

[removed] — view removed post

0 Upvotes

39% Upvoted

8 comments sorted by

4

u/FragrantCondominium 6d ago

s now, SQL is basically undying at this point. the whole nosql wave tried to bury it and somehow it just keeps chugging along while mongo hype cycles come and go

failure wise the semantic web is a classic, tim berners-lee really thought we'd all be annotating our html with rdf triples and instead we got twitter

3

u/currentscurrents 6d ago

The big problem with the semantic web was the labor-intensive manual tagging. You had to know in advance what abstractions over the data you cared about, and manually build those abstractions into a structured format. Other knowledge graph projects like Cyc had the same problem.

What we really needed was software that could automatically learn semantics from data, but we'd have to wait another couple decades for that.

6

u/cancerouslump 6d ago

(1) learning to learn. Pushing yourself to constantly learn. Learn more languages than you need.
(2) understand how the machine actually works, down to the assembly level. Understand CPU caches, memory latency hierarchies, etc.
(3) data structures. In the end it’s all data structures and algorithms.
(4) stats. There’s a huge overlap between compsci and data science. Understanding how to evaluate the results of an experiment is a superpower.

2

u/cancerouslump 6d ago

(I riffed on your question a bit to talk about things to learn than stand the test of time. Over the course of a career, few technologies persist, but the basic skills needed endure)

2

u/pbvas 6d ago

Compilers (both theory and practice)

2

u/s32 5d ago

At a verrry high level

  • Finite automota and state machines
  • Formal languages and grammars
  • Domain-specific languages
  • Turing machines and theory
  • OS abstractions
  • Data modeling and relational modeling
  • Information theory, error correction

Each one of those could have a multi page explanation, but IMO these are the things that will never die. Non exhaustive.

2

u/KnowsSomeRegs 3d ago

Failure story: Gaussian copula for CDO pricing. Elegant math, then nobody stress tested the correlation assumption until 2008. Some VaR desks still lean on similar stuff, idk.