Archive

Author Archive

Top 15 examples NoSQL database being used with PHP programming language?

January 2nd, 2013 1 comment

U2

(UniVerse, UniData): MultiValue Databases, Data Structure: MultiValued, Supports nested entities, Virtual Metadata, API: BASIC, InterCall, Socket, .NET and Java API’s, IDE: Native, Record Oriented, Scalability: automatic table space allocation, Protocol: Client Server, SOA, Terminal Line, X-OFF/X-ON, Written in: C, Query Method: Native mvQuery, (Retrieve/UniQuery) and SQL, Replication: yes, Hot standby, Concurrency: Record and File Locking (Fine and Coarse Granularity)

OpenInsight

API: Basic+, .Net, COM, Socket, ODBC, Protocol: TCP/IP, Named Pipes, Telnet, VT100. HTTP/S Query Method: RList, SQL & XPath Written in: Native 4GL, C, C++, Basic+, .Net, Java Replication: Hot Standby Concurrency: table &/or row locking, optionally transaction based & commit & rollback Data structure: Relational &/or MultiValue, supports nested entities Scalability: rows and tables size dynamically

Reality

(Northgate IS): The original MultiValue data set database, virtual machine, enquiry and rapid development environment. Delivers ultra efficiency, scalability and resilience while extended for the web and with built-in auto sizing, failsafe and more. Interoperability includes Web Services, Java Classes, XML, ActiveX, Sockets, C and, for those that have to interoperate with the SQL world, ODBC/JDBC and two-way transparent SQL data access.

OpenQM

Supports nested data. Fully automated table space allocation. Concurrency control via task locks, file locks & shareable/exclusive record locks. Case insensitivity option. Secondary key indices. Integrated data replication. QMBasic programming language for rapid development. OO programming integrated into QMBasic. QMClient connectivity from Visual Basic, PowerBasic, Delphi, PureBasic, ASP, PHP, C and more. Extended multivalue query language.

ESENT

(by Microsoft) ISAM storage technology. Access using index or cursor navigation. Denormalized schemas, wide tables with sparse columns, multi-valued columns, and sparse and rich indexes. C# and Delphi drivers available. Backend for a number of MS Products as Exchange.

non-blocking ingest, Misc: Free for Qualified Startups.

InfoGrid

API: Java, http/REST, Protocol: as API + XPRISO, OpenID, RSS, Atom, JSON, Java embedded, Query Method: Web user interface with html, RSS, Atom, JSON output, Java native, Replication: peer-to-peer, Written in: Java, Concurrency: concurrent reads, write lock within one MeshBase, Misc: Presentation »

HyperGraphDB

API: Java (and Java Langs), Written in:Java, Query Method: Java or P2P, Replication: P2P, Concurrency: STM, Misc: Open-Source, Especially for AI and Semantic Web.

DEX

: API: Java, .NET, C++, Blueprints Interface Protocol: Embedded, Query Method: APIs (Java, .Net, C++) + Gremlin (via Blueprints), Written in: C++, Data Model: Labeled Directed Attributed Multigraph, Concurrency: yes, Misc: Free community edition up to 1 Mio nodes, Links: Intro », Tutorial »

GraphBase

Sub-graph-based API, query language, tools & transactions. Embedded Java, remote-proxy Java or REST. Distributed storage & processing. Read/write all Nodes. Permissions & Constraints frameworks. Object storage, vertex-embedded agents. Supports multiple graph models. Written in Java

Trinity

API: C#, Protocol: C# Language Binding, Query Method: Graph Navigation API, Replication: P2P with Master Node, Written in: C#, Concurrency: Yes (Transactional update in online query mode, Non-blocking read in Batch Mode) Misc: distributed in-memory storage, parallel graph computation platform (Microsoft Research Project)

AllegroGraph

API: Java, Python, Ruby, C#, Perl, Clojure, Lisp Protocol: REST, Query Method: SPARQL and Prolog, Libraries: Social Networking Analytics & GeoSpatial, Written in: Common Lisp, Links: Learning Center », Videos »

BrightstarDB

A native, .NET, semantic web database with code first Entity Framework, LINQ and OData support. API: C#, Protocol: SPARQL HTTP, C#, Query Method: LINQ, SPARQL, Written in: C#

Bigdata

API: Java, Jini service discovery, Concurrency: very high (MVCC), Written in: Java, Misc: GPL + commercial, Data: RDF data with inference, dynamic key-range sharding of indices, Misc: Blog » (parallel database, high-availability architecture, immortal database with historical views)

