Study on Cross Tabulation Query in Data Mining and Statistical Data Analysis
Cross tabulation query can give a more complete picture of past and current trends as well as possible future outcomes of mess data, it usually involves aggregation of data, at the same time, a column of values will perhaps be transformed into many columns in the new view. In cross tabulation query view, almost all kinds of data distribution can be seen just at a glance. But the SQL database engine's (including Microsoft SQL Server, MySQL, and other similar database systems, also including Microsoft Office Access) primary role is the storage and retrieval of data information, not the complex processing of it. The organization form of data in database is not suitable for cross table view.