Running head: DATA WAREHOUSING SQL SERVER 1 Data Warehousing and SQL Server Wilmington University Table of Contents 1. Abstract 4 2. Introduction 5 3. Data Warehouse Information 5 4. Developments of Structured Query Language (SQL) 5 4.1. SQL Server 6 5. Purpose of Data Warehouse 6 5.1. Design Approaches of Data Warehouse 6 5.2. Bottom-Up Approach 7 5.3. Top-Down Approach 7 6. Advantages and Disadvantages 7
DATA WAREHOUSING AND SQL SERVER 2 7. Specific Structures of Data Warehouse 8 8. Benefits and Difficulties of Data Warehouse 8 9. Idea of SQL 9 9.1. Antiquity of SQL 9 9.2. Important SQL Statements 10 10. Conclusion 11 11. References 12
DATA WAREHOUSING AND SQL SERVER 3 Table of Content for Figures 1. Factors involved in SQL Server 5 2. Specific Structures of Data Warehouse 8 3. SQL Statements Types 10
DATA WAREHOUSING AND SQL SERVER 4 Abstract This research paper discusses the importance of Data Warehousing, SQL Server, SQL, Data Warehouse approaches [Mod]. The problem of the company depending on the Information Technology dependent for the better processing of the company, had remain controversial in the past decade. The IT people being technicians, and not having proper subject knowledge of the departments were the main issue to overcome. By effective data warehousing and data mining when required can bridge the gaps between the technicians and department requirements [Vow13]. Further a well-structured data warehouse can help the company to take a right decision when required with all the available data. The importance of SQL is grown drastically. The performance of this language had brought a revolution in the way clinical trials are performed in the pharmaceutical and health industries. Data warehouse is been like a whole system and SQL acting as commend to run this system of clinical, hospital and pharmaceutical industries is being discussed further in this paper. The consistence and accuracy is most required thing in the organizations, which is abundantly provided by using data warehouse. These commends of SQL have proven to be well advanced than another language commends which are in practice. These feature made the SQL a well-accepted language in the industry.
DATA WAREHOUSING AND SQL SERVER 5 Introduction SQL Server and Data Warehousing Data Warehouse Information A data warehouse is an arsenal which stores unified information for efficient querying and analysis. Data Warehousing shields all phases of the data warehouse lifecycle, facilitating to explain the roles that both technicians and business managers play at each stage. Developments of Structured Query Language (SQL) This is a language intended precisely for interacting with databases. This is very unique with other computer languages because it is easy of understanding and compatible with any database and systems. Most importantly this is designed with fewer words than any other languages. SQL was designed to perform the task with accuracy and precision, therefore the
You've reached the end of your free preview.
Want to read all 12 pages?
- Spring '16