In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges. Here are some common types of libraries.
1) A program library is a collection of (usually) precompiled, reusable programming routines that a programmer can "call" when writing code so that the programmer doesn't have to write it. A dynamic link library (DLL) is one type of program library. Another type of program library is a class library, whose stored routines are class definitions in object-oriented programming (OOP). Graphical user interface (GUI) components such as scroll bars, buttons, and windowing routines are generally stored in a class library.
2) A storage library is a collection of physical storage media such as tapes or disks and a way to access them. A tape library, for example, contains tape cartridges and a mechanism that moves them into and out of the drive(s) where their content is read or updated.
3) A data library is the area of a data center (a centralized area housing computer systems and equipment) where storage media are archived. Online service providers also sometimes refer to a directory on a server containing files for downloading as a data library.
4) A virtual library is simply the online version of the traditional library. Books and documents are made available over the Web, and may be read on line or downloaded.
This was last updated in September 2005
Email Alerts
Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute a transaction log backup and even provide a detailed breakdown at the file level so a DBA can then shrink files with the most empty space.
-
The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Instead of processing the data, it's sent to a queue where it can be automatically read at a later date and processed within the message. Follow these steps for setting up Service Broker and experience a rock solid communications' platform for transmitting data from one SQL Server system to another.
-
When determining SQL Server disk space used by an object, Microsoft's sp_spaceused has limits. Here's an original stored procedure, sp_SOS, that calculates specific object space in SQL Server. Use it to get an overview of user table sizes in a database, the summary of the total space owned by a group of tables and to see the top 10 biggest indexed objects.
-
People who read this also read...
-
Resources from around the Web