How do database systems support advanced query processing techniques, such as parallel query execution, vectorized query processing, and in-memory query processing, to exploit parallelism, hardware accelerators, and optimized data access patterns for faster query execution?