patti logo
June, 2009 - Vol III, Issue 6
Join Our Mailing List!
Quick Links
 
 

Greetings!


The database has become kind of the unseen pillar of the Internet.  The amount of data stored online is amazing.
 
Last year Yahoo claimed to have the world's largest database with a size of 2 petabytes.  For a little perspective (and arbitrary units of measure), a petabyte can hold:
  • 30 years of 24/7 DVD movies
  • 5.5 million 1,100 page Stimulus Bills
  • 400 million pictures of my son

In tribute to the unsung database, I am going to share with you some of my favorite online examples and some of the great things Patti is doing with data. 

Have a great day!
John Lehman
Patti Engineering
Phone: 248.364.0584
email: john.lehman@pattieng.com
 
Announcing Patti Engineering's New Website
 
Patti WebsiteThe recent changes in the Patti Perspective are more than just a facelift.  The format was changed to mirror the look of our newly launched website.  Please check out our new home on the web at www.pattieng.com.
 
The Gadget - Eye-Fi Camera Memory
 
Eye-FIIf you find yourself never downloading the pictures from your digital camera, this card is for you.

After you set it up, the card will connect to any wireless networks you specify and then send the pictures to your computer.  Some models will send pictures directly to sites like Flickr and Facebook.  
Theres No WWW without the DB
 
ServersWithout databases, the Internet would be a much less interesting place.  Just about any site that provides regularly changing information is going to be driven by a database.  Google, Amazon, EBay are all databases.
 
A simple way to think about a database is as a bunch of spreadsheets that are linked together by key fields.  The important thing about this is that a correctly set-up database is quick and easy to search.  A quick primer on how a database works can be found here. (This is also another great site, probably driven by a database.)
 
Some of the interesting databases out there include:
 
  • www.wikipedia.org - Wikipedia is an online, user-generated encyclopedia.  As it is user-generated, you have to treat the information like many other things on the Internet - with a grain of salt.  I often use this as a starting point when trying to find answers.
  • www.wookiepedia.org - Much like Wikipedia, but for all things Star Wars.  If you are a fan, you could spend hours here.
  • www.imdb.com  - I love movies and movie trivia.  The Internet Movie Database is the first place I look for anything movies (or TV).
  • www.songza.com - Songza is a searchable database of online music.  Just about any song you can think of, you can listen to.  Although the site does not allow downloading, it is a great tool when someone asks "Have you ever heard..."
  • www.mapofstrange.com - This site is a database of strange things that can be found in google maps.  Number 4 on this list is just outside of Detroit on the way to the airport.
  • http://dvice.com/ - If you are looking for new gadget news this is a great source.  Some of my gadgets used in the newsletter have come from this source.
     

The strength of the database is taking large amounts of data and allowing a user to extract useful information.  Whether it is who drew first (Greedo or Han?) or which employee had the least downtime, a database can tell the story.

If you have too much data floating around and you want to make some information out of it, Patti Engineering can help.  Patti uses databases for downtime tracking, storing data from Ice.It, product traceability, and on just about every project we do.  We have years of experience with collecting plant floor data and serving it to users at multiple levels.  Of course this is all driven by a database...

 

Patti Personnel - Edward Maurer
 
Name: Edward Maurer
Title:    Senior Engineer
Education: Oakland University - BS Electrical Engineering, BS Systems Engineering
Years With Company: 9.5
 
Ed began his engineering career in his early years by taking apart radios and electronic devices, building and creating things with LEGOS, and programming with his Commodore 64 computer.  These three things were a big part of his life and defined who he wanted to be when he grew up.  Through his college years he found that Electrical engineering satisfied two parts of the equation by allowing him to blend his passion for electronics along with his need to build and create.  Controls engineering was a natural fit of all three interests allowing him to build and create using electronics and software development. 
 
After college, Ed worked for Electronic Data Systems (EDS) and went through their rigorous SED program for software application development and database design.  Ed has incorporated this experience at Patti Engineering with many projects involving database design and development.  This allowed him to not only control the devices on the shop floor, but also to collect the data from those same devices.  Ed is now a senior engineer with over 15 years of industry experience in Electrical Engineering and controls, software application design, and database design and development.
 
In his spare time, Ed enjoys spending time with his family, running, and Photography.  You can see some of his photographic work here