About

Posts by :

Facebook Challenges {3}

The article talks about the giant social network site Facebook.com. Facebook’s power derives from what Jeff Rothschild, its VP of technology calls the “social graph.” The largest human population in the world is in Facebook.com. They have the highest traffic flows in term of network. Facebook centers are built on the backs of three tiers [...]

Giant Retails Partner Up {4}

The article talks about how Circuit City, Wal-Mart, GameStop, JCPenny, Kohl’s, Macy’s and Sears join the Law Enforcement Retail Partnership Network or knows as LERPnet. LERPnet is a national database that allows merchants to share information on organized retail crime with local, state and federal law enforcement agencies and with each other. According to the [...]

Bad SQL Code Can Be Dangerous {2}

The article talks about how fault SQL code can cause database performance. Poorly structured queries can often go unnoticed until we start noticing the performance going down and impact the business. With CA’s Unicenter SQL-Station, SQL queries problems can be avoided by ensuring that all SQL code is properly tuned. According to the articles Faulty [...]

Know Your Basics SQL Performance {2}

The article talks about to be good performance of database is starts with a proper formulated SQL. According to Mullins, 75% of poor relational performance is caused by “bad” SQL and application code. For those people are new to programming especially for relational database environment it is very hard to remember and determine the problem [...]

Prevent SQL Injections {0}

The article talks about eight techniques to block SQL injections. According to Schwartz, SQL injection attacks hit Web applications 71 times per hour on average, but can peak at 1,300 attacks per hour or more. California base company called Imperva has created data security platform called SecureSphere, which protect databases, files and web application against [...]

Lost of Data in T-Mobile Sidekick Users {2}

The article talks about how Microsoft’s daughter company Danger had lost the data recovery for their clients, T-Mobile Sidekick users. Due to server failure at Danger, any data not stored on the actual phone but stored in the “cloud” has been lost. Danger can only recover some but not all of the data. For those [...]

The importance of logical data modeling {1}

This article it talks about the value of Enterprise Data Warehouse or known as EDW. The benefits implement EDW include cost-effective and powerful platform for everything from predictive analysis to near real-time strategic and tactical decision support throughout the organization. Often time a company struggles with designing and implementing a logical data model or known [...]

Wise-step method in data modeling {2}

The article that I found it talks about how relational database can be complex for beginner students. A study was conducted and showed that students have been making poor database designs in the past 10 to 15 years. Poor database designs are resulted from not being able to achieve data independence in the data model. [...]

The importance of data modeling {1}

This article talks about the importance of primary key in data modeling. Selecting a unique primary key is very important because without a unique primary key or a weak key an attribute might share the same value .The article also talks about the importance of cardinality. Cardinality is a critical aspect of database design. Cardinality [...]

Hacking Using SQL injection {1}

Based on this recent article, it’s found that SQL injection is still commonly used as one of the top methods in attacking database. Over the last weekend, the SANS Internet Storm Center found about 1 million URLs worldwide infected by ‘lilupophilupop’ malware. The most infections occurred in The Netherlands domain. Public report regarding this attack [...]