Reduction of data complexity? Possible thanks to adNucleus!

In IT development, as in many other areas, in order to create new things, it's common to use existing toolboxes and building blocks. Why? Obviously, to achieve your goals faster without needing to invest in finding out new ways how to do it. But what if there are undiscovered options that are even more efficient, cost-effective and better suited to you and your business? We introduce you to our solution adNucleus in the blog post.

The typical challenges in dealing with complex data

In most cases, a process begins based on data, you start by creating a white page, add some lines and columns and you get Excel. These canvas, lines and columns will be used to define a data structure where each cell contains data values. Various projects of data management start just like this and are easy to handle until the size of the document increases. Are you familiar with these challenges?

• The amount of users increases
• It’s unclear who has access to which part of the file
• The file is used by multiple users at the same time
• The amount of data increases
• The file becomes more and more complex
• Etc.

Here are some ways to deal with those challenges:

Hire more people and still use Excel

Here’s our reservation:

• This is one possible solution, but in this blog article we show you an alternative

Search for an alternative tool who matches the requirements

Here’s our reservation:

• It can be hard to identify what's available on market
• often internal processes have to be adapted to fit tool logic
• Usually new tools come with recurrent licence cost
• It’s not always possible to make it evolve with changing needs

Create your own tool

Here’s our reservation:

• Technological choices could have long-run impacts
• Tool matching processes
• New departments come with his cost

Delegate the creation of your own tool

Here are our opinions:

• Get almost only benefits
• Big size projects if known in advance, require deeper analysis

Here is the adesso solution adNucleus

The vision of the adNucleus team was to create a constantly evolving toolbox (consisting of technologies and software modules) as an alternative to Excel monsters. The goal was to create an affordable, ready-to-use tailor-made web application with up-to-date technologies. It's an internal adesso framework and a Java Spring/Angular ecosystem providing a shell where business process logics can be put-in to produce a usable tool on the internet.

Read more

Complexity made easier for you

As soon as logics or rules have been defined for a process which involves data, it's theoretically possible for it to be automatized. One of the key elements is to be aware of what data is available and what result it should provide. Often, gaps come during analysis, where final results need other data instead of that one initially planned.

Input data can be provided in many ways (screen with report form, Excel files, Internet, ...). Once loaded in a database, the data can be processed as a page, a list, a downloadable file, report, KPI or many other – regarding your need.

Finding the balance

In the context of application development, two parts need to be aligned. What you want the tool to do (business logic rules), and how you are going to build the tool (technology). Finding a good balance here is one of the biggest challenges.

You don't want to invest in a tool if, after it’s been built, doesn't produce what it's expected to do. Or what if the process changes along the way?

In multiple cases, the first process of an application starts with a login page. The features behind are for example mail, calendar, logistics, administrative.

Business rules logic are often the biggest unknown in the equation. Agile methodology allows to mitigate this risk and often provides success.

IT technologies, on the other hand have been designed for a specific purpose. They are already existing tools/libraries/packages with their owns rules, it's either in or out of the box.

So in the end it's a developer’s job to know which one to use or create to achieve what's required.

Here’s what adNucleus offers you

adNucleus provides ready to use authentication, data audit, query engine, mail sending, and plenty of other features. That allows you to quickly build prototypes which can be presented to the business.

By seeing prototype screens, it is easier to get a concrete idea. Business rules can then be adapted and a new version of the application quickly deployed. The earlier the rules are defined, the better.

adNucleus enters in the game at this point. With his existing set of features which are quickly configurable, a prototype or POC (prove-of-concept) can be done within a few days.

Once a prototype starts to grow or/and processes are getting clearer, it can become a production-ready tool by adding quality on code.

Ready to be put in the Cloud or on-premise, any application produced has almost no dependency on the infrastructure it's sitting on.

adNucleus offers a way to build custom tools who match required processes. More than a dozen tailor made applications or prototypes have already been created for customers.

They especially help with the daily work of employees in various sectors and departments. Here are some examples of the Life Science industry where adNucleus is a part of delivery:

Risk management (CAPA)

Two projects of Root Cause Analysis and Risk Management: The solution allows to track and mitigate existing or potential risks. They are used by multiple departments as Patient Safety, Regulatory Affairs and IT Global Secure Systems by more than 500 users located worldwide.

Chemical compounds testing logistics

One project for logistics data management and another for external partner data access. The solution allows logistics data tracking during the whole process chain of testing. Compound batches are synchronized with an external provider to insure validity and datapoints can be managed during all step of an established workflow.

Raw material supply chains data tracking

Two different projects, one for a centralized multiple data source of supply chain tracking information and another to provide access to specific features to external partners. The solution allows multiple teams to work on their own data source and provide a global view on all data available.

Antibodies data management

Project of data management of an enterprise repository of antibody. The solution allows data management starting from names, protein sequences and batch information to characterization data produced during experiments.

Conclusion