28Jun2016

Database Development: RethinkDB is a modern database for real time Web

Nowadays, almost all applications are asynchronous multi layer systems linked together via events scheme. One module of the system subscribes on events produced by another part. It’s regular Listener pattern. We have been designed and implemented a lot of applications in this way, but all of them are placed in the middle layer or UI side. It would be nice to have similar functionality on the data layer of persistent storage. Redis [http://redis.io/] as a Database Development system provides Listener approach out of the box. But Redis is in-memory key-value storage. It’s used rather as cache. There is RethinkDB database [https://www.rethinkdb.com/] supported Listener pattern and used as clustered document storage like MongoDB.

Installation

RethinkDB is open-source. There are installation packages available for all major platforms. On the other hand, it would be better to use docker container:

docker run -d -P –name rethink1 rethinkdb

Technically, the database is a set of tables. A table contains documents similar to MongoDB. JSON is used as representation of the nested structure of a document. There are 4 official drivers for RethinkDB: python, ruby, java and javascript for node.js. If you use other programming language, there are a lot of community-managed drivers based on JSON protocol.

RethinkDB has out of the box sharding and replication clustering. You can configure a cluster via Web UI administration console. Last one can be used for monitoring, as well.

Read more
03Aug2014

Database Development: MongoDB 3.0 is coming

A huge amount of time enterprises and startups around the world have been using various NoSQL platforms for their Database Development needs. The open source NoSQL database MongoDB [http://www.mongodb.org] is going to major release version 3.0 in March. The latest release candidate is already available [http://www.mongodb.org/downloads]. The MongoDB team is trying to touch even higher level of new DBMS standard for any project in any industry, to be called “default database”.

Improvements and innovations

There have done a lot of work at line both the academical research and practical usage. First of all, sufficient improvements in the storage layer bring comprehensive boost performance and scalability. There is the WiredTiger storage engine.

Read more
05Feb2014

SQL server 2014 – what’s new?

On April 1st we will see officially released milestone of Server SQL 2014. This is the huge step forward for all the database developers, who were waiting for this long time already. New opportunities for database programming are awaited. Also specialists from Iflexion consider the new tool to provide more benefits for database programming in general matters.
ith significant
The new release is mainly based on the current SQL Server 2012 which is used for 2 years already without any great malfunctions. The codename the tool was presented to the audience is “Hekaton”. The new feature is so called OLTP (online translation processing). This will enable the performance gain up to 30-times faster along w scalability improvements. These are run by AlwaysON technology offered by Windows Azure. According to this technology, databases will generally fail over to installations created by SQL Server, offering high level availability and improved recovery scenarios.

Read more
02Apr2013

What shall and what shall not be used in database development in 2013

Though the current databases need new solutions, the well-known RDBMS is still active and working. Still there are places and cases where it shall not be used for your own sake. Even the people who are really fond of Oracle, RAC or any other system of this kind shall reconsider their urge to use their favorite ways in the following cases.

Searching

Do not use Oracle Text. It’s not usually used even by the Oracle lovers, since this database extension doesn’t develop actively. The other ways database developers tend to use in Oracle are either too primitive or too complicated; both options offer the bad kind of results.

However you can easily use Autonomy, Apache Solr or Hibernate Search for your task. This way you will get fast and handy results.

Recommending

If you work with ATG Commerce, try to avoid this action by all means. The reason for this option to be turned off most of the time is the great scalability – database developer just does not need that many recommendations for his work. This feature is not usually needed at all, since the tasks people solve are really various, so you just do not need recommendations based on someone else’s actions.

Read more
22Jan2013

Can SQL Server be counted as a BID for Business Intelligence Greatness?

In the term of the last months the main SQL Server got the whole set of brand new capabilities. According to the word of experts this doesn’t concern just the business intelligence inself.

One of the main features appeared to be the AlwaysOn, which now provides more significant capabilities within the infrastructure of the server. Such aspects as programmability, manageability, security and scalability are improved. The new components available in the new edition are made for analysis, integration and faster responding.

The query response within the In-Memory Column Store is also supported with the AlwaysOn system. According to the specialists’ point of view the new SQL is about 100 times faster than the previous one.

Read more