Backup methods and tools for PostgresQL

January 17th, 2013 No comments

There are different methods that one can use in order to backup and restore files.

Using pgdump, new file for each day

Process

Go to Server create a Directory called Drive:\PostgresqlBack then create a sub directory called “bin” in the Drive:\PostgresqlBack

comerr32.dll

gssapi32.dll

k5sprt32.dll

krb_32.dll

libeay32.dll

libiconv2.dll

libpq.dll

Microsoft.VC80.CRT.manifest

msvcm80.dll

msvcp80.dll

msvcr80.dll

pg_dump.dll

ssleay32.dll

zlib1.dll

Create batch file called something, example is postgresqlBackup.bat. The file must be located in PostgresqlBack directory not the bin folder.

 

Open the File then Copy/Paste the following

 

@echo off

for /f “tokens=1-4 delims=/ ” %%i in (“%date%”) do (

set dow=%%i

set month=%%j

set day=%%k

set year=%%l

)

set datestr=%month%_%day%_%year%

echo datestr is %datestr%

set BACKUP_FILE=<NameOfTheFile>_%datestr%.backup

echo backup file name is %BACKUP_FILE%

SET PGPASSWORD=<PassWord>

echo on

bin\pg_dump -i -h <HostName> -p 5432 -U <UserName> -F c -b -v -f %BACKUP_FILE% <DATABASENAME>

Change <NameOfTheFile> to something. Setting is the first part of the file name then followed by the date the file was created with the extension .backup

Change the <PassWord > setting above to the correct password for the backup users.

Change <HostName> either to ip address or dns name of the server hosting Postgresql.

Change <UserName> to backup user make sure this users has access to database for backup purposes

Change <DATABASENAME> to the database name being backed up.

Save the File

Create Task for the MS Task Scheduler

Using .pgpass and pgdumpall, same file

Achieving automated backup in a windows environment

 

Create a .pgpass file

Lock down the .pgpass file

Using NTFS permissions, disable access to this file for everybody except the user pg is running as

Create a script to call pg_dumpall

   SET PGPASSFILE=C:\foo\bar\PG_BACKUP\PGPASSFILE\pgpass.conf

“C:\Program Files\PostgreSQL\8.2\bin\pg_dumpall.exe” -U scfcu_postgres > C:\foo\bar\PG_BACKUP\db.out cu

Handling Large Databases

Use compressed dumps. You can use your favorite compression program, for example gzip:

pg_dump dbname | gzip > filename.gz

Reload with:

gunzip -c filename.gz | psql dbname

or:

cat filename.gz | gunzip | psql dbname

Use split. pg_dump dbname | split -b 1m – filename

Reload with: cat filename* | psql dbname

You can use PostgreSQL’s continuous WAL archiving method. First you need to set wal_level=archive, then do a full filesystem-level backup (between issuing pg_start_backup() and pg_stop_backup() commands) and then just copy over newer WAL files by configuring the archive_command option.

 

Update: Check out Barman for an easier way to set up WAL archiving for backup.

You can use PostgreSQL’s continuous WAL archiving method. First you need to set wal_level=archive, then do a full filesystem-level backup (between issuing pg_start_backup() and pg_stop_backup() commands) and then just copy over newer WAL files by configuring the archive_command option.

Advantages:

Incremental, the WAL archives include everything necessary to restore the current state of the database

Almost no overhead, copying WAL files is cheap

You can restore the database at any point in time (this feature is called PITR, or point-in-time recovery)

Disadvantages:

More complicated to set up than pg_dump

The full backup will be much larger than a pg_dump because all internal table structures and indexes are included

Doesn’t work work well for write-heavy databases, since recovery will take a long time.

 

Categories: Postgresql, tools Tags:

JDK6 on Solaris

January 14th, 2013 No comments

Got this weird error today on Solaris 5.8.  It could happen to other versions as well.  This is when I switched to JDK6 from JDK5…

UTF ERROR [“../../../src/solaris/npt/utf_md.c”:49]: Failed to complete iconv_open() setup

And here is a quick fix…this may or may not indirectly affect the application you run so use at your own risk.

The Fix:

# cd  /usr/lib/iconv/geniconvtbl/binarytables
# cp “ISO8859-1%ISO646.bt” “UTF-8%646.bt”
# cp “ISO646%ISO8859-1.bt” “646%UTF-8.bt”

Categories: Solaris Tags: ,

Super commands for Unix beginners and veterans!

January 8th, 2013 No comments

As a sysadmin of many years, I’m always fascinated by the world of *Unix and the untapped commands and tricks that are still there that I haven’t found out yet.  There are numerous ways to do something quicker, easier and more efficiently if a sysadmin knows where to look.

