Database Technology Trends

A few days ago I wrote the post “The Art of Social Networking” and I received a lot of positive feedback on it. One question dominated the responses. How do I use the LinkedIn Outlook Toolbar? This prompted me to write a follow-up on this topic.

First you need to download the software from LinkedIn. The download link is located at the bottom of your home page. Click on the Outlook Toolbar link.

Click on Download it now.

Make sure that you’re Outlook is closed. Then click run on the following window.

After the install completed start Outlook again and you will see this window popup.

Click on “Get Started” to synchronize your Outlook with LinkedIn.

Click on Start at the next screen.

 
Enter your LinkedIn login. Email and password.

This screen asks you if you want to look for LinkedIn connections based on your Outlook address book and if you want to automatically import contact information into your Outlook address book from LinkedIn. To get the most from your LinkedIn Outlook Toolbar, check both options.

Then click on Next.

This screen asks you about which email folder from Outlook the tool should search for email addresses to add to the new LinkedIn invite list. This is very powerful to connect with people you had an email exchange, but you never saved their information into the Outlook contacts.

Uncheck the folders you don’t want to search. There’s no point in searching the deleted item folders or the junk mail folder.

When you’re done, click on next.

The next screen asks you to enter your personal email addresses. This will speed up the search process and you are not inviting yourself to connect with you.

Click on Build when you’re done.

This screen asks you if you want to add these email contacts to your Outlook contacts. These are email exchanges with contact you never added to your address book.

Click on Create when you’re done.

This screen asks you to confirm the new contacts that will be added into your Outlook address book, based on already existing connections in LinkedIn. This is very helpful to keep your Outlook contacts up-to-date.

Click on Create to add these contacts.

The next screen is very important to grow your LinkedIn network. There are several check boxes and selection to choose from.

First, if you’re doing this for the first time, make sure that you checked the box “Show all contacts in Outlook”. This will expand the selection list with your entire Outlook contact list. Then you need to check every box next to the email you want to invite to LinkedIn. No worry, the tool knows which contacts are already connected and will not send another invitation.

Second, click on Next to compile the invitation emails.

In my case there were no more invitations to send.

Outlook sent out all the necessary invitations and added the missing contacts.

The LinkedIn Toolbar will keep track of all the changes of your contacts in LinkedIn. This assures that all your contacts are always up-to-date. I found this feature of the LinkedIn Toolbar of most value to me.

Here’s another tip. Even if you’re already a LinkedIn Toolbar user, reinstalling the tool from time to time will keep up with the software updates of the tool and also refreshes your contacts synch. I do this about every 2-3 months. This will keep my address book in sync with LinkedIn at all times and I never get an undelivered email notice again.

People tent to keep their LinkedIn information up-to-date, but do not bother to inform their contacts about the email change. The LinkedIn Toolbar does this work for me.

When I ran this tool the first time, I gained about 200 new connections in LinkedIn I didn’t have before, but I knew this contacts from my address book.

Working through the Dashboard on a regular base will keep your contacts fresh. No worries, the LinkedIn Toolbar will never update your address book automatically. You always need to confirm any changes. So, reviewing the information in the Dashboard is vital.

The last feature I want to show is the Grab feature.

Let’s say you received an email from a new business contact and you want to add this information to your address book, Outlook only auto fills the name and the email address. All the other information is up to you.

With the Grab feature, LinkedIn adds the additional information to the address book. Simply highlight the information you want to add to the address book and then click on the Grab Icon in the Outlook menu bar.

Then you will see the following address book entry.

You see that all the additional information was added to the address book records.

One last caution: The new address records are being created into a separate folder called “Collected Contacts”. You need manually move the new contacts into your Contacts folder.

This is very simple and is been done by simply selecting all the new contacts and then use the mouse to drag them into the Contacts folder. If the contact already exists you will see the following screen. It will ask you if you want to add a new contact or update an existing contact. It also shows you what changes will be updates. If everything looks OK, click on the Update button.

This screen will show up for every duplicate entry the tool finds.

There you have it. This is the fast track to the LinkedIn Toolbar. I use this tool every day and I don’t know what I would do without it.

Take care,
Peter Dobler

