Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Developer

Five apps to help you mine valuable information from big data

By Brien Posey November 14, 2012, 3:32 AM PST

Image
1
of 13

a1_Email2DB_1.jpg
a1_Email2DB_1.jpg
Five apps to help you mine valuable information from big data

Email2DB 1

Email2DB 1

ntThis gallery is also available as a post in the TechRepublic Five Apps Blog.

n

ntEditor’s note: Big data is a hot topic in information technology circles these days, but it continues to be an elusive concept for many. In the first entry in the TechRepublic Big Data Blog, John Weathington defines big data with these base principles:

n

nt

ntt“Big data is the massive amount of rapidly moving and freely available data that potentially serves a valuable and unique need in the marketplace, but is extremely expensive and difficult to mine by traditional means.”

n

n

ntThe “difficult to mine” part of that definition is the part Brien Posey is addressing with his list of five apps that you can use to mine valuable information from the big data being produced by your organization.

n

ntnn

n

ntFive Apps

n

nt1. Email2DB

n

ntEmail2DB is a data mining utility that is designed to extract information from E-mail messages and then use the extracted data to update a database.

n

ntThis application has a number of different uses. One potential use is to compile a database of potential customers by analyzing E-mail messages that have been sent to your organization. The really nice thing about this application is that it allows you to specify triggers and actions. This makes it possible for the software to not only extract data from E-mail messages, but also to react to the contents of the message. These abilities could be used to manage mailing list memberships or even to respond to E-mail based orders.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Email2DB 2

Email2DB 2

ntEmail2DB sells for $595, but a free 30-day trial is available for download.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Log Parser 1

Log Parser 1

nt2. Log Parser

n

ntLog Parser is a free command line utility for Windows that allows you to perform queries against a variety of file types including things like log files, CSV files, and XML files. This utility can even parse data sources such as the Active Directory or the Windows Event Logs.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Log Parser 2

Log Parser 2

ntLog Parser is extremely flexible, but it is not a utility for novices. Using Log Parser requires experience with custom queries as well as with working from the command line.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Parse Log QL 1

Parse Log QL 1

nt3. Log Parser QL

n

ntLog Parser QL is a free utility for parsing CSV files or other types of delimited files. When a file is open in LogQL, the software will display a description of the file’s fields. Once the fields are known, you can use SELECT statements to extract specific data from the file.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Parse Log QL 2

Parse Log QL 2

ntThis data can be viewed on screen or it can be saved to either an alternate CSV file or to an HTML file.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Parse Log QL 3

Parse Log QL 3

ntIt is worth noting, that you must install Java in order to run this utility.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Data Parse 1

Data Parse 1

nt4. Data Parse Free Edition

n

ntData Parse Free Edition is a free Java-based utility for analyzing data. Although this utility is very flexible, it is not for the faint of heart.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Data Parse 2

Data Parse 2

ntThe utility uses a scripting language to parse data. The good news however, is that the scripting language is relatively intuitive, and a tree view presented within the Solution Explorer section of the interface helps you to adapt the script to the data that you want to analyze.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

Data Parse 3

Data Parse 3

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

ParseRat File Parser 1

ParseRat File Parser 1

nt5. ParseRat File Parser

n

ntParseRat File Parser is a utility for converting and restructuring data. The utility is able to read data from a number of different formats such as binary files, dBase, CSV, tab delimited, and more. Once ParseRat has been connected to the data source, it can be used to extract data and reformat data before rewriting it to a new data file.

n

ntParseRat’s is able to do more than just filter records. It can actually restructure data. For example, it can change a name from last name, first name format to first name last name format. The software can also add titles such as Mr. or Ms.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

ParseRat File Parser 2

ParseRat File Parser 2

ntAlthough the software seems to work well, it is an older program and was apparently a victim of the screen resolution limitations of the time when it was published. As such, ParseRat’s display is a bit cluttered. Fortunately, the interface has an enlarge function that was originally intended to help the visually impaired, but that works great for modern, high resolution displays.

n

ntCredit: Images by Brien Posey for TechRepublic

Five apps to help you mine valuable information from big data

ParseRat File Parser 3

ParseRat File Parser 3

ntParseRat File Parser sells for $49.95, but a free trial version is available for download.

n

ntAlso read:

n

    nt

  • nttBig data bonanza: But is IT capable of mining it?
  • nt

  • nttFoster Big Data expertise in-house
  • nt

  • nttUsing Big Data to establish market dominance
  • n

n

ntCredit: Images by Brien Posey for TechRepublic

  • Developer
  • Account Information

    Share with Your Friends

    Five apps to help you mine valuable information from big data

    Your email has been sent

Share: Five apps to help you mine valuable information from big data
Image of Brien Posey
By Brien Posey
* 1988 - Started teaching myself about computers \ * 1992 - Mainframe programmer for an insurance company \ * 1993 - Network Administrator for a different insurance company \ * 1996 - Author for The Cobb Group \ * 1998 - Network Administrator
  • Account Information

    Contact Brien Posey

    Your message has been sent

  • |
  • See all of Brien's content

TechRepublic Premium

  • TechRepublic Premium

    Power Checklist: Building Your Disaster Recovery Plan

    Natural and man-made disasters can jeopardize the operations and future of any company today. Hurricanes, earthquakes and terrorist or cyberattacks are just a few examples of potentially crippling threats. As a result, the development of a disaster recovery plan is a must to ensure ongoing business processes in the wake of a crisis situation. This ...

    Published:  September 21, 2023, 4:00 PM EDT Modified:  September 22, 2023, 8:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Hiring Kit: Project Manager

    Keeping all the various moving parts of a business running smoothly and on time requires a well-organized individual who can see the final goal of a project, develop a path to reach that goal and communicate the path that must be followed to all the individuals and teams working to bring that final goal to ...

    Published:  September 20, 2023, 4:00 PM EDT Modified:  September 21, 2023, 12:00 PM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    SSL Certificate Best Practices Policy

    SSL certificates are essential for encrypting traffic between systems such as clients, which access servers via web browsers or applications that communicate with remote systems. Certificates protect client and server data, commonly involving confidential information such as credit card details or social security numbers. The purpose of this SSL Certificate Best Practices Policy from TechRepublic ...

    Published:  September 20, 2023, 4:00 PM EDT Modified:  September 21, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Mobile Device Computing Policy

    Mobile devices are a way of life in both the consumer and business realms — and business interests must be protected where the two converge. This policy from TechRepublic Premium provides guidelines for the safe and productive use of mobile devices (laptop computers, tablets, smartphones, etc.) by employees. It includes stipulations for company and employee-owned ...

    Published:  September 20, 2023, 4:00 PM EDT Modified:  September 21, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice