BACKGROUND: Deciding cases is only one of the functions of the Supreme Court of Oklahoma. The Court is also responsible for administering the state's entire judicial system and establishing rules of operation for all other courts in the state.
PLATFORMS: Microsoft Windows 2000, Microsoft SQL Server 7.0, Microsoft IIS, Microsoft Active Directory, Microsoft Visual Basic, Microsoft Visual Studio, Microsoft Internet Explorer.
PROBLEM SOLVED: Reducing backlog is critical to the Court. A multitiered, client/server network of Compaq ProLiant servers addresses case backlog in three ways. First, it tracks daily case-related activities from traffic tickets to sentencing. Second, it manages millions of documents online, making them available to attorneys, judges and citizens via the Web. Third, it generates real-time reports for efficient case management.
PRODUCT FUNCTIONALITY: Real-time case data flows from Compaq ProLiant file servers at district courthouses to central Compaq ProLiant servers in Oklahoma City. The central servers host a 300GB Microsoft SQL Server database, which includes 42 million docket entries for just one of eight counties online. Clerks, judges, bailiffs, district attorneys and public defenders 1,200 internal and 2,200 external users have browser access to the case information via a T1- based intranet that links them into a virtual private network of protected data. Users can also access a 3.5GB Microsoft SQL Server compressed database that includes all Oklahoma statutes and appellate decisions since 1955: a quarter-million documents. To maintain fast response despite a daily transaction load that exceeds 200,000, requests are load-balanced across a redundant array of Compaq ProLiant application servers. These servers connect to additional Compaq ProLiant database servers and Compaq StorageWorks enterprise storage array systems that house nearly 20 Microsoft SQL Server 7.0 databases. In the future, the department will build a data warehouse to study case statistics, recognize trends and compare activities across districts. The department will upgrade to a Microsoft SQL Server 7.5 database for its enhanced database management tools. Bar codes will facilitate linking documents to specific cases.
STRENGTHS: The scalability and reliability of Compaq ProLiant servers are key strengths. We add systems where and when they're needed, and it's transparent to users. By the end of 2001, workload is anticipated to exceed one million transactions per day.
WEAKNESSES: We had stability issues early on primarily programming bugs that were worked out. However, considering the size of this system and the transaction level, it was brought online very quickly: from 13 to 500 users in four weeks.
SELECTION CRITERIA: The primary advantage of Compaq ProLiant servers is reliability. I don't think there's any question that the Compaq equipment is the most reliable equipment we own. If a system goes down at either the database or application server level, another picks up the workload within seconds and with no data loss. We don't have reliability issues. We turn the servers on and don't think about them. Two other Compaq servers the department uses have been up and running continuously for three years. For an added level of protection, the department stripes and mirrors disks which provide a second copy of all documents. Transactional data is backed up every two hours, with full backups to additional Compaq ProLiant servers nightly.
DELIVERABLES: Attorneys can query the case tracking system and immediately see any new information that's been added to the docket that day. The court can quickly link people with their cross- district offenses. Judges use Microsoft Visual Basic tools to analyze data and create HTML-based reports on current case statistics, such as the types of cases assigned or how long cases remain outstanding. The Compaq ProLiant 6400 Web servers handle 90,000 hits from the public each day.
VENDOR SUPPORT: We designed and built the environment with planning and sizing assistance from Compaq. Compaq provides the most stable, reliable platform for our Microsoft Windows 2000 and Microsoft SQL Server environment.
DOCUMENTATION: The online documentation is complete, easy to understand and constantly utilized. The product ships with hard-copy documentation as well, but we don't use it.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access