Basic learning of database--first knowledge of MySQL

Source: Internet
Author: User
Tags sybase

MySQL's greatest benefit is to provide a rich interface that creates APIs for use in various languages.


Odbc:

Open Database Interconnect (CONNECTIVITY,ODBC) is an integral part of the database in the Microsoft Open Service Architecture (Wosa,windows Open Services Architecture), which establishes a set of specifications and provides a set of standard APIs (application programming interfaces) for database access. These APIs use SQL to accomplish most of their tasks. ODBC itself also provides support for the SQL language, which allows users to send SQL statements directly to ODBC. Open Database Interconnect (ODBC) is the standard that Microsoft proposes for database access interfaces. Open Database Interconnect defines a specification for accessing database APIs that are independent of different vendors ' DBMS and specific programming languages (but Microsoft's ODBC documentation is described in C, and many of the actual ODBC drivers are written in C language. The ODBC specification was later adopted by X/open and ISO/IEC, as part of the SQL standard, which can be seen in the relevant standard documents such as ISO/IEC 9075-3:1995 (E) call-level Interface (SQL/CLI).JDBC:JDBC (Java Data Base Connectivity,java Databaseconnection) is a Java API for executing SQL statements that provides unified access to a variety of relational databases,Java languagecomposed of classes and interfaces written. JDBC provides a benchmark on which to build more advanced tools and interfaces that enableDatabasedevelopers can write databasesApplication, and JDBC is also a trademark name.
ADO:aProgram Objectthat represents the userDatabaseThe data structure and the data contained in the. In Microsoft Visual BasicEditor, you can use the ADOObjectand the additional ADOComponent(called Microsoft ADO Extensions for DLLs and Security (ADOX)) to create or modify tables and queries, verifyDatabase, or AccessExternal Data sources. You can also use ADO in your code to manipulateDatabasedata in the.
PDO:The PDO extension defines a lightweight, consistent interface for the PHP Access database, which provides a data access abstraction layer so that queries and data can be executed through a consistent function, regardless of the database used. PDO is released with PHP5.1 and can be used in the PHP5.0 pecl extension, and cannot be run in the previous PHP versionSyBase:A relational database system developed by Sybase, a typical UNIX or WindowsNT platform, is a large database system in a client/server environment. Sybase provides a suite of application programming interfaces and libraries that can be integrated with non-Sybase data sources and servers, allowing data to be replicated across multiple databases, and for creating multi-tiered applications. The system has a complete definition of triggers, stored procedures, rules and integrity, and it supports optimized queries and has better data security. Sybase is commonly used with Sybasesqlanywhere for client/server environments, the former as server database, the latter as the client database, the company developed by the PowerBuilder as a development tool, in China's large and medium-sized systems have a wide range of applications. Adaptive Server Enterprise (ASE) is the flagship RDBMS product of Sybase and has been committed to providing a high-performance data and transaction processing system with the lowest total system cost of ownership (TCO) for the enterprise. The latest version of ase12.5.1/12.5.2 continues to maintain the business-critical performance and efficient computing of previous versions, enhancing and improving ease of use, system performance, and supporting new applications, and further improving system security and the scalability of Linux. Sybase Adaptive Server Enterprise 12.5.1 improves and expands the ASE product family

Basic learning of database--first knowledge of MySQL

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.