SQL RDBMS
来源:互联网 发布:mac可以玩极品飞车吗 编辑:程序博客网 时间:2024/05/17 08:00
Background
Relational Database Management Systems (RDBMS)
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most relational database management systems use SQL to access the database.
There are more similarities than differences between the different RDBMS, but the SQL syntax may be slightly different depending on which RDBMS you are using.
Here is a brief description of popular types of RDBMS
SQLite
SQLite is a popular open source SQL database. It is able to store an entire database in a single file. One of the biggest advantages this provides is that all of the data can be stored locally without having to connect your database to a server.
SQLite is a popular choice for databases in cellphones, PDAs, MP3 players, set-top boxes, and other electronic gadgets. The SQL course on Codecademy also uses SQLite.
MySQL
MySQL is the most popular open source SQL database. It is typically used for web application development, and often accessed using PHP.
The main advantages of MySQL are that it is easy to use, inexpensive, reliable (has been around since 1995) and has a large community of developers who can help answer questions.
Some of the disadvantages are that it has been known to suffer from poor performance when scaling, open source development has lagged since Oracle has taken control of MySQL, and it does not include some advanced features that developers may be used to.
PostgreSQL
PostgreSQL is an open source SQL database that is not controlled by any corporation. It is typically used for web application development.
PostgreSQL shares many of the same advantages of MySQL. It is easy to use, inexpensive, reliable, and has a large community of developers. It also provides some additional features such as foreign key support without requiring complex configuration.
The main disadvantage of PostgreSQL is that it is slower in performance than other databases such as MySQL. It is also less popular than MySQL which makes it harder to come by hosts or service providers that offer managed PostgreSQL instances.
Oracle DB
Oracle DB is owned by the Oracle corporation and the code is not open sourced.
Oracle is used for large applications, particularly in the banking industry. Most of the world’s top banks run Oracle applications because Oracle offers a powerful combination of technology and comprehensive, pre-integrated business applications, including key functionality built specifically for banks.
The main disadvantage of using Oracle is that it is not free to use like its open source competitors and can be quite expensive.
SQL Server
SQL Server is owned by Microsoft. Like Oracle DB, the code is also close sourced.
SQL Server is mainly used by large enterprise applications. The major difference between Oracle and SQL Server is that SQL Server only supports the Windows Operating System.
Microsoft offers a free entry level version called Express, but can become very expensive as you scale your application.
- SQL RDBMS
- SQL 服务器 - RDBMS
- SQL - RDBMS概念
- SQL RDBMS概念
- SQL 服务器 - RDBMS
- SQL 服务器 – RDBMS
- 初识RDBMS与SQL
- No SQL ans rdbms learning
- SQL 服务器 - RDBMS 高级教程
- RDBMS and SQL Basic Concepts
- RDBMS
- RDBMS
- 第一章:RDBMS:SQL Server 数据库的构成(学习笔记)
- SQL Server 2008编程入门经典笔记(第一章:RDBMS基础:SQL Server数据库的构成)
- Minosse RDBMS
- RDBMS基础
- RDBMS 总结
- RDBMS CLONE
- 解决数据小位数问题
- QNX系统中播放wav文件
- ABAP日期函数应用
- <a>标签在微信iOS版本的解析没有问题,但是在安卓版就解析不出来
- ThreadLocal实现方式&使用介绍---无锁化线程封闭
- SQL RDBMS
- 网络编程 笔记(十)多播与广播
- rank
- C++给函数传数组参数
- 151025 总结
- Android Design Library 浅应用
- spring 2.0 到3.0的新特性及理解
- iOS单列的实现
- Mali GPU OpenGL ES 应用性能优化--基本方法