QUESTION $5$

$(20$ Marks$)$

The case study focuses on important features of real$-$time database management systems such as

performance, indexing and scalability. Patten Matching is yet another important feature of a database

management system which refers to a process of algorithmically searching for patterns in sequences of

unprocessed data or tokens.

Depict how pattern matching can be realised in Structured Query Language.

Provide a detailed examination of the different types of DBMS languages.