Skip to content

database-design.md

Latest commit

 

History

History
438 lines (438 loc) · 26.3 KB

database-design.md

File metadata and controls

438 lines (438 loc) · 26.3 KB
layout HubPage
hide_bc true
experimental true
experiment_id 81ba5f65-59fb-4d
title SQL Server Database Design
description Discover the features of SQL Server that help you design the database that best suits your business needs.
ms.topic hub-page
ms.prod sql
author MashaMSFT
ms.author mathoma
ms.date 12/15/2018
featureFlags
clicktale

SQL Server: Database Design

      • Collation

        Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type.

      • Databases

        A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes.

      • Filestream

        Filestream enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system.

      • Filetable

        FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services - including full-text search and semantic search - over unstructured data and metadata.

      • Graph

        A graph database is a collection of nodes (or vertices) and edges (or relationships). A node represents an entity (for example, a person or an organization) and an edge represents a relationship between the two nodes that it connects (for example, likes or friends).

      • Hierarchical data

        Hierarchical data is defined as a set of data items that are related to each other by hierarchical relationships. Hierarchical relationships exist where one item of data is the parent of another item.

      • Indexes

        An overview of the different type of indexes that SQL uses to organize data.

      • Sequence numbers

        A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created.

      • Spatial data

        Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes.

      • Stored procedures

        A stored procedure in SQL Server is a group of one or more Transact-SQL statements or a reference to a Microsoft .NET Framework common runtime language (CLR) method. Procedures resemble constructs in other programming languages.

      • Tables

        Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

      • Track changes

        An overview of two features that allow for the tracking of data: change data capture and change tracking.

      • Triggers

        Triggers allow for an automated response to a specific action, such as a logon, or an alter database command.

      • Views

        A view is a virtual table whose contents are defined by a query.

      • XML data

        An overview of what can be done with the XML data type, XML indexes, XML schema collections and more.

      • Query Data

        Cursors, Synonyms, Scripting, Joins, User-defined Functions, Full-text Search