oracle

The purpose of this report is to investigate the use of a relational database system for The Outer West Metropolitan Zone Little athletics to storage, retrieve and security of athlete’s information. At the beginning of this report will introduce relational database system and its important role in organizations. Then Oracle and Microsoft Sql Server are chosen to compare and contrast. Oracle and Microsoft SQL server are the most prevalent database on the market today. This report will compare prices of two products for saving costs for this organization. Moreover, it will take a closer look about back up features in oracle as well as Sql Serer. Security is also mentioned to describe how they protect companies’s valuable data. Generally, they have similar features but they are so different vastly in some key areas such as price, back up,, and security. This report also has some limitations that only research on two products: Oracle Standard Edition and Sql Server 2005 while there are other relational database systems available such as mySQL, DB2, with different versions. Through main ideas mentioned, this report will recommend a best relational database system for this organization. Introduction

The management of data is always one of the complex issues in almost organizations. Every day, organizations must store an amount of data from different sources such as sales, orders, or contracts. In the past, data was stored in variety of ways for example: clay table or cabinets. However, in this case, data could not be shared and utilized outside applications in which it resided (Leyton, 1999). That means organizations had data but they can not do more with that data. Therefore, new technologies of information storage are researched and developed to create a best management of data. Meanwhile, organizations and companies attempt to find out a better solution or method of storing data in their business. Database system is one of the modern technologies to create, maintain, manage and present data consistently and effectively. Database system separate data away from the application and most importantly enable it to be shared (Coronel, 2003). Database can be defined in different terms, Connolly explained database system in his book: “database is now underlying framework of the information system and has fundamentally changed the way many organizations operate”. There are many models of database such as hierarchical, network and relational. Relational database system is the most well known model today. This model become more popular because it is more simple and effective than other models, it also increases levels of data independence so developers could focus on data and building applications. Nowadays, there are many relational database systems for instance Oracle, DB2 of IBM and SQL Server of Microsoft. In these products, SQL server and Oracle are the most common database system. In general, they have same functions but they are so different in some key areas. This essay will compare and contrast Oracle and Microsoft SQL server in some aspects: price, backup recovery and security.



















Findings and Analysis

Like other organizations, The Outer West Metropolitan Zone Little Athlete also wants to deploy a right system to maximize their business and the return on their investment. Thus, selecting a relational database system with lower cost and lower implementation is the target of organizations. One benefit of SQL server is cheaper than Oracle (refer to appendix A). In SQL Server, customers do not need to buy add on functionality such as data mining, online analytical processing or advanced security Moreover, SQL server provide licensing per processor, not number of cores so it can help to reduce a incremental cost (Komo, 2005). On the other hand, Oracle limited functions, and if customers want to use these functions, they need to pay additional cost and that can be very expensive. Additionally, Oracle use licensing per core so if organizations use two processor with four cores, they need to pay two licensing (Oracle, 2006) (refer to appendix B). According to Shanker, SQL Server requires fewer efforts to install, maintain than Oracle. It indicates one DBA can manage 30 SQL server database while Oracle database require 10 DBAs. That mean organizations can reduce money for hire or training staff each year. In recent years, Oracle try to reduce cost on their products but that is not enough. “customers still suffer high costs from technical support, future license and training DBA” (Westervelt, 2004). DBA can perform SQL[1] with four processors with business intelligent while Oracle
[1] Structured Query Language

The Best Vista Notebooks

The new version of Windows can be a challenge for some notebooks to run. Our tests will point you to the laptops with the power to handle Vista.

Carla Thornton; testing by Thomas Luong

Right now could be a great time to splurge on a laptop, given that many come with Microsoft's Windows Vista operating system to sweeten the deal. But is the new OS reason enough to jump now, or should you hang on to your trusty Windows XP laptop for a while longer?

To find out, we rounded up 15 Vista-equipped laptops from Acer, Asus, Dell, Fujitsu, Gateway, HP, Lenovo, Micro Express, and Toshiba, in two categories: desktop-replacement models powerful enough to serve as your Primary PC, and ultraportables weighing less than 5 pounds. We tested speed and battery life and carefully evaluated screens, keyboards, and other vital features.

We ranked the best five notebooks in each category and awarded Best Buys to the $2301 HP Pavilion dv9000t, a desktop replacement, and the $2150 Dell XPS M1210, an ultraportable. The jazzed-up dv9000t is a snazzy multimedia laptop with a 17-inch screen and designer exterior, while the M1210 is Dell at its best in a 4.9-pound package complete with a dedicated entertainment interface, smoking speed, and great battery life.

This roundup also marks the debut of WorldBench 6 Beta 2, the latest version of PC World's test suite for computers. Our PC World Test Center team refreshed the benchmark with Vista support and expanded tests that give multicore systems a workout. We also improved our battery test with a new automated script that rotates simulated typing with full-screen DVD-quality videos. (In view of its various updates, of course, WorldBench 6 Beta 2 scores are not comparable to previo