In this article, we’re listing the top most useful commands that any sysadmin should know and use when troubleshooting or in general working around their way in a Linux or Unix environments in general.

This command allows you to save a file you edited in VI without the needed permission for that file:

$ :w !sudo tee %

An alternative to traceroute or ping command on Linux is to run mtr:

$ mtr yahoo.com

Ever wanted to execute a command without saving it in history?  Here we go:

$ <space>who  (This will run the ‘who’ command without it being recommended in your history file).  Set your PS1=” ” to do it automatically by prepending space.

Ever found your screen or garbled up and you end up closing session and logging back in?  Well dont’ do that! Just type:

$ reset

To capture your activity on Linux desktop just type:

$ ffmpeg -f x11grab -s wxga -r 25 -i :0.0 -sameq /tmp/wow.mpg

Want to reverse tunnel?  Here is how you start a tunnel from some external site’s port 80 to your local server port 8001.  You can then hit that site via http://localhost:8001

$ ssh -N -L2001:localhost:80 blah.com

Just a single job around 8PM, better than a cron:

$ echo “who;ps -eaf” | at 8pm

Now, for one of the most helpful if not the most helpful command that’ll allow you to bind port to a process ID…perhaps better than lsof:

$ netstat -tlnp

Ever wanted to tweet from shell?  Perhaps you want to alert your twitter that your service is down?

$ curl -u user:pass -d status=”I am tweeting nigga!” http://twitter.com/statuses/update.xml

Run your website all in memory, here is how:

$ mount -t tmpfs tmpfs /data/blah.com -o size=10g  (Assuming you have at least 10g on server to spare, you now have a new partition to which you can copy your website to)

How about a secure mount via SSH?  First download SSHFS and then:

$ sshfs user@server:/path/to/mount/from /path/to/mount/point

 

There is more!

Categories: linux Tags: , , ,

What are the origins of NoSQL database? Where did it get started?

January 7th, 2013 No comments

This article focuses on the developmental stages of the NOSQL database and reasons that let to formation of it to date

1960s

MultiValue (aka PICK) databases are developed at TRW in 1965.

It is a programming language, that incorporates a hierarchical database with B+ tree storage.  IBM IMS, a hierarchical database, is developed with Rockwell and Caterpillar for the Apollo space program in 1966.

1970s

InterSystems developed the ISM product family succeeded by the Open M product, all M[umps] implementations.  In 1979 Ken Thompson creates DBM which is released by AT&T.

1980’s

TDBM supporting atomic transactions

NDBM was the Berkeley version of DBM supporting having multiple databases open at the same time.

SDBM – another clone of DBM mainly for licensing reasons.

GT.M is the first version of a key-value store with focus on high performance transaction processing.

BerkeleyDB reated at Berkeley in the transition from 4.3BSD to 4.4BSD. Sleepycat software is started as a company in 1996 when Netscape needed new features for BerkeleyDB.

1990’s

GDBM is the Gnu project clone of DBM

Mnesia is developed by Ericsson as a soft real-time database to be used in telecom. It is relational in nature but does not use SQL as query language but rather Erlang itself

InterSystems Caché launched in 1997 and is a hybrid so-called post-relational database. It has object interfaces, SQL, PICK/MultiValue and direct manipulation of data structures. It is a M[umps] implementation. See Scott Jones comment below for more on the history of InterSystems

2000’s

Graph database Neo4j is started in 2000.

db4o an object database for java and .net is started in 2000

QDBM is a re-implementation of DBM with better performance by Mikio Hirabayashi.

Memcached is started in 2003 by Danga to power Livejournal. Memcached is not really a database since it’s memory-only but there is soon a version with file storage called memcachedb.

Infogrid graph database is started as closed source in 2005, open sourced in 2008

CouchDB is started in 2005 and provides a document database inspired by Lotus Notes. The project moves to the Apache Foundation in 2008.

Google BigTable is started in 2004 and the research paper is released in 2006.

2006-2010

JackRabbit is started in 2006 as an implementation of JSR 170 and 283.

Tokyo Cabinet is a successor to QDBM by (Mikio Hirabayashi) started in 2006

The research paper on Amazon Dynamo is released in 2007.

The document database MongoDB is started in 2007 as a part of a open source cloud computing stack and first standalone release in 2009.

Facebooks open sources the Cassandra project in 2008

Project Voldemort is a replicated database with no single point-of-failure. Started in 2008.

Dynomite is a Dynamo clone written in Erlang.

Terrastore is a scalable elastic document store started in 2009

