Wiggle It Spindle IT

The hard worker is always behind the scene. In the case of Online Transaction Processing (OLTP) and Decision Support Systems (DSS), what’s not seen in the naked eye, the hard worker is the disk subsystem which always remains unnoticed.   ~ Chic Pencil

A customer relationship management system will always contain and maintain our records once we become a member or a customer of the business entity. Customer records is always the basis of customer analytics as well as customer loyalty campaigns.

When you want your records to be retrieved, what you know is to input your personal details when it is done via online portal or a customer service officer will retrieved it for you.

Say for example you input your details as the following via the online portal:

  • Firstname      :     John
  • Lastname       :     Smith
  • Date of birth  :     12/08/1980
  • National ID   :     589001122

In the backend processing, the CRM system will get your records via passing of your inputs to the CRM database. As such, the CRM system will pass the query using the following SQL statement (the language of most databases):

> begin tran

> select * from customer where fname = ‘John’ and lname = ‘Smith’ and DOB = ’12/08/1980′ and NID = 589001122

> end tran

> go

Once the database receives your request, it will be placed in the queue. And when it is your request’s turn for the database to process, well the database will do the following:

  1. The database will parse the SQL statement received. The parsing process involves checking of syntaxes and if there are violations, the database will return the errors to the CRM system.
  2. Once the parsing completes and there’s no violations found, the database will refer to its query processing engine to build the algorithm that will retrieve the data. We call this stage, the building of the query plans.
  3. Based on the query plans generated, the database will choose which plan will fit to retrieve the data. The query plan is one of they key workers of a database system. It is essential that the database administrator (DBA) performs the necessary maintenance in order to keep the database system at optimal health.
  4. The chosen query plan will be performed by the database engine. This time, the database engine will perform the coordination with the last worker in the hierarchy — the disk subsystem.
  5. When the disk subsystem receives the database request, it will place it in a queue. And the queue management and control is handled by spindle. The spindle will tell the disk to get the requested data basing from RPM (speed) of the physical disk.
  6. Once the spindle completes the requested operation, it will pass it back to the database with the data in it.
  7. The database will then relay the requested data to the CRM system.
  8. The CRM system will display the data requested. In this case it will validate based on the input if the customer does exists in the customers table.

The above example is only looking for data in one table. When you want to know the purchases you made or any transactions you done in the past, the database system will look for your query in different tables and indexes. The more requests you do translates to more operations to the last worker in the hierarchy and that is the disk subsystem.

Though the role of the disk subsystem is sometimes forgotten. It does play a major role in any IT needs from personal to enterprise requirements.

The disk spindle holds the key role in letting the IT system administrators know the input – output (I/O) speed — MB/sec of the subsystem it manage. It is the benchmark of the system administrators if there is a need to increase or upgrade the current disk subsystem when new business requirements arise.

Most often than not, the importance of the having the best disk subsystem is limitedly appreciated by the hardware vendors. Most software vendors does not put emphasis that by having a best disk subsystem their system will perform par better than their expected speed.

The disk subsystem is the database’s best friend. When the database is fast in getting user queries, the disk subsystem should be able to response fast as well otherwise, choking on the disk system will occur. Disk choking occurs when the disk spindle is not able to meet up with the transactions that is passed on to it. Remember that the transactions not only comes from database requests but also from the operating system side as well.

As such, for OLTP requests, a higher disk RPM and a higher disk spindle is an excellent fit. This requirement is universal regardless of database brand. These days, 10K or 15K RPM SAS disk is readily available in the market.

For DSS or OLAP requirements, you will need to consider the database architecture and technology. Since user queries especially ad-hoc queries requires huge amount of I/O operations as data retrieval is being done in bulk method, parallelism inclusive of disk spindle would be an excellent fit. Well the database technology for this requirement will be discussed in a separate article.

For Unix system, you can view the disk spindle (operations) via these commands

  • vmstat
  • sar

It is important to monitor the health of the disk. Once this component fails, a RAID configuration should be handy otherwise precious data will be completely loss as a backup system may not be able to do an up-to the minute backup.

So, if you’re not taking care of your disks better start checking it now. It is the worker who wiggles and spindles in order to retrieve your important data and files and everything in your system.

Exposure 1/60 sec. F/4.5. Focal 70 mm. ISO 400. Nikon D200.

Title: Simply happy. A symbol of a happy customer.

A happy customer is a loyal customer. Keeping customers happy not only entails business processes but also the IT system as well. As such, everything in the equation has to be balanced. And the last worker in the hierarchy shouldn’t be forgotten.

Til next time. Au revoir.


Advertisements

Expressions

Different faces.
Different places.
Different representations.

People I met.
People I treasured.
People I cared for.
People I found.

Some left.
Some stayed.
Some returned.

