GIS
Home > SQL Server Definitions - GIS
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

GIS


Show me everything on SQL Server Business Intelligence (BI) and Data Warehousing

DEFINITION - A GIS (geographic information system) enables you to envision the geographic aspects of a body of data. Basically, it lets you query or analyze a database and receive the results in the form of some kind of map. Since many kinds of data have important geographic aspects, a GIS can have many uses: weather forecasting, sales analysis, population forecasting, and land use planning, to name a few.

In a GIS, geographic information is described explicitly in terms of geographic coordinates (latitude and longitude or some national grid coordinates) or implicitly in terms of a street address, postal code, or forest stand identifier. A geographic information system contains the ability to translate implicit geographic data (such as a street address) into an explicit map location. GIS developers sometimes obtain the map data from public sources or companies that specialize in collecting and organizing geographic information. The process of converting implicit geographic data into explicit or map-form images is called geocoding.

Geographic data can be stored in a vector graphics or a raster graphics format. Using a vector format, two-dimensional data is stored in terms of x and y coordinates. A road or a river can be described as a series of x,y coordinate points. Nonlinear features such as town boundaries can be stored as a closed loop of coordinates. The vector model is good for describing well-delineated features. A raster data format expresses data as a continously-changing set of grid cells. The raster model is better for portraying subtle changes such as soil type patterns over an area. Most geographic information systems make use of both kinds of data.

GISs do these kinds of things:

  • They accept geographic input in the form of scanned-in and digitized map images. Often this data is supplied by a source that may own maps and has already digitized them.
  • They rescale or otherwise manipulate geographic data for different purposes.
  • They include a database manager, usually a relational database management system (RDBMS).
  • They include query and analysis programs so that you can retrieve answers to simple questions such as the distance between two points on a map or more complicated questions that require analysis, such as determining the traffic pattern at a given intersection.
  • They provide answers visually, usually as maps or graphs.

Learn more about SQL Server Business Intelligence (BI) and Data Warehousing
Tutorial: SQL Server Integration Services (SSIS) best practices: Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.
Export SQL Server data to an Excel file using SSIS and Visual Studio: Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel.
Tips for tuning SQL Server 2005 to improve reporting performance: We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in ...
Tutorial: SQL Server 2005 Analysis Services: Want to learn about Analysis Services 2005 in SQL Server? These tips outline helpful features and give examples of this BI tool's functionality.
Managing permissions in SQL Server Reporting Services: Protect data by managing permissions in SQL Server Reporting Services. Assign user roles and tasks in the SSRS security model.
Custom VB.Net scripting in SQL Server Integration Services: Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.
Open SSIS packages without validation using these SQL properties: Learn how to open SSIS packages without validation by using the DelayValidation and ValidateExternalMetadata property options.
Migrating SQL Server 2000 DTS packages to SSIS: SSIS is more than a replacement for DTS packages. Migrate to this new powerful ETL platform with the transitional tools of Upgrade Advisor and Package Migration Wizard.
Five steps to event handlers in SQL Server Integration Services (SSIS): Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.
An overview of SQL Server Report Builder 2.0: In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", find out about the interface details and controls available in Report Builder 2.0.
A short history of SQL Server Integration Services: In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about the history of SQL Server Integration Services.
Microsoft SQL Server Integration Services primer: In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about the new features included with SSIS 2008 and what they mean to you.
SQL Server Reporting Services Fast Guide: Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.
Tutorial: SQL Server Integration Services (SSIS) best practices: Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.

CONTRIBUTORS: Tom Cool and Shiva Prasad Salethur
LAST UPDATED: 01 Apr 2005

Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com

More resources from around the web:
- SearchCIO.com offers a story, "GIS holds promise for an information revolution."





FILE EXTENSION AND FILE FORMAT LIST
File Extension and File Format List:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #


RELATED CONTENT
Using the Pivot transformation in SQL Server Integration Services
Pivoting is a useful way to transform data in SQL Server Integration Services (SSIS) -- but it's hardly intuitive.
DBA career paths could lead to business intelligence
Business intelligence could prove to be an ideal specialty for SQL Server DBAs who feel like they've hit a wall with their current jobs.
Are data warehouses made for the cloud?
Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
comma-separated values file  (SearchSQLServer.com)
data aggregation  (SearchSQLServer.com)




GIS Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts