September 12, 2008

Special 'SQL' proposed for unstructured data

Seven leading software companies submit to the Oasis standards body the draft CMIS specification, which aims at doing for unstructured data what SQL did for databases

Companies dealing with unstructured data could be soon offered their own version of SQL following the efforts of seven leading software companies.

The Content Management Interoperability Services (CMIS) specification, which has just been submitted to the Oasis standards body, is aimed at doing for unstructured data what SQL did for databases in the 80s according John Newton, chief technology officer for Alfresco, one of the software vendors driving the process.

[ Discover the top-rated IT products as rated by the InfoWorld Test Center. ]

The objective of the draft CMIS specification is to deliver a common REST or Web Services, an API that can be used to develop write-once, run-anywhere, next generation content and social applications.

Newton believes the SQL comparison was a good one. "The query language that will be used within the spec is actually a form of SQL, offering several options for querying the repository, including location, properties, and full-text" he said. "There's a huge amount of unstructured data out there and we should be able to query it in exactly the same way that we query databases, what's been holding us back is the lack of an SQL," he added.

Most of the leading software vendors are involved in developing the specification. Besides Alfresco, the participants are EMC, IBM, Microsoft, OpenText, Oracle, and SAP. Newton said that it there will certainly be other vendors willing to work with the specification but no other vendors were approached: "It's been pretty hard keeping it a secret for the past two years but now that it's an open spec, we can expect others to work with it," he said.

Newton said that he expected a great deal of interest in the spec from the user community. "To take one example, Citigroup has 25 different content management systems, with no means of being able to discover information across all of them.

He said that the first stage in the process would be for Oasis to set up a technical standards committee but couldn't offer a timescale as to when a standard would be ratified.

The Alfresco Labs' Draft CMIS Implementation can be downloaded from the Alfresco Web site .

Techworld is an InfoWorld affiliate.

Close

On Twitter now

Applications

Powered by Twitter

On Twitter now

White Paper

D2D Virtual Tape Library Replication Primer

This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.

Download now »

White Paper

An Alternative to Virtualization for Datacenter Cost Savings

Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.

Download now »

White Paper

Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network

The emergence of WLANs has created a new breed of security threats to enterprise networks.

Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation

Download now »

White Paper

Bringing the Edge to the Data Center

Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.

Download now »

Sign up to receive Applications Resource Alerts

Subscribe to the Today's Headlines: First Look Newsletter

Find out what will be news for the day, with our first-thing-in-the-morning briefing.

©1994-2009 Infoworld, Inc.