One thing I won’t forget is they allowed me to see them in the lens of my camera.

Memories.

Expressions.

In my journey in life.

~ Chic Pencil

Few of my snaps from different places, faces, travels and art.

Exposure: 1/3200 sec. F/4.0. Focal 34 mm. ISO 640. Nikon D200. Title: Jawohl! My cousin on his dunk moves. Gutersloh, Germany. 2009.

Exposure: 1/25 sec. F/4.5. Focal 70 mm. ISO 800. Nikon D200. Title: ONE. My best buddy and his wife on their wedding ceremony. New Delhi, India. 2009.

Exposure: 1/80 sec. F/4.5. Focal 24mm. ISO 640. Nikon D200. Title: Growl. He was playing with me during our road trip to Hamburg, Germany. 2009.

Exposure: 1/60 sec. F/3.0. Focal 19 mm. ISO 800. Nikon D200. Title: Mood! One of my bestfriends in life. In his dancing mood. New Delhi, India. 2009.

Exposure: 1/60 sec. F/3.8. Focal 38 mm. ISO 800. Nikon D200. Title: Graceful. I called her my baby sis in India. She dances gracefully. New Delhi, India. 2009.

Exposure: 1/60 sec. F/4.0. Focal 38 mm. ISO 640. Nikon D200. Title: Dad & Son. Gutersloh, Germany. 2009.

Exposure: 1/90 sec. F/4.5. Focal 70 mm. ISO 640. Nikon D200. Title: Stunt! Taken at Movie Park, Bottrop Germany. 2009.

Exposure: 1/20 sec. F/4.0. Focal 45 mm. ISO 800. Nikon D200. Title: Nasi Goreng. Singapore, 2009.

Exposure: 1/45 sec. F/8.0. Focal 27.9 mm. ISO 400. Fujifilm FinePix S5500. Title: Two-gether. Taken at New Jersey, USA. 2005.

Exposure: 1/680 sec. F/5.6. Focal 5.7 mm. ISO 64. Fujifilm FinePix S5500. Title: Nation’s Pride, The Petronas Twin Towers. Kuala Lumpur Malaysia, 2006.

Exposure: 1/800. F/4.5. Focal 34 mm. ISO 640. Nikon D200. Title: Melanie. My baby sis in Germany. Taken at Cologne, Germany. 2009.

Exposure: 1/60. F/4.5. Focal 50 mm. ISO 640. Title: Innocent Grin. New Delhi, India. 2009.

Exposure: 1/60 sec. F/4.5. Focal 17 mm. ISO 640. Nikon D200. Title: 1001 Meaning. New Delhi, India. 2009.

Exposure: 1/60 sec. F/3.8. Focal 38 mm. ISO 400. Nikon D200. Title: Lovely smiles. Gutersloh, Germany. 2010.

F/3.2. Focal 4.9 mm. Nokia E71. Title: Comprende? Taken at Movie Park, Bottrop Germany. 2009.

X-res 72 dpi. Y-res 72 dpi. Rim Blackberry 9700. Title: Windy at Jebel Samhan. Salalah Oman. 2010.

Exposure: 1/60 sec. F/5.6. Focal 78 mm. ISO 400. Nikon D200. Title: Confidence. My eldest brother. Salalah Oman. 2010.

Exposure: 1/60 sec. F/4.5. Focal 40 mm. ISO 400. Nikon D200. Title: Mother & Son. Gutersloh, Germany. 2009.

 

Exposure: 1/20 sec. F/4.5. Focal 55mm. ISO 640. Nikon D200. Title: Her Eyes. New Delhi India. 2009.

Exposure: 1/100sec. F/4.0. Focal 50mm. ISO 800. Nikon D200. Title: Simply happy. A wedding made in India. New Delhi. 2009.

Exposure: 1/4 sec. F/5.6. Focal 120mm. ISO 500. Nikon D200. Title: The Bride’s Makeup. Singapore. 2013.

Exposure: 1/45 sec. F/4.5. Focal 33mm. ISO 1600. Nikon D200. Title: The Bride’s Hair. Singapore. 2013.

Exposure: 1/13 sec. F/5.3. Focal 50mm. ISO 1600. Nikon D200. Title: Surprises. Singapore. 2013.

Exposure: 1/20 sec. F/3.2. Focal 4.9mm. ISO 800. Nikon Coolpix S3000. Title: Attention. Philippines. 2014.

Exposure: 1/8 sec. F/5.6. Focal 12mm. ISO 500. Nikon D200. Title: Gnex & Harini. Singapore. 2013.

Exposure: 1/8 sec. F/5.6. Focal 11mm. ISO 500. Nikon D200. Title: Dad in-law’s birthday gift. Dad in-law’s 65th. Singapore 2013.

