The sample also includes a number of scripts that can be used to explore some of the features used in the sample database. For details about the ETL workflow, see the WideWorldImportersDW ETL workflow. The package is designed to use bulk T-SQL statements wherever possible to enhance performance. A SQL Server Integration Services (SSIS) package, Daily ETL.ispac, is used to move data from the OLTP database WideWorldImporters to the OLAP database WideWorldImportersDW.For more detail, see WideWorldImportersDW use of SQL Server features and capabilities.Partitioning is used to improve manageability of the fact tables, which can grow very large in a data warehouse.
In-Memory OLTP is used to improve the performance of the ETL process. PolyBase is used to correlate data in the local database with a public data set in Azure Blog storage. Clustered columnstore indexes are used to reduce the storage footprint and improve query performance for the fact tables. Here are some examples of the use of SQL Server capabilities with this database: The data in this database is derived from the transactional database WideWorldImporters, but it uses a schema that is specifically optimized for analytics. WideWorldImportersDW is the main database for data warehousing and analytics (OLAP – OnLine Analytics Processing). For more detail, see WideWorldImporters use of SQL Server features and capabilities. Partitioning is used to improve the manageability of large tables. 
Clustered columnstore indexes are used to reduce the storage footprint of large tables with insert-only workload.In-Memory OLTP is used to optimize the performance of table-valued parameters (TVPs) and to optimize ingestion of sensor data.Advanced security features like Always Encrypted, Row-Level Security and Dynamic Data Masking are used to secure data.JSON is used to enable AJAX calls to some of the key tables, and also to extend the relational schema to record such things as application settings and user preferences.Temporal tables are used to conveniently keep track of the history of reference data, as well as some of the main entities.Query Store is used to keep track of query performance.
#How to attach adventureworks database in sql server 2016 archive
Archive tables can be stretched to Azure for long-term retention, reducing storage cost and improving manageability. Real-time operational analytics of sales data is enabled through the use of nonclustered columnstore indexes. WideWorldImporters is the main database for transaction processing (OLTP – OnLine Transaction Processing) and operational analytics (HTAP – Hybrid Transactional/Analytics Processing). Latest release of the sample: wide-world-importers-releaseĭocumentation for the sample: wide-world-importers-documentation It also showcases the key SQL Server 2016 capabilities and performance enhancements. It does not attempt to use every single SQL Server feature, as that would not be realistic. It illustrates how the rich SQL Server feature set can be used in a realistic database. Wide World Importers is the new sample for SQL Server. AdventureWorks, which has been around since the SQL Server 2005 days, has had a good run, but it is time for an upgrade. This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server.Ī release the magnitude of SQL Server 2016 deserves a new sample.
0 kommentar(er)