Redis is persistent key-value store started in 2009

Riak Another dynamo-inspired database started in 2009.

HBase is a BigTable clone for the Hadoop project while Hypertable is another BigTable type database also from 2009.

Source

http://blog.knuthaugen.no/2010/03/a-brief-history-of-nosql.html

http://nosql.mypopescu.com/kb/nosql-getting-started

 

 

Categories: NoSQL Tags:

The wait is over…iPhone 25 has been released right on time!

January 6th, 2013 No comments

This is the story of Bob Seaskul and his determination and patience to wait for the latest and greatest iPhone ever.  At the Apple Worldwide Developers Conference on June 11, 2035 – the latest and final release of iPhone was revealed.  This of course is no surprise as Apple had already hinted at the discontinuation of the product on WWDC ’30 when they released iPhone 20 along with IOS version 41.

What does this have to do with Bob you might be saying to yourself?  When the first iPhone was released on June 29, 2007, Bob was one of the original people who had stayed on line for 3 days and nights to buy his new gadget.  He loved the product at the time as did everyone else…its futuristic look, touch screen and nicely presented user interface made him and millions of other people fall in love with it.

Not so long after the first release of iPhone, the second release came out and a year later the iPhone 3 and then iPhone 4 and finally iPhone 5.  Bob without much hesitation would stand online for days to lay his hands on a brand new iPhone and never had a second thought on whether he needed to upgrade or not.  As long as Apple released a new version, he would just blindly and happily purchase a new one.

When Bob purchased iPhone 4 on June of 2010, he was excited as ever before despite it’s new shape and look but in the back of his mind he was looking forward to 2011 when he’d lay his hands on the iPhone 5 and the amazing features that would bring!  When June, 2011 came around Bob was jumpy and excited at the WWDC and couldn’t wait to see the new iPhone 5!  However, to his disappointment iPhone 4S was released and not iPhone 5 for which he was so looking forward to for over a year!  At that point on October 14, 2011 he promised himself to not buy another iPhone every year but rather wait until its final release so he could have the latest and greatest of the iPhone family!

Bob saw new iPhones come and go, the iPhone 5 came then 6, then 7 and 14 and so on but Bob stayed true to his promise and reaffirmed his conviction and promise to himself everyday in front of the mirror so that he never betrays himself purchasing another iPhone and then see another one come into the market a few months to a year later!  Bob’s iPhone 4 was almost unusable with new apps coming out that needed large amount of memory and cpu power but he never faltered from his promise and went on with the pain and misery of using his iPhone 4 came with over the years.

Bob was 27 years old in 2007 and when he heard the announcement at WWDC on June of 2030, he had turned 55 years old in March of that year.  He couldn’t believe his eyes and ears when he heard from Apple CEO Alexis Ohanian that iPhone will be discontinued in 5 years and the final release, iPhone 25 will be made available on June of 2035 when Bob is 60.  Bob didn’t care how old he was going to be, besides he only saw age as just numbers…”what matters is the mindset of the person, age is just a stupid number!”, he’d tell himself when he’s reminded of his age.  Bob has been using iPhone4 for over 27 years now and has grown tired and sick and suicidal at times because of it.  The new iPhones looked much different, in fact they were like small chips, it did much more than just a phone.  It could turn into a computer, a car and a large screen 108″ TV and even drove a car but Bob didn’t give a shit what else it could do….he just wanted the latest release of the iPhone and he was finally at peace to hear that the final release will be available in 2035.

By the time the WWDC ’35 came around on June 2035, Bob’s story was the most trended topic on the internet, specially on Earth where Bob resided. The inhabitants of planet Khilmook and Mazar also new of Bob as they had more frequent political, business and social encounters on regular basis.  Some humans migrated to Mazar and others to Khilmook for better life and opportunities and vice versa…overall the future had changed so much than the 2007 era that Earth couldn’t be recognized.  No more did people just live on the surface but rather in freaking balloon shaped thingies with their families and holographic pets.  Out of all the fortune 500 companies, only Apple and Costco had survived.  BJ’s went out of business unfortunately as it carried weird brands and for some reason water was more expensive there than at Costco’s.

So Bob, in front row seat at WWDC ’35 was called to the stage by Alexis to present the iPhone 25 and with sheer joy and excitement, he went to the stage to do so.  To his astonishment, the new iPhone 25 was well… invisible.  It wasn’t a physical device anymore, event that micro dot that was iPhone 24 and previous was now replaced by nothing.  WTF? Bob lost it then and there and took out his old iPhone 4 which he had turned into a small pistol and started shooting at the Apple CEO who just appeared unharmed…it so happens he wasn’t even there but rather his damn hologram.

