A major strength of the relational database model is that information is stored in separate database tables structured according to semantic relationships. This concept, known as normalization, is the basis for data storage that is as redundancy-free as possible, but requires a mechanism with which data from different tables can be merged for queries. The different JOIN types provide users with...
The INNER JOIN is the most important JOIN type in the relational database model. If you want to query database tables in a group, you would usually use INNER JOINs based on equality relationships between primary and foreign keys. We will show you how to use INNER JOINs in practice, delineate the JOIN type from OUTER JOINs, and also deal with the different subtypes of INNER JOINs.
If independently installing the software package for your hosting project is your goal, then you might consider choosing one of the many free components out there. Sooner or later you are bound to encounter the widely used and very popular LAMP stack software bundle. But what exactly makes this package so attractive in comparison to alternative options?
Along with Oracle and Microsoft SQL server, MySQL is one of the most popular management systems for relational databases. Nowadays the software developed by MySQL AB belongs to the product portfolio of the Oracle Corporation and is proprietarily marketed under a dual license. Since 2009, an open source MySQL fork, known as MariaDB, has also been available from the original developers. Here we give...
Backing up your data is a popular option for securing your database. In order to create backup copies, you need additional hardware and to install a suitable backup structure. How do you secure your own network and web server against attacks and proceed to protect your databases?
“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.
There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a...
The CMS, papaya, is lauded by its developers as a high performance content management system – a fully justified claim, considering the software’s wide range of smart and powerful functions. But is papaya CMS a viable option for any web project? And what exactly are this program’s strengths and weaknesses?
The UK-based CMS ocPortal has undergone a rebrand: presenting Composr 10. Following in the footsteps of ocPortal 9, this CMS offers an all-in-one solution for web presences, with no need for extensions or templates. But who is Composr 10 suited to? And how does it compare to the CMS market leaders?
While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.