New to Overclock.net
Join Date: Apr 2009
Location: Cincinnati Ohio
Relational Database setup question
I have been trying to figure this out for a couple of days, so any input that could be offered would be great.
A little over a year ago I started to work on an application not dissimilar from Spiceworks for use at my job. I'd have used the aforementioned but it was creating and infinite loop to itself that the Security team flagged and we found that its process on target machines was sometimes hammering the systems. As such I started to plan out a web interface, VB.NET app, and a database but due to time constraints all of this was back burnered. Now it is time for my capstone project for school and I am doing an expanded version of the original idea. However, that brings me to my database issue.
The premise of the project is to query, store, accept manual input, and generate reports about assets. The issue I run into is those assets include desktops, laptops, scan guns with CE, scan guns with various versions of Android, printers, UPS systems, IP addresses, and network hardware. As such there are a number of shared properties for each asset type and A LOT that are different as well. The differences are where I have a problem though, how do you break those out into tables in a relational database in a way that makes sense? Or can you? The best solution I have so far is that the asset table has to have ALL of the properties and some are allowed to be null. For instance, how would i relate properties of an asset such as CPU Load, temperature, current user, total memory, available memory, total HD, available HD, etc.
I am not at my laptop right now so don't have the visio document with the design on it, but in short evreything revolves around events.
The event table has a one to many relation with the event_type table.
The event table has a many to one relation with the asset table.
the asset table has a one to many relation with the asset_type table.
Again, if anyone has some input on this, it would be appreciated. I really do not want to do a non relational DB with independent tables for each asset type.
. . .
Phenom II 1090T Black Edition
Crucial Ballistix Sport 16GB VLP DDR3 1600 CL9 1.35v
Vertex 3 120GB SSD
2x WD 1TB Caviar Black SATA3
WD Caviar Black 640GB SATA2
HP DVD-RW 1170i
2x Delta AFB1212SHE
7x Cooler Master SickleFlow R4 fans
Cooler Master HAF932 (Fan Mod)
Windows 10 Professional
2x Samsung SyncMaster E2420 23.6" 1920x1080
▲ hide details ▲