Tag Archives: Database

BIG Data Trends in 2012

Data Analytics as a Service Data Visualization as a Service Crowdsourcing Model – enterprise will start using the crowdsourcing model to help analyze and find patterns in the data. Big Vendors –Oracle, IBM and to some extent Microsoft will release … Continue reading

Posted in BIG Data, Cloud Computing, Next BIG Thing, NoSQL | Tagged , , , , , , , | 1 Comment

Hibernate Development Environment

Hibernate Development Environment Obtain Hibernate https://www.hibernate.org/ Locate the Download link in the left navigational bar. Click it to bring up the download page. Download compressed file & extract it. Add Hibernate’s dependencies to the classpath; they’re distributed along with Hibernate … Continue reading

Posted in Hibernate | Tagged , , , , , , , | Leave a comment

Why ORM Frameworks?

Why ORM Frameworks We are forced to download data from a database many times, transfer them to an application and save the data converted by a system to a database. It is obviously possible to do it using SQL and … Continue reading

Posted in Hibernate | Tagged , , , , , , , | Leave a comment

MySQL-Executing SQL Statements from a .sql File

However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. If you are already running mysql, you can execute an SQL script file using the source … Continue reading

Posted in How To..., MySQL | Tagged , , , , , , , , , | Leave a comment

Solution of Error in MYSQL installation on Ubuntu

Error Solution sudo apt-get update sudo apt-get dist-upgradesudo apt-get install mysql-server

Posted in How To... | Tagged , , , , , , , | Leave a comment

Install phpMyAdmin on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing … Continue reading

Posted in How To..., Ubuntu | Tagged , , , , , , , , , , , , | 1 Comment

Install MySQL Server on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS

MySQL is a relational database management system (RDBMS)that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius‘ daughter, My. The SQL phrase stands for Structured Query Language. Free-software-open source projects … Continue reading

Posted in How To..., Ubuntu | Tagged , , , , , , , , , , | 4 Comments

Oracle NoSQL Database

The Oracle NoSQL Database is a distributed key-value database. It is designed to provide highly reliable, scalable and available data storage across a configurable set of systems that function as storage nodes. Simple Data Model Key-value pair data structure, keys … Continue reading

Posted in Cloud Computing, Cloud NEWS | Tagged , , , , , , , | 3 Comments

Magento(Any) Database Backup by PHPMyAdmin

Enable phpMyAdmin By default, you can only access phpMyAdmin from the same computer. You can enable it by editing the “opt/bitnami/apps/phpmyadmin/conf/phpmyadmin.conf” file: Alias /phpmyadmin “/installdir/apps/phpmyadmin/htdocs” installdir/apps/phpmyadmin/htdocs”> AuthType Basic AuthName phpMyAdmin AuthUserFile “/installdir/apache2/users” Require valid-user Order allow,deny Allow from all  #Change … Continue reading

Posted in Private Cloud | Tagged , , , , , , , | 1 Comment

Remote Access to MySQL Database Server for Database VM

Edit my.cnf File gedit /etc/my.cnf Once file opened, locate line that read as follows [mysqld] Make sure line skip-networking is commented (or remove line) and add following line bind-address=192.168.0.101 [mysqld] user            = mysql pid-file        = /var/run/mysqld/mysqld.pid socket          = /var/run/mysqld/mysqld.sock port            … Continue reading

Posted in Cloud Computing, Private Cloud | Tagged , , , , , , , | 4 Comments