Databases are usually based on rows of data. Columnar databases turn this system on its side. Instead of saving each entry one after the other, in a columnar database entries are stored category by category. This results in a decisive speed advantage when working with massive quantities of data. But how exactly does a column-oriented DBMS work?
Almost every application utilizes databases in one form or another. Besides classic relational databases, document-oriented databases have also become well-established in the course of the development of web apps. Instead of working with complex tables, these document stores use semi-structured data in simple documents. But how exactly does this work?
A working database system is pivotal to maintaining any computer-based system. The central body that regulates the respective data pools here is always a Database Management System (DBMS). The software structures and organizes the data available in the database, and also manages writing and reading permissions for the database system.
MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive...
A wide array of database models exists, each one with its own advantages and disadvantages. Key Value Stores, for example, provide lightning-quick results because they follow such a simple principle. A key is saved to each value. There are no more specifications. These Key Value Databases are used principally in website design.
With WinSCP, you can safely create your ideal data transfer between your local Windows PC and a web server. The open source software supports all current protocols and its quick and simple installation process provides an experience that’s satisfying for the user. With the choice of two available user interfaces, you can benefit from a clearly laid-out data management system, which includes...
Are you still transferring your data online over an unencrypted connection via FTP (File Transfer Protocol)? WinSCP offers a comfortable and secure alternative to the current FTP client programs for the operating system, Windows. The encrypted network connection is based on the implementation of Secure Shell (SHH) and enables a fast data transfer via SCP (Secure Copy) and the flexible remote...
Chrome has recently become the most widely used browser in the world. However, this Google application is just as helpless as its competitors Firefox, Opera and Safari when it comes to technical problems on the server or client side. For example, if the domain name cannot be resolved by the DNS, Chrome will simply display the error message “ERR_NAME_NOT_RESOLVED”. In the following article, you...
Security support for PHP 5.6 ceases at the end of the year. Although developers had already postponed the end date by a year, many website operators still seem to be unprepared. A large number of websites still run on PHP 5.6. From January onwards, these websites will be at risk. However, many are dreading the update. How can you protect your website?
There are plenty of models for processing and storing large quantities of data. However, conventional databases with their rigid tabular structures quickly reach their limits when modeling complex relationships. So-called ‘graph databases’ have proven themselves to be particularly efficient for dealing with intensely interconnected data. But what exactly can they do?
Provide powerful and reliable service to your clients with a web hosting package from IONOS.
