OSI MODEL
The Open Systems Interconnection (OSI) model is a 7-layer conceptual framework developed by the ISO to standardize computer networking communication. While the modern Internet primarily runs on the simpler TCP/IP suite, the OSI model remains an essential reference tool for network architecture and systematic troubleshooting.
The 7 Layers at a Glance
| Layer | Name | Primary Function | Data Unit / Protocols |
|---|---|---|---|
| 7 | Application | Direct interface for network software (browsers, email clients) to initiate communication | HTTP, SMTP, FTP |
| 6 | Presentation | Formats, encrypts, and compresses data to make it usable by applications | SSL/TLS, JPEG, ASCII |
| 5 | Session | Manages dialogue between devices: opens, maintains, and cleanly closes connections using checkpoints | NetBIOS, RPC |
| 4 | Transport | End-to-end delivery, segmentation, reassembly, error checking, and flow control across networks | Segments (TCP, UDP) |
| 3 | Network | Addresses and routes data between different networks | Packets (IP, ICMP) |
| 2 | Data Link | Moves data between devices on the same local network; handles MAC addressing and framing | Frames (Ethernet, Wi-Fi) |
| 1 | Physical | Transmits raw binary bitstreams across physical transmission media | Bits (Cables, radio waves, hubs) |
How Data Moves (Encapsulation & De-encapsulation)
- Sending (Top-down): Data originates at Layer 7 and travels down to Layer 1. At each step, it is processed and packaged into progressively smaller units:
Data --> Segments (L4) --> Packets (L3) --> Frames (L2) --> Bits (L1)
- Receiving (Bottom-up): The recipient device receives the physical bitstream at Layer 1 and decapsulates the data upward through each layer until it is delivered back to the user application at Layer 7 as human-readable information.
SQL
KEY FACTS OF SQL
• Born in 1974: IBM researchers Donald Chamberlin and Raymond Boyce created SQL over half a century ago, making it older than the World Wide Web.
• Originally "SEQUEL": It stood for Structured English Query Language but was changed to SQL to resolve a trademark dispute with an aircraft company.
• Declarative design: Unlike Python or Java, you only tell SQL what data you want, not how to step-by-step retrieve it.
• Replaced a math typo nightmare: It was built to replace a language called SQUARE, which required mathematical notations that were nearly impossible to type on 1970s keyboards.
• The foundation of safe transactions: Its "ACID" compliance guarantees that database actions (like banking transfers) either succeed perfectly or fail completely without errors.
• Oracle beat IBM to market: Though IBM invented the language, Larry Ellison saw its potential in a research paper and released the first commercial SQL database in 1979.
• One standard, many dialects: While standardized by ANSI/ISO, major platforms (MySQL, PostgreSQL, SQL Server) all use their own unique syntax extensions.
Would you like to explore how to write basic queries, see a comparison of the different dialects, or dive deeper into how database optimization works? Let me know what you'd like to learn next!
References
https://www.cloudflare.com/learning/ddos/glossary/open-systems-interconnection-model-osi/
Top comments (0)