The database has several

Source: Internet
Author: User
Tags ibm db2 informix microsoft sql server postgresql sybase web database

One, SQL Server

SQL Server is a relational database management system launched by Microsoft Corporation.

With the advantages of easy to use scalability and high integration of related software,

It can be used across multiple platforms, from laptops running Microsoft Windows 98 to large multiprocessor-based servers running Microsoft Windows 2012.

Microsoft SQL Server is a comprehensive database platform that provides enterprise-class data management with integrated Business Intelligence (BI) tools.

The Microsoft SQL Server Database engine provides more secure and reliable storage capabilities for relational and structured data, enabling you to build and manage high-availability and high-performance data applications for your business.

Second, Access

Microsoft Office Access is a relational database management system that is released by Microsoft.

It combines two features of the Microsoftjet Database Engine and the graphical user interface and is one of the system programs for Microsoft Office.
Microsoft Office Access is a database management system that combines the graphical user interface of the database engine with the software development tools.

It is a member of Microsoft Office and is sold separately in both professional and later versions of Office.

December 4, 2012, the latest Microsoft Office Access 2013 was released in Microsoft Office 2013, and Microsoft Office Access 2010 was the previous version.
MS Access stores data in its own format in the Access jet-based database engine.

It can also import or link data directly (this data is stored in other applications and databases).
Software developers and data architects can use Microsoft Access to develop application software that "advanced users" can use to build software applications.

Like other Office applications, access supports the Visual Basic macro language, which is an object-oriented programming language that can reference a variety of objects, including DAO (data Access Objects),

ActiveX Data Objects, as well as many other ActiveX components. Visual objects are used to display tables and reports, and their methods and properties are in the VBA programming environment,

The VBA code module can declare and invoke Windows operating system functions.

Third, Oracle

Oracle Database, also known as Oracle RDBMS, or Oracle. Is

Oracle has a relational database management system. It is a leading product in the field of database.

It can be said that Oracle database system is currently the world's popular relational database management system,

The system portability is good, the use is convenient, the function is strong, applies to each kind of big, medium, small, microcomputer environment.

It is a highly efficient and reliable database solution that adapts to high throughput.

Iv. Sybase

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.

Ideal 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 typically used with Sybasesqlanywhere for client/server environments, which serve as server databases, which are client databases,

Using the PowerBuilder developed by the company as a development tool, it is widely used in large and medium-sized systems in China.
Adaptive Server Enterprise (ASE) is the flagship RDBMS product for Sybase,

has been committed to providing the enterprise with a high-performance data and transaction processing system with the lowest total system cost of ownership (TCO).

The latest version of ase12.5.1/12.5.2, while continuing to maintain the critical business performance and efficient computing of previous versions,

Enhancements and improvements in ease of use, system performance, and support for new applications, further improving system security and Linux scalability.

Sybase Adaptive Server Enterprise 12.5.1 improves and expands the ASE product family

Five, MYSQL

MySQL is a relational database management system developed by the Swedish MySQL AB company, currently owned by the Oracle company.

MySQL's most popular relational database management system,

In WEB applications MySQL is one of the best RDBMS (relational database Management system, relational databases management systems) application software.
MySQL is an associated database management system, and the associated database stores the data in different tables.

Instead of putting all the data in a large warehouse, this increases speed and increases flexibility.
The SQL language used by MySQL is the most commonly used standardized language for accessing databases.

MySQL Software uses a dual licensing policy, which is divided into community and commercial editions, due to its small size, speed, low total cost of ownership,

In particular, the characteristics of open source, the general development of small and medium-sized web sites have chosen MySQL as a Web database.

Thanks to the performance of its community edition, PHP and Apache make a good development environment.

Vi. Informix

Informix is a relational database management system (RDBMS) family produced by IBM.

As an integrated solution, it is positioned as the IBM Online transaction processing (OLTP) flagship data service system.

IBM has long-term plans for both Informix and DB2, with two database products absorbing each other's technological advantages.

Earlier in 2005, IBM launched the 10th edition of Informix Dynamic Server (IDS).

VII. FoxPro

Visual FoxPro Formerly known as Foxbase, was originally a database product launched by the American Fox software company in 1988,

Runs on DOS and is compatible with the Xbase series. FoxPro is an enhanced version of Foxbase, with the highest version having been 2.6.

Then, in 1992, Fox software was acquired by Microsoft and developed to enable it to run on windows,

and renamed to Visual FoxPro. FoxPro has a great improvement in function and performance than Foxbase,

Mainly introduced the window, button, list box and text box and other controls, and further improve the system's development capabilities.

Eight, PostgreSQL

PostgreSQL, developed by the computer department at the University of California, Berkeley, has now been renamed PostgreSQL, POSTGRES,

Version 4.2 is the underlying object-relational database management system (ORDBMS).

PostgreSQL supports most SQL standards and offers many other modern features: complex queries, foreign keys, triggers, views, transactional integrity, MVCC.

Similarly, PostgreSQL can be extended in many ways, such as by adding new data types, functions, operators, aggregation functions, and indexes.

Free use, modification, and distribution of PostgreSQL, whether for private, commercial or academic use.

Ix. IBM's DB2

IBM DB2 is a relational database management system developed by IBM in the United States, and its main operating environment is UNIX (including IBM's own Aix), Linux, IBM i (formerly known as os/400), z/OS, and the Windows Server version. DB2 is mainly used in large-scale applications, with good scalability and support from mainframe to single-user environments, to all common server operating system platforms. DB2 provides high-level data utilization, integrity, security, recoverability, and execution capabilities for small to large-scale applications, with basic platform-agnostic functionality and SQL commands. The DB2 employs data classification technology to enable mainframe data to be easily downloaded to a LAN database server, enabling client/server users and LAN-based applications to access mainframe data and make database localization and remote connectivity transparent. DB2 is known for having a very complete query optimizer, whose external connections improve query performance and support multitasking parallel queries. DB2 has a good network support capability, each subsystem can connect a hundred thousand of distributed users, can activate thousands of active threads at the same time, especially for large distributed application system. In addition to providing mainstream os/390 and VM operating systems, as well as medium-sized as/400 systems, IBM offers cross-platform (including Unix-based Linux,hp-ux,sunsolaris, and Scounixware DB2) There are also DB2 products for the OS/2 operating system for PCs, as well as Microsoft's Windows 2000 and its early systems. The DB2 database can be accessed by any application by using the Microsoft Open Database Connectivity (ODBC) interface, the Java database Connection (JDBC) interface, or the CORBA interface proxy.

The database has several

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.