Suggestions on type of software/system to build a datamap?

Basically I want to be able to do this and present it visually/give a report:

- Input/populate a database using data about a system(software) and its qualifications/specs/what sort of data it can input/output (all done by a user (normally me)

- Be able to search for a system in the database by any criteria it has

- Be able to visually represent this information either through visuals or pulling up a report.

My best guesses to use are any relational database programs. I am not sure if this is the best option as the scope of the database is only about 150 or so systems that need to be inputted. Please help with any suggestions! Sorry I am not the most tech savvy person and I know this comes off as extremely amateur. Will answer any questions for clarifications.

Discussion is locked
Reply to: Suggestions on type of software/system to build a datamap?
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: Suggestions on type of software/system to build a datamap?
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
- Collapse -
Re: datamap

It's not really clear what a "datamap" is, so let's start simple by asking one question: why not Excel?

- Collapse -
Re: datamap

First off, thanks for replying!

I agree data map is a very broad term. What I mean by data map in this question is I need to be able to populate a spreadsheet or database so a user can search a system's qualifications or criteria. For example, a user wants to see what systems a system owner has jurisdiction over, or see if a system has PII (personal identification information). I want a user to be able to navigate a flowchart of this data map; for example the user searches for a particular system and ends up in seeing a system stores their data in the specific location. The user then wants to see what other systems store their data in this location, and can do so from this "query". If possible I want to be able to do this visually.

For your Excel question, I am wondering this myself. I already have the information inputted into Excel but I am wondering if this "map" can be done in Excel, or if the information can be exported to a RDBMS and then have the visual path be implemented there. I am guessing my client does not want its users looking through an Excel spreadsheet. Hopefully this makes sense, will gladly answer any clarifications if needed. Thanks!

- Collapse -
Re: datamap

Such an application is called a CMDB (Configuration Management Database). There are many and probably none meets the requirements, vague as they are.

It seems a nice subject for an IT-student to select and the best solution and get this working as an end of his bachelor study. That can be an open source program that needs to be changed and implemented or just the implementation of a commercial product.

CNET Forums