Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/databas2/public_html/articles.php on line 14 Database Articles - Database Directory

Database Articles

Business Intelligence
Business Intelligence term describes the process of gathering information and knowledge through the process of analyzing business data. The purpose of business intelligence is to facilitate better business decisions, utilizing the newly found knowledge ab...

Data Backup
Data Backup is the process of copying data to a different location than the original one. The actual copy of the data is called data backup too. The purpose of data backup is to create additional copy of the existing data. Data backups are done as a safet...

Data Mining
Data Mining also known as data discovery and knowledge discovery is the process of researching and analyzing huge data sets in order to find patterns and/or relationships. The idea behind data mining is to find and extract previously unknown and somehow ...

Data Protection
Data Protection is one of the most important tasks faced by any business. Your data can be in different formats and saved on different media - paper, files or a database. No matter where your data resides or in what format your data is, you have to protec...

Data Recovery
Data Recovery is the process of salvaging data from a media, when this data can no longer be accessed normally, due to a physical damage of the storage media or problem with the file system (logical damage). The storage that we need to recover data fro...

Data Warehousing
Data Warehousing is the procedure of designing, and maintaining a Data Warehouse system. Data Warehousing is a method for gathering and controlling data from different sources making the data easily available for querying and analysis. A Data Wareho...

Database Design
Database Design term refers to the formal process of creating a complete data model of a database. The Database Design is very important process in the lifecycle of every database, because it affects its performance, scalability and usability. The Data...

Databases and Web Hosting
Databases or RDBMS play very important role in almost any online activity today. There is a database backend behind every major online business website. Web hosting companies nowadays offer variety of database options along with their web hosting pac...

DB2
DB2 is relational database management system developed by IBM. DB2 is the first database product that used SQL language. DB2 was first available on the mainframe and later moved to UNIX, Linux and Wind...

Informix
Informix was established by Laura King and Roger Sippl, under the name Relational Database Systems Inc in 1980. In 1988 the company changed its name to Informix Software Inc. The Informix DBMS started from the Ingres system that also led to Sybase and ...

Microsoft Access
Microsoft Access is an entry-level database management software and it’s one of the most popular Microsoft products. MS Access comes with the professional edition of MS Office package. MS Access use the Jet database engine which utilize a specific
MS SQL Server
MS SQL Server is a Relational Database Management System developed by Microsoft Corp. MS SQL Server is an enterprise level database competing with products like Oracle and DB2. MS SQL Server cost much less than its comparable competitors products, hence i...

MySQL
MySQL is an open source relational database management system released under GNU General Public License. The Swedish company called MySQL AB develops MySQL. MySQL is available on many different platforms including Microsoft Windows, the major Linux dis...

OLAP
OLAP stands for OnLine Analytical Processing and is a technology used to collect, manage and process multidimensional data and provide fast access to this data for analytic purposes. OLAP is widely used in business reporting for marketing, sales...

Oracle
Oracle is a relational database management system developed by Oracle Corporation. The Oracle RDBMS is used in many database applications on sevarl OS platforms, including Unix and Windows. Oracle database was initially developed by Larry Ellison, Bob ...

PostgreSQL
PostgreSQL is a open source object-relational database management system. PostgreSQL is free and it’s an alternative to other open-source database systems like MySQL. PostgreSQL is a highly scalable, S...

RAID - Redundant Array of Independent Disks
RAID stands for Redundant Array of Independent Disks. RAID is a system, which uses several hard disks for replicating data between the hard disks. The basic idea behind RAID is combining multiple hard disks into a single logical unit. When RAID is impleme...

MS SQL Server 2005 Released
MS SQL Server 2005 was finally released on November 7th, 2005. The previous version of the database software MS SQL Server 2000 was released in 2001. Even Microsoft’s CEO Steve Ballmer admitted that th...

SQL Training
SQL training can be free or can be very expensive, but the fact is if you are in IT you need it. Most software applications use one or another form of data storage, and the majority use RDBMS a...

SQLite
SQLite is an relational database management system contained in a relatively small C library. SQLite is a public domain project developed by D. Richard Hipp. The SQLite is not a standard relational database management system, but is part of the program...

ThinkSQL
ThinkSQL is cross-platform RDBMS developed by the UK based company ThinkSQL. Thinks SQL complies with the ISO SQL standard. ThinkSQL Server supports transactions, views, nested selects, and referent...

What is a database?
There are many definitions of the term “database” and one of the most common once is that the database is a collection of information/knowledge stored in digital format. The database can be in form of a flat text file or can be a relational database. ...

What is RDBMS?
RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields. RDBMS st...

What is SQL?
SQL stands for Structured Query Language. SQL language is used to create, transform and retrieve information from RDBMS (Relational Database Management Systems). SQL is pronounced SEQUEL. SQL wa...


SQL Tutorial