{"Database APIs"}

API Database Patents

I have been tracking on API related patents for some years, trying to understand how APIs are being referenced in patents, and in some cases the focus of the patent. Here are the patents I've tagged as being DNS related from the companies who are doing interesting things with APIs and databases.

API for programmatic retrieval and replay of database trace

Owner: Microsoft Corporation
Publication #: 07822741
Publication Date: 2010-10-26

Trace and replay objects can be designed to automatically perform operations concerning database trace data upon invocation by custom computer processes. Trace data can be saved to any of variety of locations. It can be manipulated for the purpose of storage or replay. Trace data can be played back against any database server using numerous replay configuration options. Replay notifications allow data to be changed just before it is submitted to a database for execution, and allow immediate examination of replay results and validation of playback correctness. Thus, trace and replay objects greatly simplify manageability of trace data. Custom processes can now completely automate security audit and health monitoring of traced database servers. Automatic verification of new server releases and security packs can also be performed. Custom processes can use the provided objects to flexibly access and manipulate the retrieval, storage, and replay of database trace data.


Searching content managed by a search engine using relational database type queries

Owner: INTERNATIONAL BUSINESS MACHINES CORPORATION
Publication #: 09501529
Publication Date: 2016-11-22

According to one embodiment of the present invention, a system searches content managed by a search engine. The system receives a relational database type query, translates the relational database type query into a query for the search engine, and submits the translated query to the search engine to retrieve information. The system formats resulting information from the search engine into a relational database query result set. Embodiments of the present invention further include a method and computer program product for searching content managed by a search engine in substantially the same manners described above.


Database-driven entity framework for internet of things

Owner:
Publication #: 09495401
Publication Date: 2016-11-15

Unified and normalized management of an object within a structured data store on any machine and/or across difference machines. In an embodiment, a first agent accesses a first request dataset representing a two-dimensional structure. Each row in the request dataset comprises an identification of an agent, a statement, an identification of a resource to execute the statement, and one of a plurality of request types. Each row in the request dataset is processed according to the identification of the agent in the row. When the identified agent is the first agent, the request type of the row is accessed, and one or more elements in the row are processed based on the request type. When the identified agent is not the first agent, the row is sent within a second request dataset to the identified agent (which may be on a different machine than the first agent) for processing.


System and method for intelligent database backup

Owner: ACTIFIO, INC.
Publication #: 09495435
Publication Date: 2016-11-15

Systems and methods are provided for backing up database storage. A protection policy for database storage is activated at a remote host, wherein the database storage is not physically accessible by the computing device, such that the out-of-band storage is not in communication with the remote host through the computing device. A backup request is transmitted to the remote host comprising data indicative of a volume on the database storage to back up according to the protection policy. A response to the backup request is received comprising staging disk requirements including a required size for a staging disk. A staging disk is determined based on the response. The staging disk is presented to the remote host so that the remote host can perform a backup of the volume to the staging disk using a database backup tool provided by a vendor of the database storage.


System and method for accessing dimensional databases

Owner: Dell Software Inc.
Publication #: 09495437
Publication Date: 2016-11-15

In one embodiment, a method includes defining a slice of a dimensional database. The slice includes at least one dimension and at least one measurement and is expressable as a table. The method further includes building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases. The SQL dialect represents the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases. In addition, the method includes parsing the single query. The parsing includes generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases. Furthermore, the method includes executing the dimensional query on the dimensional database. Moreover, the method includes, for each non-dimensional database of the one or more non-dimensional databases, executing the non-dimensional query on the non-dimensional database.


Gateway enablement of analytic database services

Owner: SAP SE
Publication #: 09489436
Publication Date: 2016-11-08

