Both SATA and PATA are IDE drives. PATA (parallel ATA) are the older type of drive that normally use the wide flat ribbon cables and the common 4-pin Molex power connection. SATA (serial ATA) drives use the narrow data cables and may use a new power connetor, though many still have the 4-pin Molex connector as well. Parallel data connections have to have at least 8 wires plus a couple for control signals while Serial data connections can be handled by only one wire or one out and one in for bidirectional commo.
The F-L (four letter) acronyms are more descriptive to avoid the confusion and/or extra effort of using just IDE or having to type "SATA IDE drives" or "PATA IDE drives". The eSATA spec includes different connectors, better shielding at the connector and higher current, line drivers for allowing longer cables. There are also "external SATA" connectors that are frequently mistakenly called eSATA, but they are generally just SATA extensions with few or none of the improvements of true eSATA so you have to watch your cable lengths and number of connections there.
Most SATA controllers support hot-swapping, but it's definite with eSATA. Ultra ATA designates 66 to 133 MHz PATA operation which requires the 80-wire/40-pin cables. With older spec PATA drives (33 MHz and down) you can use the old 40-wire/40-pin cables. SATA speeds are 150 or 300 MB/sec with data frequencies of approx. 1500 MHz or 3000MHz which is why you sometimes see them designated as SATA 1500 or 3000 (1.5k or 3k). Those GigaHertz frequencies are why shielding and connections are much more important for SATA and partly why SATA data cables are so stiff.
.bh.