数据库和实例之间的区别 [英] Difference between database and Instances

问题描述

安装新的SqlServer时，它要求我创建一个实例。我有一个关于实例的基本知识，但我无法弄清楚数据库和实例之间的区别。



在网上搜索时，它描述了什么是

实例 - 保存数据库的软件（内存）。

数据库 - 有数据和元数据



并且更多的实例可以映射到单个数据库，但是单个实例只能有一个数据库。



任何人都可以说，实例和数据库的深度有何不同？两者的主要用途是什么？



谢谢4你的回复

Hi,
While installing the new SqlServer, it ask me to create an Instance. I have basic knowledge about an instance but I couldn''t figure out what is the difference between a database and instance.

While searching in the net, what it describes is
Instance- Software (memory) that holds the database.
Database- Has data and metadata

and more over many instance can be mapped to single database but single instance can have only one database.

Can anybody tell, how instance and database differ in depth? What are the major use of both.

Thanks 4 your Reply

推荐答案

数据库：物理集合操作系统文件或磁盘。使用Oracle 10g自动存储管理（ASM）或RAW

分区时，数据库可能不会在操作系统中显示为单独的单独文件，但定义保持不变。



实例：一组Oracle后台进程/线程和共享内存区域，它是在单台计算机上运行的那些线程/进程之间共享的内存。这是维护易失性，非持久性内容（其中一些被刷新到磁盘）的地方。数据库实例可以在没有任何磁盘存储的情况下存在。它可能不是世界上最有用的东西，但以这种方式思考肯定会有助于在实例和数据库之间划清界线。



检查这个< a href =http://asktom.oracle.com/pls/asktom/f?p=100:11:0:::::P11_QUESTION_ID:1631683800346891854> LINK 了解更多信息。

Database: A collection of physical operating system files or disk. When using Oracle 10g Automatic Storage Management (ASM) or RAW
partitions,the database may not appear as individual separate files in the operating system, but the definition remains the same.

Instance: A set of Oracle background processes/threads and a shared memory area, which is memory that is shared across those threads/processes running on a single computer. This the place to maintain volatile, nonpersistent stuff (some of which gets flushed to disk).A database instance can exist without any disk storage whatsoever. It might not be the most useful thing in the world, but thinking about it that way will definitely help draw the line between the instance and the database.

Check this LINK for more information.

这篇关于数据库和实例之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！