An example database system comprises one or more database servers configured to serve database data of a database and configured to provide database services and a generic database gateway server coupled to the one or more database servers, the generic database gateway server configured to provide an interface to define analytic database services which can be called during run-time by inputting a uniform resource identifier at a user device to provide to the user device with database server data processed by one or more predefined analytic operations, the generic database gateway server being configured to obtain, during design time, a specification of an analytic database service by selecting database server data of the one or more database servers and one or more analytic operations to be applied on the selected data by the analytic database service, convert the obtained specification of the analytic database service into one or more objects in a format that can be processed on the one or more database servers, wherein the one or more objects include one or more analytic database service data objects specifying one or more attributes of the analytic database service and one or more analytic database service metadata objects, the one or more analytic database service metadata objects including annotations to the attributes of the one or more analytic database service data objects to be processed by the one or more database servers to implement the one or more predefined analytic operations and provide the one or more converted objects to the one or more database servers to be called by a user by inputting a uniform resource identifier.


Master data management database asset as a web service

Owner: Teradata US, Inc.
Publication #: 09489437
Publication Date: 2016-11-08

A method, system, apparatus, and article of manufacture is configured to expose a database asset as a web service. A relational database management system (RDBMS) that stores information is executed in a computer system. As part of a process and framework, a series of business rules and process workflows are maintained that manage data that resides in RDBMS tables. A rule is created that contains an application programming interface definition with predefined input and output for exposing the database asset as the web service. The rule is exposed as the web service. The web service is used to invoke a database operation based on the database asset, and to output a result.


Scheduling of splits and moves of database partitions

Owner: Amazon Technologies, Inc.
Publication #: 09489443
Publication Date: 2016-11-08

A system that implements a data storage service may store data in multiple replicated partitions on respective computing nodes on behalf of clients. A storage node may, based on the amount of provisioned resources on a given storage device or logical volume, identify candidate partition management operations to be performed, and may send information about the operations to a central partition management scheduler. The scheduler may apply a global prioritization scheme to determine an order in which to perform the candidate operations. The order may be based on whether the operations include partition splits or partition moves, whether they aim to reduce provisioned storage capacity or reduce throughput capacity on a storage device or logical volume, whether they conflict with each other, whether the total number of partitions (or replicas thereof) involved in partition management at any given time exceeds a pre-determined limit, or whether they were requested by clients.


Isolating resources and performance in a database management system

Owner: Microsoft Technology Licensing, LLC
Publication #: 09477710
Publication Date: 2016-10-25

Techniques for tenant performance isolation in a multiple-tenant database management system are described. These techniques may include providing a reservation of server resources. The server resources reservation may include a reservation of a central processing unit (CPU), a reservation of Input/Output throughput, and/or a reservation of buffer pool memory or working memory. The techniques may also include a metering mechanism that determines whether the resource reservation is satisfied. The metering mechanism may be independent of an actual resource allocation mechanism associated with the server resource reservation.


Systems and user interfaces for dynamic access of multiple remote databases and synchronization of data based on user rules

Owner: CONSUMERINFO.COM, INC.
Publication #: 09477737
Publication Date: 2016-10-25

A computing system is configured to access a plurality of remote databases in order to identify data inconsistencies between the remote databases and provide user interfaces to a user in order to initiate communication via one or more APIs to certain remote databases indicating updates that reconcile said data inconsistencies.


Intermediate data format for database population

Owner: International Business Machines Corporation
Publication #: 09471653
Publication Date: 2016-10-18

An approach is provided that receives input from multiple data sources and transforms it into a common, intermediate format, where only one generic parser is required for the purpose of transformation into RDF, and the subsequent input to a triplestore database. A triplestore management tool provides this capability. The triplestore management tool includes a formatting component configured to receive data sources from a plurality of data source parsers, and transform each of the data sources into a single format. A parsing component parses each transformed data source at a common parser, and loads each of the transformed data sources from the common parser to a triplestore database.


Metric gathering and reporting system for identifying database performance and throughput problems

Owner: SECUREWORKS CORP.
Publication #: 09465850
Publication Date: 2016-10-11

A database back end system includes a monitoring server operable to poll a first database for a first query running on the first database and add the first query to a query list in a second database, and a reporting server operable to normalize the first query, analyze the second database to find a second query in the query list, wherein the second query is found based upon the normalized first query, and report the second query to a user, wherein the reporting is based upon the analyzing of the second database to find the second query.


Rotational maintenance of database partitions

Owner: Amazon Technologies, Inc.
Publication #: 09460126
Publication Date: 2016-10-04

