 Flat data can be combined with transactional data through the use of nested columns, enabling mining of data involving one-to-many relationships (e.g.a star schema).The full functionality of SQL can be used when preparing data for data mining, including dates and spatial data.