Location: Latigude, longitude, speed, course, heading, rate of turn, number of satellites in view, horizontal dilution of precision, and position dilution of position.Wing Engine: rpm, oil pressure, coolant temperature, hours, and start battery voltage.Shore Power: volts, amps, frequency, and kWhrs.Generator: rpm, oil pressure, coolant temperature, battery voltage, hours, voltage, amperage, frequency, and kWhrs.240V AC: voltage, amperage, frequency, inverter A temperature, Inverter B temperature, and kWhrs.120V AC: voltage, amperage, frequency, inverter temperature, and kWhrs.24V DC electrical: house voltage, house amperage, house state of charge start alternator temperature, house alternator temperature, start voltage, start amperage, and start state of charge.Main engine data: RPM, load percentage, hours, coolant temp, oil pressure, intake air temperature, transmission temperature, transmission pressure, boost pressure, fuel pressure, and fuel temperature.Tank levels: Fresh water, black water, grey water, starboard fuel, port fuel, supply fuel, and day tank fuel.The data that is collected and stored includes: We have every data point from every 5 seconds going back many years stored in the on-board RDMS. Our “home” is actually a boat and the boat is fairly heavily instrumented and automated, Just about everything is stored in the relational database. It’s still not even within an order of magnitude as busy as many business databases but it is likely is as busy as half of them. It’s hard to believe that a relational database in personal use at home will ever have much of a load when it comes to transaction processing but our home RDBMS is surprisingly busy, with more than a hundred database interactions per second.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |