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.
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
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.
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.
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.
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.
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.
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.
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.
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.
Starting the article, I decided to assume most people are already common with the database development and the details of its organization. Still I realized in the process that sometimes people dealing with the data protection aren’t really well informed about a lot of needful things. As we speak about databases, not all the developers actually know the aspects of the database security, as well as some issues that are security related can easily pass them. Moreover some databases are literally full of rather sensitive information.
So why would the companies through away awesome sums of money to keep their desktops and perimeters secure? Here are the main reasons to do so:
1. “I don’t see so I don’t care”. Usually the databases won’t get our attention unless they get slow or break down.
2. “Cat in a box”. Most compliance officers have no idea, what does actually happen inside the database aside from getting the needed information out of it.
3. “Welcome if you get access”. The feature of DBA is that they stay secure as long as you have the access, they will just go on tuning the performance of the database.
It doesn’t look like the answer will be an easy one. Most shops will be completely satisfied with any of the versions, even if they end up with the worst possible selection. It’s not easy to choose the best as all the good database developers will try to balance perfectly the support availability, the project strength and of course the code and documentation quality offered in the particular database.
The most noticeable divergence we can see in the extras. Most of them tend to store a lot of keys with the encrypted values; still the most important is how they spread data across the accessible servers and how effective they can run the changes across all of them. The hosting question is no less important. The cloud service will be the most suitable if you’re seduced by the clear maintenance.
The database choice was particularly easy no more then three years ago. The people with a significant budget opted for Oracle. The fans of Microsoft run the installation of the SQL Server. The specialists with zero budget opted for MySQL. It was easy to choose between these three options.
Now the times have changed. The new projects appear faster then the users can actually comprehend what they’re dealing with. Most of the projects just do not follow the basic rules of safety thus offer practically no protection the
Every manager of the local database is usually in charge for a series of actions like integrity, performance and security of the given database management system. Also the database managers tend to plan and develop the database they’re working with as well as to deal with the incoming troubles of all kind. The specific details of manager work vary according to the databases and the inner nature of the organization that hired the specialist. The level of responsibility and the measures of control are also different. The manager may work with the entire database in all its aspects or be limited just to the database development in specified fields.
Many people tend to use MySQL every day, thus they need the system to work effectively. Here we offer the basic survey over the various types of this program depending on the company that released it. The healthiest MySQL is believed to be in the hands of Oracle. Still this type od the program is not the open source, still the open source programs seem to be the most wanted and valuable. However Oracle never tried to deal with the open source, so the company most likely holds to its natural course.
So who can perform the really best of the best software of this kind?
We assume it might be any firm that has the possibility to do MySQL development. The hosting based on shared infrastructures is popular today, still the developers do not think about it too often. The users tend to choose the database that is really comfortable to use. With it we can define two mostly common features:
– MariaDB, that obtains most features of the MySQL;
– PostgreSQL, that is also a nice alternative.