Change Location × Atlanta

    Recent Locations

      ROXIE ECL (Part 2) - Complex Query Development - Atlanta in Alpharetta


      • ROXIE ECL (Part 2) - Complex Query Development - Atlanta Photo #1
      1 of 1
      December 4, 2019

      Wednesday   1:00 PM

      1000 Alderman Drive
      Alpharetta, Georgia 30005

      Map
      Performers:
      • No Performers Listed
      EVENT DETAILS
      ROXIE ECL (Part 2) - Complex Query Development - Atlanta

      NOTE: RELX and LexisNexis employees should register using the approved promo code provided by their manager or contact training@hpccsystems.com. Roxie ECL (Part 2) – Complex Query Development Note: This course is the second in a two-part ROXIE series. People who attend the Roxie ECL (Part 1) – Indexes and Queries class should continue with this class. Learn how to optimize and organize your ROXIE queries for optimal performance. This class reviews and recommends best practices used in ROXIE development, including INTERFACE, Half Keyed JOINS, LIMIT, superkeys, and package maps. Course Length: 2 days Class Prerequisites: Students must have attended the Advanced ECL (Part 2) – Super files, Working with XML, and Free-form Text Parsing, and the Roxie ECL (Part 1) – Indexes and Queries training classes. Students are welcome to bring their own laptops to take away the code and examples from the class. Topics include: • Using INTERFACE structures with ROXIE queries• Limiting your ROXIE results (LIMIT, JOIN, CHOOSEN) • Designing queries using multiple datasets• Case insensitive searches• Use of Superkeys in ROXIE queries• Use of package maps for Query organization• ROXIE-specific functions (PRELOAD, ALLNODES, etc.)• ROXIE Post filtering Class on Wednesday begins at 1pm and concludes at 5pm. Class on Thursday begins at 9am and concludes at 5pm. 

      Categories: Science

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.