Database basics – Dyalog Webinar with Richard Park
In this webinar, we will discuss some fundamentals of databases and when they are useful. We then show some of the different levels of control of external database systems available from Dyalog.
Slides PPTX: https://www.dyalog.com/uploads/files/...
Slides PDF: https://www.dyalog.com/uploads/files/...
Dyalog ]demo file TXT: https://www.dyalog.com/uploads/files/...
Start: (0:00)
Introduction: (1:00)
What is a database?: (3:10)
What is a DBMS?: (4:20)
Types of databases: (5:48)
Creating a relational data model: (7:55)
Query languages: (18:00)
APL arrays vs DBMS: (19:26)
OLTP and OLAP types of relational databases: (23:08)
Relational data technologies - matrices, inverted tables, dataframes and DBMS: (25:10)
Nested matrix example: (29:13)
Inverted tables and performance: (34:46)
Reference to Table2JSON (to do: publish utility): (41:05)
Ideas for creating a query language DSL in APL: (41:16)
Existing inverted table columnar database systems: (43:26)
Column names cover function: (45:37)
When to use an OLTP or OLAP system: (49:56)
SQAPL SQL Dyalog APL interface demonstration: (50:52)
Conclusion: (1:02:14)
--------------------
GET STARTED
Download the latest version of Dyalog:
https://www.dyalog.com/downloads
TAKE PART IN OUR APL COMPETITIONS
THE APL CHALLENGE
Learn APL and compete for one of three $100 prizes. Open to all experience levels.
https://challenge.dyalog.com
THE APL FORGE
Got a problem to solve or a library to share?
Use Dyalog APL to build something great — and win £2,500 + an expenses-paid trip to present at a Dyalog user meeting.
https://forge.dyalog.com
--------------------