A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

PLM and Oracle New Full Text Query

PLM and Oracle New Full Text Query
Oleg
Oleg
28 August, 2013 | 2 min for reading

Are you familiar with 1% internet rule? It is also called 90-9-1 principle. According to this rule, only 1% of internet users are actively involved into content creation. Even 1% percent rule cannot be applied as-is to enterprise, my hunch retrieval of data (or data access) becomes more and more important these days. The amount of data in enterprise organizations is growing. To get access to this data is a critical IT requirement.

Companies are thinking about different ways to access data. It comes in a form of search, reports, analysis and many others. All I said above, applies to manufacturing companies and PLM systems. Traditionally, engineering uses, which represents a majority of CAD/PLM users from the beginning are very concerned about data creation – CAD design, Simulation, Drawings – all these elements assumes creation of information. However, when it comes to user adoption, the problem of data consumption comes to the place.

While the question of noSQL database adoption by PLM is still open, my guess the majority of PLM implementation in the world are running on top of RDBMS and probably with heavy presence of Oracle databases. On this note, Oracle recently  updated its database to include XQuery Full Text Search. The following article in AMS Tech blog provides lots of useful information about this full text search query functionality and code examples.

What is my conclusion? New technologies like noSQL and others are cool. However, while you have to support many existing customers in production, usage of existing mainstream database technologies can become an interesting option. I’m not sure it will be become a life saver for Oracle databases in the race against other databases options. Nevertheless, to solve customers problems is a priority. Full text query can provide some cool search capabilities to existing implementations. Just my thoughts…

Best, Oleg

 

Recent Posts

Also on BeyondPLM

4 6
9 March, 2012

Cloud is hyping these days. However, it also becomes real and moving from the state of “think” to “make” something....

24 October, 2014

The number of SaaS businesses is growing these days. You probably had a chance to read my CAD, PLM and...

7 January, 2016

The nice thing about standards is that there are so many to chose from. Engineering.com article Moving Towards Product Innovation...

21 January, 2017

Manufacturing world is changing and it can bring new opportunities for transformation and changes. Few days ago, I posted an...

17 December, 2017

Recent Forrester Wave report made some turbulence in PLM world. I shared my thoughts in my earlier blog –What I...

21 December, 2011

Cost is an important topic. Period. Everybody agrees with this statement. I can even say many companies investing a lot...

25 May, 2010

A short note on WorldCAD Access by Ralf Grabowski got my attention few days ago. In a very competitive world...

13 May, 2017

Aras is buzzing PLM industry. Aras PLM gradually took a position to challenge big 3 PLM vendors – Dassault Enovia, Siemens’ Teamcenter...

19 May, 2015

Siemens PLM connection 2015 is taking place in Dallas this week. Thanks for Siemens PLM inviting me, I had a...

Blogroll

To the top