• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Oracle Schemes Schema Protection in JDEREF Website Shutdown

    April 14, 2014 Alex Woodie

    Concerns about intellectual property infringement led Oracle‘s lawyers to force a JD Edwards support website to shut down. The UK-based website JDEREF.com says it agreed to pull down the content of its site after receiving a threatening letter from Oracle’s managing counsel about violations of Oracle’s copyright concerning database schemas for JD Edwards EnterpriseOne.

    “It is with a heavy heart that I must inform you that jderef.com can no longer exist, having recently been served legal notice from Oracle regarding information copyright infringements relating to their product schemas,” the website’s webmaster posted to the site. “This is a bitter blow, not only for me personally, having invested many hours creating this shared resource, but mostly for the users like you, who have started to depend on the presence of this resource, to use and enhance JDE and its satellite products–to further your knowledge and insight into Oracles flagship ERP products.”

    Apparently, Oracle’s legal team doesn’t take such a democratic view on the sharing of detailed technical information about its products. While there are numerous websites that provide technical resources for JD Edwards professionals, and plenty of third-party firms who will service your JD Edwards applications and databases, JDEREF.com apparently shared a little too much in too public a manner.

    According to the JDEREF.com webmaster, the website contained all table names, column descriptions, and table indexes for the majority of the database tables for JD Edwards Enterprise One versions 8.12 and 9.10. “The information was grouped by ‘system code’ and contained, for each version, around 5,000 tables, all logically [but not human readable] named by an alphanumerical naming convention” such as F4101, the webmaster says via email. Each of the columns in the tables (up to 200 columns per table) were also alphanumerically named.

    Collectively, this information constituted the database schema for the ERP system. “It was a very well structured site with a great UI which meant the data was easily accessible–and above all–a convenient reference,” the webmaster says.

    JD Edwards makes this data difficult to obtain. If you know where you look and have the access, it’s clunky and awkward to use. “The JDEREF site just made life easier. That’s the whole reason I built it,” the webmaster wrote. “As a JDE user myself, I constantly need to refer to this data, so I built my own database of this information.” The webmaster decided to give something back to the community, and it was very well received.

    But, as the saying goes, no good deed goes unpunished.

    Database schemas are considered the intellectual property of the software company or individual who created them. Software companies like Oracle license database schemas to others as part of their overall product. After all, a schema is pretty much useless by itself, but forms the critical foundational layer when implemented on a database management system, such as Oracle’s database, IBM‘s DB2 for i, DB2 for LUW, and Microsoft SQL Server, the three RDBMs that EnterpriseOne runs on. (JD Edwards World, of course, only runs on IBM i, and therefore only has schemas for DB2 for i, or DB2/400).

    With the proper technical skills and the right tools, any licensee of a JDE product could view the schema and the collection of database tables that it encompasses. This may be useful to do to track down problems or to plan for an expansion or other modification of the underlying database schema.

    This is undoubtedly what JDERF.com was doing as it helped programmers and administrators deal with performance issues and make or fix the custom modifications that are so commonly made to JDE installations. Nobody is going to complain about the schema changes a company makes in the privacy of its own bedroom. However, take those detailed discussions of the size, shape, and nature of the JD Edwards database into a public venue, and be prepared to receive a threatening letter from Oracle’s lawyer.

    The JDERF.com webmaster wonders why a $50 billion company would bother with a small UK-based firm. “Personally, I’m of the opinion that this is a rather narrow sighted view adopted by Oracle’s product team given that: A) it’s supporting their product; B) anyone with access to JDE will technically be able to obtain this information anyway, albeit in a far less convenient and expedient fashion; and C) any competitors will have long since already obtained this information.

    “But as a private individual based in the UK,” the webmaster continues, “I have no choice but to concede. I don’t fancy going up against charges from Oracle’s legal teams. It was only a matter of time before my little website got the attention of Oracle, but this was not the response I was hoping for.”

    If you feel like helping out JDEREF.com, visit the website or send a note to Oracle asking to have them reinstate the website–or better yet, buy the information and make the information publicly available on Oracle’s website. Like the JDEREF webmaster said, the information was a big help to JD Edwards customers, and assisted them with supporting their implementations. Surely helping JD Edwards customers is something Oracle is interested in.



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Raz-Lee Security

    Raz-Lee Security is the leader in security and compliance solutions that guard business-critical information on IBM i servers. We are committed to providing the best and most comprehensive solutions for compliance, auditing, and protection from threats and ransomware. We have developed cutting-edge solutions that have revolutionized analysis and fortification of IBM i servers.

    Raz-Lee’s flagship iSecurity suite of products is comprised of solutions that help your company safeguard and monitor valuable information assets against intrusions. Our state-of-the-art products protect your files and databases from both theft and extortion attacks. Our technology provides visibility into how users access data and applications, and uses sophisticated user tracking and classification to detect and block cyberattacks, unauthorized users and malicious insiders.

    With over 35 years of exclusive IBM i security focus, Raz-Lee has achieved outstanding development capabilities and expertise. We work hard to help your company achieve the highest security and regulatory compliance.

    Key Products:

    • AUDIT
    • FIREWALL
    • ANTIVIRUS
    • ANTI-RANSOMWARE
    • MULTI-FACTOR AUTHENTICATION
    • AP-JOURNAL
    • DB-GATE
    • FILESCOPE
    • COMPLIANCE MANAGER
    • FIELD ENCRYPTION

    Learn about iSecurity Products at https://www.razlee.com/isecurity-products/

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    IBM Names 11 Fellows As Analytics Dominates Discussion Oracle Ties In-Memory JDE Enhancement to Own Hardware

    Leave a Reply Cancel reply

Volume 24, Number 13 -- April 14, 2014
THIS ISSUE SPONSORED BY:

Profound Logic Software
LANSA
ASNA
Linoma Software
WorksRight Software

Table of Contents

  • Big Blue Launches IBM i 7.1 TR8 As 7.2 Looms
  • Heartbleed, OpenSSL, and IBM i: What You Need to Know
  • Life In Javaland
  • Mad Dog 21/21: Who Says Elephants Can’t Die?
  • IBM Schedules Power Systems Event For April 28
  • Reader Feedback On Penton Media IBM i Shutdown And Women In IT
  • Oracle Schemes Schema Protection in JDEREF Website Shutdown
  • In Mainframe We Antitrust: System/360 Compels System/3
  • More IBM Job Losses Expected This Week
  • Education Foundation Airlifts Students To COMMON

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • The IBM i Power10 Upgrade Cycle Forecast Looks Favorable
  • White Hats Completely Dismantle Menu-Based Security
  • Cloud Software To Drive Enterprise Application Growth
  • How Do You Stay In Touch With The IBM i Community?
  • IBM i PTF Guide, Volume 25, Number 6
  • Security Still Top Concern, IBM i Marketplace Study Says
  • Bob Langieri Shares IBM i Career Trends Outlook for 2023
  • Kisco Brings Native SMS Messaging to IBM i
  • Four Hundred Monitor, February 1
  • 2023 IBM i Predictions, Part 4

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.