SIGO: DBMS independence

Context

SIGO is a product for Activity Management in OSS area (Operations Support Systems as defined by TMForum), covering Incident, Problem, Request, Changes, Preventive Maintenance and Contracts with Suppliers Management Processes.
It is a fault tolerant system, which is expected high performance and availability.
The system uses the ORACLE for persistence and control of business rules.

Project objectives

The high competitiveness in the market area of the SIGO ​​product puts a huge stress on areas such as innovation, functionality, performance and cost.
Taking into account the objective of maintaining the degree of maturity reducing system costs, there is a need to explore an alternative to Oracle DBMS, which ensures scalability, performance, consistency, and possibility of implementing business logic.
At first glance the choice lies with the PostgreSQL given the similarities with ORACLE and the existence of a Procedural Language Engine (plpgsql).
The aim is to study and implement the adoption of PostgreSQL as support for data persistence and implementation of SIGO business rules, which includes the migration of objects and PL/SQL code.
At the end of the internship must be produced a methodology and best practices that guides and makes it easier to implement in a similar process. Considering a 12 months internship, at the end SIGO system must be supported in both DBMSs across all existing features.

Key skills required

Altice Labs product lines

Telecom Operator Support Tools and Platforms

Want to participate in this project?

If you think you have the appropriate competences to work with us at this project, please contact us to genius@inova-ria.pt.