Difference between Connection Oriented architecture and Disconnected architecture?

Connection Oriented Disconnected
The application will establish a connection with database server and it will be kept open until unless the task has been completed.  The required data will be fetched into the dataset and then the connection will be closed.
For each and every opertaion we need to communicate with database server, so that traffic to the database server will be increased. The required data manipulations will be done on the tables into the dataset and the changes will be updated back to the database at once, so that traffic to the database sever can be reduced.
Parallel transactions will be easy. Parallel transactions will be difficult.
Fetching the data will be fast. Fetching the data will be slow.
No memory management is required. Memory management is required for dataset.