• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
blaze systems lims logo

Blaze Systems

BlazeLIMS offers a suite of solutions with no up-front cost.

  • Solutions
    • Industries
      • Biotechnology
      • Clinical Labs
      • Discrete Manufacturing
      • Electronics
      • Environmental Laboratories
      • Food and Beverage
      • Pharmaceutical
      • Process Industries
    • Lab Automation Products
      • LIMS – Laboratory Information Management System
      • Integration Middleware – BlazeLink
      • LIMS Inventory Management
      • Stability Shelf Life Management
      • LIMS Dashboards For Analytics
      • LIMS Statistical Control
      • LIMS Solution Suite for Enterprise Integration
    • Laboratory Types Supported
      • Manufacturing Quality Control
      • Research and Development
      • Analytical Services
      • Regulatory and Governmental Labs
      • Specialty Laboratories
  • Services
    • Cost Effective Partnering For Blaze LIMS Implementation
    • Project Implementation
    • Training
    • Configuration Assistance
    • Data Migration
    • Instrument Integration
    • GxP Validation
    • Customization
  • About Us
    • Company
      • Who Are We
      • Why Choose Blaze LIMS and Blaze Systems
      • Company Background
      • Note From The President
    • Implementation
      • Implementation Methodology
      • Object Oriented Implementation
      • RDBMS Implementation
      • Integration Emphasis
    • Technology Base
      • What is a LIMS
      • Thin Client Architecture
      • LIMS SaaS – LIMS in the Cloud
      • Information Modeling
      • Software Architecture Framework
      • Platforms and Tools
  • Resources
    • White Papers
    • Blaze LIMS Training Videos
    • BlazeLIMS Downloads
  • Support Login
Request Demo

Blaze LIMS RDBMS Implementation

Relational database technology remains the mechanism of choice for data storage in information management systems. BlazeLIMS supports Oracle and SQL Server, the two industry standards for RDBMS, giving the customer the choice of the system most suitable to the situation. This choice allows for cost effective installations ranging from 5 or fewer concurrent users up to hundreds of concurrent users:

  • Oracle
    • Superior concurrency management.
    • More suitable for larger systems with more concurrent users.
    • More expensive.
    • More difficult to maintain.
  • SQL Server
    • Less effective concurrency management – susceptible to more deadlocks.
    • More suitable for systems with fewer concurrent users.
    • Less expensive.
    • Royalty free low-end database engine.
    • Easier to maintain.
    • More friendly tools.

Perhaps more important than choice of database is how the database is used. BlazeLIMS RDBMS has been implemented using the highest quality approach:

  • Proper transaction bounding with brief transactions and minimum locking windows, using an optimistic locking model, provides superior concurrency management.
  • Use of the most efficient API (native SQLNet for Oracle, ODBC for SQL Server).
  • Server-only read/write transactions insures robust scaleable operation.
  • Superior physical schema implementation reduces long term DBA maintenance/tuning costs.
  • Proprietary automated query generation insures predictable response times in the face of common query optimizer weaknesses.

Primary Sidebar

Site Search

Products

  • LIMS – Laboratory Information Management System
  • Integration Middleware – BlazeLink
  • LIMS Inventory Management
  • Stability Shelf Life Management
  • LIMS Dashboards For Analytics
  • LIMS Statistical Control
  • LIMS Solution Suite for Enterprise Integration
  • Comparison of LIMS Software

Contact Blaze Systems

300 Creek View Road
Suite 204
Newark, DE 19711
+1 (302) 733-7236
sales@blazesystems.com
  • Facebook
  • LinkedIn
  • Twitter

Footer

Blaze Systems Corporation
+1 (302) 733-7236
sales@blazesystems.com
  • Facebook
  • LinkedIn
  • Twitter
Privacy Policy  | Terms of Use