blocks|key|1342114|text|什么是RDBMS？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1342115|RDBMS是关系数据库管理系统的缩写。RDBMS数据在数据库表、字段和记录中结构化。每个RDBMS表由数据库表行组成。每个数据库表行由一个或多个数据库表字段组成。|1342116|RDBMS将数据存储到表的集合中，这些表可能由公共字段(数据库表列)关联。RDBMS还提供了关系操作符来操作存储在数据库表中的数据。大多数关系数据库管理系统使用SQL作为数据库查询语言。|1342117|Edgar+Codd介绍了关系数据库模型。许多现代DBMS不符合Codd对RDBMS的定义，但它们仍然被认为是RDBMS。|1342118|最流行的关系型数据库是MS+SQL+Server、DB2、Oracle和MySQL。Source|offset|length|1342119|entityMap|0|LINK|mutability|MUTABLE|url|http://www.databasedir.com/what-is-rdbms/^0|0|0|0|0|16|6|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$J|Y|K|Z|1|10]]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

What is RDBMS?

RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields. 

RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query language.

Edgar Codd introduced the relational database model. Many modern DBMS do not conform to the Codd’s definition of a RDBMS, but nonetheless they are still considered to be RDBMS.

The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL.
<a href="http://www.databasedir.com/what-is-rdbms/" rel="nofollow noreferrer">Source</a>

blocks|key|1342158|text|对于SQL+Server2008来说，Files+and+Filegroups+Architecture+-+MSDN是基本数据库架构的一个很好的概述。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1342159|如果您需要有关SQL+Server2008如何存储数据的更多详细信息，MSDN站点将是一个有价值的资源。|1342160|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms179316.aspx^0|J|14|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

You can take this just about as deep as you want to go, but for SQL Server 2008 <a href="http://msdn.microsoft.com/en-us/library/ms179316.aspx" rel="nofollow noreferrer">Files and Filegroups Architecture - MSDN</a> is a good overview of basic database architecture.

The MSDN site will be a valuable resource if you need even more detailed specifics on how SQL Server 2008 stores data.

blocks|key|1557718|text|SQL+Server数据存储在默认情况下具有.MDF扩展名的数据文件中。日志(.LDF)文件是SQL+Server用来记录针对SQL+Server实例执行的事务的顺序文件(稍后将详细介绍实例)。使用简单恢复模式时，会自动截断日志文件(.LDF文件)，但使用大容量日志或完整恢复时则不会。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1557719|实例允许在一台计算机上安装多个SQL+Server。如果实例是无名称的，则它是默认实例。命名实例也是可能的。例如：|1557720|MACHINENAME+<--默认实例仅为计算机名称MACHINENAME\Test+<--这是此计算机上的"Test“实例|1557721|您可以使用SQL+Server+Management+Studio+(从SQL+Server2005开始)或Enterprise+Manager+(SQL+Server2000及更早版本)等工具与实例以及实例下的数据库进行交互。|1557722|所有实例(从SQL+Server+2005开始)都将有一个隐藏的资源数据库，以及一个master、model、msdb和temp数据库。这些数据库是“系统”数据库。|1557723|不知道你还在找什么。希望这能有所帮助。|1557724|编辑:哦，是的，从物理上讲，“数据文件”(默认情况下是.MDF文件)中的数据是结构化的，在SQL+Server中称为“页面”。日志文件(.LDF文件)中的数据按顺序存储。在企业中，数据和日志文件有时会被分割到不同的物理硬盘上，以获得更好的磁盘I/O。|1557725|EDIT2:忘记提及文件组。使用文件组，您可以设计逻辑数据库架构，以便该架构的元素在物理上是分开的，通常是为了将物理数据库分布在不同的硬盘驱动器上。例如，您可以有一个数据文件组、一个索引文件组和一个图像文件组(对于二进制图像)。|1557726|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

SQL Server data is stored in data files that, by default, have an .MDF extension. The log (.LDF) files are sequential files used by SQL Server to log transactions executed against the SQL Server instance (more on instances in a moment). The log files (.LDF files) are truncated automatically when using the SIMPLE recovery model, but not when using BULK LOGGED or FULL recovery.

Instances allow for more than one installation of SQL Server on a single machine. If the instance is nameless, it is the default instance. Named instances are possible as well. For eg:

MACHINENAME &lt;-- the default instance is just the machine name
MACHINENAME\Test &lt;-- this is the "Test" instance on this machine

You can use tools like SQL Server Management Studio (as of SQL Server 2005) or Enterprise Manager (SQL Server 2000 and before) to interact with the instance &amp; the databases under the instance.

All instances (as of SQL Server 2005) will have a hidden resource database, as well as a master, model, msdb, and temp database. These databases are "system" databases.

Not sure what else you're looking for. Hope that helps.

EDIT:
Oh yeah, physically, data in the "data files" (.MDF files, by default) is structured in what are known as "pages" in SQL Server. Data in the log files (.LDF files) is stored sequentially. In the enterprise, the data and log files are sometimes split on different physical hard drives for better disk I/O. Or hardware RAID is used for this purpose.

EDIT2:
Forgot to mention file groups. Using file groups, you can design your logical database schema such that elements of that schema are physically separated, typically to disburse the physical database across different hard drives. For example, you could have a data file group, an indexes file group, and an images file group (for binary images).

blocks|key|1557772|text|我推荐“Microsoft+SQL+Server2008Internals”这本书--事实上，Kalen+Delaney写的任何关于内部结构的书都很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1557773|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I recommend the book 'Microsoft SQL Server 2008 Internals' -- in fact anything by Kalen Delaney on internals is good, IMO.

问数据在SQL server中是如何存储的？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据在SQL server中是如何存储的？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问数据在SQL server中是如何存储的？
EN