Systems, methods, user interfaces and algorithms for performing database analysis and search of information involving structured and/or semi-structured data

A system configured to provide an interactive user interface and process one or more data sets in response to inputs received via the interactive user interface in order to search and analyze transaction data within one or more databases, the system comprising:

• one or more hardware computer processors configured to execute software code stored in at least one tangible storage device in order to cause the system to:
• process data involving a user interface that is configured to process information between a user and the databases, the databases containing organized information including object oriented or relationally-structured information associated with the transaction data, wherein at least one of the databases is configured to be accessed via technical queries using a technical search language;
• provide interactive user interface tools in the user interface including at least one of graphical input fields or indicia to perform at least one of predefined or customizable searches of the transaction data as a function of one or more search queries, the graphical input fields or indicia comprising query fields for entering search terms in a free textual format;
• automatically generate technical database queries based on the search terms entered via the query fields;
• search all of the information in the databases based on the automatically generated technical database queries;
• update the user interface responsive to the user searches, wherein the user interface is configured to display the transaction data including one or more representations of the organized information within the user interface, the one or more representations of the organized information corresponding to parameters of the transaction data determinable via the one or more search queries, the representations displayed in the user interface comprising a graphical representation comprising at least a single parent node as an initial object and a plurality of child nodes, and wherein the representations further comprise displaying in the user interface a plurality of second objects comprising second identifying information, the second objects comprising attributes associated with resources in which data regarding the second objects is stored, wherein the user selects the resources to search or filters the search to selected resources;
• and
• in response to selection of one or more search queries in the user interface:
• perform a secondary search based on the selection of one or more of the search queries;
• process the organized information into at least one subset that meets the secondary search;
• and
• update the user interface to display the at least one subset that meets the secondary search, wherein the subset contains only refined search results provided via the secondary search as a function of search selections by the user.