Query Tables

1. 
SELECT "Cost", "Customer Name", "Date" FROM "Sales"
/* This is a sample SQL SELECT Query
*/http://reports.zoho.com/ZDBDataSheetView.cc?DBID=215642000000006833

2.
SELECT "Region", "Customer Name", "product category", "Date" FROM "sales"
http://reports.zoho.com/ZDBDataSheetView.cc?DBID=215642000000006833


3.
SELECT "Date", "Customer Name", "product","product category" FROM "sales"
http://reports.zoho.com/ZDBDataSheetView.cc?DBID=215642000000006833

DSS

“A decision Support System (DSS) is a computer-based information system that supports business or organizational decision-making activities.  DSSs serve the management, operations, and planning levels of an organization and help to make decisions, which may be rapidly changing and not easily specified in advance” (1).  The purpose of decision support systems is to collect data, analyze it, and shape it.  Decision support systems gather significant data and there are many different types of them.  “Typical information that a decision support application might gather and present are:  inventories of information assets (including legacy and relational data sources, cubes, data warehouses, and data marts), comparative sales figures between one period and the next, projected revenue figures based on product sales assumptions” (1).

There are many different types of decision support systems, which include cooperative decision support systems, the Model Driven DSS, Communications Driven DSS, Data Driven DSS, Document Driven DSS, and a Knowledge Driven DSS.  “A cooperative decision support system is when data is collected, analyzed and then is provided to a human component which then can help the system revise or refine it.  It means that both a human component and computer component work together to come up with the best solution” (2).  This type of decision support system benefits businesses because it is useful in terms of completing various difficult tasks.

“Model Driven DSS is when decision makers use statistical, simulations or financial models to come up with a solution or srtategy” (2).  These decision support systems do not have to be filled with data intensely.

Communications Driven DSS “are targeted at internal teams, including partners. Its purpose are to help conduct a meeting, or for users to collaborate. The most common technology used to deploy the DSS is a web or client server. Examples: chats and instant messaging softwares, online collaboration and net-meeting systems” (3).  This model can be used in various locations including an office environment or on the Internet.


“Decision support systems are gaining an increased popularity in various domains, including business, engineering, the military, and medicine. They are especially valuable in situations in which the amount of available information is prohibitive for the intuition of an unaided human decision maker, and in which precision and optimality are of importance” (4).  Decision support systems can help people with deficiencies by providing various types of useful information, helping people with the process of decision making, and providing a great deal of knowledge.  “They can also support choice among well-defined alternatives and build on formal approaches, such as the methods of engineering economics, operations research, statistics, and decision theory” (4).


1. http://en.wikipedia.org/wiki/Decision_support_system
2. http://www.tech-faq.com/decision-support-system.html
3. http://www.gdrc.org/decision/dss-types.html

4. http://www.pitt.edu/~druzdzel/abstracts/dss.html

T3.11

<iframe width="500" height="400" frameborder="0" scrolling="no" src="http://sheet.zoho.com/publish/vkozlov/kozlov-incorporated"> </iframe>

Electronic Business

Electronic business, which is otherwise referred to as “e-business”, is the submission of information and communication technologies within the business world.  “Commerce constitutes the exchange of products and services between businesses, groups and individuals and can be seen as one of the essential activities of any business. Electronic commerce focuses on the use of ICT to enable the external activities and relationships of the business with individuals, groups and other businesses” (1).  This benefits both the businesses as well as the customers because websites like Amazon have become extremely popular in the world of selling.  “Electronic business methods enable companies to link their internal and external data processing systems more efficiently and flexibly, to work more closely with suppliers and partners, and to better satisfy the needs and expectations of their customers” (1).  With these internet technologies, business profits are booming not only due to the fact that products and services are available online, but also because these businesses care for their customers.  Customer satisfaction is very important in the world of e-business and this is recognized each and every time a customer purchases a product on Amazon or Ebay.  “In addition to buying and selling products, ebusiness may also handle other traditional business aspects. The use of electronic chat as a form of technical and customer support is an excellent example of this. An ebusiness which uses chat to supplement its traditional phone support finds a system, which saves incredible amounts of time while providing opportunities unavailable through traditional support. By using virtual computer systems, for example, technical support operators can remotely access a customer's computer and assist them in correcting a problem” (2).  This is another way in which e-businesses find customer support/satisfaction important.  “Business organizations include any for-profit, governmental, or nonprofit entity. Examples of electronic business processes are:  Production- focused processes include procurement, ordering, automated stock replenishment, payment processing and other electronic links with suppliers, as well as production control and processes more directly related to the production process.  Customer-focused processes include marketing, electronic selling, processing of customers orders and payments, and customer management and support.  Internal or management-focused processes include automated employee services, training, information sharing, video conferencing, and recruiting” (3).  Electronic business has been successful and is consistently improving and growing every day.

1.  http://en.wikipedia.org/wiki/Electronic_business

 

2.  http://www.wisegeek.com/what-is-ebusiness.htm

 
3.  http://www.census.gov/epcd/www/ebusines.htm

Web 2.0

Web 2.0 is a social and innovative concept to the internet as we know it today.  Web 2.0 is developing and witnessing various changes of the web is quite an exciting experience.  “A Web 2.0 site allows users to interact and collaborate with each other in a social media dialogue as consumers of user-generated content in a virtual community, in contrast to websites where users (prosumers) are limited to the active viewing of content that they created and controlled” (1).  We live in a very social, technologically based world and make use of the internet daily by going on facebook, twitter, you tube, myspace, blog sites, and other social networking sites.  These are examples of Web 2.0 and every one of them show how much the internet has evolved.  One reason why Web 2.0 is exciting and changes the internet as we know it today is because people around the world can now publish their own thoughts, ideas, and interact with others within a social media.  “Web 2.0 websites allow users to do more than just retrieve information.  By increasing what was already possible in “Web 1.0”, they provide the user with more user-interface, software and storage facilities, all through their browser.  This has been called “Network as platform” computing.  Users can provide the data that is on a Web 2.0 site and exercise some control over that data.  These sites may have an “Architecture of participation” that encourages users to add value to the application as they use it” (1).  This new generation of the internet is not only about social networking, it is also about allowing its users to go beyond receiving information and using more software.  Web 2.0 is useful in many ways and opens up many more social opportunities for everyone around the world.  “In the year and a half since the term “Web 2.0” has clearly taken hold, with more than 9.5 million citations in Google.  But there’s still a huge amount of disagreement about just what Web 2.0 means, with some people decrying it as a meaningless marketing buzzword, and others accepting it as the new conventional wisdom” (2).  While opinions vary regarding this second generation of the internet, it does not change the fact that it is gaining popularity with new users every day and that it is making the internet ten times better than ever before.  “Originally, data was posted on Web sites, and users simply viewed or downloaded the content. Increasingly, users have more input into the nature and scope of Web content and in some cases exert real-time control over it. For example, multiple-vendor online book outlets such as BookFinder4U make it possible for users to upload book reviews as well as find rare and out-of-print books at a minimum price, and dynamic encyclopedias such as Wikipedia allow users to create and edit the content of a worldwide information database in multiple languages. Internet forums have become more extensive and led to the proliferation of blogging” (3).

 

 

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

2. http://www.oreillynet.com/oreilly/tim/news/2005/09/30/what-is-web-20.html
3.  http://whatis.techtarget.com/definition/0,,sid9_gci1169528,00.html

Zoho Table: Database Lab

http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=215642000000002035&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true&SEARCHBOX=true