DataSet can be considered as a logical database as it has the capability to store more than one table and have relations maintained between the tables as in a relational database. Where as a RecordSet can hold only one table at a time.
dataset is based on disconnected architecture where as recordset is based on connected architecture.dataset is type safe where as record is not.dataset can contain different tables fron different database whereas recordset cannot.