تجربه های یک برنامه نویس - Experience of programmer
Data Base, Relatinal Data Base

IBM DB2 Installation Guide

December 17, 2017 by arfprogrammer No Comments
  1. Register in IBM web And Download Express-C edition via timetohide.me proxy web site.
  2. Download Manuals Books
  3. Extract v10.5_linuxx64_nlpack.tar.gz to /opt/ibm_db2
  4. Execute db2prereqcheck from /opt/ibm_db2 for determine pre requirements of bd2
  5. If operating system of server is 64 bit of ubuntu, I recommend to read this link
  6. After db2prereqcheck matched all dependencies you can run db2install
  7. After installation has been done, the /opt/ibm/ directory and it`s child directories will be created
  8. Then you can run db2setup to install db2 and you can flow instructions in BD2InstallingServers-db2ise1051.pdf page 125
  9. After setup successfully done, user db2inst1 has been created.
  10. In terminal login this user using command sudo su db2inst1
  11. Start the database manager by entering the db2start command.
  12. Enter the db2sampl command to create the SAMPLE database. This command can take a few minutes to process. There is no completion message; when the command prompt returns, the process is complete.The SAMPLE database is automatically cataloged with the database alias SAMPLE when it is created.
  13. In terminal execute db2 and then enter the following
    commands
connect to sample
select * from staff where dept = 20
connect reset
  1. This database management system, stores data on file and database restart will not affect on data storage.
Share:
Reading time: 1 min
Data Base, No SQL Data Base

Aerospike Database overview

December 17, 2017 by arfprogrammer No Comments

Installatin Steps

wget -O aerospike.tgz 'http://aerospike.com/download/server/latest/artifact/ubuntu12'
tar -xvf aerospike.tgz
cd aerospike-server-community-*-ubuntu12*
sudo ./asinstall # will install the .rpm packages
sudo service aerospike start

Write Key Value

ascli put

ns the namespace for the record being written.
The set is the set for the record being written.
The key is the key for the record being written. It can be either an > integer or string.
The record is a JSON object representing the record to be written. The JSON object’s keys are the bin names and the value are bin values.

Reading Key Value

ascli get

Reading All Values

  1. Enter aql command in terminal
  2. Enter bellow query
select * from

Start, Stop and Restart aerospike service

sudo service aerospike start
sudo service aerospike stop
sudo service aerospike restart

Data Storage

after restart service, all stored data will be cleaned.

Reserved TCP Ports

Name Default Port Description
Service 3000 Application, Tools, and Remote XDR use the Service port for database operations and cluster state.
Fabric 3001 Intra-cluster communication port. Replica writes, migrations, and other node-to-node communications use the Fabric port.
Mesh Heartbeat 3002 Heartbeat protocol ports are used to form and maintain the cluster. (Only one heartbeat port may be configured.)
Multicast Heartbeat 9918 Heartbeat protocol ports are used to form and maintain the cluster. (Only one heartbeat port may be configured.)
Info 3003 Telnet port that implements a plain text protocol for administrators to issue info commands. For more information, see asinfo documentation.
XDR Service1 3004 (Optional) Port to query health state of the Cross Datacenter Replication (XDR) client.

Refrences

Aerospike Install
Aerospike Networks

  1. Ensure that all Application and XDR nodes can communicate to the service port on all Aerospike nodes. Also ensure that each node can communicate over the configured heartbeat and fabric ports. ↩
Share:
Reading time: 1 min
Data Base, Relatinal Data Base

Relational Database Compare

December 17, 2017 by arfprogrammer No Comments
Name DB2 MySQL Oracle Percona Server VoltDB
Description Common in IBM host environments, 2 different versions for host and Windows/Linux Widely used open source RDBMS Widely used RDBMS Enhanced drop-in replacement for MySQL based on XtraDB storage engine with improved performance and additional diagnostic and management features. Distributed In-Memory NewSQL RDBMS
Database model Relational DBMS Relational DBMS Relational DBMS Relational DBMS Relational DBMS
License commercial, free version is available Open Source, GPL version 2. Commercial licenses with extended functionallity are available commercial, restricted free version is available Open Source, GPL version 2 Open Source, GPL version 3 for Community Edition, commercial license for Enterprise Edition
Implementation language C and C++ C and C++ C and C++ C and C++ Java
Server operating systems Linux,Unix,Windows,z/OS FreeBSD,Linux,OS X,Solaris,Windows AIX,HP-UX,Linux,OS X,Solaris,Windows,z/OS Linux Linux,OS X
Data scheme yes yes yes yes yes
Typing yes yes yes yes yes
Secondary indexes yes yes yes yes yes
SQL yes yes yes yes yes
APIs and other access methods JSON style queries,XQuery,ADO.NET,JDBC,ODBC ADO.NET,JDBC,ODBC ODP.NET,Oracle Call Interface (OCI),JDBC,ODBC ADO.NET,JDBC,ODBC,Java,API RESTful HTTP/JSON API,JDBC
Supported programming languages C,C#,C++,Cobol,Fortran,Java,Perl,PHP,Python,Ruby,Visual Basic Ada,C,C#,C++,D,Eiffel,Erlang,Haskell,Java,Objective-C,OCaml,Perl,PHP,Python,Ruby,Scheme,Tcl C,C#,C++,Clojure,Cobol,Eiffel,Erlang,Fortran,Groovy,Haskell,Java,JavaScript,Lisp,Objective C,OCaml,Perl,PHP,Python,R,Ruby,Scala,Tcl,Visual Basic Ada,C,C#,C++,D,Eiffel,Erlang,Haskell,Java,Objective-C,OCaml,Perl,,PHP,Python,Ruby,Scheme,Tcl C#,C++,Erlang,Java,JavaScript,PHP,Python,Ruby
Server-side scripts yes yes PL/SQL yes Java
Triggers yes yes yes yes no
Partitioning methods Sharding horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric horizontal partitioning Sharding
Replication methods yes Master-master replication, Master-slave replication Master-master replication, Master-slave replication Master-master replication, Master-slave replication,XtraDB Cluster Master-slave replication
MapReduce no no no no no
Consistency concepts Immediate Consistency Immediate Consistency
Foreign keys yes yes yes yes
Transaction concepts ACID ACID ACID ACID ACID
Concurrency yes yes yes yes yes
In-memory capabilities yes yes
Durability yes yes yes yes yes => Snapshots and command logging
Horizontal scalable no yes yes yes yes
Value size max. 10 B 4 B 2 EB
Memory minimum 256 MB 11 MB 512 MB ? 4 GB
Data Storage File System, Volatile memory File System, Volatile memory ASM, File System File System Volatile memory, File System,Data Persisted to Disk
Share:
Reading time: 2 min
Data Base, No SQL Data Base

NoSql Database comapre

December 17, 2017 by arfprogrammer No Comments
Name Aerospike Redis MongoDB Neo4j
Description Flash-optimized In-memory NoSQL Database In-memory data structure store, used as database, cache and message broker One of the most popular document stores Open source graph database
Database model Key-value store Key-value store Document store Graph DBMS
License Open Source – Apache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition available Open Source – BSD 3-Clause, commercial license available Open Source – AGPL version3, Commercial Licence available Open Source – AGPL version3, Commercial Licence available
Implementation language C C C++ Java
Server operating systems Linux BSD, Linux, OS X, Windows Linux, OS X, Solaris, Windows Linux, OS X, Windows
Data scheme schema-free schema-free schema-free, Although schema-free, documents of the same collection often follow the same structure schema-free
Typing yes partial => Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes yes => string, integer, double, boolean, date, object_id yes
Secondary indexes yes no yes yes => pluggable indexing subsystem, by default Apache Lucene
SQL no no no no
APIs and other access methods proprietary protocol proprietary protocol using JSON Cypher query language, Java API, RESTful HTTP API
Supported programming languages C, C#, Erlang, Go, Java, JavaScript (Node.js), Lua, Perl, PHP, Python, Ruby C,C#,C++,Clojure,Crystal,D,Dart,Elixir,Erlang,Fancy,Go,Haskell,Haxe,Java,JavaScript (Node.js),Lisp,Lua,MatLab,Objective-C,OCaml,Perl,PHP,Prolog,Pure Data,Python,R,Rebol,Ruby,Rust,Scala,Scheme,Smalltalk,Tcl Actionscript, C, C#, C++, Clojure, ColdFusion, D, Dart, Delphi, Erlang, Go, Groovy, Haskell, Java, JavaScript, Lisp, Lua, MatLab, Perl, PHP, PowerShell, Prolog, Python, R, Ruby, Scala ,Smalltalk .Net, Clojure, Go, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby, Scala
Server-side scripts user defined functions Lua JavaScript yes
Triggers no no no yes
Partitioning methods Sharding Sharding Sharding none
Replication methods selectable replication factor Master-slave replication Master-slave replication Master-slave replication
Consistency concepts Eventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configuration Eventual Consistency Eventual Consistency, Immediate Consistency Eventual Consistency configurable in High Availability Cluster setup, Immediate Consistency
In-memory capabilities yes yes yes no
Durability (data storage) yes yes => Configurable mechanisms for persistence via snapshots and/or operations logs yes => optional yes
Horizontal salable yes yes Yes, with sharding No (Community), Yes (Enterprise)
Data storage RAM,SSD Volatile memory, File System Volatile memory, File System local (community), Data,Persisted to Disk,Volatile memory,Memory-Mapped File (Enterprise)
Memory minimum 2 GB 3 GB depends on several factors 2 GB (Enterprise)
Value size max. 1 MB 512 MB 16 MB 34 B(comunity), 1 TB (Enterprise)
Share:
Reading time: 2 min
Page 3 of 3123

Archive