Systems and Methods for Analyzing, Integrating and Updating Media Contact and Content Data

• US 20100106702A1
• Filed: 10/26/2009
• Published: 04/29/2010
• Est. Priority Date: 11/12/2004
• Status: Active Grant

• Current Assignee: Engage121, Inc.
• Original Assignee: Engage121, Inc.
• Inventors: Victor, Jon, Strumpf, Kurt
• Granted Patent: US 8,296,324 B2
• Time in Patent Office: Days
• US Class Current: 707/706
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06Q 30/00 Commerce

Abstract

A computer implemented system for integrating, updating, and searching media related databases and building media lists and reports comprising a first server for receiving digital content from multiple sources, a second server for receiving queries from multiple user computing devices; and a database access layer being utilized by the first and second servers to read and write to multiple databases including a content database, a media database, a mapping database, and a report database. The content database receives digital content from the first server and stores such digital content. The media database receives author data and media outlet data of digital content from the first server and stores such data. The mapping database stores mapping data between byline data and source outlet data of digital content in the content database and author data and media outlet data in the media database for updating the media database. The report database stores user report requests. The system also includes a mapping module for storing digital content in a matched content database for articles that could be matched to journalists or bloggers or an unmatched content database for articles that could not be matched to journalists or bloggers. The system further includes an exceptions processor for pulling unmatched digital content data from the unmatched content database and formatting a call down project to telemarketers to update the unmatched digital content data and forwarding the updated digital content data to the content database.

Claims

1. A computer implemented system for integrating and searching media related databases comprising:

a) a first server for receiving digital content from at least one of a plurality of sources;

b) a second server for receiving queries from at least one of a plurality of user computing devices;

c) a database access layer being utilized by the first and second servers to read and write to a plurality of databases,

wherein the plurality of databases include a content database and a media database;

the content database receiving at least one article of digital content from the first server via the database access layer and storing the at least one article;

the media database containing at least one author data and media outlet data; and

d) a mapping module for matching author data and media outlet data from the received digital content to at least one author data and media outlet data contained in the media database.

2. The system of claim 1, further comprising a mapping database for storing mapping data between byline data and source outlet data of articles in the content database and author data and media outlet data in the media database and for updating the media database.

3. The system of claim 1, further comprising a report database for storing user report requests.

4. The system of claim 1, further comprising an indexing database for receiving the digital content from the first server and maintaining an index of the digital content.

5. The system of claim 4, further comprising an archiver for receiving the digital content from the indexing database and for managing the indexing database and storing the digital content.

6. The system of claim 5, wherein the archiver further includes a full archive for storing the complete text of the digital content for a predetermined period of days and a summary archive for storing a summary of the digital content after the predetermined period of days.

7. The system of claim 2, wherein the first server includes a pre-parser for receiving the digital content including a plurality of articles and parsing out a plurality of data elements from each of the plurality of articles in the digital content.

8. The system of claim 7, wherein the plurality of data elements parsed out from each of the plurality of articles in the digital content include at least one of headline, byline, date, media outlet source, content body, and section where broadcast or print edition of the article was found.

9. The system of claim 7, wherein the pre-parser forwards the parsed elements of digital content to the mapping module for comparison to mapping data stored in the mapping database;

wherein the parsed elements of digital content are stored in a matched content database for articles that could be matched to authors or stored in an unmatched content database for articles that could not be matched to authors.

10. The system of claim 9, wherein the first server further includes an exceptions processor for pulling unmatched digital content data from the unmatched content database and formatting a call down project to telemarketers to update the unmatched digital content data and forward the updated digital content data to the content database via the mapping module.

11. The system of claim 10, wherein pre-parser generates a normalized XML file of the updated digital content data for processing by the indexing database.

12. The system of claim 2, wherein the first server forwards the digital content to the mapping module for comparison to mapping data stored in the mapping database and storing the digital content in a matched content database for articles that could be matched to authors or an unmatched content database for articles that could not be matched to authors.

13. The system of claim 12, wherein the second server includes a simple search engine for providing at least one web page to at least one of the plurality of user computing devices for a user to enter various search criteria.

14. The system of claim 13, wherein the search criteria includes at least one of a author name, a media outlet name or a keyword.

15. The system of claim 14, wherein the simple search engine receives search criteria from a user computing device and the simple search engine creates a query and compares query data to data in the matched content database.

16. The system of claim 15, wherein the simple search engine receives query results including a mapping of the article contents and identifiers of the media outlet and the author with the related article.

17. The system of claim 16, wherein the simple search engine queries the media database for media contact data about the media outlet and author and then provides the results of the query to the user computing device as a formatted web page with links to more detailed information.

18. The system of claim 13, wherein the simple search engine receives an uploaded press release document or a cut and paste content of a press release document at the at least one web page from one of the plurality of user computing devices.

19. A method for integrating and updating media related databases comprising the steps of:

a) receiving digital content from at least one of a plurality of sources at a first server;

b) receiving at least one article of digital content from the first server and storing the at least one article in a content database;

c) receiving at least one author and media outlet data of digital content from the first server and storing the at least one author and media outlet data in a media database;

d) storing mapping data between byline and source outlet data of articles in the content database and author and media outlet data in the media database in a mapping database to update the media database.

20. A method for integrating and updating media related databases comprising the steps of:

a) receiving digital content from at least one of a plurality of sources at a first server that includes a pre-parser;

b) parsing out a plurality of data elements from each of the plurality of articles in the digital content using the pre-parser, wherein the plurality of data elements include at least one of headline, byline, date, media outlet source, content body, and section where broadcast or print edition of the article was found;

c) forwarding the parsed elements of digital content to a mapping module for comparison to mapping data stored in a mapping database, wherein the mapping data includes mapping data between byline and source outlet data of articles in a content database and author and media outlet data in a media database;

d) storing the parsed elements of digital content in a matched content database for articles that could be matched to authors

e) storing the parsed elements of digital content in an unmatched content database for articles that could not be matched to authors;

f) pulling the unmatched digital content data from the unmatched content database at an exceptions processor of the first server and formatting a call down project to telemarketers to update the unmatched digital content data;

g) and forwarding the updated digital content data to a content database via the mapping module.