Database normalisation

Less redundancy thanks to database normalisation

Redundancies occur when various details are combined in a single database table. These redundancies use up storage capacity and prevent efficient data processing. The relational database model offers strategies for splitting datasets among several linked tables, in a process called database normalisation. Find out what it’s all about with practical examples.

SQL OUTER JOIN

SQL OUTER JOIN

OUTER JOINs are queries that take place across several database tables. There are LEFT OUTER JOINs, RIGHT OUTER JOINs and FULL OUTER JOINs. Each of these JOIN types has a larger result set than the INNER JOIN. But what exactly is the difference between the individual types? Here, we will distinguish OUTER JOINs from INNER JOINs, compare the different subtypes of OUTER JOINs and explain how they...

SQL JOIN

SQL JOIN – queries across multiple data tables

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 normalisation, 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...

Dereferrer | anonymiszing links made easy

Anonymising links – advantages and disadvantages of dereferrer

Privacy is one of the most important aspects of the Internet. Whoever wants to protect themselves will hopefully begin with one of the most basic elements of the World Wide Web: the hyperlink. References from one webpage to the other usually lead in one direction only – information exchange via HTTP, however, takes place in both directions. To prevent this from occurring, Internet users used to...

HTTP 503: how to fix website errors

HTTP 503 (Service Unavailable): meaning and troubleshooting

It’s very likely that you’ve stumbled on the 'HTTP Error 503 The service is unavailable' notification or something similar during your daily browsing. The error message appears whenever a web server can’t display the website that the user is trying to access. There are many reasons for these notifications, just as there are many solutions. It’s your responsibility as the website operator to...

What is a rewrite engine?

What is a rewrite engine?

A rewrite engine is a component of the web server software that allows website operators to internally rewrite URLs or to redirect them to external URLs. The most popular rewrite engine is mod_rewrite for the Apache HTTP server, but other web servers also offer similar functions. We show you how URL rewriting works in different web servers.

What are quotas?

Quotas – storage for web space and e-mail

Did you encounter the word 'quota' from your web space provider or as part of mail hosting and wonder what is it? When does this storage limit come into play? We show you when and why quotas are used and how to differentiate between the different types.

Index management with the robots.txt file

Index management with robots.txt files

With the file, robots.txt, website operators are able to greatly influence which portions of their web projects are able to be read by search bots. In addition to HTML meta tags, redirects, and canonical tags, this seemingly insignificant text file located in the domain’s root directory is an important tool for index management. We’ve laid out how robot.txt files are built and what website...

What is a CDN (Content Delivery Network)?

What is a CDN (content delivery network)?

If your online project is growing and beginning to attract international customers, the workload of your server is also increasing. High user numbers and the large geographical distribution of the clients result in ever-increasing loading times and slow transfer rates. By using a CDN (content delivery network), you’ll be able to react to increasing demands and optimise your data delivery.

Why you should switch to Cloud hosting

Four reasons to switch to cloud hosting

Say goodbye to dedicated server hosting. The future belongs to the cloud. Still not sure if you should make the switch to flexible Cloud hosting? These four arguments for a contemporary web hosting strategy illustrate how you can achieve effective IT requirements for a competitive business.


Own your online success
IONOS takes care of your online challenges
Create your website with the perfect domain and the UK's fastest hosting!