How to Optimize a K2V Database

Array Cast - May 26, 2023 Show Notes

Thanks to Bob Therriault, Marshall Lochbaum, Conor Hoekstra, Adám Brudzewsky and Nick Psaris for gathering these links:

[01] 00:02:15 Eric's post J Programming Language http://www.jsoftware.com/pipermail/programming/2023-May/062524.html

              J wiki https://code.jsoftware.com/wiki/Main_Page

[02] 00:03:23 Programming language design on StackOverflow  https://languagedesign.stackexchange.com/

[03] 00:05:04 Phineas Porter's blog post https://iabdb.me/2021/05/28/idempotent-moving-window-is-simply-a-reduction/

[04] 00:08:00 ArrayCast Episode 3 https://www.arraycast.com/episodes/episode-02-challenges-facing-the-array-languages

              ArrayCast Episode 4 https://www.arraycast.com/episodes/episode-03-what-is-an-array

              ArrayCast Episode 5 https://www.arraycast.com/episodes/episode-04-responding-to-listeners-email
              ArrayCast Episode 42

https://www.arraycast.com/episodes/episode42-nick-psaris-q

              "Q Tips" by Nick Psaris https://www.goodreads.com/book/show/25221469-q-tips

              "Fun Q" by Nick Psaris https://www.goodreads.com/book/show/54656615-fun-q

[05] 00:09:40  PyKX https://kx.com/pykx/

              Python Programming Language https://en.wikipedia.org/wiki/Python_(programming_language)

[06] 00:12:27 peach in q https://code.kx.com/q/basics/peach/

[07] 00:16:10 Z compression https://en.wikipedia.org/wiki/Zstd

              Garbage Collection https://code.kx.com/q/ref/dotq/#gc-garbage-collect

              Loading databases https://code.kx.com/q/basics/syscmds/#l-load-file-or-directory

              \c autosizing https://code.kx.com/q/basics/syscmds/#c-console-size

[08] 00:25:20 GPU https://en.wikipedia.org/wiki/Graphics_processing_unit

[09] 00:26:09 Stable Marriage problem https://en.wikipedia.org/wiki/Stable_marriage_problem

               Nick's presentation https://nick.psaris.com/presentation/maching-algorithms-in-q/

[10] 00:29:55 Attila Vrabecz ArrayCast Episode https://www.arraycast.com/episodes/episode-08-attila-vrabecz-and-the-k-group-of-programming-languages

[11] 00:32:23 Mohammad Noor at Citadel https://www.linkedin.com/in/mohammadnoor/

[12] 00:33:50 Kevin Webster's  Handbook of Price Impact Modeling https://www.routledge.com/Handbook-of-Price-Impact-Modeling/Webster/p/book/9781032328225

[13] 00:35:05 Erin Stanton https://www.linkedin.com/in/erin-stanton-data-science/

[14] 00:42:15 Snowflake https://en.wikipedia.org/wiki/Snowflake_Inc.

              Snowpark https://www.snowflake.com/en/data-cloud/snowpark/

             kdb+ Snowflake https://pipes.datavirtuality.com/connectors/integrate/kdb/snowflake/

[15] 00:44:00 Nateraj Dasgupta medical application https://www.linkedin.com/in/natarajdasgupta/

[16] 00:47:09 Igor Kantor Data as a Service https://www.linkedin.com/in/igorkantor/

                        Karthic Murali - Goldman Sachs https://www.linkedin.com/in/karthikmurali2/

[17] 00:49:05 Rebecca Kelly qubot https://www.inqdata.com/

[18] 00:49:23 Aaron Davies Transformer Discussion https://github.com/adavies42/qist/blob/master/lib/raspq.q

[19] 00:52:55 Phineas Porter Edge Detection https://pindash.github.io/talks/seam_carving.html

              Liquid rescaling https://en.wikipedia.org/wiki/Seam_carving

[20] 00:55:20 Alex Donohue Toronto Dominion https://www.linkedin.com/in/alex-donohue-b228a159/

[21] 00:56:05 Type promotion https://en.wikipedia.org/wiki/Type_conversion

              Type system https://en.wikipedia.org/wiki/Type_system

[22] 00:58:00 Perl programming language https://en.wikipedia.org/wiki/Perl

              Strong Typing https://en.wikipedia.org/wiki/Strong_and_weak_typing

[23] 01:02:00 2016 KXCon https://www.kdnuggets.com/2016/04/kxcon2016-kdb-conference-may-montauk-ny.html

[24] 01:04:09 Nick's 2016 kxcon presentation https://nick.psaris.com/competition/parsing-mnist-dataset/

              Nick's kx25 presentation https://nick.psaris.com/presentation/decision-trees-in-q/

[25] 01:06:45 Dyalog Conferences https://www.dyalog.com/user-meetings/index.htm

[26] 01:07:10 2012 J conference https://code.jsoftware.com/wiki/Community/Conference2012

              2014 J conference https://code.jsoftware.com/wiki/Community/Conference2014

[27] 01:09:02 APLSeeds conference https://www.dyalog.com/apl-seeds-user-meetings/aplseeds23.htm

[28] 01:14:56 Awesome q Stephen's GitHub library https://github.com/qbists/awesome-q

[29] 01:21:30 Contact AT ArrayCast DOT Com

[30] 01:22:32 Dyalog 21 Live ArrayCast episode https://www.arraycast.com/episodes/episode14-dyalog-21-live