Meronymy

RDF enterprise database management system. It is cross-platform and can be used with most programming languages. Main features: high performance, guarantee database transactions with ACID, secure with ACL’s, SPARQL & SPARUL, ODBC & JDBC drivers, RDF & RDFS. »

OpenLink Virtuoso

Hybrid DBMS covering the following models: Relational, Document, Graph

Categories: NoSQL, PHP Tags:

Top 10 Reasons why you should use Relational over NoSQL databases

December 31st, 2012 No comments

With the introduction of NOSQL database, many people find that it is easier to shift to these databases but this does not mean they will get all the solutions that they need. It is still important to settle with the relational databases due to a number of reasons and some of the developers find that it is easy to stick to the system.

  1. With the relational database, one is investing in a low-volume and less complex applications, which makes it easier for them to handle and this means they can start to develop this application in a matter of time
  2. With the chance to do normalization with relational database, you find that it is effect to have the duplicated volumes of data in the system that you want
  3. Switching to another database is not an easy process since you have already invested in this program, bought the services. This means that you have to let go, learn a new system, and in most cases, you find that it does not solve all the matters, that you want and this means you have to go back to the SQL method. You need to learn and find what other developers have to say before you switch to a new system
  4. Just because a system is popularized by the search engine and has good marketing methods done online, does not mean that you have the chance to trust it. This is the reason why one needs to go through the reviews and find the reasons why they need to stick to the system and if they have to switch to NOSQL< the benefits they get over the relational methods
  5. Before investing in a new system, many people find that it will not meet their needs, and gets trickier to start learning another language and develop it. This is why one needs to stick to the database they have since all have faults but one has managed to stay with them due to the effectiveness and ability to control them regardless of their issues
  6. Relational databases are known to have the best declarative syntax and strong mathematical basis compared to other systems in the market.
  7. Relational databases have a well-known language known as structured query language in short, SQL
  8. Relational databases have a good existing ecosystem introduced into the channel and this means the documentation, third party vendors, binding to other programming languages, and loads of tools.
  9. Relational databases have the ability to host different bonuses like geographical databases and mechanism
  10. The relational database offers different indexing solutions, trustworthy transactional details, and extensive security installations.

Before one settles with any new system, they need to find more about the qualities and start the comparison process. Many people want to stick with relational methods due to the programming language, the effectiveness in the security methods, easy procedures and the chance to have the developing structures in place and center the programming language to the method that developer wants, making it hard for other people to crack the codes installed.

Sources

http://programmers.stackexchange.com/questions/109192/why-nosql-over-sql

http://stackoverflow.com/questions/3713313/when-should-i-use-a-nosql-database-instead-of-a-relational-database-is-it-okay

http://stackoverflow.com/questions/4160732/nosql-vs-relational-database

http://readwrite.com/2011/06/09/when-you-should-still-use-a-re

Categories: General, mysql, NoSQL Tags: , , ,

Top 10 most popular video tutorials on NoSQL

December 29th, 2012 No comments

These are some of the top rates YouTube videos on the suitable tutorials that will make it easy it for you to have the opportunity to understand more about the programs since they have the photos, examples and integral look at the definition of terms used in this program.

  1. NoSQL Database Tutorial part1 | Introduction to NoSql

This tutorial offers some of the best introduction details to the people who want to learn more about the NOSQL details. It makes it easier for one to have the full understanding of the process and this becomes easier for one to understand the correct ways they will use when they want to start activating this system.

[youtube]http://www.youtube.com/watch?v=AMpvjJtcHsk[/youtube]

 

 

2. GOOGLE/IO/2012-SQLVS NOSQL BATTLE OF THE BACKENDS

This shows the difference that one will get when they settle with the new database method and over from the other SQL method of programming

[youtube]http://www.youtube.com/watch?v=rRoy6I4gKWU[/youtube]

 

3. hadoop and NOSQL downfall parody

This shows the ability for investing in the NOSQL database, and it gives the technical stuff and this enables one to have the basic details about the database that are in use and ends up comparing them in order to find the ones that are suitable for the different users

[youtube]http://www.youtube.com/watch?v=hEqQMLSXQlY[/youtube]

 

4. Row, column, NOSQL and Hadoop- when to use and where

This video shows the relation between the database, that are in the NOSQL method and some of the ways that will make it easier for them to start investing in it. Most of the developers want to find out some of the details that make it easier for them to settle with good results but with the ability to settle with top-notch results and this video starts to showcase all different settings, and one ends up knowing when to use the different applications.