Exposure: 1/60 sec. F/3.8. Focal 38mm. ISO 320. Nikon D200. Title: The Innocent Cry. Gutersloh, Germany. 2010.

Exposure: 1/125 sec. F/5.6. Focal 70mm. ISO 400. Nikon D200. Title: Me and the gracious ladies. Salalah, Oman. 2010.

Exposure: 1/8 sec. F/3.0. Focal 21mm. ISO 800. Nikon D200. Title: Sultan Al Qaboos Mosque. Salalah, Oman. 2010.

Exposure: 1/750sec. F/5.0. Focal 50mm. ISO 640. Nikon D200. Title: Here they come! A unique brewery! Hamburg, Germany. 2009.

Exposure: 1/15 sec. F/4.5. Focal 17mm. ISO 640. Nikon D200. Title: The Cathedral. Cologne, Germany. 2009.

Exposure: 1/500 sec. F/11. Focal 62mm. ISO 400. Nikon D200. Title: Let’s finish the job. Workers at the ruins of Queen Sheba’s palace (Remember King Solomon in the Bible?). Salalah, Oman. 2010.

Exposure: 1/40 sec. F/3.3. Focal 26mm. ISO 1600. Nikon D200. Title: Family party @ Germany. 2010.

Til next time. Au revoir.

Dance Like Nobody’s Watching

We can’t manage the outside world if we don’t manage our inside self.

~ Chic Pencil

Dance has always been a part of human society. It’s a form of expression, a communication, aesthetics, and an art. To some, it is a form and part of religion, a ritual, and a healing process. The movement of the body in tune to the rhythm of the song constitutes the graceful effect of the dancer conveying the message of the performance.

Dancing as an expression has been portrayed since the earliest human civilizations. Archeologists already found traces of dance since the prehistoric times such as the 9000 year old Rock Shelters of Bhimbetka paintings of India and Egyptian tomb showing dancing figures from 3300 BC.

Different continents and countries have different dance movements, they are called their own ethnic or traditional dance. All dance movement portrays a story, a message that needs to be conveyed to the audience or the receiver.

Widely known as it is, dance is an art.

However, dance or dancing can also be a therapy, an outlet of an individual.

All of us suffered from stress and pressures which can be from work and even family. And as such, all of us need an outlet to regain focus and energy from what has been drained from mundane work and responsibilities.

Dance releases endorphins, the mood enhancer, which gives an individual the natural euphoria and good feeling after the physical movement of more than 20 minutes.

Nancy Cassman, a dance/movement therapist from Boulder Colorado believes that when you start moving your body you’ll start moving the energy in your life too. In dance movement therapy, especially the sensual, rhythmic response aroused by dance and music is used as a way of bypassing the conscious mind and making contact with the inner emotional world. Through dance, hidden emotions can be expressed in a nonverbal way and accepted by the conscious self.

Since I was a child one of my passions is dancing. After our afternoon siesta my dad would usually asked us to dance or to sing. I prefer dancing and I love dancing with my dad in the tune of salsa and cha-cha with the old Spanish tunes. Needless to say, dancing is but a part of Spanish culture.

I stopped dancing when I suffered from hypothyroidism last 2001. Such condition made me succumb to weight gain and water retention that I reached 100+ kilograms, twice the value from my original weight. Though my height is 163cm, having such weight made my body structure suffer from health problems not to mention the low morale and inferiority complex that I’ve been through.

After years of medication, I became free from my hypothyroidism. My doctor decided to put me in weight management program in early 2010. After one year of weight management, I reduced my weight to 65 – 67kgs. It’s very challenging but one’s motivation and faith is always the key to achieving results.

As part of my weight management, I went back to dancing and using it as part of therapy. Dancing not only as one of my passions but it also become my outlet, a stress reliever from the outside pressures.

Here’s an excerpt from Step Up Movie. The dance finale, a fusion of ballet and hip hop.

Here’s the ancient and ever popular belly dancing. My favorite of all dance routine.

We cannot escape the pressures and stress of the outside world. If we don’t take care of our internal self, no else will do it on our behalf.

So let’s dance.. like nobody’s watching… It always feels good.

After my belly dancing workout. 🙂

 

Here’s one wish that I will dance  as what Shakira (my fave artist) did in this video. 🙂

 

Til next time. Au revoir.

 

References:

  1. Wikipedia Online – Dance
  2. Laurel Kallenbach, Dance For Your Health, http://www.thrivingnow.com/dance-for-your-health/

 

The Iconic Figure Of The Queen of Sheba

When King Solomon received the wisdom that God has bestowed upon him, he became famous and so does his kingdom. The thirst of wisdom led him to discoveries of variety of things including his desire for women. He was known to have marriages to different women of royal bloodlines from different kingdoms but not neglecting his leadership to his people.

