-
Notifications
You must be signed in to change notification settings - Fork 24
AdvancedQueries
Sybil is focused on the very specific queries related full table scans, the other experimental queries have been phased out. If you want a DB for session analysis, try out http://traildb.io/
sybil has several experimental queries being explored and developed. sybil (as a DB) aims to provide actionable information alongside the traditional queries that DBs support.
some example queries that are in development and testing:
-
Session queries: determine frequency and durations of sessions grouped by an activity key. Supports a single join against a user table for issuing queries like: "show me average session time by device"
-
Pathing queries: examine paths taken at an aggregate level. lets one issue queries like "show me unique count of users who did A -> B -> C" or "show me all paths that lead to event X"
-
Calendar queries: show calendars of activity and retention length at the aggregate level, let's one issue queries like "show me retention time by join week" or "how many days per month are my users active"
-
ICC / explanatory model queries: supports running intra-class correlation to determine how well a group by captures the variance of an underlying numeric variable