Database II

1. SELECT "Date", "Sales", "Cost", "Profit" FROM "Sales" WHERE "Region"='East'
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005079&STANDALONE=true&privatelink=627a962e9c415aad7a473fe3c656b799&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

2. SELECT "Date", "Region", "Product Category", "Sales" FROM "Sales" WHERE "Customer Name"='Michael Moore' and "Sales">80
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005177&STANDALONE=true&privatelink=a473b1a83025d190a29a1a344a2c1066&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

3. SELECT  "Customer Name", "Region", "Product Category", "Sales"
FROM "Sales" WHERE "Product" = 'Fruits and Vegetables'
http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=202103000000005275&STANDALONE=true&privatelink=de5add2804cd36c867fa43d4f4291aba&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

KMS

Knowledge management systems, or KMS, are systems that help create, store and share information within an organization. These types can be very useful in promoting efficiency within a company. When many coworkers are working on the same or similar projects, KMS systems come into play by allowing them to share the knowledge that they have collected and developed for different knowledge-intensive tasks. This promotes efficiency because different can take data from these systems rather than having to collect or create knowledge themselves. This can save hours of work for all employees withing projects. (1)

KMS can also be useful to a company by assuring that all knowledge be deposited in the same place, so that employees work and creation can be kept track of so that they do not take valuable information to a competing company without the first company finding out. (2) KMS are based on databases using software such as Microsoft SQL database. On top of the database, a user interface is given, mostly in the form of a GIU, or graphical user interface, which allows the individual employees within a company able to access and add to the database on their own.(3) The architecture is based on the three uses of the KMS; knowledge creation, knowledge sharing and knowledge reuse.(4)

An example of a possibility of applying the use of a KMS in a business could be in marketing, where employees create different ideas for marketing a product based on data found in the KMS, such as demographic pricing and focus groups on the product. This would be the knowledge creation. Their ideas generated during a brainstorming session could be stored in the KMS and accessed by anyone in their organization. This would be the knowledge sharing. If one idea is used for a marketing campaign, the rest of the unused ideas could be stored and may be useful at a later date when the process resatarts. This would be the knowledge reuse.

(1) http://en.wikipedia.org/wiki/Knowledge_Management_System

(2) http://www.ibs-company.com/content/eng/212/2122-article.asp

(3) http://uits.iu.edu/page/azet

(4) http://www.sciencedirect.com/science?_ob=ArticleURL&_udi=B6VB4-4BKPSMC-1&_user=1510644&_coverDate=02/29/2004&_rdoc=1&_fmt=high&_orig=search&_origin=search&_sort=d&_docanchor=&view=c&_searchStrId=1603866579&_rerunOrigin=google&_acct=C000053384&_version=1&_urlVersion=0&_userid=1510644&md5=14466d55e4916fe0a961eaac4e265986&searchtype=a

Enterprise 2.0

Enterprise 2.0 is essentially the application of Web 2.0 technology to the information systems within a company. Using Web 2.0 technology, companies can allow employees to communicate more efficiently with each other while allowing management to keep information from different projects organized.(1) There are many benefits to utilizing this type of system within a company, including the use of Blogs, Community Networks and Employee Profiles.

These systems are helpful in collaborative efforts between groups of employees. Having workers share their work in a community platform within a company allows them to see the progress of their coworkers, give feedback and share with as little redundancy as possible. The use of these systems also allows for new employees to integrate into companies more quickly, minimizing the time it takes them to process into all of the company systems by having their information linked.(2) Beyond internal use, the implementation of these social network systems to efforts between clients and partners can increase efficiency. People who may not be working in the same office can work on the same documents and projects from anywhere in the world. Rather than giving constant updates over the phone or having multiple versions of the same document sent over email, causing a lot of confusion, people can see the progress as it is happening and know each others status.(3) The use of Wiki pages can assure that all people using common information are current and that anyone can edit information to help collaboration.

1. http://en.wikipedia.org/wiki/Enterprise_2.0

2. http://socialmedia.mit.edu/enterprise-2-0-and-new-hire-integration/

3. https://confluence.delhi.edu/download/attachments/268/AIIM+Enterprise+2.pdf

Web 2.0 and Cloud Computing

Web 2.0 and Cloud Computing are two technologies that have been quickly developing in the world of computers for the past several years. While both technologies are very important and innovative in their own rights, they are a very useful combination together to benefit the computing experience and cost for both businesses and private end users. Web 2.0 is very useful to the general public as it allows for more of an Internet presence for individuals. Users can upload and share photos with Flickr, keep blogs with Tumblr, Wordpress and Blogger, share short messages with large groups of people using Twitter and share personal information with Facebook. (1)

Along with a growing individual experience on the Internet comes new marketing opportunities for companies. Products like Google’s AdSense and Facebook’s decommissioned Beacon use information the Internet presence maintained by the end user to deliver targeted advertising, or advertising tailored to the user’s interest. (2) This targeted advertising makes the advertising more effective as it is more likely that the viewer will be enticed by the ad.

The role that cloud computing plays in Web 2.0 is that it makes it more cost effective for companies to try to gather personal information and create targeted advertising. Cloud computing means that processing and storage can be distributed over the internet, so that companies are not responsible for all of their servers in-house. (3) This allows companies to have flexible storage and bandwidth for cheap. Because of this, companies like Flickr and Facebook can offer users free space to store their information over the internet. While someone still has to pay for this computing, it becomes much cheaper, and allows for most of the company’s revenue to come from advertising interests.

While there is some concern about the use of personal information in the Web 2.0 age, it is clear that both individual users and corporations can benefit from the use of Web 2.0 and Cloud Computing technologies. Individuals benefit from the plethora of free services available to them and corporations benefit from increased sales from directed advertising as well as the reduced cost offered by the use of Cloud Computing.

1. http://oreilly.com/web2/archive/what-is-web-20

2. http://edlab.tc.columbia.edu/index.php?q=node/3341

3. http://netseminar.stanford.edu/seminars/Cloud.pdf