4 ms·
It's just view, materialized view, udf, stored procedure in fancy corp speak.
by est 8mo ago
It's just view, materialized view, udf, stored procedure in fancy corp speak.
- trollbridge 8mo agoBelieve it or not, this stuff is still incredibly valuable.
- est 8mo agoI have to admit, those fancy concepts pay the bills.
- trollbridge 8mo agoI'm having a blast with using PostgreSQL to hold unstructured data in JSON-B and then creating views off of that that "feel" like more conventional SQL. If performance becomes an issue, just turn it into an MV... and then consider some indexing on the JSON itself.
- kumarvvr 8mo agoDo you have any resources or books to learn all the details of all these? Also, what is UDF?
- tfryman 8mo agoUser defined functions
- AxiomaticSpace 8mo agoPretty much any SQL book will cover it those, and there's a bunch of online SQL tutorials. UDF means user defined function, so if there's some function you want to perform in SQL but that function doesn't come out of the box, you can just write your own. And those can be defined in non-SQL syntax, such as UDF's written in python or C++, which can be pretty handy.
- dmoy 8mo ago> python or C++ Also sometimes Lua, which is kinda a nice middleground between c++ efficiency and python ease of writing
- whattheheckheck 8mo agoData warehouse toolkit for Kimball Google will inmon for the info factory Google data vault Joe reis is the guy for tying it up with a modern bow recently. Designing data intensive applications book
- rapind 8mo ago> fancy Karp speak. The paypal mafia are all about stories. They can attract talent and investor money with those stories, but they are just tall tales full of hype, and people are catching on (ok that last bit might be a hopium).
- jhanschoo 8mo ago> fancy corp speak Perhaps gov contractor speak would be more accurate. I'd think a corp with an org sufficiently aligned to their business value and profit motive wouldn't stand for the fancy speak either