pros and cons

SQL vs NoSQL in the Cloud {2}

by Hongde H
The article I choose this week is about the difference between SQL and NoSQL. According to the author, the different access patterns provided by NoSQL and SQL result in very different scalability and performance. He pointed out that NoSQL elements allow data access only in a narrow predefined access pattern. And by giving us an example, the author stated that DHT (Distributed Hash Table) is accessible via hash table API; given the exact key, the value is returned. The access pattern for other NoSQL data services is similarly narrow and well-defined, and as a result scalability and performance structure are predictable and reliable. However, In other words, in SQL, the access pattern is not known in advance, the data model does not enforce a specific way to work with the data. It is built with an emphasis on data integrity, simplicity, data normalization and abstraction, which are all extremely important for large complex applications. read more...

Pros and Cons of Different Databases {4}

by Daniel M
The article i read was about the different types of databases and which ones are right for different applications. The first type of database the article talks about are desktop databases such as Microsoft Access, FileMaker Pro, and Lotus Approach. These databases are mainly used by small business’ because they are relative;y cheap and they often already have a graphical user interface built into them. The problem with these databases is the fact that they are usually not very safe. The next type of database is server databases. These can hold many more records than a desktop database but it comes at a cost. The licensing on server databases is generally much more expensive. This type also generally uses SQL and needs some sort of database design which is another cost that is incurred when using these. The main upside to server databases is that they are very fast and generally much safer to use. The nest type of database is cloud-based databases. The nice thing about the cloud based databases is that there is no need to have high end hardware to run the database. As a company you would not need to keep as many people staffed to run the database also. Cloud services are also widely available and for the most part allow you to have access to the information virtually anywhere. The problem with the cloud based services is the security issues, if you have access to it anywhere it is much easier for someone else to have access to it. The other problem is that it is kind of one-size-fits-all. The cloud services don’t generally allow you too much customization. read more...

Pros & Cons of Consolidating SQL Servers {Comments Off on Pros & Cons of Consolidating SQL Servers}

by Wendy O

This week’s article was regarding the consolidation of SQL servers. Many companies, especially non-IT departments find themselves installing their own SQL servers and ultimately end up over-consuming financial, hardware, and administrative resources. Their solution to this becomes the consolidation of their servers. There are many pros and cons when considering any type of consolidation. Cotter breaks down the Pros and Cons to Licensing, Hardware, and Monitoring. He also pin points the issues that pop up such as runaway applications, a wide-spread of downtime, consolidation user accounts and other version-specific problems. Some Pros include cost savings in licensing, and hardware, and monitoring. It also frees up hardware resources for other applications. With fewer servers to maintain, IT resources can be allocated elsewhere. Some Cons include the increase of licensing requirements, increasing hardware resources, issues with upgrading, and server performance will need to be monitored more closely since now one application can affect the performance of all others sharing the server. read more...