# US 2025/0094698 A1 · Integrated management device based on big data platform, method and system > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2025/0094698 A1 - Document ID: US20250094698A1 - Status: Published application - Kind: A1 - Application number: 18/493,158 - Filed: 2023-10-24 - Published: 2025-03-20 - Earliest claimed: 2023-09-20 - Assignees: Archivsoft Co., Ltd. - Applicants: Archivsoft Co., Ltd. - Inventors: Ji Sung KIM; Jong Eun CHAE - Web page: https://patentgrep.com/patent/US20250094698A1 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/258: {Data format conversion from or to a database} - G06F 16/284: {Relational databases} - G06F 40/106: Display of layout of documents; Previewing - G06V 30/19: Recognition using electronic means - G06V 30/412: Layout analysis of documents structured with printed lines or input boxes, e.g. business forms or tables - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06V: IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING ## Abstract Disclosed is efficiently perform a function of accurately extracting. identifying. and utilizing texts and tables in image files and PDF files. ## Claims ### Claim 1 An integrated management device based on a big data platform, the integrated management device comprising: a communication unit configured to communicate with a big data collection device and a user terminal; and a processor electrically connected to the communication unit and configured to control an operation related to integrated management based on the big data platform, wherein the processor includes: an extraction module configured to extract a text and a table in an image file of pieces of public data and a text and a table in a PDF file of the pieces of public data among big data, which is received from the big data collection device, through the communication unit by using AI OCR; a preprocessing module configured to input unstructured data related to the text and the table in the image file and the text and the table in the PDF file into an AI model, and to perform preprocessing to store structured data in a form of key and value, which is learned and output based on the AI model, in a relational database; a search interface module configured to perform an integrated search on unstructured data and structured data in a requested public data based on SDK and RestfulAPI when a search request for the requested public data among the pieces of public data is received from the user terminal; and a display interface module configured to display the found public data through the user terminal. ### Claim 2 (depends on 1) The integrated management device of claim 1, wherein the search interface module performs an integrated search linked to a search engine on the unstructured data and the structured data in the found public data based on the SDK and the RestfulAPI. ### Claim 3 (depends on 2) The integrated management device of claim 2, wherein the processor further includes: a generation module configured to generate an Excel file having a dynamic layout with respect to structured data corresponding to the text and the table in the image file and the text and the table in the PDF file in the found public data. ### Claim 4 (depends on 3) The integrated management device of claim 3, wherein the processor further includes: a conversion module configured to convert the Excel file having the dynamic layout into a file in a data format of CSV, XML, and JSON at a request of a data format of the user terminal. ### Claim 5 (depends on 4) The integrated management device of claim 4, wherein the processor further includes: a determination module configured to determine a corresponding compressed file for transmitting the Excel file having the dynamic layout to the user terminal through the communication unit from among compressed files predetermined for each data capacity, when a data capacity of the Excel file having the dynamic layout exceeds a predetermined level. ### Claim 6 A big data platform-based integrated management method of an integrated management device based on a big data platform, the method comprising: extracting a text and a table in an image file of pieces of public data and a text and a table in a PDF file of the pieces of public data among big data, which is received from a big data collection device through AI OCR; inputting unstructured data related to the text and the table in the image file and the text and the table in the PDF file into an AI model, and performing preprocessing to store structured data in a form of key and value, which is learned and output based on the AI model, in a relational database; performing an integrated search on unstructured data and structured data in a requested public data based on SDK and RestfulAPI when a search request for the requested public data among the pieces of public data is received from a user terminal; and displaying the found public data through the user terminal. ### Claim 7 (depends on 6) The method of claim 6, wherein the performing of the integrated search further includes: performing an integrated search linked to a search engine on the unstructured data and the structured data in the found public data based on the SDK and the RestfulAPI. ### Claim 8 (depends on 7) The method of claim 7, further comprising: generating an Excel file having a dynamic layout with respect to structured data corresponding to the text and the table in the image file and the text and the table in the PDF file in the found public data. ### Claim 9 (depends on 8) The method of claim 8, further comprising: converting the Excel file having the dynamic layout into a file in a data format of CSV, XML, and JSON at a request of a data format of the user terminal. ### Claim 10 (depends on 9) The method of claim 9, further comprising: determining a corresponding compressed file for transmitting the Excel file having the dynamic layout to the user terminal from among compressed files predetermined for each data capacity, when a data capacity of the Excel file having the dynamic layout exceeds a predetermined level.