The 20 Most Annoying Tech Products

roducts aren't necessarily bad, buggy, or dangerous. But they all have one or two traits that make you want to wrap them in 200 pounds of steel cable and toss them off the side of a boat. From stupid features and rude behavior to brain-dead design and poor corporate policies, these 20 products have truly annoyed us over the years, and some continue to do so. This list hardly covers every annoying tech product ever made. But where did this list of 20 come from? You picked the worst



Top 10 most annoying products flagged with icons. Just for fun, we've added 10 more products that didn't get enough votes from you in our poll but that we found particularly irksome.

It's still possible, though, that a product not listed here or in our reader survey really got under your skin, so please post a comment below. If nothing else, you might feel a little better.

CVS Exposed Customers to Identity Theft

The Texas Attorney General has taken legal action against CVS Pharmacy for exposing customers to identity theft the old-fashioned way.

According to a press release issued by Attorney General Greg Abbott's office on Tuesday, employees at a CVS store in Liberty, Texas, chucked hundreds of customer records into a dumpster behind the storefront. Left in the trash were documents including customers' names, addresses, Social Security numbers, credit card numbers, prescriptions and doctors, according to the release.

Many of the credit and debit card numbers were still active when found, the release says, as expiration dates were included in the information.

While CVS's actions won't likely end up exposing as many customers' to the risk of identity theft as other recent breaches, such as the colossal , the Attorney General's office is warning customers of that CVS location to monitor their finances for suspicious activity.

Such action on CVS's part violates the 2005 Identity Theft Enforcement and Protection Act, a Texas state law that requires businesses to protect customer records that contain sensitive information, the release says. The law allows for prosecutors to seek up to US$50,000 per violation.

Adobe to Show off Media Player to Broadcasters

Adobe Systems has developed its first desktop media player and plans to give the industry an early peek at it at the National Association of Broadcasters trade show in Las Vegas this week.

The company is already a major player in the exploding market for online video with its ubiquitous Flash player and accompanying authoring and streaming products. Adobe hopes to extends its presence with Adobe Media Player: a desktop application that will let content owners embed ads in clips that users can play back offline.

The ability to let consumers "download and carry" ad-supported videos and play them back offline makes the product an important one for media companies, which already use Flash to distribute 80 percent to 90 percent of their content, an analyst said. "It provides a way to share media and make money, which until now has been a scary proposition for most media companies," said James McQuivey, a principal analyst of television and media technology at Forrester Research.

Would You Buy a Green PC?

Your mission this weekend: Gather up your used computers, cell phones, batteries, CDs, DVDs, and other electronic garbage and get it ready for the weekend after that.

Earth Day is coming up on Sunday, April 22, inspiring tech companies to host recycling take-back programs. Dell, for example, is teaming up with the Environmental Protection Agency (EPA) on an Earth Day event in Washington D.C. They'll take back any brand of computer and peripheral from 11 a.m. to 3 p.m. on April 22nd at Freedom Plaza. California Integrated Waste Management Board is also offering similar at locations throughout the state.

Responsibly disposing of your old e-waste is great, but what if you could buy new equipment that used less energy, came in less-exotic but more biodegradable packaging, and incorporated fewer toxic substances (like mercury and lead). Would you buy them? Would you buy them even if they took a performance hit?

We'd like to know. Be so kind as to take our poll:

Eight Tips for a Faster Hard Drive

Have you uncovered the secret to a faster drive yet? It's removing unnecessary files and defragging your drive. I've got the tools and tricks, so read on...

The Hassle: I ran the Windows Disk Defragmenter, but when I tried another defragging tool, it said that my drive was still mostly fragmented. Which one should I believe?

The Fix: Windows, right? Please. For one thing, the Windows tool misses Restore Points--files that are created and deleted each day, take up 13MB each (on my PC), and are scattered all over the drive. Also, third-party tools permit you to decide how to defrag--say, by packing the files tighter.

One defragger I recommend is Golden Bow Systems' $40 Vopt 8. This program is compatible with Vista and XP, and it defrags Restore Points. Among Vopt's neat extras are tools for deleting temp files; a slick feature that closes unnecessary apps, including Windows Services; and a way to automatically defrag multiple drives and then shut down the system. Get a trial .

No matter which program you use, get a better defrag with these simple tricks:

• Defrag early and often. Theoretically, defragging improves performance. PC World's lab hasn't found that to be consistently true. But here at Bass International labs, it's a different story. I didn't defrag my drive for six months and had thousands of fragmented files scattered about my hard drive. After defragging, my system seemed faster.
• Open applications don't get defragged, so close them all before you begin. Ditto for tools that reside in the system tray.
•