On 5/10/06, Alan Dayley <
alandd@consultpros.com> wrote:
>
> Trent Shipley said:
> > There has been a discussion about drive interface standards on the
> Postgresql
> > general list. I don't understand it.
>
> Your questions are very broad. Maybe some context of the discussion would
> help to narrow the focus a bit. Let me provide some specific bullet
> points.
>
> > What is the difference between IDE, SSCI, ATA, and SATA?
>
> - IDE (Integrated Drive Electronics) is the early marketing term for ATA
> (Advanced Technology Attachment). They are really the same. [1]
>
> - You didn't mention ATAPI (Advanced Technology Attachment Packet
> Interface) with started as an extension to ATA for support of removable
> media drives like CD-ROM and Iomega ZIP drives. Probably because ATAPI
> hard disks don't exist. In any case, ATAPI is part of the ATA protocol
> specification now.
>
> - SATA (Serial ATA) is an update to ATA to transfer the same command set
> over serial channels instead of a parallel bus. [2]
>
> - Because of SATA, the term PATA (Parallel ATA) is now being applied to
> the original ATA devices. ie. IDE == ATA == PATA.
>
> - SCSI (Small Computer System Interface) has been around a long time
> compared to ATA with it's roots going back to 1979. It handles devices of
> many types (scanners, tape drives, media changers, etc.) besides hard disk
> drives.
>
> - You did not mention a new tech called SAS (Serial Attached SCSI) which
> is similar in nature to the ATA-->SATA evolution. That is, transmitting
> the same SCSI commands in serial packets. [4]
>
> > What are the
> > implications for:
> > drives on notebooks and PCs
>
> This maybe best answered by looking at the goals of each protocol. I'll
> reduced them to ATA vs. SCSI since the rest are flavors of one or the
> other.
>
> The original goal of ATA was to provide an inexpensive "consumer grade"
> hard drive interface. SCSI, from the beginning, was intended for reliable
> "systems or industrial grade" data operations, including higher
> performance. As a result of these somewhat opposing goals ATA
> technologies are common in the consumer computer world and ATA devices
> tend to be less expensive per MB. SCSI devices are very common in
> industrial applications, servers and main frames, for example and are more
> expensive per MB. SCSI fans look down on ATA devices as cheap and prone
> to failure sooner rather than later. ATA fans look down on SCSI devices
> as overly expensive and over engineered.
>
> Truth is that, whether by side effect of improving technologies or by
> design, ATA is evolving to be just as good and fast as SCSI. Believe it
> or not but there are still far more SCSI storage systems in use today than
> ATA but ATA use is multiplying very fast and is taking over uses where
> SCSI was traditionally deployed. It used to be that finding ATA drives
> with high duty cycles and MTBF was difficult but that is changing.
>
> The bottom line is that you'd be hard pressed to find a notebook with a
> SCSI hard drive in it. Similarly you'd be hard pressed to find a
> mainframe or heavy industrial computer with an ATA drive. But the two are
> converging both in terms of price and capabilities.
>
> > low TB drive arrays
> > SAN?
>
> Drive arrays and SAN and NAS, etc. are technologies either combining or
> sharing (or both) storage to a host or across a network. This is a layer
> "above" the actual hard disk interface layer represented as SCSI or ATA or
> one of it's flavors. In other words, you could have a SAN server that
> uses ATA drives and another that uses SCSI and both would interact with
> the network layer exactly the same. Clients using the storage would not
> know what hard drive protocol is used.
>
> So, how the hard drive protocol effects the network storage technology
> manifests in only in how reliable, fast, etc. the interface operates. One
> who believes SCSI is best in a SAN service probably believes it is best in
> every other situation for the same reasons. Some dismiss ATA as a viable
> server interface because of it's history as consumer grade. I can accept
> such a thought as a rule of thumb but not as universally true.
>
> A server is general powered and operating for 24/7 so the most important
> specification is the drive's duty cycle. How many hours per 24 is the
> drive designed to be operating? The duty cycle of most ATA drives is 10
> hours or less per 24. (There are more and more that have a 24 hour cycle
> but they'll cost you.) Using such a drive in a server is not "wrong" if
> you have a good data backup process that you actually follow and you are
> willing to save money on each drive but probably buy them more often.
>
> Corrections and discussions are invited.
>
> Alan
>
> [1] http://en.wikipedia.org/wiki/Integrated_Drive_Electronics
> [2] http://en.wikipedia.org/wiki/Serial_ATA
> [3] http://en.wikipedia.org/wiki/SCSI
> [4] http://en.wikipedia.org/wiki/Serial_Attached_SCSI
>
> PS Wikipedia is wonderful!
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
If the
Main PLUG discussion list <
plug-discuss@lists.plug.phoenix.az.us>
has an FAQ archive, or any kind of
"BEST of" the all-stars (all-time helpful posts) log,
then I would nominate this [answer from Alan Dayley],
for such an honor.
--
Mike Schwartz
Glendale AZ
schwartz@acm.org
Mike.L.Schwartz@gmail.com
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)