madIS documentation

” Making the simple complicated is commonplace; making the complicated simple, awesomely simple… that’s creativity. “

madIS 1.9

madIS is a extensible relational database system build upon the SQLite database and with extensions written in Python.

The extensibility permits quick experimentation concerning data analysis tasks, rapid development of data processing workflows and serves in general as a simple and easy environment to test database related ideas without much effort. madIS’ query language is SQL with some syntactic “extensions” aiming to simplify query composition.

madIS is hosted at https://github.com/madgik/madis/

Contents:

• Installing madIS
• About
  • madIS is suitable for
    • Complex data analysis tasks
    • Data transformations
    • Database research
• Manual
  • Functions
    • Creating and using a simple row function
    • Creating and using a simple aggregate function
  • madIS SQL extensions
  • Multisets
  • On the fly multidimensional indexing (the cache virtual table)
  • Workflows
  • Designing and building a data processing system with madIS
  • Limitations of madIS
• Useful notes
  • Understanding function examples
  • Understanding function parameters
  • Understanding function return types
  • Shell interaction
  • Empty schema exception
  • Efficiency in streaming virtual tables
• Examples
  • Pivot
  • Application scenario
• Row functions list
  • boolean functions
  • date functions
  • evals functions
  • fileops functions
  • formating functions
  • htmlops functions
  • iptools functions
  • jpacks functions
  • langtools functions
  • logparse functions
  • mathops functions
  • settings functions
  • similarity functions
  • stopwords functions
  • stringdist functions
  • termsetops functions
  • text functions
  • tzconverter functions
  • util functions
  • variables functions
• Aggregate functions list
  • date functions
  • graph functions
  • jpacks functions
  • mining functions
  • partialsort functions
  • selection functions
  • skcluster functions
  • skdimred functions
  • statistics functions
  • subgroup functions
  • text functions
  • util functions
• Vtable functions list
  • cache function
  • clipboard function
  • clipout function
  • coltypes function
  • dirfiles function
  • examplevt function
  • exec function
  • expand function
  • file function
  • flow function
  • fromeav function
  • hidden function
  • jsonpipe function
  • mysql function
  • oaiget function
  • oracle function
  • ordered function
  • output function
  • pipe function
  • postgres function
  • queryplan function
  • range function
  • rowidvt function
  • sample function
  • setschema function
  • skpredict function
  • sktrain function
  • slidingwindow function
  • sqlite function
  • stdinput function
  • timeslidingwindow function
  • toeav function
  • unindexed function
  • unionalldb function
  • variables function
  • webtable function
  • whilevt function
  • xmlparse function
• People
  • Core developers
  • Extensions developers
• Copyright and License
• Thanks

Indices and tables

• Index
• Module Index
• Search Page