DATABASE; DATABASE SYSTEMS, SQL; MariaDB

Physical Data Organization in MariaDB / MySQL Please get an overview of the existing MariaDB Storage Engines1. In particular, make you familiar with 1. InnoDB/XtraDB 2. MyISAM 3. MEMORY 4. und Blackhole. Additionally, get an overview of the existing MariaDB Index Strucutres2 and use the passengerdetails table in your database (or a copy) to answer the following questions: a) Why are hash indices only available in the MEMORY Storage Engine? b)How does MariaDB behave with InnoDB when you create a hash index? Try it using a DDL statement. c) How does the B+ tree (as used by MariaDB with InnoDB) differ from the classic B-tree? Think of a query for the passengerdetails table that is faster with a B+ tree than with a classic B tree. Run your query before and after creating a B+ tree index. Measure the time difference. Please note there is only a B+ tree in MariaDB (index type BTREE). d)Are wildcard queries on strings (e.g. street LIKE 'Andechstr%' or street LIKE '%strasse') answered with the help of an index? Create a B-Tree index on the attribute street and test wildcard queries. You can use a EXPLAIN to see if an index is being used. e) (1 point) Create an index that supports you with queries on the attributes country and emailaddress in the table passengerdetails. Create a query that gives you all the email addresses of Finnish passengers starting with Julius. Is your query supported by the index? Is the index used if you search for all email addresses that start with Julius?