Patents by Inventor Robert Hanckel
Robert Hanckel has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11170002Abstract: Techniques are described herein for analyzing data streams in conjunction with relational database data in a DBMS. A database dictionary defines one or more columns for an external table and a data source for said external table that comprises an external message stream. Executing a query that targets the external table includes generating one or more rows from the external table, each row corresponding to a message in the external message stream that was retrieved from the external message stream after a message stream offset.Type: GrantFiled: October 4, 2019Date of Patent: November 9, 2021Assignee: Oracle International CorporationInventors: Robert Hanckel, Manjari D. Yalavarthy, Rongzheng Yan, Chen Cao
-
Patent number: 10756947Abstract: Systems, methods, and other embodiments associated with logging event messages in a computing grid using a distributed memory are described. In one embodiment, a method includes storing, in a distributed memory, a batch of log messages received from one of a plurality of handlers. Storing the batch in the distributed memory includes storing the batch in one of a plurality of memories that are part of the distributed memory and storing the batch with a group of batches from the plurality of handlers. The example method may also include generating, after a predefined period of time has elapsed, a formal log from the group of batches. The predefined period of time is an amount of time after a reporting period within which batches from the reporting period are expected to arrive in the distributed memory. The formal log includes sorted messages from the group of batches.Type: GrantFiled: January 20, 2014Date of Patent: August 25, 2020Assignee: Oracle International CorporationInventor: Robert Hanckel
-
Publication number: 20200125572Abstract: Techniques are described herein for analyzing data streams in conjunction with relational database data in a DBMS. A database dictionary defines one or more columns for an external table and a data source for said external table that comprises an external message stream. Executing a query that targets the external table includes generating one or more rows from the external table, each row corresponding to a message in the external message stream that was retrieved from the external message stream after a message stream offset.Type: ApplicationFiled: October 4, 2019Publication date: April 23, 2020Inventors: ROBERT HANCKEL, MANJARI D. YALAVARTHY, RONGZHENG YAN, CHEN CAO
-
Patent number: 10108682Abstract: A method and system to creating query-level access to an external distributed file system by identifying a location of one or more external data residing on the external distributed file system, creating a query specifying an external table within a database engine having one or more location files, wherein the location files identify metadata operations for accessing and processing the one or more external data, defining metadata operations for accessing and processing the one or more external data, wherein the processing that produces one or more result files occurs at the external distributed file system, and executing the query at the database engine to create the external table, the external table comprising the one or more location files identifying the metadata directives for processing query-level requests on the one or more external data stored on the external distributed file system.Type: GrantFiled: March 6, 2017Date of Patent: October 23, 2018Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Robert Hanckel, Garret Swart
-
Publication number: 20170242901Abstract: A method and system to creating query-level access to an external distributed file system by identifying a location of one or more external data residing on the external distributed file system, creating a query specifying an external table within a database engine having one or more location files, wherein the location files identify metadata operations for accessing and processing the one or more external data, defining metadata operations for accessing and processing the one or more external data, wherein the processing that produces one or more result files occurs at the external distributed file system, and executing the query at the database engine to create the external table, the external table comprising the one or more location files identifying the metadata directives for processing query-level requests on the one or more external data stored on the external distributed file system.Type: ApplicationFiled: March 6, 2017Publication date: August 24, 2017Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Robert HANCKEL, Garret SWART
-
Patent number: 9742624Abstract: Systems, methods, and other embodiments associated with intelligently processing log messages are described. In one embodiment, a computer-implemented method includes analyzing, by a logging appliance that includes at least hardware, communications received from a plurality of handlers to determine whether at least one of the communications indicates an error has been encountered by one of a plurality of components associated with the plurality of handlers. The method includes scheduling a subset of the plurality of handlers to provide reports that include a detailed set of log messages in response to detecting the error. The subset of the plurality of handlers includes handlers that are associated with the error.Type: GrantFiled: January 21, 2014Date of Patent: August 22, 2017Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Robert Hanckel, Parthiban Thilagar
-
Patent number: 9589036Abstract: A system to implement query-level access by a database engine to an external distributed file system by identifying a results file location of one or more results files on the external distributed file system, and storing the results file locations in external table files on the database engine for subsequent use during retrieval of data from the results files. The database engine serves to process queries where the query specifies the external table (which in turn references locations of the results files). Execution of the query streams data from the external distributed file system into the database engine. The data from the external distributed file system is not stored in the external table files on the database engine; rather, the external table files specify a location of code or operational directives which, when executed, streams results from the external distributed file system to at least one parallel query engine.Type: GrantFiled: August 1, 2012Date of Patent: March 7, 2017Assignee: Oracle International CorporationInventors: Robert Hanckel, Garret Swart
-
Patent number: 9501346Abstract: Systems, methods, and other embodiments associated with intelligently gathering log messages are described. In one embodiment, a computer-implemented method includes collecting, by a logging handler associated with a component, log messages according to two different granularities for logging messages. The two different granularities include a fine granularity and a coarse granularity. Collecting the log messages according to the fine granularity includes storing log messages in an incident buffer. The method includes, in response to detecting an error at the component, (i) freezing the incident buffer to preserve log messages present in the incident buffer, and (ii) communicating log messages that are collected according to the coarse granularity that are stored in a regular buffer to a logging appliance.Type: GrantFiled: January 21, 2014Date of Patent: November 22, 2016Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Robert Hanckel, Parthiban Thilagar
-
Patent number: 9384222Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.Type: GrantFiled: April 5, 2012Date of Patent: July 5, 2016Assignee: Oracle International CorporationInventors: Jayanta Banerjee, Robert Hanckel, Siva Ravada
-
Publication number: 20150205696Abstract: Systems, methods, and other embodiments associated with intelligently gathering log messages are described. In one embodiment, a computer-implemented method includes collecting, by a logging handler associated with a component, log messages according to two different granularities for logging messages. The two different granularities include a fine granularity and a coarse granularity. Collecting the log messages according to the fine granularity includes storing log messages in an incident buffer. The method includes, in response to detecting an error at the component, (i) freezing the incident buffer to preserve log messages present in the incident buffer, and (ii) communicating log messages that are collected according to the coarse granularity that are stored in a regular buffer to a logging appliance.Type: ApplicationFiled: January 21, 2014Publication date: July 23, 2015Inventors: Robert HANCKEL, Parthiban THILAGAR
-
Publication number: 20150207855Abstract: Systems, methods, and other embodiments associated with logging event messages in a computing grid using a distributed memory are described. In one embodiment, a method includes storing, in a distributed memory, a batch of log messages received from one of a plurality of handlers. Storing the batch in the distributed memory includes storing the batch in one of a plurality of memories that are part of the distributed memory and storing the batch with a group of batches from the plurality of handlers. The example method may also include generating, after a predefined period of time has elapsed, a formal log from the group of batches. The predefined period of time is an amount of time after a reporting period within which batches from the reporting period are expected to arrive in the distributed memory. The formal log includes sorted messages from the group of batches.Type: ApplicationFiled: January 20, 2014Publication date: July 23, 2015Inventor: Robert HANCKEL
-
Publication number: 20150207709Abstract: Systems, methods, and other embodiments associated with intelligently processing log messages are described. In one embodiment, a computer-implemented method includes analyzing, by a logging appliance that includes at least hardware, communications received from a plurality of handlers to determine whether at least one of the communications indicates an error has been encountered by one of a plurality of components associated with the plurality of handlers. The method includes scheduling a subset of the plurality of handlers to provide reports that include a detailed set of log messages in response to detecting the error. The subset of the plurality of handlers includes handlers that are associated with the error.Type: ApplicationFiled: January 21, 2014Publication date: July 23, 2015Inventors: Robert HANCKEL, Parthiban THILAGAR
-
Publication number: 20140040310Abstract: A system to implement query-level access by a database engine to an external distributed file system by identifying a results file location of one or more results files on the external distributed file system, and storing the results file locations in external table files on the database engine for subsequent use during retrieval of data from the results files. The database engine serves to process queries where the query specifies the external table (which in turn references locations of the results files). Execution of the query streams data from the external distributed file system into the database engine. The data from the external distributed file system is not stored in the external table files on the database engine; rather, the external table files specify a location of code or operational directives which, when executed, streams results from the external distributed file system to at least one parallel query engine.Type: ApplicationFiled: August 1, 2012Publication date: February 6, 2014Applicant: Oracle International CorporationInventors: Robert HANCKEL, Garret SWART
-
Publication number: 20120191682Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.Type: ApplicationFiled: April 5, 2012Publication date: July 26, 2012Applicant: Oracle International CorporationInventors: Jayanta BANERJEE, Robert Hanckel, Siva Ravada
-
Patent number: 8156083Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.Type: GrantFiled: December 1, 2005Date of Patent: April 10, 2012Assignee: Oracle International CorporationInventors: Jayanta Banerjee, Robert Hanckel, Siva Ravada
-
Patent number: 7970742Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The history table's rows are copies of rows of the history-enabled table that have changed and include start time and end time fields whose values indicate a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table. The temporal queries are speeded up by period of time indexes in which the leaves are grouped based on time period size, identifiers are assigned to the groups, and the keys of the index include the group identifiers.Type: GrantFiled: December 1, 2005Date of Patent: June 28, 2011Assignee: Oracle International CorporationInventors: Robert Hanckel, Jayanta Banerjee, Siva Ravada
-
Publication number: 20070130171Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The history table's rows are copies of rows of the history-enabled table that have changed and include start time and end time fields whose values indicate a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table. The temporal queries are speeded up by period of time indexes in which the leaves are grouped based on time period size, identifiers are assigned to the groups, and the keys of the index include the group identifiers.Type: ApplicationFiled: December 1, 2005Publication date: June 7, 2007Inventors: Robert Hanckel, Jayanta Banerjee, Siva Ravada
-
Publication number: 20070130226Abstract: Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.Type: ApplicationFiled: December 1, 2005Publication date: June 7, 2007Inventors: Jayanta Banerjee, Robert Hanckel, Siva Ravada
-
Patent number: 7174340Abstract: Interval-based adjustments to data are applied by a relational database engine. The engine stores raw, unadjusted data values in a separate table from adjustment values. The adjustment values are dynamically updated in response to a new adjustment interval. The adjustments are applied to the raw data during retrieval from the database. This results in an efficient and transparent adjustment to data.Type: GrantFiled: August 17, 2000Date of Patent: February 6, 2007Assignee: Oracle International CorporationInventors: Lory Molesky, Robert Hanckel