Wednesday, September 30, 2009

For the Anti-XML crowd, sometimes you have no choice!

The below link is the National Vulnerability Database XML mapping that major security vendors use, including my old company IBM ISS.

http://nvd.nist.gov/download.cfm#CVE_FEED

Basically, NVD (through a committee decision) has decided to use XML mapping to describe vulnerabilities and the various platforms they affect. Security vendors would then import this information into their databases and map them to their own security vulnerability records.

It's confusing, I know, but the bottom line is sometimes a third party (such as the government in this case) forces companies to read, manipulate, and use XML data. So if you're in the anti-XML camp, sometimes outside influences box you into a corner and you have no real choice. Bummer, eh Phil? :)

Sunday, September 27, 2009

Readings on SQL server integration services


Here are two books related to SQL server integration services and they provide comprehensive materials on SQL server integration services. For people interested, you can access to the free book web site above.

1. Microsoft SQL Server 2008 Step by Step by Mike Hotek, Microsoft Press © 2009 (544 pages)

This learn-by-doing tutorial teaches you the essentials for getting started, from data transformation to scripting, to security, and best practices, and so on.

2. SQL Server 2005 Bible by Paul Nielsen

This book includes all the basics, best practices, dozens of targeted examples, and sample code, this comprehensive tutorial is a must for any developer or database administrator transitioning to the new version of SQL Server.

More readings and ideas will be published before our presentation day! Stay tuned.

Friday, September 18, 2009

Handout for presentation - presentation thoughts

Hi everyone,

Dr. Zheng has asked us to publish the little handout that we handed out for our DB middleware presentation last week, and here it is:

http://docs.google.com/View?id=dfpw84nc_7cbr494f3

I think it would be useful if the groups import PPTs into Google Present (part of google docs) and then publish them so everyone can view the presentations before/after the presentations.  I think this is useful because sometimes I want to go back and view a point that one of the groups made, but it's impossible if the PPT isn't shared.  It just takes 2 minutes to upload and share your PPT or Word file to Google docs, and then publish it and post the link.

While receiving my BS in Technical and Professional Communication many years ago, we learned that often times it is helpful to hand out notes and handouts to strengthen and diversify a PPT presentation.  I think Google Present is a good way to avoid having to handout a bunch of paper, but still save your presentation for later use.  What do you guys think?

Thanks! -mtm

Sunday, September 13, 2009

MegaHotPot Readings Blog and Abstract for Upcoming Database Middleware Presentation

(Readings Blog and Abstract combined per Dr. Zheng's request - mtm)


Well, the MegaHotPot presentation is coming right up on Tuesday, and we're hammering out the last details.  We hope to live up to the great presentations that we've already heard from, and equally hope to set the standard for future presentations.

For those who would like to do some readings before the presentation, we have presented six readings in two categories below - 3 from scholarly journals (free PDFs) and 3 casual readings (from well-known web sites).  

The scholarly journal readings are quite dense, while the casual readings are very light.  Taken together, they give a good overview, good examples, and technical details of database middleware.  Give them a once over and see if you agree.

Scholarly Journals:
Transforming Heterogeneous Data with Database Middleware: Beyond Integration
http://dbs.informatik.uni-halle.de/Lehre/Integr/stuff/debull99.pdf
--- For those who want a highly technical read, with a few graphics thrown in for good measure.  It's quite a dense read, but it's just six pages so it's not overly exhausting.  Good article.
Grid Enabled Relational Database Middleware
http://hep.ac.uk/papers/GGF3Rome2001.pdf
---DataGrids as they relate to DB Middleware discussed here.  Also pretty technical, but again not very long.  These best part about this article are the different examples they use to show DB middleware in action.
Web Client and ODBC Access to Legacy Database Information: A Low Cost Approach
http://www.pubmedcentral.nih.gov/picrender.fcgi?artid=2233436&blobtype=pdf
--- This is an older article, but it's just five pages and sums up a lot of ODBC/Legacy issues very nicely.  Definitely Worth a Read.

Casual Reading:
What Is Middleware? Web site

http://www.middleware.org/whatis.html
--- Great starting place to learn about middleware, and has a nice little section on DB middleware, too.
Open Database Connectivity - Wikipedia
http://en.wikipedia.org/wiki/Open_Database_Connectivity
--- I'm a wikipedia fan, and this nice summary article shows why.  Talks about ODBC and how it relates to other DB middleware types.  If you don't know much about ODBC, give this a read.


ODBC Microsoft Article
http://support.microsoft.com/kb/110093
--- ODBC talk straight from Microsoft.  This reads a little like a sales pitch, but I think it's a good basic coverage on ODBC that takes the above Wiki article and extends even further.  The funniest header in this article is "What's So Great About ODBC?"
Classic Microsoft. :)

