database 数据库和数据源的区别

Difference between Database and Data Source

提问by ANP

What is the difference between Database and Data Source?

数据库和数据源有什么区别？

回答by BoltClock

A data source is simply something your program relies on to get data. A database is a kind of data source that persists data to some digitized form. Other data sources include files, services, etc — these all provide data to your programs.

数据源只是您的程序获取数据所依赖的东西。数据库是一种将数据保存为某种数字化形式的数据源。其他数据源包括文件、服务等——这些都为您的程序提供数据。

回答by Marko

Further to BoltClock's answer, here are example of Databases (or Database Servers) vs various Data Sources.

除了 BoltClock 的回答，这里是数据库（或数据库服务器）与各种数据源的示例。

Databases

数据库

1. SQL
2. Oracle
3. MySQL

1. SQL
2. 甲骨文
3. MySQL

Data Sources

数据源

1. All of the databasesabove
2. XML Files
3. CSV Files
4. Web Services
5. and many many more..

1. 所有的数据库以上
2. XML 文件
3. CSV 文件
4. 网页服务
5. 还有很多..

回答by fastcodejava

Data Source may not be connected to DB, it can be just file system or any source of data.

数据源可能没有连接到数据库，它可以只是文件系统或任何数据源。

回答by Naina Mantry

To quote the description from Techopedia:

引用Techopedia的描述：

A data source, in the context of computer science and computer applications, is the location where data that is being used come from. In a database management system, the primary data source is the database, which can be located in a disk or a remote server. The data source for a computer program can be a file, a data sheet, a spreadsheet, an XML file or even hard-coded data within the program.

在计算机科学和计算机应用程序的上下文中，数据源是正在使用的数据的来源位置。在数据库管理系统中，主要数据源是数据库，它可以位于磁盘或远程服务器中。计算机程序的数据源可以是文件、数据表、电子表格、XML 文件，甚至是程序内的硬编码数据。

回答by sidhu marajke

Data --- image, video, file , pdf,msg, name, age, height, weight, etc

数据---图像、视频、文件、pdf、msg、姓名、年龄、身高、体重等

Database is a collection of data (contact number, best friend names, shopping list is a collection of data) stored in a formet Systematically that can be easily accessed.

数据库是数据的集合（联系电话，最好的朋友姓名，购物清单是数据的集合）系统地存储在一个可以轻松访问的格式中。

Example of database: attendance register

数据库示例：考勤登记表

1. Attendance register of employees in office
2. Attendance register of students in school

1. 办公室员工出勤登记表
2. 学生在校出勤登记表

Attandance register is a database

出勤登记是一个数据库

• Database store in computer , mobile , tables, excel, folders etc

• 计算机、手机、表格、excel、文件夹等中的数据库存储

Types of database: Network Database, Object-Oriented Database, Relational Database, Hierarchical Database like attendance register, attendance page, attendance darry.

数据库类型：网络数据库、面向对象数据库、关系数据库、分层数据库，如考勤登记表、考勤页、考勤darry。

Database Management System (DBMS)------- A database management system (DBMS) is a software package create, manipulate, retrieve and manage data in a database .A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data. example of DBMS---> HR, Teacher.

数据库管理系统 (DBMS)------- 数据库管理系统 (DBMS) 是一个软件包，用于创建、操作、检索和管理数据库中的数据。 DBMS 通常操作数据本身、数据格式、字段名称、记录结构和文件结构。它还定义了验证和操作这些数据的规则。DBMS的例子---> HR，老师。

1. Hr, Teacher maintain register same as Dbms maintain database ...

                           ________database create ________
                          |                               |
                    MANUALLY                         Electrically 
                  (Hands)                       ( computer,mobilephones etc)
                   using pen, paper               using  DBMS software, File system etc
   

1. hr，老师维护注册与DBMS维护数据库相同......

                           ________database create ________
                          |                               |
                    MANUALLY                         Electrically 
                  (Hands)                       ( computer,mobilephones etc)
                   using pen, paper               using  DBMS software, File system etc
   

A DATABASE store the data and provide a method to access it, a DBMS actually converts the queries into a meaningful command, to invoke the method used to access the database.

DATABASE 存储数据并提供访问它的方法，DBMS 实际上将查询转换为有意义的命令，以调用用于访问数据库的方法。

Some other DBMS (teacher, HR) examples include:

其他一些 DBMS（教师、HR）示例包括：

• MySQL ( example ->eng teacher)
• SQL Server ( hindi teacher)
• Oracle ( evs teacher)
• dBASE ( senior teacher)
• FoxPro ( math teacher)

• MySQL ( 例子 -> eng 老师)
• SQL Server（印地语教师）
• 甲骨文（evs老师）
• dBASE（高级教师）
• FoxPro（数学老师）

All teacher maintain attendance register same as all this DBMS maintain database..

所有教师维护的出勤登记表与所有这些 DBMS 维护的数据库相同。

Principal or head decide which teacher is create and maintain register same as developer decide which DBMS( my sql, oracle) is create and maintain database and which is best.

校长或负责人决定哪个老师创建和维护寄存器与开发人员决定哪个 DBMS（我的 sql，oracle）创建和维护数据库以及哪个最好。

Find rohan total attendance?

求罗汉总出勤率？

Find rohan total attendance --------> HR/Teacher -----------> Attandance register

查找 rohan 总出勤 --------> HR/Teacher -----------> 出勤登记表

Find rohan total attendance------> DBMS(my sql) --------->database

查找rohan总出勤------> DBMS(my sql) --------->数据库

SQL (Structured query language)

SQL（结构化查询语言）

NOSQL

NOSQL

SQL--------- SQL stands for Structured Query Language. SQL is used to communicate with a database it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common DBMS( Oracle, Sybase, Microsoft SQL Server, Access, Ingres, My sql, Oracle,Sqlite) that use Sql . Sql database is tablebase database like Ms excel, vertically data store, relational database. In NOSQL data is store in key value, pair like json...NOSQL used by---Redis , MongoDB. example ofsql , sql is class monitor or head student of class that is help to the DBMS( Teacher, Hr) to manage Database (Register)... one class monitor helps all teacher same as one SQL Used by many dbms (My sql , oracle )

SQL--------- SQL 代表结构化查询语言。SQL 用于与数据库通信，它是关系数据库管理系统的标准语言。SQL 语句用于执行诸如更新数据库数据或从数据库检索数据等任务。一些使用 Sql 的常见 DBMS（Oracle、Sybase、Microsoft SQL Server、Access、Ingres、My sql、Oracle、Sqlite）。Sql 数据库是类似于 Ms excel 的 tablebase 数据库，垂直数据存储，关系数据库。在 NOSQL 中，数据存储在键值中，对像 json...NOSQL 使用的 ---Redis , MongoDB。sql的例子，sql是班长或班长，帮助DBMS（Teacher, Hr）管理数据库（Register）...

         Purpose .. To query and operate database system.



                                              SQL use by                     NOSQL  use by
                                        1.My sql                             1.Redis 
                                        2.Ms-sql                             2.MongoDB etc
                                        3. oracle etc
                                             |                                     |                       
                                             |_______________DBMS__________________|