SQL database (MS SQL, MySQL)
SQL database (MS SQL, MySQL)– SQL is ‘structured query language’ and is an industry-standard database language. A database is usually used to store the people count data in a way that can be queried so that questions such as “how many people entered such-a-zone last week?” or “how does the footfall at one site compare to another?’ Such flexible structure allows users to import, compare, query and report on multiple metrics. There are two main variants of a SQL database: MySQL and Microsoft SQL. There are other variants from Oracle, and other software vendors.