Trends in Data Management: 'High Availability.'

Bock, Douglas B.; Bordoloi, Bijoy
June 2006
Journal of Digital Information Management;Jun2006, Vol. 4 Issue 2, p150
Academic Journal
In today's highly competitive business environment, for most companies it is imperative that their business data is always accessible from their data servers in a seamlessly fault tolerant manner. DBMSs, which constitute the core of most business information systems, are attempting to implement this requirement through a feature often referred to in the data management literature as 'high availability'. Against the backdrop of a leading DBMS, Microsoft SQL Server 2005, we define the concept of high availability and examine the various approaches to high availability, namely, mirroring, clustering, replication, and log shipping, which should be of interest to database administrators and the students of database management system technology.


Related Articles

  • T-SQL Tiebreakers.  // SQL Server Magazine;Apr2005, Vol. 7 Issue 4, p19 

    The article reports that a tiebreaker is a rule used to determine precedence between candidates when there's a tie. Suppose one need to return the order ID, customer ID and shipper ID of the most recent order for each employee. This request by itself is problematic because an employee row might...

  • SQL Server Downloads. Oley, Michael // SQL Server Magazine;Apr2005, Vol. 7 Issue 4, p48 

    The article reports that when someone is looking for SQL Server-related add-ons and resources, he can find updates, tools and utilities, code samples, product documentation and SQL Server technologies on the SQL Server home page. But most people don't realize that the bulk of Microsoft's SQL...

  • 3 ways to maximize the benefits of SQL Server 2005's new features. Kumar, Vinod // SQL Server Magazine;May2005, Vol. 7 Issue 5, p12 

    Suggests ways to maximize the benefits of SQL Server 2005's features. Ability of SQL Server 2005 to execute user-defined functions, stored procedures, user-defined aggregates (UDA), user-defined types and triggers written in common language runtime (CLR) languages; Use of the CLR to replace...

  • SQL Server 2005 Editions. Otey, Michael // SQL Server Magazine;May2005, Vol. 7 Issue 5, p56 

    Introduces four editions that Microsoft will release for SQL Server 2005. SQL Server Express; Workgroup Edition; Standard Edition; Enterprise Edition.

  • SQL Server 2005 Integration Services extensibility lets you solve uncommon problems. McDowell, Douglas; Hackney, Jay // SQL Server Magazine;May2005, Vol. 7 Issue 5, p39 

    Focuses on the SQL Server 2005 Integration Services (SSIS), an extraction, transformation, loading product that offers performance, a catalog of dynamic components and a sound deployment mode, and flexibility and extensibility. Key features; Advantages of using SSIS; Creation, installation and...

  • Toward a Grid-Based DBMS. Thompson, Craig W. // IEEE Internet Computing;May/Jun2006, Vol. 10 Issue 3, p87 

    The article discusses the development of specialized grids for relational database management system (DBMS). Textbooks describe a traditional relational DBMS architecture using a Structured Query Language that is translated to a query tree consisting of relational algebra operators. On the...

  • Simplify your life with SQL Server 2005's fast, easy, powerful coding model. Cook, John Paul // SQL Server Magazine;May2005, Vol. 7 Issue 5, p19 

    Discusses the coding model of the SQL Server 2005. Introduction to SQL Management Objects (SMO), the programming access layer in SQL Server 2005; Use of Visual Studio 2005 and SMO to develop managed code for three basic but important SQL Server 2005 administrative tasks; Building of a simple...

  • Seeing the CLR's Potential. Nunn, Matt // SQL Server Magazine;May2005, Vol. 7 Issue 5, p27 

    Focuses on SQL Server Common Language Runtime (CLR). Use of SQL Server CLR in database management; Benefits offered by SQL Server CLR; Use of SQL Server CLR as a tool to move complex procedural logic that works primarily against values stored in the database from the middle or client tiers to...

  • New Features in SQL Server 2008. Otey, Michael // SQL Server Magazine;Sep2007, Vol. 9 Issue 9, p48 

    A list of the new features in the SQL Server 2008, a database server, is presented. It includes the ability to hot-add central processing units (CPUs) on supported platforms with no downtime, enhancing scalability, another is the FileStream Data which allows large binary objects to be stored in...

  • SQL Server's Rounding Secrets. Moran, Brian // SQL Server Magazine;May2005, Vol. 7 Issue 5, p7 

    Explains why SQL Server rounds certain decimal values. Calculation of the result precision and scale for various operations; Query that uses precision level 19 and scale level 10, and level 19 and scale level 9; Management of rounding operations in complex calculations using explicit CAST...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics