lmwnshn

5 ms·

31.
by lmwnshn 4y ago
Would you be able to provide examples of interesting facts, and is this tool (or anything similar) open-source or described publicly? Thanks!
32.
by lmwnshn 4y ago
Thanks! Super interesting.
33.
by lmwnshn 4y ago
On the other hand, you're probably writing your SQL parser to parse SQL queries that are being fed into some DBMS. I found pg_query's argument convincing: "Our conclusion: The only way to correctly parse all valid SQL queries
34.
by lmwnshn 4y ago
> less impactful now with Sql Server 2019 Could I ask what your process is for detecting whether a rewrite rule is still useful in subsequent versions of the DBMS? Do you read the release notes and test things out manually, or do you hav
35.
by lmwnshn 4y ago
In Andy Pavlo's current seminar class 15-799 [0], everyone parsed SQL to extract which columns were being accessed in a workload's queries. This was used to build an automatic index tuning tool. [0] https://15799.course
36.
by lmwnshn 5y ago
Since you have a CMU ID, AFAIK you should be able to enroll in Piazza in addition to following along with the assignments/projects (if you wanted to).
37.
by lmwnshn 7y ago
FWIW, Carnegie Mellon runs a "tools of the trade" course which is targeted to CS first-years, GPI [0], that is mostly taught by student TAs with the supervision of a professor. Asking students to create and teach the material seem
38.
by lmwnshn 7y ago
The previous offering of this course had students implement some of ARIES [0]. [0] https://15445.courses.cs.cmu.edu/fall2018/project4/
39.
by lmwnshn 7y ago
He does. [0] [0] https://15445.courses.cs.cmu.edu/fall2019/slides/02-advanced... slide 3