MongoDB vs. SAP SQL Anywhere

MongoDB [is] great at storing JSON data grouped into "collections". In this format, you can store any JSON documents and conveniently categorize them by collections. The JSON document contained in MongoDB is called binary JSON or BSON and, like any other document in this format, is unstructured. Therefore, unlike traditional DBMS, any kind of data can be stored in collections, and this flexibility is combined with the horizontal scalability of the database. It should be noted that MongoDB does not have links between documents and “collections” (this is partially compensated by the Database Reference - links in the DBMS, but this does not completely solve the problem). As a result, a situation arises in which there is a certain set of data that is not related to other information in the database, and there is no way to combine data from different documents. In SQL systems, this would be an elementary task.

SAP SQL Anywhere is better than not using a database, let's be clear there! However, I wouldn't pick it as my first or even second or third choice. I'd recommend looking at other options. Largely, it appears less powerful both in terms of its robustness and general performance and in its implementation of SQL. The standard Sybase utilities provided are lacking in basic features, and the interactive SQL utility is quite horrendous. However, the great thing is it is an ODBC-compliant SQL-compliant relational database.

Incentivized

• Easy to learn. When I picked up MongoDB for the first time, I had little background in database management or modeling. If you have a background in javascript (and JSON)... then you can figure out how to use MongoDB pretty fast.
• Fast performance.
• It's relatively easy to set up in certain environments because there are lots of ready-made solutions out there.
• There's a lot of support in the existing ecosystem for it —, especially in the node.js realm.
• Query syntax is pretty simple to grasp and utilize.
• Aggregate functions are powerful.
• Scaling options.
• Documentation is quite good and versioned for each release.

Incentivized

• It queries large set of data and has a speedy run time.
• With the rate at which data is going with Internet of All things, SQL Anywhere cuts across database applications outside of traditional data centers in which department data's are stored.
• The amazing thing about SQL Anywhere is the relational standard it maintains as a structured language that works across any DB. Yes, you might need to adopt some changes within the environment DB you are working; however, its important to know SQL itself to help archive data goals.

Incentivized

• I love the idea of Map-Reduce native support in MongoDB. Admittedly I have not used it as much as I would like -- it always seems to trip me up.
• Recent additions to the aggregation queries have helped reduce (no pun intended) my need to better wield the weapon that is Map-Reduce.

Incentivized

• User interface is a little bit outdated
• May have some issues in connecting to different versions
• When syntax check enabled, the editor could be slow

MongoDB is one of the most famous non-relational databases in the world, there are famous active projects that use this database. I think that the same company that develops the database gives you the online induction totally free is something that really is very positive. Accounts with a first-class support to be able to relate the correct implementation of the database, in addition to teaching you the best practices to optimize your projects, I believe that with this decision it is more than obvious which is the best decision at the time of seeing with which database to work.

Incentivized

Ease of use, relationship to existing software's used in house and familiarity with the product

Incentivized

It is one of the reasons why we prefer it to store documents in a JSON-style format, to access the desired document very quickly regardless of its size, to be readable by human eyes, and to be easily scalable and manageable.

Incentivized

I have reached multiple times to the MongoDB community for the help and they have provided each and easy solution for every problem. Over the internet and on stack overflow many people responds over the challenges. Now this tool is very much used in every company and projects so internally many people are there to give a support.

Incentivized

While the setup and configuration of MongoDB is pretty straight forward, having a vendor that performs automatic backups and scales the cluster automatically is very convenient. If you do not have a system administrator or DBA familiar with MongoDB on hand, it's a very good idea to use a 3rd party vendor that specializes in MongoDB hosting. The value is very well worth it over hosting it yourself since the cost is often reasonable among providers.

Incentivized

The environment I work in is somewhat unique in that we use both MySQL and MongoDB. However, each is used for specific purposes that the other is not well suited for. MongoDB is not a relational database like MySQL, so it serves as the perfect place to dump key bits of data for quick retrieval later. This is something we can't easily do with MySQL. On this smaller database, MongoDB also lets us retrieve data more quickly with its fast and efficient querying.

Incentivized

I worked with Oracle for years during my career. I wouldn't select SQL Anywhere to implement a global ATM system with tens of thousands of concurrent connections, but SQL Anywhere is much easier to use and deploy and works very well in workgroup settings. Query performance often exceeds some Oracle versions without having to rely on database tuning.

• We can make more open and flexible systems due to its easy adaptation to new evolutions in web applications.
• In the latest versions it offers support for different transactions and we could carry out real tests related to the concurrency of the application.
• MongoDB allows you to have distributed clusters, which improves the speed of the queries by reducing the latency that exists between the database cluster and the service that executes the query.

Incentivized

• Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
• You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Incentivized