What is Mass Data Analysis Service?

  • Currently, B-Box™ may store up to approximately 16,000 columns, and 1,000,000 rows of data, on par with Microsoft Excel.
  • Mass Data Analysis Service enables the user to analyze large amounts of data that exceed the above limits (in reality, the performance suffers significantly with data exceeding 50% of these limits).
  • By linking a database with B-Box™, the user can handle the data and apply all the analytical techniques that B-Box™ provides.
  • To view the data, the available tools are CalebABC Prism™, which is an OLAP (On-Line Analytic Processing) tool, and CalebABC ePrism™, which is a web-based reporting tool.
  • If you would like to use Mass Data Analysis Service, please contact 82-2-322-1342 to speak to our B-Box™ representative.

DB Link for Mass Data Analysis Service

What is DB Link?

  • DB Link overcomes the limitations on handling data with over 1,000,000 rows on the grid, enabling the utilization of data on the original database by extracting data through a pre-defined DB Link. Verifications and statistical analyses of mass data are then performed. The data extracted from the original DB and results of analyses are saved on a separate B-Box™ database.

    • System Environment

  • DB Administrator’s assistance is required for Service Environment Configuration of DB Link

    • Analysis Flow

Analysis procedure

DB Access

  • Define a new DB environment, and test for the DB connection.

Table

  • From the table list in the Source DB, select a table to be analyzed.

Field

  • Define the field information to be used for analysis from the selected table. Multiple data can be registered within the same table.

Extraction

  • Confirm the number of rows of the designated data, and extract it to either B-Box™ DB, or the Grid. The maximum number of rows that can be extracted to the Grid is 1,048,576. If exceeded, data extraction will be incomplete. With a Right-Click, connection with “CalebABC Prism” will be established. Raw data may be viewed by entering the name of the corresponding report.

B-Box™

  • If data is extracted to B-Box™ DB, click on “Import to B-Box™” to load the data into B-Box. From then on, the data can be analyzed using “Data Mining” and “Data Analysis”.