You are here

Blog

CLR types (schema) evolution

From version 4.1 Eloquera supports native type evolution.

Eloquera.config contains TypeUpdateAllowed tag that determines whether type changes shall be auto detected and applied.

Stored Procedures

The latest releases of the Eloquera DB have seen some new functionality like SNMP and WCF monitoring, diagnostics and profiling, and some old new functionality – yes, JOINs are back if you haven’t noticed yet. Well, it is all good – but what’s next?

Referential integrity

Referential integrity is one of the most important features of the relational databases because entities like Employee are referred by their artificial keys, like Employee.ID field in the Employee table.
The object and document-oriented databases like the Eloquera DB (which is both, actually) use the object references instead of referencing by the external keys. For example, Payment object may contain a property of the Employee type for referencing to the right person:

Monitor, Control and Profile

With the upcoming version of the database you will be able to monitor, to control and to profile the database server as well as queries.
An SNMP agent will be provided as well as the WCF assemblies allowing access to the reporting and controlling facilities of the database server.

How database looks inside?

Eloquera Database is a free closed source product. Eloquera Database as per design and per corporate roadmap targets enterprise level market, not an embedded applications.
We were asked a numerous times about database internals, though we cannot disclose internal API or source code we can provide with a general overview how database looks inside.
Keep in mind that below picture intends to give an overall idea only. Database is a complex product, with a number of patents pending and with sophisticated logic inside, which is very hard to describe in one picture.

Joy of JOINs

The next release of the Eloquera DB will include a few new features, the main being return of JOINs. The Eloquera DB implements all type of JOINs now:

• Inner JOIN
• LEFT and RIGHT OUTER JOINs
• FULL JOIN

Adding indexes to the fields that are joined will speed up the queries exponentially.

Bulk inserts

Bulk inserts in fact are handled by the same Store method used for storing any other object.
You simply store an array - and the database will take care of everything, e.g. database will find all dependencies and store them (see Store Method (obj)).

Example 1:

Licensing Q&A

We have had a few questions on licensing recently, from people asking about changes, etc. Therefore, I decided to answer some common questions in the short form.

Q. Is it still free?
A. The Eloquera DB is free, both for non-commercial and commercial use. That has not changed and is not going to change.

Q. What are the conditions of use for the database?
A. You need to register and provide correct details about yourself/your company in order to be legally using the Eloquera DB 3.0.

Dynamic is here

In the version 3.0 of the Eloquera Database we have introduced a new functionality that we call dynamic objects. From the point of view of the documentation, it is a minute change – just a new class called Dynamic in the Eloquera.Client namespace. But it adds new magic to the developer’s treasury of tricks.

Eloquera Database - the native object database for .NET

Have you ever thought about having a database that you can write your objects directly, and use SQL for retrieving them back?
Write objects into database and get them back.

Copyright © 2008-2012 Eloquera Corp. All rights reserved.