#opendaylight-meeting: tws

Meeting summary

1. agenda (tbachman, 18:00:12)
   1. presentation on XSQL (tbachman, 18:00:38)
   
   
2. XSQL presentation (tbachman, 18:08:18)
   1. xSQL is a query language for trees (tbachman, 18:17:43)
   2. xSQL examines the schema context of the yang models, and develops a blueprint using each node type in the tree with each parent (tbachman, 18:18:26)
   3. This allows you to just extract data from a node in the tree just using a node type (tbachman, 18:18:54)
   4. For exmple, with a module structure of node/node-connectors/node-connector-statistics, xSQL will examine the schema contents and map that node-connector-statistics has a parent type of node-connector (tbachman, 18:19:58)
   5. It is modeled after the SQL language for queries (tbachman, 18:20:21)
   6. dbainbri asks if select allows things like field matches (tbachman, 18:20:48)
   7. Sharon says yes - it walks all the data, and currently doesn’t use indexes (tbachman, 18:21:09)
   8. It takes each node root and starts traversing the data according to the schema (tbachman, 18:21:25)
   9. right now is defined as one thread, but can do 20-30 at one time (tbachman, 18:21:43)
   10. It also allows you to avoid joins with queries (tbachman, 18:23:38)
   11. dbainbri asks if they’ve looked into doing “graph-ish” qeuries, like “find all the nodes joined by this node-connector" (tbachman, 18:24:56)
   12. Sharon says the yang model is a tree (tbachman, 18:25:22)
   13. Sharon says it all depends on how a link is defined between two edges (tbachman, 18:26:38)
   14. alagalah asks what projects need to do in order to leverage xSQL (tbachman, 18:32:05)
   15. alagalah asks how rich the SQL-like language is (tbachman, 18:32:32)
   16. https://www.opendaylight.org/sites/opendaylight/files/bk-user-guide.pdf Helium User Guide, which has section on xSQL (tbachman, 18:37:34)
   17. https://wiki.opendaylight.org/view/OpenDaylight_Controller:MD-SAL:XSQL XSQL Wiki page (tbachman, 19:00:25)
   18. Use “ telnet 0 34343” to telnet into the XSQL command handler (tbachman, 19:01:00)

Action items

1. (none)

People present (lines said)

1. tbachman (29)
2. odl_meetbot (4)
3. flaviof (2)
4. alagalah (1)