Patents Assigned to MACHBASE, INC.
  • Patent number: 11068463
    Abstract: A system and method for efficiently managing log data to be transferred to a DBMS (database management system). The system includes a processor that detects a change in a log file and reads a log message; performs a first preprocessing to change the content of the log message when it is decided that inputting the log message to the DBMS is necessary, and that changing of the content of the log message is necessary; generates column data by parsing on the first preprocessed log message and separating the parsed log message into columns; performs a second preprocessing to change the content of the column data when it is decided that inputting the column data to the DBMS is necessary, and that changing of the content of the column data is necessary; and provides the second preprocessed column data to the DBMS.
    Type: Grant
    Filed: August 21, 2017
    Date of Patent: July 20, 2021
    Assignee: Machbase, Inc.
    Inventor: Sung Jin Kim
  • Patent number: 10749764
    Abstract: A device for generating and searching sensor tag data in real time is provided. The device can include a rollup executor that is configured to generate statistics data per time from raw data; and a rollup memory storing per-second statistics data in units of seconds for new input data and per-minute statistics data in units of minutes for the per-second statistics data, where the statistics data can be automatically calculated and provided by the system by using statistics for time series sensor tag data based on tag names/times.
    Type: Grant
    Filed: August 22, 2018
    Date of Patent: August 18, 2020
    Assignee: Machbase, Inc.
    Inventor: Sung Jin Kim
  • Patent number: 10706054
    Abstract: An embodiment of the invention provides a device for searching indexes for sensor tag data. The can include a memory that has sensor tag data stored as a time series; an interface that is configured to receive tag names and time segment information for searching sensor tag data; and a processor that is configured to determine partitions of the memory having the sensor tag data stored therein based on the time segment information and configured to determine corresponding indexes and leaf nodes for the determined partitions based on the tag names and the time segment information. An embodiment of the invention can provide an optimized index structure for and a method of storing and searching time series sensor tag data with which most query patterns relating to time series sensor tag data can be satisfied.
    Type: Grant
    Filed: August 22, 2018
    Date of Patent: July 7, 2020
    Assignee: Machbase, Inc.
    Inventor: Sung Jin Kim
  • Publication number: 20200057818
    Abstract: An embodiment of the invention provides a device for searching indexes for sensor tag data. The can include a memory that has sensor tag data stored as a time series; an interface that is configured to receive tag names and time segment information for searching sensor tag data; and a processor that is configured to determine partitions of the memory having the sensor tag data stored therein based on the time segment information and configured to determine corresponding indexes and leaf nodes for the determined partitions based on the tag names and the time segment information. An embodiment of the invention can provide an optimized index structure for and a method of storing and searching time series sensor tag data with which most query patterns relating to time series sensor tag data can be satisfied.
    Type: Application
    Filed: August 22, 2018
    Publication date: February 20, 2020
    Applicant: Machbase, Inc.
    Inventor: Sung Jin KIM
  • Publication number: 20200059422
    Abstract: A device for generating and searching sensor tag data in real time is provided. The device can include a rollup executor that is configured to generate statistics data per time from raw data; and a rollup memory storing per-second statistics data in units of seconds for new input data and per-minute statistics data in units of minutes for the per-second statistics data, where the statistics data can be automatically calculated and provided by the system by using statistics for time series sensor tag data based on tag names/times.
    Type: Application
    Filed: August 22, 2018
    Publication date: February 20, 2020
    Applicant: Machbase, Inc.
    Inventor: Sung Jin KIM
  • Patent number: 10452685
    Abstract: Provided herein are a method and an apparatus for replicating data. A master node or a data node stores data and indices in a table region including a plurality of data regions and a plurality of index regions, merges the plurality of index regions with one another to be one index region, and then replicates a table region including the plurality of data regions and the one index region to other nodes.
    Type: Grant
    Filed: May 26, 2017
    Date of Patent: October 22, 2019
    Assignee: MACHBASE INC.
    Inventor: Sung Jin Kim
  • Patent number: 10380111
    Abstract: The present disclosure relates to a data search system capable of providing increased speed in searching large-volume time series data in a DBMS. A data search system according to an embodiment of the invention may be implemented by a computing terminal as a system for searching data. The system may include: a query optimizer that checks whether or not a parallel scan is possible for a search target data table and generates a query execution plan; a parallel scan manager module that conducts a parallel scan on the table; and a query executer that executes the query execution plan generated by the query optimizer and, if a parallel scan is possible for the table, calls the parallel scan manager module, where the parallel scan manager module determines whether or not to execute a parallel scan by comparing the number of records forming the table with a preset value.
    Type: Grant
    Filed: August 21, 2017
    Date of Patent: August 13, 2019
    Assignee: Machbase, Inc.
    Inventor: Sung Jin Kim
  • Publication number: 20190057132
    Abstract: The present disclosure relates to a data search system capable of providing increased speed in searching large-volume time series data in a DBMS. A data search system according to an embodiment of the invention may be implemented by a computing terminal as a system for searching data. The system may include: a query optimizer that checks whether or not a parallel scan is possible for a search target data table and generates a query execution plan; a parallel scan manager module that conducts a parallel scan on the table; and a query executer that executes the query execution plan generated by the query optimizer and, if a parallel scan is possible for the table, calls the parallel scan manager module, where the parallel scan manager module determines whether or not to execute a parallel scan by comparing the number of records forming the table with a preset value.
    Type: Application
    Filed: August 21, 2017
    Publication date: February 21, 2019
    Applicant: Machbase, Inc.
    Inventor: Sung Jin KIM
  • Publication number: 20190057125
    Abstract: Disclosed are a system and a method for managing log data. The system includes: a log collector part that detects a change in a log file and reads a log message, which includes newly inputted log data information; a first preprocessing command generator part that receives the log message via the log collector part, decides whether or not to input the log message to a DBMS or whether or not to change a content of the log message, and generates a command to preprocess the log message according to the decision; a log analyzer part that preprocesses the log message according to the command generated at the first preprocessing command generator part, performs parsing on the preprocessed log message, and generates column data by separating the parsed log message into columns; and a log transmitter part that provides the column data of the log analyzer part to the DBMS.
    Type: Application
    Filed: August 21, 2017
    Publication date: February 21, 2019
    Applicant: Machbase, Inc.
    Inventor: Sung Jin KIM
  • Patent number: 10120768
    Abstract: A data management system for backup, recovery, and mount of a partition including a specific number of records recorded in a time-series mode includes a backup managing part configured to record partition data in a backup file in response to an input conditional clause, and a recovery processing part configured to recover a database by reading the backup file in a case of receiving a recovery instruction, wherein the partition data includes at least a part of time-series data and is classified from other partition data through a partition index to which a recording time of the at least a part of time-series data is applied.
    Type: Grant
    Filed: September 14, 2016
    Date of Patent: November 6, 2018
    Assignee: MACHBASE, INC.
    Inventor: Sung Jin Kim