Abstract: A system and method rate limits database access to, for example, prevent or reduce damage from unauthorized or errant access of a database by enforcing a network-level limit to the amount of data that may be accessed from the database. In at least one embodiment, a data transfer rate limiter monitors data transfer and determines whether the data transfer exceeds one or more predetermined thresholds. Based on the determination, the data transfer rate limiter generates a control signal that controls one or more processes that appropriately address any the data rate transfer of concern.

Abstract: A database access, monitoring, and control system and method monitor database access, detect suspicious database activities, and react to suspicious database activities by initiating one or more control functions. In at least one embodiment, suspicious database activities include activities related to a number of rows of data retrieved in response to one or more queries within a predetermined threshold window of time. Data retrieval row count above a predetermined threshold that represents an anticipated maximum request for legitimate users can indicate a suspicious database activity. In at least one embodiment, the database access, monitoring, and control system and method detects suspicious database activities even if a data requestor has thwarted other security measures or if the data requestor has authorized access but is potentially accessing data inappropriately.

Abstract: A communication simplifier system and method simplify communication between a client application and a single-board data processing system using a tethering architecture. In at least one embodiment, the communication simplifier system and method allows a software developer to build a communication tethering application for the single-board data processing system, define a communication connection strategy, and add a client communication tethering application to a remote computer system, such as a mobile or desktop client computer system, to handle communication with the single-board data processing system. The client computer system also offloads processing from the single-board data processing system by including a processing logic application to implement additional logic to process data received by the single-board data processing system.

Abstract: A method or system for application program interface (API) request conversion, includes generating a plurality of configuration files, each associated with a different API format. A first API format of the first API request is identified and a first configuration file is identified based on the first API format. A second API request having a second API format is generated by applying the first API request to the first configuration file. A third API request is received and a third API format of the third API request is identified. A second configuration file is identified based on the third API format. A fourth API request is generated having the second API format by applying the third API request to the second configuration file.

Abstract: A data object design system and method facilitates and generates creation of data objects to contain and, thus, contain data structures within the data objects. The data objects and interaction between the data objects implement a higher level of abstraction between data objects and data entities. Particularly for complicated, sophisticated data models, the data objects support an increased usability, efficiency, and comprehension of a data modeling system. Thus, in at least one embodiment, the data object design system and method increases the technical capabilities of data modeling tools by, for example, implementing data objects to reduce complex data modeling implementations into manageable data objects and increasing the efficient utilization of data modeling tools.

Abstract: A communication simplifier system and method simplify communication between a client application and a single-board data processing system using a tethering architecture. In at least one embodiment, the communication simplifier system and method allows a software developer to build a communication tethering application for the single-board data processing system, define a communication connection strategy, and add a client communication tethering application to a remote computer system, such as a mobile or desktop client computer system, to handle communication with the single-board data processing system. The client computer system also offloads processing from the single-board data processing system by including a processing logic application to implement additional logic to process data received by the single-board data processing system.

Abstract: A memory monitoring and selective defragmentation method and system disclosed herein monitor memory usage by and modification of one or more database indexes. The monitoring and selective defragmentation method and system selectively defragment the one or more database indexes based on memory cost savings as opposed to a percentage of fragmentation to improve performance of databases.

Abstract: Embodiments disclosed herein may be useful for controlling access to data, and particularly to data intended for restricted access. In at least one embodiment, a system and method for dynamic data masking intercepts input/output (I/O) read requests for data in external memory, determines if the data to be read should be masked, and appropriately, dynamically masks data before the requested data is written into system memory. The system and method for dynamic data masking provides a technical improvement to computing systems by, for example, avoiding the need to create an entirely separate database with scrubbed data and, thus, resource and costs associated with creating a separate, scrubbed database.

Abstract: A database performance testing system and non-transitory, computer readable medium utilizes a virtual database system to test a production-level database without interfering with operations of the production-level database by redirecting test commands to a backup database. By incorporating the virtual database system into a production-level database test, the database performance testing system and non-transitory, computer readable medium is able to overcome technical and resource obstacles of testing against a production-level database. The database performance testing system also includes a database management system that issues a test command to a production-level database. However, the virtual database system intercepts the test command and redirects the test command to a backup database, which is an equivalent of the production-level database.

Abstract: A database access, monitoring, and control system and method monitor database access, detect suspicious database activities, and react to suspicious database activities by initiating one or more control functions. In at least one embodiment, suspicious database activities include activities related to a number of rows of data retrieved in response to one or more queries within a predetermined threshold window of time. Data retrieval row count above a predetermined threshold that represents an anticipated maximum request for legitimate users can indicate a suspicious database activity. In at least one embodiment, the database access, monitoring, and control system and method detects suspicious database activities even if a data requestor has thwarted other security measures or if the data requestor has authorized access but is potentially accessing data inappropriately.

Abstract: A system and method rate limits database access to, for example, prevent or reduce damage from unauthorized or errant access of a database by enforcing a network-level limit to the amount of data that may be accessed from the database. In at least one embodiment, a data transfer rate limiter monitors data transfer and determines whether the data transfer exceeds one or more predetermined thresholds. Based on the determination, the data transfer rate limiter generates a control signal that controls one or more processes that appropriately address any the data rate transfer of concern.

Abstract: A virtual database is attached to a server database management system (“DBMS”) such that the DBMS believes it needs to recover the database to a last known point of consistency. In order to perform this recovery, the DBMS requests the transaction log file entries to be read from what it believes is the database's transaction log file. However, the requests are intercepted and translated into requests to read the transaction log portion of the backup file. The DBMS then uses the transaction log records to bring the database to a point of transactional consistency, unaware that the log records are actually being sourced from the backup file. All changes made to the data during the recovery phase and subsequent execution of any TSQL statements are routed into a cache file. Accordingly, a “virtual” database is created and used by the server DBMS engine as if it were a real database.

Abstract: A memory monitoring and selective defragmentation method and system disclosed herein monitor memory usage by and modification of one or more database indexes. The monitoring and selective defragmentation method and system selectively defragment the one or more database indexes based on memory cost savings as opposed to a percentage of fragmentation to improve performance of databases.

Abstract: A data object design system and method facilitates and generates creation of data objects to contain and, thus, contain data structures within the data objects. The data objects and interaction between the data objects implement a higher level of abstraction between data objects and data entities. Particularly for complicated, sophisticated data models, the data objects support an increased usability, efficiency, and comprehension of a data modeling system. Thus, in at least one embodiment, the data object design system and method increases the technical capabilities of data modeling tools by, for example, implementing data objects to reduce complex data modeling implementations into manageable data objects and increasing the efficient utilization of data modeling tools.

Abstract: Embodiments disclosed herein may be useful for controlling access to data, and particularly to data intended for restricted access. In at least one embodiment, a system and method for dynamic data masking intercepts input/output (I/O) read requests for data in external memory, determines if the data to be read should be masked, and appropriately, dynamically masks data before the requested data is written into system memory. The system and method for dynamic data masking provides a technical improvement to computing systems by, for example, avoiding the need to create an entirely separate database with scrubbed data and, thus, resource and costs associated with creating a separate, scrubbed database.

Abstract: A system and method for backing up a database, where the system has read threads running simultaneously, write threads, and data buffers. Each read thread repeats the following operations until all the data is backed up: read a block of data from the database, compress the data using a dynamic compression ratio which is initialized and adjusted after every compression, write the data to an available data buffer until the data buffer is full, write to the next available data buffer once the data buffer is full, and determine a new compression ratio. A controller determines the new compression ratio using either a method that monitors the timing of system components and/or a method that monitors CPU consumption.