Apache Derby vs. IBM Informix

Derby is absolutely the best when it comes to needing a small, embeddable RDBMS in your applications. Certain jobs, like Risk Modeling, are perfect for a database that is small enough to fit into memory with no trouble then store data from various sources, and then allow a user to access those data sets quickly.

Incentivized

Informix is very well suited for either OLTP and OLAP transaction processing. This means that it has the best technology, concentrating both business requirements: transactional and analytical processing at the same time, as well as being able to store and process structured and unstructured data at the same time as well, and able to scale up and out if needed or required. This is why Informix is able to adapt to almost any sort of environment and satisfy almost any sort of requirement, even if the requirement is to be embedded in hardware! This last is possible because it it requires zero support and maintenance, as it can be self tuned and self healed. One of the main scenarios which is nowadays getting promoted for is the IoT one. Starting from mid 90's Informix incorporated the extensibility concept through the datablades it had brought from Illustra. This is why it is pioneer in the TimeSeries and GeoSpatial (tracking moving objects) technology, with the fastest and best storing TimeSeries techniques and GeoSpatial functionalities. The Wire Listener is one of the best features Informix has introduced to its suit of functionalities, can work in three different scenarios API types: MQTT, REST and MONGO, supporting IoT, MongoDB (an application using MongoDB can be redirected as it is to Informix-Mongo without changes) and able to understand HTTP functions (POST, GET, PUT, etc).

Incentivized

• Embedded SQL-capable database client and server
• Good performance for a file-based database
• Zero cost open source solution

Incentivized

• Informix since its conception has a distinct multi-threading architecture no other engine has, it is unique of its kind. This is precisely how the engine is able to scale up like no other, with the lowest footprint, without killing the host and profiting each bit of the hardware. The threads are sub-proceses like any other one, but the difference is that they are are not controlled by the OS process dispatcher. This is why you will never be able to see these threads running at OS level. Informix is an OS itself, on top of the OS.
• Informix has the best replication techniques. Not many ppl know that MongoDB (the NoSQL engine) scales out because of its data sharding replication technology, and Informix is able to store Mongo BSON documents using the same data partitioning as MongoDB does. This way Informix extends the SQL or structured data with the unstructured data natively, together within the same data repository. This means that it is not only able to store JSON/BSON documents, but the engine is able to behave as it would be the MongoDB engine itself. Any application using MongoDB can be redirected to the Informix Mongo wire listener transparently. What´s more, it also improves the NoSQL (BASE) characteristic, making it ACID by allowing transactions to the CRUD operations. This last is something MongoDB is working on, promised to be delivered next year.
• As described previously, MongoDB's sharding concept relies on data partitioning, this is how it scales out, and as I also described previously Informix scales up given the described multithreading unique architecture! It implements the data sharding with one of its best replication technologies called Enterprise Replication. This is an Active-Active replication technology that allows replicating even between different platforms. This is actually how I managed to migrate the whole Informix platform from Solaris to Linux, with just a DNS change. There was almost ZERO downtime nor application change - this was really amazing!.

Incentivized

• Not as well positioned in the market as the "big dogs" (Oracle, MSSQL)
• Been around awhile, and not a lot of exposure. This I believe is primarily due to it's relation to the Apache Project (which is not bad, but they don't force big, lumbering corporate volume licensing on you), and thus people are a bit gun-shy about NOT throwing money at something
• Java is still "slow" compared to C/C++, thus making Derby a bit slow too

Incentivized

• No major on this system just the security setting.
• Big data transfer slows performance.
• Ability to manage huge amount of different data type requires a professional.

Incentivized

Informix is the best RDBMS on the market. Period.

Incentivized

Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.

Incentivized

The Informix product support team has won awards and is appreciated by the entire Informix user community.

Incentivized

SQLite is another open-source zero-cost file-based SQL-capable database solution and is a good alternative to Apache Derby, especially for non-Java-based solutions. We chose Apache Derby as it is Java-based, and so is the solution we embedded it in. However, SQLite has a similar feature set and is widely used in the industry to serve the same purposes for native solutions such as C or C++-based products.

Incentivized

IBM Informix unlike the tools above creates effective solutions for big data extraction and data transportation functionalities across the entire Cloud services and the Automation ability is the best. The security that IBM Informix provides for all our business data and other project information and contacts is effective and the reports are very clean and easy to understand.

Incentivized

• Saved money on database licensing.

Incentivized

• Although I do not own nor have visibility on my company's figures:
• Informix generates consistent savings on DBA staffing, no need for many DBAs as other DBMS require.
• The replication architecture allowed consistent savings in the infrastructure as well as developments and maintenance, the job is already done, no need to develop complex and costly solutions, it's just a matter of configuring it.
• The advantages of hybrid development (i.e mixing SQL and NoSQL in the same database) is not just a marketing hype: it allowed us to solve with a brilliant solution, in one afternoon of coding, a functional problem we have been having for more than 10 years!
• The biggest drawback is that IBM pricing may be constraining, it has too important gaps between the mid range and highrange in terms of pricing

Incentivized