Krishna After Linus Torvalds created Linux back in the 1990s, he wanted to stop working for a little bit. So, what he did was he made the source code for his new operating system completely available to the public. This allowed everybody in the world, especially … Read more
The reason that you should learn Linux and start deploying Linux is for server functionality. Linux is incredibly rock-solid. Once you install Linux, and once you get through all the quirks and you set up all the configurations, a Linux server will … Read more
Heuristic optimization often includes making transformations to the query tree by moving operators up and down the tree so that the transformed tree is equivalent to the tree before the transformations. Before we discuss these heuristics, it is necessary to discuss the following rules governing the manipulation of relational algebraic expressions: 1. Joins and Products … Read more
Before query optimization is carried out, one would of course need to decide what needs to be optimized. The goal of achieving efficiency itself may be different in different situations. For example, one may wish to minimize the processing time but in many situations one would wish to minimize the response time. In other situations, … Read more
In most database systems, queries are posed in a non-procedural language like SQL and as we have noted earlier such queries do not involve any reference to access paths or the order of evaluation of operations. The query processing of such queries by a DBMS usually involves the following four phases: 1. Parsing 2. Optimization … Read more
Step 1 – Insert USB and Identify Volume $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 28G 24G 2.3G 92% / udev 1.4G 12K 1.4G 1% /dev tmpfs 277M 1.2M 276M 1% /run none 5.0M 0 5.0M 0% /run/lock none 1.4G 34M 1.4G 3% /run/shm /dev/sdc1 14.8G 1.4G 13.4G 10% /media/admin Now, … Read more
SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the Data Manipulation Language (DML) part of SQL: • INSERT INTO – inserts new data into a database table • UPDATE – updates data in a database table • DELETE – deletes data from a database table … Read more
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables. The most important DDL statements in SQL are: • CREATE TABLE – creates a new database table • ALTER TABLE – alters (changes) … Read more
Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally case sensitive, though this in this tutorial all commands (SELECT, UPDATE etc) are upper-cased. • Variable and parameter names are displayed here as lower-case. • New-line characters are ignored in SQL, so a command may be … Read more
There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction Control