full-text database
Home > SQL Server Definitions - Full-text database
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 #

full-text database


Show me everything on Microsoft SQL Server 2000

DEFINITION - A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition to text documents, images are often included, such as graphs, maps, photos, and diagrams. A full-text database is searchable by keyword, phrase, or both.

When an item in a full-text database is viewed, it may appear in ASCII format (as a text file with the .txt extension), as a word-processed file (requiring a program such as Microsoft Word), as an HTML (Web page) file, or as a Portable Document Format (PDF) file. When a document appears as a PDF file, it is usually a scanned hardcopy of the original article, chapter, or book.

Full-text databases are used by college and university libraries as a convenience to their students and staff. Full-text databases are ideally suited to online courses of study, where the student remains at home and obtains course materials by downloading them from the Internet. Access to these databases is normally restricted to registered personnel or to people who pay a specified fee per viewed item. Full-text databases are also used by some corporations, law offices, and government agencies. (In the United States, the Internal Revenue Service and most state departments of revenue are good examples.)

>>Stay up to date by receiving the latest IT term daily. Simply check "Word of the Day" to register.

Learn more about Microsoft SQL Server 2000
Tutorial: Learn SQL Server basics from A-Z: If you're new to SQL Server of simply want a refresher on some fundamentals, check out this tutorial on topics from security and performance to SSIS and using native tools.
FAQ: Creating and altering SQL Server tables: Selecting rows, moving records and tracking table activity are a few of the tasks discussed in this SQL Server tables FAQ.
FAQ: SQL Server comparison features: In this FAQ, our SQL Server experts answer your questions about comparison features in both SQL Server 2000 and SQL Server 2005.
Chapter Download: Essential SQL Server 2000 maintenance: This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going ...
Learning Guide: SQL Server basics: This Learning Guide highlights basic SQL Server information that can help Oracle and DB2 pros get up to speed on the system.
Track changes to SQL Server 2000 and 2005 with one simple utility: SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and databases.

LAST UPDATED: 30 Sep 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:
- Syracuse University publishes a set of FAQs (frequently asked questions) about full-text databases.





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
Track changes to SQL Server 2000 and 2005 with one simple utility
SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and...
Is it possible to find disabled indexes in SQL Server 2000?
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.
SQL Server 2000 indexing Q&A to create and tune indexes
Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers...

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




full-text database 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 - 2010, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts