Issue link: https://let.epubxp.com/i/254119
38 Law Enforcement Technology February 2014 www.officer.com TA L K I N G P O I N T S incident records, vehicle records, warrant or arrest records, etc., making the search time-consuming at best. At worst, search results may miss vital information need- ed for an arrest. During a traffic stop you might not see an outstanding arrest war- rant or other relevant criminal activity. Speed of search A central data repository contributes to faster search speeds. ISAM's precise control of index structures returns fast search results because ISAM allows CAD systems to control which elements are searched, according to how the data has been indexed. New advancements have shattered information access barriers across multiple data formats (relational and non-relational), by layering ISAM and SQL into a single database. The database engine maps the non-relational data into a relational (or tabular) model on-the-fly, providing SQL access to this data. Public safety agencies particularly favor CAD systems with this dual capability when their personnel are proficient using SQL to run reports, but want faster perfor- mance possible with ISAM. Furthermore, ISAM was designed to embed the database directly into applications or data files, a unique fea- ture that stands apart from SQL-only databases like Oracle and Microsoft SQL Server. ISAM maintains data index integrity by collectively describing hierarchical data and index file relation- ships, which permit a single call to the data engine to then update a record and all of its key values. Then when new information is entered and associ- ated with a name, the database updates all records associated with that name, regardless of where it is used or referenced. Advanced CAD systems help offi- cers responding to emergencies and crime scenes by increasing safety and situational awareness. They contribute to the nationwide effort to increase inter-agency sharing. But not all CAD systems are equal. Ask yourself: Does the CAD system allow for creation of precise indexes for quicker searching? Does it deliver information as it is hap- pening, or does it cache and refresh it only periodically? Will there be added costs for maintaining the database? To best understand these systems, you must consider the database. Like the engine of a car, it powers CAD systems and plays a key role in deter- mining its levels of speed, performance and cost. ■ Powerful Portable Scene Lighting • Honda EB-3000 Generator • Rugged Stainless Steel Handcart • (2) 500 W Quartz Telescoping Lights • (2) 500 W Quartz Portable Lights • (2) Weather resistant receptacles • (2) 25ft. Extension Cords 1-800-538-0022 www.tele-lite.com For optimum performance and safety, we recommend you read the Owner's Manual before operating your Honda Power Equipment. Connection of generators to house power requires transfer device to avoid possible injury to power company personnel. Consult a qualifi ed electrician. Nova-Lite N o v a - L i t e Rochester, New York Circle 38 on Reader Service Card Circle 39 on Reader Service Card LET_36-38_TalkingPoints0214.indd 38 1/24/14 12:29 PM