Presented to the Phoenix Linux Users Group (PLUG) on April 13th 2017 by Phil Waclawski.
Real world data is often made of hierarchical relationships, or “trees”.
Representing that data in a Relational Database starts to get complicated as soon as you have more than two levels in your “Tree”.
There are many strategies for handling such data, and I will cover examples of at least two of them (adjacency list and nested sets) and possibly more.
If you have access to a mysql instance, you can create the test tables and follow along, or get the code later.
Phil has been a faculty member, focusing on open source software at MCC for nearly two decades.
This summer, Phil will once again be offering a “MCC Multimedia Madness” summer camp for 6-8th graders. Over the two weeks I will cover a wide range of open source software, including GIMP, Inkscape, Krita, Audacity, Blender, Hydrogen Drum Kit, Tux Guitar, Openshot, Linux Multimedia Studio, work with green screen and more.
For hobbies, Phil has too many. Blacksmithing, archery, Leatherworking, Wood Working, Jewelry, Sound Recording/editing and SCUBA diving. Phil is also learning to play the Bass.
Phil has been using linux at home for desktops and servers since 1994.
If you like what you see here, the Phoenix Linux Users Group meets several times a month. Please visit for meeting times and locations then come see the presentations live and uncut.
Xem thêm bài viết khác: https://saesrpg.net/giai-tri/
Xem thêm Bài Viết:
- TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
- Conversation with foreigners in English | Learn English for all levels
- Cố Chấp – Về Nơi Đâu (Phần 1) – TraCy Thảo My [ Official Music Video ]
- Học trực tuyến trên truyền hình MyTV: Giải pháp tối ưu mùa Covid-19
- Hướng dẫn sử dụng tính năng Điều khiển tivi (Remote Controller) trên MyTV và MyTV Net