Library Technology Guides

Document Repository

Polaris ILS scales up with SQL database technology

Press Release: Polaris Library Systems [March 03, 2006]

Copyright (c) 2006 Polaris Library Systems

Abstract: ILS development is alive and well at Polaris Library Systems, where the Research and Development team continues to exploit to the fullest the functionality of a true end-to-end Windows system.

Syracuse, NY - March 3, 2006 ILS development is alive and well at Polaris Library Systems, where the Research and Development team continues to exploit to the fullest the functionality of a true end-to-end Windows system. The benefits of this are becoming increasingly evident to a growing number of large libraries and consortia that have selected the Polaris Integrated Library System. Polaris ILS customers running over 500 workstations (staff and PAC) include:

  • The consortium of Mohawk Valley Library System and Southern Adirondack Library System (NY) 54 libraries
  • Washington County Cooperative Library System (OR) Over 7 million annual circulation transactions
  • Maricopa County Library District (AZ) growing at over one million circulation transactions per year
  • Louisville Free Public Library (KY) largest urban public library running Polaris, with more than four million annual circulation transactions

Polaris ILS has always been well-suited to the multi-branch and consortial environments, according to Jim Mieczkowski, Polaris chief information officer. "The inherent structure of Polaris ILS and use of a SQL database give large libraries and consortia the flexibility they need to meet the needs of their individual libraries and manage data in a way that makes sense to them. With SQL Server 2005 we'll be able to deliver even more powerful capabilities. Larger public libraries and multi-type consortia with aging Unix or HP/Tandem-Non-Stop systems will benefit from a high capacity Windows-based option."

Mieczkowski said Polaris will be testing SQL Server 2005 in the next several months. The Polaris ILS is built solely on the Windows platform, so the transition from SQL Server 2000 to SQL Server 2005 is expected to continue going smoothly, he said. SQL Server provides a comprehensive data storage, management, analysis, and reporting platform for organizations of all types and sizes.

Mieczkowski said there are numerous features in SQL Server 2005 that will be of particular interest to large libraries and consortia, including:

  • No database limit size
  • Elimination of the 2GB memory limit for SQL Server 2005 Standard edition. Memory will be limited only by the specifications of the operating system (e.g., 32 GB for 32-bit Windows 2003 Server and 1TB for 64-bit Windows 2003 Server).
  • Database mirroring (with minimal or no impact on performance)
  • Failover clustering
  • Online system changes (including Hot Add Memory, dedicated administrative connection and other online operations)
  • Auto-tuning for performance
  • Native XML
  • Report Server, Builder and Reporting Data Services (OLAP and Relational). These capabilities eliminate the need for a separate product to perform data mining or dedicated report generation.

Some libraries may opt for the SQL Server 2005 Enterprise Edition, which has a few additional features such as data driven reports, online restore and fast recovery (the database is still available when undo operations begin). Examples of data driven reports include requests such as "send a report when funds gets below $10,000"or "issue a report when we surpass 10 million annual circulation transactions."

"Corporate America has been running large Windows/SQL deployments for years," said Mieczkowski. "Organizations like NASDAQ, Bank of America and Xerox run millions of transactions every day, far surpassing library transaction loads. Polaris ILS with SQL Server 2005 offers a solid, proven alternative for libraries and library consortia that have older generation software and are paying high fees to maintain and manage more complex Unix/Linux or HP/Non-Stop environments."

For detailed information on What's New in SQL Server 2005, please visit: For detailed information on the new versions of SQL Server 2005, please visit:

About Polaris Library Systems

From its beginnings thirty years ago, Polaris Library Systems has served libraries with time-saving, forward-thinking technology, from its first circulation system in the mid-1970s through its third-generation Polaris Integrated Library System. Polaris ILS runs exclusively on Windows 2000/2003 and on SQL 2000/2005 technologies. More than 800 libraries use Polaris ILS to facilitate all aspects of their library operations. Every library benefits from SiteScan, a unique proprietary support system that automatically checks all sites daily to identify potential problems before a site is aware there is an issue. Within six months of the release of Polaris 3.2, two-thirds of all customers had upgraded to the new release; no customer is more than one release behind, a testament to the ease of upgrading as well as to the superior value of new releases.

In addition to its library automation systems, Polaris Library Systems offers workflow analysis, database enhancement, wireless access and network services to libraries of all types. For more information about Polaris Library Systems, visit

View Citation
Publication Year:2006
Type of Material:Press Release
Language English
Issue:March 03, 2006
Publisher:Polaris Library Systems
Place of Publication:Syracuse, NY
Company: Polaris Library Systems
Products: Polaris
Subject: Product announcements
Record Number:11837
Last Update:2012-12-29 14:06:47
Date Created:0000-00-00 00:00:00