Sign in to see all reviews and comparisons. It's Free!
By clicking Sign In with Social Media, you agree to let PAT RESEARCH store, use and/or disclose your Social Media profile and email address in accordance with the PAT RESEARCH
Privacy Policy
and agree to the
Terms of Use.
MonetDB is a full-fledged relational DBMS that supports SQL:2003 and provides standard client interfaces such as ODBC and JDBC. It is designed to exploit the large main memories of modern computers during query processing.
Category
Column-oriented DBMS
Features
• Enterprise level features such as clustering, data partitioning, and distributed query processing
• Management of External Data (SQL/MED)
• Information and Definition Schemas
• Routines and Types using the Java Language
• Database cracking is a technique that shifts the cost of index maintenance from updates to query processing
• Vertical fragmentation ensures that the non-needed attributes are not in the way
License
• Open source
Price
• Open source
Pricing
Subscription
Free Trial
Available
Users Size
Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)
Company
MonetDB
What are the benefits?
• Static evaluation: Expressions over functions without side-effect and constant arguments can be evaluated before the program block is considered further
• Performs very well with both a simple and complex query with multiple join operations
• Combining the efficient XQuery functionality with the spatial module leads to the powerful GML processing solution
• Functional behavior: Easily recognize operators with and without side-effects
PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.6
5.8
Features & Functionality
7.6
8.5
Advanced Features
7.6
7.2
Integration
7.6
8.8
Performance
7.6
8.4
Customer Support
7.6
—
Implementation
8.7
Renew & Recommend
—
Bottom Line
MonetDB is designed for high performance applications in data mining, business intelligence, OLAP, scientific databases, XML query, text and multimedia retrieval.
7.6
Editor Rating
7.9
Aggregated User Rating
5 ratings
You have rated this
MonetDB is a full-fledged relational DBMS that supports SQL:2003 and provides standard client interfaces such as ODBC and JDBC. It is designed to exploit the large main memories of modern computers during query processing. A rich collection of linked-in libraries provides functionality for temporal data types, math routine, strings, and URLs. MonetDB is built on the canonical representation of database relations as columns, a.k.a. arrays. They are sizeable entities -up to hundreds of megabytes- swapped into memory by the operating system and compressed on disk upon need. MonetDB excels in applications where the database hot-set - the part actually touched - can be largely held in main-memory or where a few columns of a broad relational table are sufficient to handle individual requests. Further exploitation of cache-conscious algorithms proved the validity of these design decisions. MonetDB is designed to accommodate different query languages through its proprietary algebraic-language, called the MonetDB Assembly Language (MAL). The primary front-end being distributed is a SQL to MAL compiler. MonetDB supports a broad palette of application domains by hooking up external supplied libraries, e.g. pcre, raptor, libxml and geos. Several external file formats are being encapsulated into data vaults, which creates a symbiosis and natural bridge between database processing and legacy file-based processing prevalent in some science domains. For fixed width data types, MonetDB uses a plain C array of the respective type to store the value column of a BAT. MonetDb stores each BAT in a single contiguous file, where columnDB partitions those files in large chunks. MonetDB is used worldwide for education, research, and businesses.
We are the movers and shakers of B2B Software & Services. We have been copied by many including the you know who?
Why not get it straight and right from the original source. Join over 66,000+ Executives by subscribing to our newsletter... its FREE ! and get fully confidential personalized recommendations for your software and services search
Privacy Policy: We hate SPAM and promise to keep your email address safe.
By clicking Sign In with Social Media, you agree to let PAT RESEARCH store, use and/or disclose your Social Media profile and email address in accordance with the PAT RESEARCH Privacy Policy and agree to the Terms of Use.