It was summer of 2000 when I first learned about Sybase IQ and its revolutionary column vector database technology. As a long time Sybase ASE and Oracle DBA I was used to database engines that organize data in a row by row method. For quite some time I had difficulties to think in column terms and not in row terms.

A column vector database requires totally different methodology for performance and tuning efforts. Nothing is straight forward and the message that more data volume doesn’t make a difference in the query performance is not easy to understand. For example: A traditional database engine allows the usage of only one index per table in the same query. Sybase IQ has no limits. If each column in the query requires a different index, it will use a different index. In fact, by default every column is an index.

Getting my hands around the fact of having queries perform up to a 1000 times faster on Sybase IQ than on traditional row based RDBMS systems is no easy matter either. Of course in an Oracle implementation with the OLAP technology similar results can be achieved. However, you are paying for the underlying OLTP engine regardless if you’re using it or not. Sybase IQ doesn’t have this overhead.

One of the key features of Sybase IQ is its data compression. I worked with Sybase IQ systems that easily exceeded 80% compression ratio. Meanwhile, every database vendor introduced data compression into their database engines, but Sybase IQ is the undisputed leader in the highest compression ratio of them all.

This post is not meant to explain how Sybase IQ works and why it is so superior in analytical query processing compared to its row processing based counter parts. Please click here to read more about Sybase IQ’s amazing technology.

I know that there are other data warehouse systems out there that are equally as fast as Sybase IQ and some are even faster, but in this article I am focused on the Sybase IQ engine and its recent setting of a new benchmark record for TPC-H transactions. This record is all about saving money while providing blazing fast performance. Please click here to read the detail report on this milestone.

OK, back to what’s new in version 15 of Sybase IQ.

There are two major improvements in the new release that are worth mentioning.

1. The overall query performance was once again dramatically improved and yields in an average 20%-50% performance gain, compared to the previous Sybase IQ release.

What does this mean for your business?

Analytical queries are typically CPU hungry monsters that can eat up your entire processing resources. Producing results faster means more queries will be processed in the same time window.

It also means the hardware upgrade can be postponed for a while. Considering that the associated QA requirements to move an entire production system to a new hardware platform can be a very expensive proposition and combined with the cost of the new hardware maybe not worth the investment. In comparison; a standalone upgrade of the database engine might be worth the effort.

It further means that cheaper server hardware on Linux can be used to build Sybase IQ multiplex systems that produce high end performance results on a slim budget. Due to Sybase IQ’s architecture there are no added network constraints either. 

2. Multiple writer nodes in a single multiplex environment.

This is an enormous step forward. Previously a typical Sybase IQ was build with one big server that acts as the writer node and many smaller servers for the reader nodes. The thinking was to provide the best hardware to the CPU intensive load jobs to minimize the load windows. The downside of this architecture was that in a failure situation, one of the smaller servers would take over the writer part and then would be helplessly overwhelmed in case the writer node couldn’t be fixed in time for the next load.

It is also economically not practical to devote high-end, expensive server hardware to a job that only last for a fraction of a daily work load. Having multiple writer nodes solves this problem once and for all.
Utilizing all the available processing power in a multiplex environment ultimately leads to faster load performance, which can be solved without upgrading the writer node server hardware over and over again.

Also, another data load performance improvement is the new feature of loading data directly from clients. This means that data can be loaded from files using a simple SQL statement instead of copying data files onto a server and then using the bcp command.

Of course there are other major improvements in security, flexibility and integration support, but the two improvements above are the major contributors to any cost savings or cost avoidance initiative a business is taking on these days.

Sybase also improved their client apps to better manage Sybase IQ, easier develop applications for Sybase IQ and more effectively monitor Sybase IQ. Once the Achilles heel of Sybase, these tools are now very usable and mature.

From a cost/performance point of view, Sybase IQ is a force to be reckoned with and due to its column vector architecture there is no other major database engine in the market like it. To support Sybase’s strong performance in technology they also had their best financial year ever in 2008 and the best quarter on record in Q1 2009.

I hope you enjoyed my brief introduction into Sybase’s data warehouse engine Sybase IQ and its latest version 15 features.

Take care,
Peter

Like it or not, social networking has become an integral part of our daily life. No matter if you try to reach new clients for your business, looking for a new job or reconnect with old friends; social networking is the weapon of choice.