A distributed database management system may comprise a group of partitions that includes a master writeable partition and one or more additional partitions that act as read-only replicas of the master. A rotational mechanism for performing maintenance operations on non-master partitions may be employed to transition a second partition, selected for undergoing maintenance, into a role as the new master following performance of the maintenance operation.


Managing databases in data storage systems

Owner: EMC Corporation
Publication #: 09460136
Publication Date: 2016-10-04

There is disclosed a method for use in managing databases in data storage systems comprising a plurality of nodes. A request is received to provision storage for a specified application intending to use a database. Based on application-awareness, the storage system is provisioned for storing the database in response to receiving the request. Database tables are distributed across the nodes based on a forecasted first I/O profile between application and database. Information is captured in connection with the activity between the application and database. A second I/O profile is determined based on the captured information. The second I/O profile is an actual in-running I/O profile between application and database. The first I/O profile and second I/O profile are compared. The database tables are re-organized on the nodes based on the comparison identifying a discrepancy between first and second I/O profiles such that storage system is rebalanced.


Storage device selection for database partition replicas

Owner: Amazon Technologies, Inc.
Publication #: 09460185
Publication Date: 2016-10-04

A system that implements a data storage service may store data in multiple replicated partitions on respective storage nodes. The selection of the storage nodes (or storage devices thereof) on which to store the partition replicas may be performed by administrative components that are responsible for partition management and resource allocation for respective groups of storage nodes (e.g., based on a global view of resource capacity or usage), or the selection of particular storage devices of a storage node may be determined by the storage node itself (e.g., based on a local view of resource capacity or usage). Placement policies applied at the administrative layer or storage layer may be based on the percentage or amount of provisioned, reserved, or available storage or IOPS capacity on each storage device, and particular placements (or subsequent operations to move partition replicas) may result in an overall resource utilization that is well balanced.


Creation of a graph database of a virtualization infrastructure

Owner: VMware, Inc.
Publication #: 09460187
Publication Date: 2016-10-04

In a computer-implemented method for creating a graph database of a virtualization infrastructure, data defining entities and relationships of the entities of a virtualization infrastructure is received at a graph database, wherein the relationships of the entities are in accordance with an inventory structure of the virtualization infrastructure. The graph database is populated with the entities and the relationships of the entities of the virtualization infrastructure.


Secure storage and retrieval of data in a database with multiple data classes and multiple data identifiers

Owner: EMC Corporation
Publication #: 09455973
Publication Date: 2016-09-27

Secure storage and retrieval of data is provided with multiple data classes and data identifiers. Data values of a client are stored by receiving one or more authentication sets, at least one data value, an associated data class of the data value and a pseudo-random client value; calculating a data seed value based on the pseudo-random client value, a pseudo-random server value and the associated data class of the data value; generating a random data index value; generating a database index value based on the data seed value and the random data index value; storing the database index value; and providing the random data index value to the client. The client can be authenticated at the time of storage based on the one or more authentication sets. The authentication of the client and the storage of the data can be atomic such that only authenticated clients store the one or more data values. Techniques are also provided for the retrieval of stored data.


Streaming restore of a database from a backup system

Owner: Amazon Technologies, Inc.
Publication #: 09449038
Publication Date: 2016-09-20

A distributed data warehouse system may maintain data blocks on behalf of clients in multiple clusters in a data store. Each cluster may include a single leader node and multiple compute nodes, each including multiple disks storing data. The warehouse system may store primary and secondary copies of each data block on different disks or nodes in a cluster. Each node may include a data structure that maintains metadata about each data block stored on the node, including its unique identifier. The warehouse system may back up data blocks in a remote key-value backup storage system with high durability. A streaming restore operation may be used to retrieve data blocks from backup storage using their unique identifiers as keys. The warehouse system may service incoming queries (and may satisfy some queries by retrieving data from backup storage on an as-needed basis) prior to completion of the restore operation.


Automatic repair of corrupted blocks in a database

Owner: Amazon Technologies, Inc.
Publication #: 09449039
Publication Date: 2016-09-20

