Datalog Educational System or DES is a handy, multiplatform, prolog-based implementation of a basic deductive database system.
This tool enjoys Datalog and SQL query languages, full recursive evaluation with memoization techniques, arithmetic, stratified negation and novel approaches to declarative debugging, null values support, (tabled) outer join and aggregate predicates.
Here are some key features of "Datalog Educational System":
· Datalog, Relational Algebra and SQL query languages
· Aggregates, nulls, duplicates
· ODBC connections to relational databases
· Integrity constraints
· Textual API for plugin to any software development system (Java, .NET, Python, ...)
· Cross-platform
· Declarative debuggers and tracers
· Test case generation
· Hypothetical SQL queries (Decision-Support)
· Distributed computations
What's New in This Release: [ read full changelog ]
Enhancements:
· Extended relational algebra processor including all the original operators but division, and extended operators for dealing with outer joins, duplicate elimination, recursion, and grouping with aggregates
· Multi-line input is also allowed in addition to the current single-line input. Long inputs as typical SQL statements can be spanned over several lines. When multi-line is enabled with the command /multiline on, Datalog inputs must end with a dot (.), and SQL and RA inputs with a semicolon (;). When disabled, each line is considered as a single (Datalog, SQL or RA) input and ending characters are optional
· When multi-line input is enabled, remarks enclosed between /* and */ can span over several lines and can be nested as well
· Single-line (--) and multi-line (/**/) remarks can be included in SQL statements at any place a separating blank can occur
· SQL statement CREATE TABLE can include LIKE for creating a table with the same schema as an existing one
· SQL statement DROP T...
Find us on Google+
