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...
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...
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...
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...
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.
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.
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...
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 optimize your data delivery.
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.
For many, the cloud is a place where private documents, music, pictures, or videos can be stored and exchanged online. Understanding the different technological aspects of these services, however, proves to be a cloudy venture for many. Did you know, for example, that, in addition to many other things, online stores and websites can also be hosted in the cloud?
Provide powerful and reliable service to your clients with a web hosting package from IONOS.