A distributed data warehouse system maintains data blocks on behalf of clients, and stores primary and secondary copies of data blocks on different disks or nodes in a cluster. The data warehouse system may back up data blocks in a key-value backup storage system. In response to a query targeting a data block previously stored in the cluster, the data warehouse system may determine whether a consistent, uncorrupted copy of the data block is available in the cluster (e.g., by applying a consistency check). If not (e.g., if a disk or node failed), the data warehouse system may automatically initiate an operation to restore the data block from the backup storage system, using a unique identifier of the data block to access a backup copy. The target data may be returned in a query response prior to restoring primary and secondary copies of the data block in the cluster.


Customizable storage system for virtual databases

Owner: Delphix Corp.
Publication #: 09436556
Publication Date: 2016-09-06

A database storage system provides replication capability that allows data from a source database and application specific data from a source application to be replicated respectively to a target database storage system and a target application, thereby creating a virtual database and a virtual application. The database storage system generates a plurality of snapshots of the virtual database at a corresponding plurality of time points and a plurality of snapshots of the virtual application at the corresponding plurality of time points. The database storage system associates the plurality of snapshots of the virtual database with the plurality of snapshots of the virtual application at the corresponding plurality of time points so as to generate a historical time-sequence of concurrent modifications to both the virtual database and the virtual application at the one or more development environments, thereby allowing concurrent read/write and rollback, of data and applications.


Optimization of mixed database workload scheduling and concurrency control by mining data dependency relationships via lock tracking

Owner: International Business Machines Corporation
Publication #: 09436721
Publication Date: 2016-09-06

The present disclosure relates generally to the field of determining data access patterns associated with different workloads. In various examples, determining data access patterns associated with different workloads may be implemented in the form of systems, methods and/or algorithms. The present disclosure also relates generally to the field of scheduling workloads (and/or recommending scheduling for workloads) based upon the determined data access patterns associated with the different workloads. In various examples, scheduling workloads (and/or recommending scheduling for workloads) may be implemented in the form of systems, methods and/or algorithms.


Migrating data in tables in a database

Owner: SAP SE
Publication #: 09436724
Publication Date: 2016-09-06

Techniques for migrating data in a database include identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response: updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status indicates to update the target table, and in response: updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table.


Implementation of clustered in-memory database

Owner: QBase, LLC
Publication #: 09430547
Publication Date: 2016-08-30

An in-memory database system and method for administrating a distributed in-memory database, comprising one or more nodes having modules configured to store and distribute database partitions of collections partitioned by a partitioner associated with a search conductor. Database collections are partitioned according to a schema. Partitions, collections, and records, are updated and removed when requested by a system interface, according to the schema. Supervisors determine a node status based on a heartbeat signal received from each node. Users can send queries through a system interface to search managers. Search managers apply a field processing technique, forward the search query to search conductors, and return a set of result records to the analytics agents. Analytics agents perform analytics processing on a candidate results records from a search manager. The search conductors comprising partitioners associated with a collection, search and score the records in a partition, then return a set of candidate result records after receiving a search query from a search manager.


Optimizing data synchronization between mobile clients and database systems

Owner: salesforce.com, inc.
Publication #: 09424329
Publication Date: 2016-08-23

Mechanisms and methods are provided for optimizing data synchronization between clients and database systems. These mechanisms and methods provide optimizations for synchronization requests, by either breaking a synchronization request into multiple smaller requests, or by executing different code routines for differing client types, or by pre-caching data that a user is anticipated to want at a future point. Such optimization techniques can enable clients with varying capacities (e.g., mobile client vs. full desktop client) to optimally utilize their respective device capabilities.


Method for efficiently processing comments to records in a database, while avoiding replication/save conflicts

Owner: GOOGLE INC.
Publication #: 09424553
Publication Date: 2016-08-23

A system for processing comment contents associated with a parent document by providing a parent document user interface including a display object enabling a user to enter comment contents, creating a comment document associated with said parent document and storing said comment contents in said comment document, obtaining said comment contents from said comment document and displaying said comment contents within a region of said parent document user interface, copying, in response to detecting a change of state of said parent document from a state in which comments can be added to a state in which comments cannot be added, said comment contents from said comment document into said parent document, deleting said comment document, and presenting said comment contents after deleting said comment document.