Such popularity reached the kingdom of the Queen of Sheba who is in her own possesses such wit and intelligence as a ruler of her kingdom that is rich in gold, incense due to trades. Magnetized by King Solomon’s wisdom she and her servants went to King Solomon. She offered the king all the rich gifts in exchange of wisdom from the king.

However, human as they are, there were beliefs that it is very possible that the two had an affair. I guess having such intelligence and wit, a person can have such charisma and magnetism. There are still debates pertaining to the topic of King Solomon and Queen of Sheba of whether they had such an affair and whether it was the Queen of Sheba who is referred by Solomon in the book of Song of songs from the Old Testament.

However, the Queen of Sheba is already a ruler in her own right. The wisdom of King Solomon as a leader is an attraction for the queen. It is also possible that the King and the Queen were merely discussing affairs of their states. However, such intelligence and wit can be the basis of admiration and probably infatuation.

In the end the two leaders separated ways. For reality still is, they have different kingdoms that they have to rule and lead. Different lives they are bound to live. The Queen of Sheba together with her servants went back to her kingdom.

The Queen of Sheba has been very popular though very little is known about her. There are still debates of her origins and bloodlines. Her kingdom was believed to have been very strategic with respect to location. Though there are discussions of where her kingdom is, archeological findings of the Queen of Sheba’s palace were discovered in the Dhofar region of Oman. It is called Sumhuram.

Sumhuram was known as the greatest city of Southeast Arabia during 1000BC. The port was strategically built and its location paved the success of frankincense trade route from Arabia to Jerusalem to Alexandria and even to Rome. Having such powerful kingdom and the frankincense route, the kings and queens of Sheba protect and control their incense together with Yemen who controlled myrrh of Yemen. The frankincense routes were watered from places with zigzagging approach  across Arabia as implemented by the Queen of Sheba due to the advise of King Solomon. This is to protect the frankincense routes and trades. Powerful as these trades as the bags of frankincense can reach India and even China.

All such discoveries were uncovered by archeologists and the site was first excavated by Wendell Philipps, the American who first dig the site in Dhofar region.

Could it be that wisdom of King Solomon helped the Queen of Sheba protect her trades and kingdom?

As the helping of kingdoms and affairs of states, were the two leaders actually had such affection for each other?

Leaders as they are, they are still humans with feelings and emotions. They have kingdoms to rule, lives to live, culture and religion to follow. Such amount of responsibilities entails sacrifices and compromises.

I salute the Queen of Sheba as the ruler of her kingdom and the successful trades and frankincense routes. She’s a powerful figure yet remained unnoticed and hidden.

I was privileged to visit the place of Khor Rori, the archeological place which is known the be the palace of the Queen of Sheba. Together with my brother and his buddy, we drove towards the excavation site which is located between Wadi Attair and Wadi Dirbat during my Salalah visit last December 2010. The place is preserved and until today birds such as flamingos, herons and gulls can be seen.

The strategic port location of Sumhuram. Salalah Oman. December 2010.

Nikon D200. Exposure 1/640. F/13.0. Focal 17 mm. ISO 400.

 

 

Birds of Sumhuram. Salalah Oman. December 2010.

Nikon D200. Exposure 1/640. F/13.0. Focal 300 mm. ISO 400.

 

 

Birds of Sumhuram. Using telefoto lens. Salalah Oman. December 2010.

Nikon D200. 1/400. F/10.0. Focal 300 mm. ISO 400.

 


Overlooking the sea. The Port opening and location. Sumhuram Salalah Oman. December 2010.

Nikon D200. 1/640. F/13.0. Focal 17mm. ISO 400.

 

 

Khor Rori archeological site. Sumhuram. Salalah Oman. December 2010.

 

The storehouses and gate. Sumhuram. Salalh Oman. December 2010.

 

The storehouses and gate. Sumhuram. Salalh Oman. December 2010.

 

The ruins of monumental building. Sumhuram. Salalah Oman. December 2010.

 

The residential area of Sumhuram. Salalah Oman. December 2010.

 

My brother Pat and his buddy Kuya Bong at Khor Rori archeological site. Salalah Oman. December 2010.

 

Me with my brother at Sumhuram. Salalah Oman. December 2010.

 


Enjoying my archeological visit to Sumhuram. Salalah Oman. December 2010.

The story of King Solomon and the Queen of Sheba have always been famous and I have constantly listens to it even when I was still a child.

I wonder sometimes if the two leaders had an affection for each other, letting go must have caused some pains.

I guess saying goodbye to the person that you care about has always never been easy.

 

 

Til next time. Au revoir.

 

References:

– Bradt Travel Guides – Oman

– The Queen of Sheba by Michael Wood – BBC History UK