SQL Features and Benefits

SQL Features and BenefitsSQL is both an easy-to-understand language and a comprehensive tool for managing data. Here are some of the major features of SQL and the market forces that have made its successful:

• Vendor independence
• Portability across computer systems
• SQL standards
• IBM endorsement (DB2)
• Microsoft commitment (ODBC and ADO)
• Relational foundation
• High-level, English-like structure
• Interactive, ad hoc queries
• Programmatic database access
• Multiple views of data
• Complete database language
• Dynamic data definition
• Client/server architecture
• Extensibility and object technology
• Internet database access
• Java integration (JDBC)

These are the reasons why SQL has emerged as the standard tool for managing data on personal computers, minicomputers, and mainframes.