Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Development
    • Development

    Lessons Learned at the Excellence Awards Site

    By
    Timothy Dyck
    -
    March 4, 2002
    Share
    Facebook
    Twitter
    Linkedin

      This year, as with last year, we used a secure Web site to gather entry information for the eWeek eXcellence Awards program.

      The Web application was written in JavaServer Pages and runs on Apache Software Foundation Inc.s Tomcat 4.0.1 application server. All data was stored in an IBM DB2 7.2 database.

      The biggest change to the site architecture this year was a switch in back-end databases.

      Last year, we used MySQL ABs MySQL. After a year of use, we appreciated the stability of the product and its Java Database Connectivity driver, as well as its easy-to-use activity logging and encryption facilities. However, we were also frustrated by some major feature gaps, such as a lack of foreign keys and SQL views, less-than-competitive administration tools, and poor data analytic and complex query capabilities.

      As a result, we switched to DB2 7.2 (running on Red Hat Inc.s Red Hat Linux 6.2) for the latest eXcellence Awards. Overall, DB2 was a pleasure to use and provided a significantly richer data processing environment.

      We were able to use foreign keys extensively to double-check that no orphaned data—data not correctly linked to related data—ever made it into the database, something that caused us problems when we were using MySQL. (The problems were in our application code, but the database made it easy to miss our coding bugs.)

      We also used views throughout the database to enforce a multilevel security scheme. (The Web application user, site judges, entry fee payment processing staff, labs staff and site administrator all needed different, sometimes overlapping, sets of rights.)

      We implemented this scheme using a set of views for each class of user, which allowed us to have a simple set of permissions for each view, instead of having one complex set of permissions on the base tables—a design that makes it easy to make security mistakes.

      This year, we also switched from Sun Microsystems Inc.s Java 1.3 Virtual Machine on Linux to the IBM Java 1.3 VM because we had frustratingly mysterious VM deaths about every three weeks using the Sun VM last year. With the IBM VM, on the other hand, we didnt have a single problem in more than five months of use, so thats the one were sticking with for next year.

      Tomcat continued to be completely trouble-free software, and we just let it do its thing.

      eWeek Labs West Coast Technical Director Timothy Dyck can be reached at [email protected]

      Timothy Dyck
      Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.

      MOST POPULAR ARTICLES

      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×