Experda

Redesign database management system

EasyManage is a database management system. Until now the system was a local system on the computer. The requirement is to design a SAAS system, which allows users to manage and monitor servers in various different companies.

The challenge

There were two main challenges.
First, entering a world of very technical content, fully understanding it to its core so that I can provide accurate solutions.
Second, characterizing an easy-to-use system suitable for both the professional target audience of the field, and the less proficient systems person.

The solution

Designing a SAAS database management system, which allows users to monitor and manage servers in various companies. I have designed UX solutions that support the need to make the system accessible for users from different levels of experience, such as the gradual exposure of modules at different complex levels.

The research

3 main users

With 3 different needs

DBA

The professionals of this field, knowing how to solve and prevent problems.

System person

People who handle computing in the company and as part of it know how to monitor servers.

Client (CEO)

Wants to know when a problem occurs, but does not know how to solve it.

Interviews

I interviewed 7 different users

DBA

Boris

Ohad

Shay

System person

Yossi

Boris

Client

Assaf

Customer support

Rachel

Natalia

Sarit

Current system

I went through the system and divided it into usage amount, in order to understand the needs for rearrangement of data.

Market research

Market research is complex in this type of system. There are lots of systems, each has a different complexity, therefore requiring different solutions. It was important for me to know and understand what has already been done and what best practices are already established in this field.

Direct competitors

Indirect competitors

Information architecture

The wireframes

Timeframe

The timeframe allows you to switch between 2 modes. First, live mode -  for monitoring. Second, historical mode - for investigating a particular problem.

Alerts

Alerts are the heart of the system. This is the first step in identifying the problem, and I wanted to make this step more efficient, better organized and actionable.

Old system

New system

Performance

In this module you see the performance of the servers. Its purpose is to signal to the DBA that there is something unusual. For quick identification, I chose to mark the alerts on the graphs as well, and produce a visual distinction between an alert that occurs and irregular numbers.

Setting the alerts

These are the results

What have I learned?

System speed

In complex systems, every feature you add has a big impact on system speed. It is therefore important to constantly check the meanings in front of the technical staff.

Using libraries

When designing complex modules, it is necessary to work with existing libraries, since these modules are usually not developed from scratch.

Work processes in complex systems

The high significance of the designer in the face of technical features in highly technical systems, and how I should integrate myself into such processes.