_____
Abstract of presentation, as presented by Bing:

Abstract of presentaion--Database Middleware
In our presentation, we would start from basic introduction of middleware, different types of middleware,and then dig into our main topic, which is database oriented middleware. we would both provide detailed explanation of different kinds of database middleware and empirical demonstration of one database middleware, which is ODBC.

You would actually learn how database middleware works and differenciate database middleware from other middlewares. With ODBC demo, you would know intuitively how database middleware work and how to connect databases or applications via database middleware.

Our presentation is the second one on week 5. Hope everyone enjoys!

Here is the tentative link through our google presentation: http://docs.google.com/present/edit?id=0Ae7CQJaENDlQZGNuc3g5MndfMjM4Y214Njg3ZjU&hl=en

Saturday, September 5, 2009

Are you interested in Middleware? Go and check our blog!!

Our Middleware presentation is around the corner. To avoid dry out your interests, I would love to provide a little background info on this topic.
Middleware works as "glue" between the operating system and the application. It allows one application interoperate with another software. No programmers need to understand internal process. Isn't that neat?
I found two youtube videos which shows how Middleware works and its use in RFID. Enjoy!

How Middleware eliminates your downtime


The importance of Middleware in RFID

Wednesday, September 2, 2009

A simple SAP/ERP video.

Since we heard a great presentation on ERP as it relates to systems integration tonight from Asha, Jimmy, and Rahul, and also since SAP was featured in the presentation, I thought it'd be relevant to post this youtube video for those who are unfamiliar with ERP. This video gives quite a nice overview to SAP and is under five minutes:



Videos like this are abundant, and you can search for some that go into quite a bit of detail in showing screenshots and some how-to's.

I, like Dr. Zheng, have never really used an ERP product, although a client of mine once had something called Solomon and they were very unhappy with it. The client had it before I got there, and they spent a ton of money on it and it barely worked.

I'm not a big fan of ERP, as statistics show (from CIS8010) that about half of ERP implementations fail, and ERP can negate any competitive advantage that a company has. In my opinion, the upfront cost and the risk involved is just too much to put all your eggs in this basket. But it seems to be a reality in business today, so we should definitely be aware that it exists and know something about it. 

Great job on the presentation tonight, guys, enjoy the video!
-mtm

Tuesday, September 1, 2009

Our first presentaion is on week 5--Interface Middleware

Here is the basic knowledge of materials that we might be involved in our presentaion.

Interface middleware:
Middleware is computer software that connects software components or applications.

RPC(remote procedure call):
It
is anInter-process communication technology that allows a computer program to cause a subroutine or procedure to execute in another address space (commonly on another computer on a shared network) without the programmer explicitly coding the details for this remote interaction.

API(application programming interface):
It is an interface in computer science that defines the ways by which an application program may request services from libraries and/or operating systems.

We would pick a specific topic from these three major areas and it would be updated before our presentaion.

Besides, there is one good web that mainly focus on RPC. we would link it in our blog.


Followers