# US 11,310,210 B2 · Applying unified governance and integration platform to social media data > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,310,210 B2 - Document ID: US11310210B2 - Status: Granted - Kind: B2 - Application number: 16/745,752 - Filed: 2020-01-17 - Published: 2021-07-22 - Granted: 2022-04-19 - Earliest claimed: 2020-01-17 - Assignees: International Business Machines Corporation - Applicants: International Business Machines Corporation - Inventors: Michal Bodziony; Grzegorz Piotr Szczepanik; Lukasz Jakub Palus; Krzysztof Rudek - Web page: https://patentgrep.com/patent/US11310210B2 ## CPC - G06Q 10/40: Business processes related to social networking or social networking services - G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses} - G06F 16/9035: Filtering based on additional data, e.g. user or group profiles - G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries} - G06F 21/6245: {Protecting personal data, e.g. for financial or medical purposes} - H04L 63/0428: {wherein the data content is protected, e.g. by encrypting or encapsulating the payload} - H04L 63/20: {for managing network security; network security policies in general (filtering policies H04L63/0227)} - H04L 67/565: Conversion or adaptation of application format or content (adding application control or application functional data H04L67/561) - H04W 12/02: Protecting privacy or anonymity, e.g. protecting personally identifiable information [PII] - H04W 12/03: Protecting confidentiality, e.g. by encryption - H04W 12/37: Managing security policies for mobile devices or for controlling mobile applications - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) - H04W: WIRELESS COMMUNICATION NETWORKS (broadcast communication H04H; communication systems using wireless links for non-selective communication, e.g. wireless extensions H04M1/72) ## Abstract A computer-implemented method, system and computer program product for applying a unified governance and integration platform to social media data. Data integration definitions for managing and protecting social media data are received. After receiving the data integration definitions for social media data, data integration externalization, governance catalog externalization or lineage externalization may be performed. For example, social media data may be extracted from a database system by a governance and integration unit (“unit”) using the data integration definitions. The extracted social media data is then transformed and loaded to the social media data system via a connector linking the data from the unit to the social media data system. In another example, social media data is extracted from the social media data system by the unit, such as via the connector, using the data integration definitions and then transformed and loaded to the database system for analysis. ## Claims ### Claim 1 A computer-implemented method for applying a unified governance and integration platform to social media data, the method comprising: receiving data integration definitions for managing and protecting social media data; extracting a first set of social media data in a database system using said data integration definitions; transforming said first set of extracted social media data into a format suitable for a social media data system; loading said transformed first set of social media data to said social media data system via a connector linking data to said social media data system; extracting a second set of social media data from said social media data system using said data integration definitions via said connector; transforming said second set of extracted social media data into a format suitable for said database system; and loading said transformed second set of social media data to said database system. ### Claim 2 (depends on 1) The method as recited in claim 1 further comprising: selecting metadata in said social media data system using said data integration definitions to be extracted to a governance catalog database; and extracting said selected metadata from said social media data system to said governance catalog database via said connector. ### Claim 3 (depends on 1) The method as recited in claim 1 further comprising: logging information related to social media data in a data integration flow using said connector. ### Claim 4 (depends on 3) The method as recited in claim 3, wherein a first social media data is depicted as a node in a lineage graph using said logged information. ### Claim 5 (depends on 1) The method as recited in claim 1, wherein said social media data comprises information regarding how users view, share and engage with content and profiles. ### Claim 6 (depends on 1) The method as recited in claim 1, wherein said social media data is a data source in a governance catalog database assigned one of the following asset types: page, post, article, endorsement, comment, reaction and shares. ### Claim 7 (depends on 1) The method as recited in claim 1, wherein said connector is configured to retrieve metadata, extract data, load data, record lineage and lookup data. ### Claim 8 A computer program product for applying a unified governance and integration platform to social media data, the computer program product comprising one or more computer readable storage mediums having program code embodied therewith, the program code comprising the programming instructions for: receiving data integration definitions for managing and protecting social media data; extracting a first set of social media data in a database system using said data integration definitions; transforming said first set of extracted social media data into a format suitable for a social media data system; loading said transformed first set of social media data to said social media data system via a connector linking data to said social media data system; extracting a second set of social media data from said social media data system using said data integration definitions via said connector; transforming said second set of extracted social media data into a format suitable for said database system; and loading said transformed second set of social media data to said database system. ### Claim 9 (depends on 8) The computer program product as recited in claim 8, wherein the program code further comprises the programming instructions for: selecting metadata in said social media data system using said data integration definitions to be extracted to a governance catalog database; and extracting said selected metadata from said social media data system to said governance catalog database via said connector. ### Claim 10 (depends on 8) The computer program product as recited in claim 8, wherein the program code further comprises the programming instructions for: logging information related to social media data in a data integration flow using said connector. ### Claim 11 (depends on 10) The computer program product as recited in claim 10, wherein a first social media data is depicted as a node in a lineage graph using said logged information. ### Claim 12 (depends on 8) The computer program product as recited in claim 8, wherein said social media data comprises information regarding how users view, share and engage with content and profiles. ### Claim 13 (depends on 8) The computer program product as recited in claim 8, wherein said social media data is a data source in a governance catalog database assigned one of the following asset types: page, post, article, endorsement, comment, reaction and shares. ### Claim 14 (depends on 8) The computer program product as recited in claim 8, wherein said connector is configured to retrieve metadata, extract data, load data, record lineage and lookup data. ### Claim 15 A system, comprising: a memory for storing a computer program for applying a unified governance and integration platform to social media data; and a processor connected to said memory, wherein said processor is configured to execute the program instructions of the computer program comprising: receiving data integration definitions for managing and protecting social media data; extracting a first set of social media data in a database system using said data integration definitions; transforming said first set of extracted social media data into a format suitable for a social media data system; loading said transformed first set of social media data to said social media data system via a connector linking data to said social media data system; extracting a second set of social media data from said social media data system using said data integration definitions via said connector; transforming said second set of extracted social media data into a format suitable for said database system; and loading said transformed second set of social media data to said database system. ### Claim 16 (depends on 15) The system as recited in claim 15, wherein the program instructions of the computer program further comprise: selecting metadata in said social media data system using said data integration definitions to be extracted to a governance catalog database; and extracting said selected metadata from said social media data system to said governance catalog database via said connector. ### Claim 17 (depends on 15) The system as recited in claim 15, wherein the program instructions of the computer program further comprise: logging information related to social media data in a data integration flow using said connector. ### Claim 18 (depends on 17) The system as recited in claim 17, wherein a first social media data is depicted as a node in a lineage graph using said logged information. ### Claim 19 (depends on 15) The system as recited in claim 15, wherein said social media data comprises information regarding how users view, share and engage with content and profiles. ### Claim 20 (depends on 15) The system as recited in claim 15, wherein said social media data is a data source in a governance catalog database assigned one of the following asset types: page, post, article, endorsement, comment, reaction and shares.