Database-independent mechanism for retrieving relational data as XML

Owner: Progress Software Corporation
Publication #: 09411851
Publication Date: 2016-08-09

Techniques are disclosed for retrieving both data stored in relational form and data stored in XML form responsive to a single XQuery query. The techniques allow applications to retrieve relational data residing in various relational database management systems by using XQuery and XQuery for Java. In one such embodiment, an embeddable serverless computer component implements the techniques, and includes a combination of one or more relational adaptors and a mediator to access relational data and transform it into appropriate XML. The techniques are embeddable, and can be standards-based, database-independent, and operating-system independent. Optimized performance and scalability from desktop to enterprise applications are enabled as the number of users and/or database size increases.


Mass delete restriction in a database

Owner: International Business Machines Corporation
Publication #: 09405788
Publication Date: 2016-08-02

In an approach for limiting mass deletions from database tables, a computer receives a deletion request corresponding to data in a database table. The computer determines whether the database table includes a restriction of a mass deletion. Responsive to determining the database table includes a restriction of a mass deletion of data from a database table, the computer determines whether the quantity of data in the deletion request exceeds the restriction of a mass deletion. Responsive to determining the quantity of data in the deletion request exceeds the restriction of a mass deletion, the computer prevents execution of the deletion request.


Systems and methods for managing replicated database data

Owner: Commvault Systems, Inc.
Publication #: 09396244
Publication Date: 2016-07-19

Systems and methods for replicating database data and generating read-only copies of the replicated data in a clean shutdown state. For example, systems can include a tracking module (e.g., a filter driver) that monitors transactions from a database application to a source storage device to generate log entries having at least one marker indicating a known good state of the application. The systems further include a computer coupled to a target storage device comprising a database and log files. The computer processes the transactions, based on the log entries, to replicate data to the target storage device; performs a first snapshot on data stored in the database and log files; replays into the database data stored in the log files; performs another snapshot on the database; and reverts the database back to a state in which the database existed at the time of the first snapshot.


Virtual database rewind

Owner: Delphix Corp.
Publication #: 09396074
Publication Date: 2016-07-19

A database storage system allows users to modify the state of a virtual database. The database storage system provides a respective virtual database (VDB) at a respective destination, the respective VDB having a first timeflow stored in a respective container. A user can send a request to rewind a VDB. The request identifies timeflow of the VDB and a state of the VDB associated with a timeflow. The database storage system modifies the virtual database to refer to database blocks associated with a snapshot of the VDB associated with the identified timeflow. The database storage system maintains a new timeflow for the modified VDB. The database storage system also allows the virtual database to be refreshed to a state of a source database. The source database can be a database stored in an external system or a virtual database stored within the database storage system.


Interfacing with a virtual database system

Owner: Delphix Corporation
Publication #: 09389962
Publication Date: 2016-07-12

User interactions with a database storage system allow creation of virtual databases based on point-in-time copies associated with a source database. Multiple point-in-time copies are obtained for each source database. A point-in-time copy retrieves data changed in the source database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system and mounting the files on a database server allowing the database server to access the files. User interactions allow the user to specify the source database, a point in time associated with the source database and a destination server to create the virtual database. User input can specify other attributes associated with the virtual database including the file paths, database parameters etc. The user can specify schedules of various actions, including making and retention of point-in-time copies.


Database architecture for storing multi-structured data

Owner: ZEPHYR HEALTH, INC.
Publication #: 09390159
Publication Date: 2016-07-12

In various embodiments, a system for ingesting, organizing, and storing data is disclosed. The system comprises a processor and a memory unit. A document database is stored by the memory unit. The document database is configured to store data without any foreknowledge of a structure of the data. The data comprises an ontology comprising a plurality of terms describing the data within the document database. A graph database is stored by the memory unit. The graph database comprises a materialized view of the document database. The graph database provides connections between the ontology. The document database and the graph database share common entity profile UUIDs.


Systems and methods for searching cloud-based databases

Owner: SoundHound, Inc.
Publication #: 09390434
Publication Date: 2016-07-12

