Abstract: A computerized method for automatically converting hierarchical data to a flat database table can comprise receiving a hierarchical data set comprising one or more nodes. The method can also comprise identifying at least one node comprising at least one data field. The method can then comprise distilling the at least one node to one or more independent data fields, wherein each of the one or more independent data fields comprise more than a single data entry. The method can further comprise automatically generating one or more flat data tables to store data entries form the one or more independent data fields. Further still, the method can comprise constructing a relational database of the one or more flat data tables and storing the relational database.

Abstract: A method for data packet communication between a data beacon and a command-and-control server that are located within separate networks can comprise accessing a beacon identification indicator. The method can also comprise generating a command-request data packet comprising the beacon identification indicator and a public network address associated with the data beacon. Additionally, the method can comprise transmitting the command-request data packet to a command-and-control server address. The method can also comprise receiving a command data packet from the command-and-control server that comprises a command to query a local database for specific data elements. The method can then include querying the local database for the specific data elements. Further, the method can include generating a response data packet that comprises the specific data elements. Further still, the method can include transmitting the response data packet to the command-and-control server address.

Abstract: Systems and methods for collecting, managing and sharing date include a server computer system that receives a data set containing flat data from a client computer system. The server computer system generates a relational database from the flat data and provides, through a web-based interface, user options for modifying the relational database, as well as application programming interfaces configured to provide data of the relational database to third parties. In accordance with another implementation of the invention, a client computer system sends flat data to a server computer system, causing the server computer system to generate a relational database from flat data. The client computer system receives and displays a web-based user interface that identifies fields of the flat data as part of the relational database, along with user options for modifying the fields of the relational database.