Really simple syndication (RSS) and database integration

• US 20080162507A1
• Filed: 12/28/2006
• Published: 07/03/2008
• Est. Priority Date: 12/28/2006
• Status: Abandoned Application

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Glick, Richard, Papaioannou, Theodore
• Application Number:
  US11/646,657
• Publication Number:
  US 20080162507A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Techniques for integrating Really Simple Syndication (RSS) information into relational database information are provided. RSS information is acquired from an RSS feed in a native RSS data format. The RSS information is selective translated into the relational database information in a relational database format. The relational database information is accessible via a relational database and its interface.

Claims

1. A method, comprising:

receiving really simple syndication (RSS) information from an RSS feed;

translating selective elements of the RSS information into fields of a database table; and

making the database table available for use via an interface associated with a database.

2. The method of claim 1 further comprising, processing one or more automated applications against the database table to do more or more of the following:

query the database table for specific information, extract specific information from the database table, generating a report in response to specific information detected in the database table, and performing custom analytics against specific information in the database table.

3. The method of claim 1, wherein receiving further includes acquiring a World-Wide Web (WWW) site for the RSS feed as a Uniform Resource Locator (URL) link for contacting the WWW site to acquire the RSS information.

4. The method of claim 1, wherein translating further includes using one or more of the following to assist in translating the selective elements into the fields of the database:

an Extensible Markup Language (XML) Style Sheet (XSL), an XSL Transform (XSLT), an XML parser, and an XML Schema Definition (XSD).

5. The method of claim 1, wherein making further includes creating a persistent database table for the database table within the database.

6. The method of claim 1, wherein making further includes creating a temporary virtual database table for the database table within the database.

7. The method of claim 1 further comprising one or more of the following:

querying the database table;

deleting selective portions of the database table;

inserting additional information into selective fields of the database table;

modifying selective portions of the database table; and

merging or joining selective portions or the entire database table with other tables associated with the database.

8. A method, comprising:

presenting a graphical user interface (GUI) tool to a user for defining settings associated with a Really Simple Syndication (RSS) feed; and

associating a database translation service with the settings, wherein the database translation service processes upon receipt of RSS information acquired from the RSS feed, and wherein the RSS information is acquired in accordance with the settings, and the database translation service is to translate the RSS information into database information accessible and usable in a relational database.

9. The method of claim 8 further comprising, storing the settings in a table of the relational database.

10. The method of claim 8 further comprising, receiving additional settings for one or more additional RSS feeds via the GUI tool.

11. The method of claim 10 further comprising, identifying the settings as one or more of the following a RSS feed name, a RSS Uniform Resource Locator (URL) link, a RSS version number, and a custom service to apply as a preprocess against the RSS information when acquired from the RSS feed.

12. The method of claim 8 further comprising, identifying selective elements in the settings for identifying selective portions of the RSS information to include in the database information when the database translation service acquires the RSS information from the RSS feed.

13. The method of claim 8 further comprising, modifying or augmenting the settings received from the GUI tool with additional information.

14. The method of claim 8 further comprising, identifying a log file identifier in the settings for the database translation service to record log, history, or transaction details associated with acquiring the RSS information from the RSS feed.

15. A system comprising:

a relational database residing in a machine accessible medium; and

a database translation service residing in the machine accessible medium, wherein the database translation service is to translate Really Simple Syndication (RSS) information into a data structure recognized within the relational database.

16. The system of claim 15 further comprising, a settings table residing in the relational database, wherein the settings table is to include settings to acquire the RSS information from an external RSS feed.

17. The system of claim 16 further comprising, a Graphical User Interface (GUI) tool residing in the machine accessible medium to interact with a user and to receive the settings from the user that define an RSS feed used to acquire the RSS information.

18. The system of claim 15, wherein the data structure is one or more of the following:

a results table residing in the relational database, a database set residing in the machine accessible medium, and a virtual results table residing in the relational database.

19. The system of claim 15 further comprising, one or more post processes residing in the machine accessible medium to process on a machine using the data structure in order to perform one or more of the following:

reporting, analytics, and mining against the relational database.

20. The system of claim 15 further comprising, an Application Programming Interface (API) residing in the machine accessible medium, wherein the API includes one or more operations that can be selective processed on a machine using the data structure.