Systems and methods for searching cloud-based databases are provided herein. A service provider may have a need to make their database(s) searchable through search technology. However, the service provider may not have the resources to implement such search technology. The search technology may allow for search queries against these cloud-based databases. The technology described herein provides a solution addressing the service provider's need, by giving a search technology that furnishes search results in a fast, accurate manner. In further embodiments, systems and methods to monetize those search results are also described herein.


Database query language gateway

Owner: INTERNATIONAL BUSINESS MACHINES CORPORATION
Publication #: 09384248
Publication Date: 2016-07-05

A method includes receiving a query request, generating a modified query in a database query language by modifying a stored query in the database query language based on the query request, and transmitting the modified query to a database endpoint. The method includes receiving query results in the database query language and converting by the processor the query results from the database query language to a format usable by a reporting engine.


Systems and methods for exporting, publishing, browsing and installing on-demand applications in a multi-tenant database environment

Owner: salesforce.com, inc.
Publication #: 09378227
Publication Date: 2016-06-28

In accordance with embodiments, there are provided mechanisms and methods for creating, exporting, viewing and testing, and importing custom applications in a multitenant database environment. These mechanisms and methods can enable embodiments to provide a vehicle for sharing applications across organizational boundaries. The ability to share applications across organizational boundaries can enable tenants in a multi-tenant database system, for example, to easily and efficiently import and export, and thus share, applications with other tenants in the multi-tenant environment.


Methods, systems, and computer-readable media for providing a query layer for cloud databases

Owner: Infosys Technologies, Ltd.
Publication #: 09372890
Publication Date: 2016-06-21

A method, non-transitory computer readable medium, and apparatus for receiving data from a cloud database. One or more queries requesting data from the cloud database are received. The one or more queries are converted from a row-store database query into a column-store database query. An optimal join plan is identified for the one or more queries using a cost based optimizer based on metadata for one or more relations in the cloud database. The optimal join plan is executed using a cloud application programming interface.


Method for efficient database formation and search on media devices acting synchronously with television programming

Owner: Gracenote, Inc.
Publication #: 09367544
Publication Date: 2016-06-14

Techniques for efficient database formation and search in applications embedded in a media device are provided. The search may be performed synchronously with presentation of media programming content on a nearby media presentation device. A mobile media device captures some temporal fragments of the presented audio/video content on its microphone and camera, and then generates query fingerprints for the captured fragment. A local reference database resides on the mobile media device and a master reference database resides on a remote server with a most recent chunk of reference fingerprints transferred dynamically to the local mobile media device. A chunk of the query fingerprints generated locally on the mobile media device are searched on the local reference database for continuous content search and identification. The method presented automatically switches between the local search on the mobile media device and a remote search on an external search server.


Methods and apparatus for suppressing network feed activities using an information feed in an on-demand database service environment

Owner: salesforce.com, inc.
Publication #: 09367643
Publication Date: 2016-06-14

Disclosed are systems, apparatus, methods, and computer readable media for suppressing network feed activities using an information feed in an on-demand database service environment. In one embodiment, a message is received, including data indicative of a user action. An entity associated with the user action is identified, where the entity is a type of record stored in a database. A type of the entity is identified. It is determined whether the entity type is a prohibited entity type. When the entity type is not a prohibited entity type, the message data is saved to one or more tables in the database. The tables are configured to store feed items of an information feed capable of being displayed on a device. When the entity type is a prohibited entity type, the saving of the message data, to the one or more tables in the database configured to store the feed items, is prohibited.


Systems and methods of using an artificially intelligent database management system and interfaces for mobile, embedded, and other computing devices

Owner:
Publication #: 09367806
Publication Date: 2016-06-14

The current disclosure generally relates to database management systems (DBMSs) and may be generally directed to methods and systems of using artificial intelligence (i.e. machine learning and/or anticipation functionalities, etc.) to learn a user's use of a DBMS, store this “knowledge” in a knowledgebase, and anticipate the user's future operating intentions. The current disclosure may also be generally directed to associative methods and systems of constructing DBMS commands. The current disclosure may also be generally directed to methods and systems of using a simplified DBMS command language (SDCL) for associative DBMS command construction. The current disclosure may also be generally directed to artificially intelligent methods and systems for associative DBMS command construction. The current disclosure may also be generally directed to methods and systems for associative DBMS command construction through voice input. Other methods, systems, features, elements and/or their embodiments are also disclosed.


Interfacing with a virtual database system

Owner: Delphix Corporation
Publication #: 09361186
Publication Date: 2016-06-07

User interactions with a database storage system allow creation of virtual databases based on point-in-time copies associated with a source database. Multiple point-in-time copies are obtained for each source database. A point-in-time copy retrieves data changed in the source database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system and mounting the files on a database server allowing the database server to access the files. User interactions allow the user to specify the source database, a point in time associated with the source database and a destination server to create the virtual database. User input can specify other attributes associated with the virtual database including the file paths, database parameters etc. The user can specify schedules of various actions, including making and retention of point-in-time copies.


Database replication

Owner: Google Inc.
Publication #: 09361348
Publication Date: 2016-06-07

A database server receives a request from a client application for performing a data transaction on persistent data storage. The request is sent to a set of replication servers. An acknowledgement for the request is received from each replication server, including a start sequence number and an end sequence number for data that is stored in local cache of the replication server, and a latest committed sequence number for data that was written to the persistent data storage by the replication server. A maximum value of latest committed sequence numbers received from the set of replication servers is determined. For each replication server, it is examined whether there is a gap between the start sequence number for data stored in local cache and the maximum value of the latest committed sequence numbers. Based on the examining, it is determined whether there is an occurrence of loss of data.


Accessing schema-free databases

Owner: EMC Corporation
Publication #: 09361359
Publication Date: 2016-06-07

Accessing a schema-free database includes constructing a model indicating a structure for the data to be used by applications accessing the data, validating the model based on the structure and on the data stored in the schema-free database, providing an API based on the structure, and accessing the database using the API. The model may be constructed by extracting data structure information from a program. The program may be written in the Ruby programming language or the Python programming language. The API may be a RESTful API.


Using a graph database of a virtualization infrastructure

Owner: VMware, Inc.
Publication #: 09355163
Publication Date: 2016-05-31

In a computer-implemented method for providing management of a virtualization infrastructure, a query related to the virtualization infrastructure is received. A graph database of the virtualization infrastructure is accessed, the graph database including nodes associated with members of the virtualization infrastructure and edges associated with relationships of the members of the virtualization infrastructure, wherein the nodes and the relationships include types. An answer to the query is received from the graph database.


Systems and methods for searching cloud-based databases

Owner: Soundhound, Inc.
Publication #: 09355407
Publication Date: 2016-05-31

Systems and methods for searching cloud-based databases are provided herein. A service provider may have a need to make their database(s) searchable through search technology. However, the service provider may not have the resources to implement such search technology. The search technology may allow for search queries against these cloud-based databases. The technology described herein provides a solution addressing the service provider's need, by giving a search technology that furnishes search results in a fast, accurate manner. In further embodiments, systems and methods to monetize those search results are also described herein.


Searching content managed by a search engine using relational database type queries

Owner: INTERNATIONAL BUSINESS MACHINES CORPORATION
Publication #: 09348870
Publication Date: 2016-05-24

According to one embodiment of the present invention, a system searches content managed by a search engine. The system receives a relational database type query, translates the relational database type query into a query for the search engine, and submits the translated query to the search engine to retrieve information. The system formats resulting information from the search engine into a relational database query result set. Embodiments of the present invention further include a method and computer program product for searching content managed by a search engine in substantially the same manners described above.


Managing a binary object in a database system

Owner: Microsoft Technology Licensing, LLC
Publication #: 09336218
Publication Date: 2016-05-10

A method for managing a binary object in a database system is provided. The method may include receiving a request to store the binary object and determining if a size of the binary object is above a first threshold. If the size is less than the first threshold, the method may include storing the binary object in a database of the database system using a database communication protocol. If the size is above the first threshold, the method may include determining if the size is above a second threshold. To this end, if the size is less than the second threshold, the method may include storing the binary object in a file system of the database system using the database communication protocol. Furthermore, if the size is above the second threshold, the method may include storing the binary object in the file system using a file system communication protocol.


