Database

MongoDB: an introduction and comparison to MySQL
MongoDB — the flexible and scalable NoSQL database
  • Web development

NoSQL databases have long since been serious competitors to classic relational database systems, like MySQL. They replace the strictly-defined storage structures of traditional models through flexible saving procedures. This allows data pools to be easily distributed onto multiple servers in order to guarantee high availability of web applications. But are these new systems really all that they’re...

MongoDB — the flexible and scalable NoSQL database
SQL injection: Fundamentals and safeguards
SQL Injection: Protect your database system
  • Security

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it?

SQL Injection: Protect your database system
Databases
Databases – why do you need them and what kinds are there?
  • Technical matters

Databases are a fundamental part of our information society today. They organize 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. While the history of the database began with the hierarchical model, today the relational database model is the...

Databases – why do you need them and what kinds are there?
Set up ownCloud with Raspberry Pi
Creating a Raspberry Pi cloud server with owncloud
  • Configuration

With ownCloud software, your Raspberry Pi can be used as a private cloud, performing the same kind of tasks as clouds from major providers such as Google, Amazon, and Dropbox. Cost-effectiveness is just one of many the benefits of creating your own personal cloud; another is the privacy and security of your data. This step-by-step Raspberry Pi cloud tutorial explains how to set up ownCloud.

Creating a Raspberry Pi cloud server with owncloud
XAMPP tutorial: create your own local test server
XAMPP tutorial: installation and first steps
  • Tools

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

XAMPP tutorial: installation and first steps
Relational Databases
The relational database model
  • Technical matters

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

The relational database model
Buyer personas for optimal targeting
Buyer personas: Getting to know your customers better
  • Web analytics

When it comes to online marketing, data is what counts most today. But what good is the information you have collected and analyzed if you address indefinite groups of people in your messages? It is better to identify the people behind the data set and focus on them. Creating concrete buyer personas helps to better align marketing measures with the target group.

Buyer personas: Getting to know your customers better
IndexedDB
IndexedDB: Tutorial for browser storage
  • Web development

Holding certain data in the client helps to make the Internet faster and more flexible, enabling users to enjoy a better browsing experience. IndexedDB allows larger volumes of data to be stored in the users’ browsers so that they don’t have to be downloaded from the server each time the website is accessed. Get to know IndexedDB based on an example.

IndexedDB: Tutorial for browser storage
What is Big Data?
Big Data: definition and examples
  • Web analytics

When we shop online, book vacations, and search for gift ideas, we hardly give a second thought to the fact that each search entry leaves behind a trail of our identity. Busy web bots are never far behind and sweep up this information. The result of all of this is Big Data: massive volumes of data that are analyzed and used for a variety of reasons. But is there reason to be wary of leaving behind...

Big Data: definition and examples
In-memory databases
In-memory databases: the storage of big data
  • Technical matters

In-memory databases enable big data to be analyzed and made available in real time. The quick access speeds are made possible by storing the data on the working memory – hence the name in-memory database. Traditional databases, on the other hand, are based on the method of storing data on the hard disk. How do in-memory databases differ from traditional database systems? And what are the go-to...

In-memory databases: the storage of big data