Database

Elasticsearch

Elasticsearch: the flexible search engine

If you work with large amounts of data, you’ll need a powerful search engine. Elasticsearch offers you a full-text search that you can configure so that it is perfectly tailored to your needs. But first you have to understand the principle behind it – what is Elasticsearch?. In this Elasticsearch tutorial we’ll explain the first steps in using the search engine, from installation to creating a...

Relational databases

The relational database model

With relational database systems, you use tables to store and manage information. This sounds simple but involves quite complex concepts such as normal forms, key relationships, and JOINs. This article will introduce the basics of the relational database model, compare its advantages and disadvantages, and delimit this type of data storage from alternative approaches, like object databases,...

Databases

Databases – why do you need them and what kinds are there?

Databases are a fundamental part of our information society today. They organise electronic data and regulate access to it. Databases have a wide range of applications, both commercial and private. Each database system has a database management system based on a specific database model. Whilst the history of the database began with the hierarchical model, today the relational database model is the...

XAMPP tutorial: create your own local test server

XAMPP tutorial: installation and first steps

The software packet XAMPP is a collection of popular applications like the web server Apache, a leading database management system (either MySQL or MariaDB), the scripting languages PHP and Perl, and more – all together in a compact test server. Our XAMPP tutorial will take you through the installation and configuration process, with the aid of clear instructions and screenshots, to help you set...

How does data backup work for databases?

Backing up your database

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?

UML: activity diagram

Activity diagrams: clearly present chronological activity processes with UML

UML activity diagrams help you to graphically illustrate the chronological sequence of system processes in object-oriented programming. They show which actions take place in which order to execute an activity. With a finished diagram, you can create code frames using XML transfer. Or do you want to map business processes? We show examples of how to create an activity diagram, which symbols belong...

Securing servers with Fail2ban

Securing your server with Fail2ban

For server operators, security is of the utmost importance. Only those who have developed and set up a foolproof defence strategy are ready for drastic situations. As well as regular protection mechanisms, like security software, backups, and encryption, there are also some useful tools and frameworks that may come in handy in the fight against intruders. We have laid out the essential details on...

Managed cloud hosting: customized servers

Managed cloud hosting: flexible server structures at the click of a button

More and more website operators are turning to managed cloud hosting as a solution for their server environment. This option promises flexible scalability of required resources in real time, along with a wide range of services offered by the provider including the installation, maintenance, and protection of the hosting platform. So how does managed cloud hosting work? Find out what services...

A comparison of data mining tools

Data mining tools for better data analysis

In the digital age, it’s normal for data from small and medium-sized companies to grow to unmanageable amounts. Data mining tools are used to extract desired information from data sets. These extract recurring patterns from the data and make them available to marketers and statisticians. We have compared the most important data mining software and show where their strengths and weaknesses lie.

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.


Wait! We’ve got something for you!
Get your .co.uk domain for just £1/1st year.

Enter the web address of your choice in the search bar to check its availability.
12 months for £1
then £10/year