Techniques for accessing a parallel database system via external programs using vertical and/or horizontal partitioning

Owner: Teradata US, Inc.
Publication #: 09336270
Publication Date: 2016-05-10

Techniques for accessing a parallel database system via an external program using vertical and/or horizontal partitioning are provided. An external program to a database management system (DBMS) configures external mappers to process a specific portion of query results on specific access module processors of the DBMS that are to house query results. The query is submitted by the external program to the DBMS and the DBMS is directed to organize the query results in a vertical or horizontal manner. Each external mapper accesses its portion of the query results for processing in parallel on its designated AMP or set of AMPS to process the query results.


Collection of web server performance metrics to a centralized database for reporting and analysis

Owner: Sprint Communications Company L.P.
Publication #: 09330051
Publication Date: 2016-05-03

Systems, methods, and computer-readable media are provided for, among other things, generating web server performance metrics from log file information and storing the metrics offline in a centralized database. A collector accesses log file information from a log file for a web server and generates web server performance metrics on a per web page basis. The web server metrics include a number of requests for a web page, error count for the web page, average response time for the web page, total number of bytes transferred for the web page, and a number of times a service level objection for the web page was exceeded. The web server metrics are stored in a centralized database such that the metrics are available for offline web server performance reporting and analysis.


Methods and systems to facilitate providing spreadsheet and database data to users via a social network

Owner: SAP SE
Publication #: 09330080
Publication Date: 2016-05-03

A spreadsheet application platform facilitates accessing a spreadsheet stored using a spreadsheet database at a server computer. The spreadsheet application platform includes a computer-implemented social network, and a publisher may use the social network to publish a spreadsheet so that other users of the social network may subscribe to and access the spreadsheet's data. Further, a subscribed user may generate other spreadsheets that reference the publisher's spreadsheet via the application platform. When a stored value for a cell of the publisher's spreadsheet is updated at the spreadsheet database, the application platform may generate update requests for one or more target spreadsheet cells that reference the updated cell. An update request may indicate that a target cell is to be updated, and the application platform may process a plurality of update requests in parallel to update the stored values for a corresponding plurality of spreadsheet cells.


Transient virtual single tenant queries in a multi-tenant shared database system

Owner: XACTLY CORPORATION
Publication #: 09330140
Publication Date: 2016-05-03

A data processing method comprising using an application server computer, establishing a shared multi-tenant system in which tenant data that is associated with tenants is stored together in a real shared data store system; providing to a tenant computing device identifiers that identify virtual objects, wherein each of the virtual objects represents a data entity that is stored in the real shared data store system; receiving a SQL query from the tenant computing device that specifies a data operation on a first virtual object of the virtual objects; rewriting the SQL query by dynamically replacing the first virtual object with an identifier of a function; executing the function and the rewritten query without explicit metadata to generate a result set; sending the result set to the tenant computing device.


Application programming interface (API) for navigation applications that merges incremental updates with existing map database

Owner: GM Global Technology Operations LLC
Publication #: 09304005
Publication Date: 2016-04-05

A system and method for efficiently updating the map database in a mobile computing system, such as a vehicle navigation system. The system includes a central server that computes changes between the latest version of a master map database and a previous version of the map database, and wirelessly transmits the changes to participating vehicles' onboard navigation systems. The navigation system stores the changes in a look-aside buffer, and a navigation processor uses the stored changes to update a base map database.


Systems, methods, and apparatuses for implementing data upload, processing, and predictive query API exposure

Owner: salesforce.com, inc.
Publication #: 09367853
Publication Date: 2016-06-14

Disclosed herein are systems and methods for implementing data upload, processing, and predictive query API exposure including means for receiving a dataset in a tabular form, the dataset having a plurality of rows and a plurality of columns; processing the dataset to generate indices representing probabilistic relationships between the rows and the columns of the dataset; storing the indices in a database; exposing an Application Programming Interface (API) to query the indices in the database; receiving a request for a predictive query or a latent structure query against the indices in the database; querying the database for a prediction based on the request via the API; and returning the prediction responsive to the request. Other related embodiments are further disclosed.


I tend to process the new patent filings and publications every couple of weeks. When ready I try to publish them along with my research.