[youtube]http://www.youtube.com/watch?v=iliG63sJhxA[/youtube]

 

5. NOSQL- this shows the details about the database by giving a description on some of the examples that leads one to know more about the terms, and familiarize with the system. This is one of the best videos, which make to easier for one to understand this database.

6.  handlerSocket: NOSQL via MUSQL- this is one of the simplified version that make it possible for anyone who wants to know more about this database to understand more about it.

[youtube]http://www.youtube.com/watch?v=-DTLvnew_qU[/youtube]

 

7. NOSQL database tutorial part 4/ c# and cloud based mongodb using orchestra php platform

This allows you to understand the different platforms that you can use when operating this databases

[youtube]http://www.youtube.com/watch?v=PaagTyMOPyE[/youtube]

 

8. datastax Cassandra tutorials-datastax opscenter overview

This is a newer version that many people do not know about but it has all the key details that one needs to know in order to have the deeper understanding of this program

[youtube]http://www.youtube.com/watch?v=UUtu_3UCctw[/youtube]

 

9. Datastax webinar-NOSQL for big data in the enterprise

This is dedicated to the people who want to have the larger platform to understand bigger operational database systems

[youtube]http://www.youtube.com/watch?v=PoMsXvHkHG4[/youtube]

 

10. NOSQLdistilled a brief guide to the emerging world of polyglot persistence

This gives an integral and detailed look to enable one get the details of NOSQL database and some of the different ways that you can use them.

[youtube]http://www.youtube.com/watch?v=ip7Xbwhl1s4[/youtube]

 

Categories: NoSQL Tags:

How does NoSQL database work?

December 27th, 2012 No comments

NoSQL database is new introduction in the system but this does not mean it started the other day. In fact, it has been there for a long time but many developers were focused on the mathematical programming language and did not want to invest in other new systems. However, with time, this changed and it became easier for them developers to start using it. This started to gain momentum and with time, most of the developers started to favor it from the other programming options due to the effectiveness and the ability to encompass a large data storage and high level of monitoring tools

What is NoSQL
this is a systematic special system, that allows loading of new data and storage of backups and they do not follow the relational DB model. This means that you do not have it master the mathematical language, which becomes harder for one to invest when merging in the developing world.

How does it work?

There are more them 150 current NOSQL databases available in the market and some of them are being developed currently. This makes it easier for one to choose the one that they want, since some are suitable for small developers and some for large-scale developers. The systems are labeled with generic name and this works differently in the sense of scalability. One does not need to have enough memory space in order to support this system. You only need to keep on replicating the data and you will find that the message is stored and this saves you on the memory space. This is one of the best descriptions that make many people prefer to use the NOSQL database. Often more characteristics apply such as: schema-free, easy replication support, simple API, eventually consistent / BASE (not ACID), a huge amount of data and more.

Benefits

Delivers ultra-efficiency, scalability and resilience while extended for the web and with built-in auto sizing, fail safe and more. Interoperability includes Web Services, Java Classes, XML, ActiveX, Sockets, C and, for those that have to interoperate with the SQL world, ODBC/JDBC and two-way transparent SQL data access.

Handel big data- the NOSQL database makes it easier for one to handle big data, which means that it can handle the revolution of data and this is suitable for people who have numerous data to handle, and this makes it easier for them to store, update, change, and retrieve without blocking the system from basic operations.

Handel big data- the NOSQL database makes it easier for one to handle big data, which means that it can handle the revolution of data and this is suitable for people who have numerous data to handle, and this makes it easier for them to store, update, change, and retrieve without blocking the system from basic operations.

Is it effective?

Experts’ advice developers need to keep in mind a number of different options when dealing with databases. It is not easy to choose the right NOSQL database to use due to their expansiveness but this does not mean they will get the results they want.

Categories: NoSQL Tags:

MongoDB Sharding, how to do sharding

December 21st, 2012 No comments

MongoDB Sharding systems give users the platform to partition an entire collection in a simple database form and distribute it to documents in the MongoDB instances or in simpler terms shards. This enables the writing capacity to increase and provides the ability to support the volumes of working set. This raises the limits of data size much higher beyond physical resources in a single node.

Features of sharding

Range-based data partitioning

MongoDB describes data in shards, according to the value of the shard key. Each represents a single block of documents that lie in a specific range. When the volume grows bigger, the MongoDB splits the shards into other smaller chinks known as splitting

Automatic data volume distribution

The system balances data automatically in all areas in the cluster and prevents intervention in the application layer. It does not need any additional features in modification or any developmental interventions.

Transparent Query routing

Transparency in sharding is because of connections in the cluster, which go through the MongoDB, and only requires basic configuration for the application to run smoothly.

A sharded cluster comprises of replica sets, which hold data, lightweight routing process and three configurations sever to store the data.

The process

This is the process of creating multiple shreds in order to facilitate storage of large data volumes. It is easy to multiply and backup data in several servers for easy retrieval and use.

  1. Start up the new machine in the process
  2. Install the MongoDB program, and start a new process which acts as the shard cluster for the storage of data
  3. Create another new process and this acts as the configuration which maintains and verifies the information given
  4. Start the process of sharding as directed by the program, and use mongo to find the current db,
  5. Enter the commands that enable sharding of collections and database you have.
  6. Modify all the applications to activate the MongoDB Sharding process and update the system.
  7. The configuration process is automatic and done through the IP

When to apply sharding

You do not need to apply sharding all the time and is usually applicable when you have a number numerous volumes of data. This a significant infrastructure development but you have the chance to deploy the operation when

–          Your data set exceed the limited capacity of your single node system

–          When you have volumes of writing activity in a single MongoDB and the process is slowing down and unable to meet your demands.

–          The current working set will not fit into your RAM system and you do not want to stop the process

When installing the MongoDB Sharding, you need to make sure that you follow the correct processes especially in configuration since this can delete all information in the indexes and servers when you do not use the correct handles. This is the reason why you need to customize your MongoDB and have numerous servers that will store extra memory details to prevent massive data loss. This process makes it easy to deal with massive production and you do not need to stop the working set in order to increase your memory space.

 

Categories: MongoDB Tags: , ,

Top 10 Reasons why you should use NoSQL over Relational databases

December 19th, 2012 No comments

The latest development currently in the market for developers is the NOSQL database but this does not mean that one should not use the other methods to access the data. You have the chance to start investing in the database that you need but some developers are finding it effective to move from the relational database and start choosing the NPSQL method. Some of the reasons include

  1. Elastic scaling- tone does not need to keep on investing in the bigger servers, when they want to increase the information, which is common with relational system. You only need to scale out, which means that you source the database, accessing several hosts, when there is increase of data. This means that you can handle volumes of data in a short memory space, and this saves on the costs of installing new hardware servers and memory space, which is hard for one to get the optimum results.
  2. Handel big data- the NOSQL database makes it easier for one to handle big data, which means that it can handle the revolution of data and this is suitable for people who have numerous data to handle, and this makes it easier for them to store, update, change, and retrieve without blocking the system from basic operations.
  3. Less repairs and monitoring- most of the companies do not want o incur extra costs when dealing with the databases. With SQL, one needs to keep on monitoring the system virtual data distribution and repairs. This also involves updating the servers and the memory space, placing it at result of losing details when not stored in the correct manner. With NOSQL, the system has automatic monitoring methods, which allows the user to apply the command settings in the best way they want to monitor and handle the system.
  4. Cost effective- NOSQL database makes it easier for one to have the economic sense of not investing in multiple servers and upgrades of the mathematical programming language. With different severs to use with the relational method, users are at risk when they do not backup data when updating and this means one should have multiple servers for the upgrading sessions to avoid losing information.
  5. Flexible data modes- it is easier for one to choose the keys they want to operate and upgrades are done on the system when one has installed the command
  6. Less input of data- one does not need to be at the system in order to access all the information or have the upgrades the system still runs automatically
  7. Easy to use commands- there are different commands making it easier for one to automatic selections, and minimizes time spend on doing routine process
  8. Expertise- one does not need to become a programming expert since this does not need one to master all the mathematical languages to develop a system
  9. High level of security- with multiple servers to operate from several locations, the database only allows authorized access making it safer to store the data
  10. Updating tools- unlike the relational method, you do not need to worry about losing data when updating since it has the automatic upgrading tools to update and save data.

Sources

http://www.techrepublic.com/blog/10things/10-things-you-should-know-about-nosql-databases/1772

http://facility9.com/2010/09/five-reasons-to-use-nosql/

 

Categories: NoSQL Tags:

What are 5 key differences between Relational and NoSQL databases?

December 19th, 2012 No comments

Ever since the development of NOSQL databases, many people find it hard if they should settle with them or not. It is important to have an integral look at the different reasons to choose one over the other. The relational or the SQL databases have been in the market for long but due to the recent developments in the market, you find that many people prefer to choose the ones that have the adaptability features.

 

