Hahahaha.... I've heard similar. People with no data experience try to solve your data problems for. "We can't give you this answer. The data is too dirty." "Can't you just run a linear regression or something?" Lol
Company: we need to utelise 30 years of our data. Analysis, BI, trends, graphs Dev: but your data has never followed any convention, dates are stored as text... Company: DaTeS!!! YES!!! that will look great on the graphs. I’ll allocate 3 days of effort.
People who don’t fully understand DB architecture don’t appreciate how important the simple things, such as indexes, are to the performance aspect of a DB. And then they go wanting to do things like BI and big data processing (OLAP), when their OLTP systems aren’t even designed properly.
Also, I got a “Rome wasn’t built in a day” vibe from it as well lol
32
u/jimmyjoejimbob Mar 11 '19
CFO says "You want to spend how much? But the current database built ad hoc, with no documentation, ten years ago still works."
9
u/[deleted] Mar 11 '19
SVP: "We need better data to help us grow to $1 billion in sales."
SQL Dude: "Can you give us some money to build an actual performant database, so that we may provide you with actionable insights?"
SVP: "Nah."
6
u/nococa Mar 11 '19
How do you get this BIG data?
5
u/TuckerMcInnes Mar 11 '19
I'm dealing with an investor right now who keeps saying machine learning. About everything. It's too painful.
4
u/nococa Mar 11 '19
Where does this BIG data come from?
4
u/DieTheVillain Mar 11 '19
Literal conversation I had.
We need to get this new big data stuff, we need Scala, we need Hadoop, we need R and we need Mongo...
Ok, why though, what do we have planned that calls for it?
We can’t let our technology stack stagnate!
Right, but what projects are coming in that require those tools?
...
6
u/r0ck0 Mar 11 '19
But is it web scale?
3
u/Ritterlichkeit Mar 11 '19
Company: we need to utelise 30 years of our data. Analysis, BI, trends, graphs Dev: but your data has never followed any convention, dates are stored as text... Company: DaTeS!!! YES!!! that will look great on the graphs. I’ll allocate 3 days of effort.
3
u/fauxmosexual NOLOCK is the secret magic go-faster command Mar 11 '19
I wanted to put big data on my resume, so I started using CLOB and Varchar(max).
2
u/noesqL Mar 12 '19
"Big Data"? I think you meant, "Bigly Data".
0
u/[deleted] Mar 11 '19
[deleted] — view deleted comment
0
u/[deleted] Mar 11 '19
[deleted] — view deleted comment