Bob, disappointed and emotionally unstable at this point gives in to the authorities.  His iPhone 4 that was turned into a pistol was confiscated and returned to Apple who is now displaying it at their manhattan store in South Africa.  You might be asking yourself Manhattan in Africa???  Long story…the geological changes that occurred in the same span of time wasn’t the focus of this article…

Categories: iPhone Tags: ,

Top 50 MongoDB PDF Tutorials

January 6th, 2013 No comments

It is not easy to get the correct and applicable tutorials and it is important to know all the details of the programs in order to settle with the correct details. Most of the PDF tutorials make it easier to get all the correct details and it leads you to settle with the ideal information. The tutorial needs to cover everything from the introduction, operations, and other details that you need to know about operating the MongoDB system.

www.docs.mongodb.org/manual/tutorial/

Connect to a Database

www.downloads.mongodb.org/docs/mongodb-docs-2010-05-22.pdf

  • Connect to a mongod
  • Select a Database
  • Display mongo Help

Create a Collection and Insert Documents

  • Insert Individual Documents
  • Insert Multiple Documents Using a For Loop

Working with the Cursor

  • Iterate over the Cursor with a Loop
  • Use Array Operations with the Cursor
  • Query for Specific Documents
  • Return a Single Document from a Collection
  • Limit the Number of Documents in the Result Set

Next Steps with MongoDB

www.openmymind.net/mongodb.pdf

For additional details about the manipulation of docs, you need to proceed in the learning process of MongoDB using

www.wiki.hsr.ch/Datenbanken/files/MongoDB.pdf

  • CRUD Operations
  • SQL to MongoDB Mapping Chart
  • Drivers

The complete MongogDB tutorial

www.mkyong.com/tutorials/java-mongodb-tutorials/

This gives a comprehensive introduction installation and ways that enables the learn to set up the MongoDB program

  • Installing MongoDB
  • The MongoDB Tutorial
  • Frequently Asked Questions
  • Release Notes

Introduction

A Quick Tour

  • Making A Connection
  • Authentication (Optional)
  • Getting A List Of Collections
  • Getting A Collection
  • Setting write concern
  • Inserting a Document

Finding the First Document In A Collection using findOne()

  • Adding Multiple Documents
  • Counting Documents in A Collection
  • Using a Cursor to Get All the Documents

Getting A Single Document with A Query

  • Getting A Set of Documents With a Query
  • Creating An Index

Getting a List of Indexes on a Collection

Quick Tour of the Administrative Functions

  • Getting A List of Databases
  • Dropping A Database

Getting started

Using the tutorials that will enable you to understand more about the introduction and operations of MongoDB programs and database- www.w3resource.com/mongodb/introduction-mongodb.php

Introduction

Downloads

Developer Documentation

Administrative Documentation

  • Journaling
  • Production Notes
  • Starting and Stopping MongoDB

DB Operations from the Shell

  • Windows
  • Troubleshooting

Community

  • 10gen
  • Meetup Events
  • MongoDB Masters
  • Slides and Video
  • Hosting Center

MongoDB Monitoring Service (docs)

  • Administrative Interfaces
  • International Documentation
  • MongoDB Books

 

MongoDB PDF Wiki tutorial

 

This manual offers some tips and solutions, which makes it easier for one to start understanding the process in the command sections, installations, and setting up. This does not happen when you use other tutorials since they are complex and the wiki offers affordable tutoring.

Getting Started

  • Introduction
  • Downloads

Developer Documentation

  • Administrative Documentation
  • Journaling
  • Production Notes
  • Starting and Stopping MongoDB

DB Operations from the Shell

  • Windows
  • Troubleshooting

Community

  • 10gen
  • Meetup Events
  • MongoDB Masters
  • Slides and Video
  • Hosting Center

MongoDB Monitoring Service (docs)

  • Administrative Interfaces
  • International Documentation
  • MongoDB Books

There are numerous details to keep in mind before you subscribe to most of the tutorials. It is advisable to check the source and rely in the ones that give the clear paths and indications that will offer you nothing but the main solutions. This is the reason why you need to rely on MongogDB solutions to get the latest details and updates on this program.

www.hacksparrow.com/the-mongodb-tutorial.html

www.stackoverflow.com/questions/11490625/rails-with-mongodb

Categories: MongoDB Tags: ,

Top 50 MongoDB Video Tutorials

January 4th, 2013 No comments