Differences

  1. Relational databases or SQL databases are relational meaning that it uses the frequency of tables and relations. This works by using them to match data by use of several characteristics known as Schema. This is through the division in terms of rows and columns The NOSQL databases do not need to use the schema or the tables in order to operate but scale horizontally. This means that the database has a structured system.
  2. NOSQL database have the integrated caching method, which means they have to increase the memory, and this increases the performance. This technique makes it easier to use the cache data technique to install the system memory The SQL databases do not have the integrated caching method and this is done using a separate infrastructure.
  3. With relational, when the data does not fit into the tables and columns, one need to create another database structure and this is a complex work, which takes time and effort. With NOSQL databases, it accommodates the formation of additional features into the system even when adding new data, since the infrastructure is defined.
  4. With relational databases, the uses need to scale on powerful servers and this is an expensive cost and this means that one has to keep on investing in new ones and connect to operate multiple servers, which becomes harder to manage. The NOSQL database uses the replica method and this means automatic increases of the memory, and easy to operate different servers at the same time without limiting the current operations.
  5. NOSQL has auto elasticity and this means that one has the chance to automatically update the different servers from any location and use different commands to aid in the process. When dealing with relational databases, a simple mistake in the update on the servers, risks deleting the entire information.

Conclusion

Both databases have the ability to handle effective data storage and the retrieval process. They both have integrated security levels and this makes it easier for a company to store the information safer due to restricted access. Both have the chance to handle data storage and easy access especially when dealing with multiple servers.

It is important for a developer to understand the operation of both databases and this makes it easier for them to know the ones, which are suitable based on their needs. Both have positive and negative sides, making it easier for one to choose the ones that will satisfy their needs in the best way they can expound, and relate it to the work they want to do. Due to future technical enhancements, developers need to adjust to the new settings and choose the one that fits their infrastructure

Sources

http://www.thewindowsclub.com/difference-sql-nosql-comparision

http://dba.stackexchange.com/questions/5/what-are-the-differences-between-nosql-and-a-traditional-rdbms

http://stackoverflow.com/questions/4811744/what-is-the-difference-between-a-relational-and-non-relational-database

Categories: NoSQL Tags:

Why use MongoDB Architecture for your business

December 18th, 2012 No comments

Most of the companies and individual businesses find it harder to retrieve documents, blog posts or past search results to present to their clients, online or when they need to revisit past issues. With the latest installation of MongoDB Architecture, they have higher chances of benefiting from archiving, which enable proper dissemination and storage of data in unique filling system in the database. This makes the database to grow and still have the same old ways of making the correct and easy retrieval.

A business needs to have several channels of storing the data and the indexing option makes it easier for processing queries in the database and saves all search results, connects with other programs in channeling the information and has backup databases to assist when the system is busy. This is common with most of the database applications but the MongoDB Architecture offers faster archiving dissemination and presentable in different forms.

When dealing with content management, and deployment in hierarchical order in terms of storage, and retrieval searches. This makes it easier for website and blog management of data and present in several forms based on the options the user intends to choose. The reads are scaled easily in the database management forms and support other infrastructure options like MySQL and ProstgtreSQL.

The MongoDB Architecture extensively been used in online gaming by supporting small reads and constant replica set functionality. MongoDB Architecture has the auto-sharing option and backup solutions, which stores it in the RAM and other memory devices that one can choose when dealing with online gaming businesses. This software has the ability to deal with numerous workloads with many gaming companies choosing this option to serve various clients from all over the globe. It is easy to use even with other applications and manages the RDBMS infrastructure.

Benefits a business gets when they use MongoDB Architecture include auto-sharding, fast lightening can perform multiple indexes with a single command and perform rich queries. However, the indexes take up a lot of RAM storage and this becomes complex for those who want to store numerous data. The problem with the updating method and you can lose all the data when you do not follow all the correct procedures. This is the reason why you need to have a backup storage service instead of storing all your details in one server.

According to most clients’ the MongoDB Architecture offers a solid platform for indexing, archiving and uses numerous tools for the deployment and creating the right form of database that enables them to store large capacities and support other readable formats stored in the system. It is easier to share the information, provide the online users the chances to settle with the information they need through the archiving system and the presence of backup keeps the business safe and prevents data loss. However, this system is complex and one needs to keep testing it and ensure they have the customized version in order to use it for their preferred platform and center it to the basic operations and infrastructure you need.

Categories: MongoDB Tags: , ,