The recent economic downturn has forced many of us to become more pro-active in many aspects of our business life. Regardless of the situation, it is a buyer’s market. It’s a buyer’s market in real estate, in the job market or in the business world in general. You need to be pro-active to be noticed. This holds true especially in social networking.

But be aware, not all social networking sites are made equal. They have very specific features and functionalities that you need to know to gain the most from them. I personally use 5 distinctive social networking sites to promote my skills and services. The goal is to keep my profile in peoples mind repeatedly to be on somebody’s short list when the need of my services arises.

Here’s my list of the 5 social networking sites that I personally use and how to use them most effectively.

LinkedIn

LinkedIn is the 800 pound gorilla of social networking sites. Many business professionals are a member of LinkedIn and use it on a daily base to stay in contact with their business contacts. The primary concept is to utilize existing connections to get introduced to new contacts. This concept works very well and allowed me to extend my network to people I previously didn’t know and now maintain a solid business relationship.

The key to success in LinkedIn is to be an active member. Ask questions, answer questions, join groups, write recommendations for people you’re connected with, announce your status, start discussions in groups you’re a member of, write comments to discussion topics, etc.

I use the Outlook add-in from LinkedIn to keep my outlook contacts in sync with LinkedIn’s information. People tent to keep their contact information in LinkedIn up-to-date and this way I always have the latest contact information in my Outlook contacts.

This is my LinkedIn profile.

Plaxo

Plaxo has a similar approach as LinkedIn, but is more geared to exchange current status information of each member. Somewhat like Twitter on steroids. Unlike LinkedIn, Plaxo doesn’t support a concept of connection levels. You are either connected to somebody or not. I like Plaxo’s integration tools a little bit better than the LinkedIn toolbar.

Especially the Plaxo pulse program is an interesting concept that informs you about any new activity from your network connections. I also like the feature of the Plaxo Outlook add-in that synchronizes the Plaxo photo and birthdays with your Outlook contacts. Even if you’re not connected to an individual, if you receive an email from a new contact and you are adding this information to your contacts, Plaxo then synchronizes the photo and when you read the email from this contact it will display a picture in the upper right corner. Very cool technology.

This is my Plaxo profile.

Naymz

Naymz is all about reputation. There are a couple of things you need to do to become a successful Naymz networker. Take your time and review each and every contact. It is important the every contact gets its assessment. That’s how Naymz works. People will give you their assessment anonymously and this will count towards your RepScore. The higher your RepScore, the better your reputation.

Another feature of Naymz is that it monitors the web for any mentioning of your name and creates a history for you to review. This allows you to take action against anything that could harm your reputation before more damage is done. The biggest threat to your professional success is harmful information about your and/or your business floating around in the internet without your knowledge.

This feature alone is worth being a member of Naymz.

This is my Naymz profile.

Ecademy

Ecademy has in impressive SEO feature that will get you onto Google’s map in no time. Create a Google alert with your name and then create a profile on Ecademy. You will be surprised on how fast Google indexes your name.
I used Ecademy for SEO related message placement and of course expanding my network. The best use of Ecademy is to connect as many members as possible, this will keep your profile on top of the list and indexed by Google over and over again.

I don’t think that Ecademy will produce any professional connections that will yield in business activities, but it helps to keep my name in rotation. This is a mostly UK and European based network, but it has a good presence in the United States as well.

This is my Ecademy profile.

Ryze

Ryze is the smallest of the social networks I use. Regardless its size, it offers a couple of features that are very unique to Ryze like the event calendar and posting classifieds to the network.

I have to admit that this is the latest network I joined and I am still gauging its benefits. So far I didn’t explore its entire functionality. I joined Ryze due to an article I read and now I’m exploring its features.

This is my Ryze profile.

Summary

LinkedIn is and will be my main social networking site, but I will utilize the other sites to maximize my online presence. I really like the special features of Plaxo and the reputation approach of Naymz. Ecademy and Ryze are a little bit too spamy, but I will explore their strengths and use it to my advantage. Needless to say that all social networks are free to join and all of them offer a paid upgrade. I do not think that the paid upgrades are worth it, but this is everybody’s own decision.

Bottom-line: No matter which social networking site you’re using, you’re being pro-active as long as you are using at least one of them. As I mentioned earlier, it is a buyer’s market.

Take care,
Peter Dobler