When you want to know more about the performance and enhancement of the program, it is wise when you settle with the video tutorials, and they will show you all the steps and the descriptions that you need to know about the performance. With this, you have more chances of understanding the basic details that will lead you to understand this program and start to adhere to the processes presented. www.learn-with-video-tutorials.com

www.youtube.com/watch?v=2ajlfURobd8

www.architects.dzone.com/articles/video-how-think-non-relational

The complete MongoDB video installation program

This video enables you to grasp all details in matters of presentation of the program and all the basic subjects you will learn in the different stages. The methods are self-explanatory when you view the video and understand.

 MongoDB installation and theory (06:45) www.glenscott.co.uk/…/getting-started-with-mongodb-and-php-on

 

NoSQL, document-oriented database, collection, MongoDB installation, connection do database

    MongoDB introduction (09:30) www.slideshare.net/mdirolf/introduction-to-mongodb

 

MongoDB shell, mongod, use database, inserting data, selecting data, save, insert, find, query selector, updating data, update, deleting data, remove, drop, operators: set, unset

Advanced MongoDB (21:05) www.youtube.com/watch?v=w5qr4sx5Vt0

 

creating complex documents, joining documents, cursor variable, documents iterating, operators: push, addToSet, each, pop, rename, limit, it, hasNext, printJSON, skip, sort, lt, lte, gt, gte, in, nin, all, distinct, count, boolean operators: ne, not, or, and, exists

    MongoDB performance and administration (09:25)

Database performance, indexing, index, explain, properties: nscanned, nscannedObjects, nYields, nChunkSkips, isMultiKey, indexOnly; getIndexes, uniqueIndex, mongodump, mongorestore, mongoexport, mongoimport, mongosniff, mongostat, show dbs, show collections, system.indexes, db.stats

    MongoDB and PHP (06:30) www.php.net/manual/en/class.mongodb.php

PHP driver installation, php_mongo.dll, php.ini modificaations, writing and running example PHP script

Best video presentations and descriptions of MongoDB www.mongodb.org/display/DOCS/Database+Profiler

www.slideshare.net/fwso/mongodb-withphpjamestang-10101992

 

 

  • Analytics MongoDB Analytics for Online Advertising at Magnetic
  • DevOps Data Center Awareness with MongoDB
  • DevOps Deployment Best Practices
  • DevOps Diagnostics and Performance Tuning
  • DevOps Keeping your data safe: replication, backup/restore, mongodump
  • DevOps MongoDB and Amazon Web Services
  • DevOps MongoDB on Amazon EC2
  • DevOps Scaling with MongoDB
  • DevOps Tips for a Successful, Scalable MongoDB Deployment
  • Geo Geospatial Indexing with MongoDB
  • Hadoop Hadoop plugin for MongoDB: The Elephant in the Room
  • Indexing Indexing Matters: A MongoDB Optimization Primer
  • Indexing Indexing With MongoDB
  • Intro Developing Applications with MongoDB: A Quickstart Tutorial
  • Intro Introduction to MongoDB
  • Java What’s New in Java Driver Version 2.5
  • Java Zero to MongoDB – Introduction for MongoDB with Java
  • Journaling Journaling in MongoDB version 1.8
  • Node.js Node.js and MongoDB, a Panel Discussion
  • Ruby MongoDB and Ruby
  • Scala MongoDB and Scala
  • Schema Schema Design with MongoDB
  • Use Cases How MongoDB helps Visibiz tackle social CRM
  • Use Cases Humongous Data at Server Density: Approaching 1 Billion Documents in MongoDB
  • Hybrid Applications with MongoDB and RDBMS
  • v1.8 What’s new in MongoDB v1.8.0
  • v2.0 What You Need to Know About MongoDB 2.0

 

Image of video screenshot of MongoDB shell version

The following tutorials offer the video formats of understanding the obtaining MongoDB features and processes. www.slideshare.net/fwso/mongodb-withphpjamestang-10101992

 

  • OS X 32-bit
  • OS X 64-bit
  • Linux 32-bit
  • Linux 64-bit
  • Windows 32-bit
  • Windows 64-bit
  • Solaris i86pc
  • Solaris 64

The latest Course Introduction to MongoDB (course outline) https://github.com/mongodb/mongo-php-driver/downloads

 

  • Introduction to MongoDB
  • Overview and working with documents
  • Datatypes
  • Schema Design
  • CRUD Operations
  • Operators
  • Indexes
  • Aggregation
  • Map and Reduce
  • PHP, Java and Python Drivers
  • C# Drivers
  • Replication
  • Replication Sets
  • Sharding
  • GridFS
  • Import and Export Data
  • Backup and Restore
  • Monitoring
Categories: MongoDB Tags: ,

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: