Differences between decision support systems and operational database systems

May 16, 2012 in Uncategorized

Decision support systems and operational database systems are similar because both use stored data, but the data is organized differently for the two types (Power, 2007, par 1). Powers (2007) also states that DSS data is data about business occurrences and often a summarization of transaction. Operational data is a detailed record of a company’s daily business transactions.

The benefits of DSS and ODS are:

DSS
1. Improves personal efficiency
2. Speed up the process of decision making
3. Increases organizational control
4. Encourages exploration and discovery on the part of the decision maker
5. Speeds up problem solving in an organization
6. Facilitates interpersonal communication
7. Promotes learning or training
8. Generates new evidence in support of a decision
9. Creates a competitive advantage over competition
10. Reveals new approaches to thinking about the problem space
11. Helps automate managerial processes

ODS
1. Quick retrieval
2. the ability to share information across the company
3. The amount of data that can be stored that pertains to a business
4. provide simultaneous read/write requests through pre-defined queries
5. have the ability to flag specific information that may need to be retrieved on a continuous basis

Powers, D. 2007. How does DSS data differ from operational data?, DSSResources.com Retrieved from http://dssresources.com/faq/index.php?action=artikel&id=146

How might we consider storing XML data in a database? What are the advantages and disadvantages?

May 3, 2012 in Research

The ability to store XML in a database for retrieval and updating on demand has became a requirement. Also there is the ability to take the inverse of that requirement which is to take the regular or nonXML data and convert it to XML form. There are three ways that data can be stored in a database which are:

1. Store the entire document as attribute values in a table.
This is done by defining a new data type “XMLDOC” which values are XML documents and define specific attributes of specific relvars to be of that type. XMLDOC have a set of associated operators that provide retrieval and update capabilities on XMLDOC-valued attributes at a lower-level, supporting access to individual elements or XML attributes.

2. Shred the document and represent various pieces of it as various attribute values within various tuples within various relations.

Although no new data types are used XML documents are shredded into individual XML elements and attributes and stored as values of various relational attributes in various places in the database. With this approach an application can create an XML document from regular database data. The problem know of method is the “impedance mismatch”. This is when child nodes of a given parent node in the hierarchic model form not a set but a XML document D, where aspects of D is lost when shredded and stored in the database.

3. Store the document in a native XML database and not in a conventional database.
There is no reason to use a XML database which is just a desire for completeness. A relational model is adequate enough to represent any data.

Developer vs. Business Manager

October 14, 2011 in Uncategorized

Developer vs. Business Manager

But first, a funny story: A man is flying in a hot air balloon and realizes he is lost. He reduces height and spots a man down below. He lowers the balloon further and shouts: “Excuse me, can you tell me where I am?” The man below says: “Yes you’re in a hot air balloon, hovering 30 feet above this field.” “You must be a software developer,” says the balloonist. “I am,” replies the man. “How did you know?” “Well,” says the balloonist, “everything you have told me is technically correct, but it’s of no use to anyone.” The man below says, “You must work in business as a manager.” “I do,” replies the balloonist, “but how did you know?” “Well,” says the man, “you don’t know where you are or where you are going, but you expect me to be able to help. You’re in the same position you were before we met but now it’s my fault.” (Jeroenvan den Bos, 2005)

http://www.scn.org/tesc-ds/2002-2003/fall/slides/what-user-wanted.html

Search Engines: Improve learning through searches

June 13, 2011 in Research

I have redirected my research temporally to educational based search engines. My focus is to develop a search engine that will promote learning. Currently, there are downfalls with most modern day search engines, which are:

  1. vague array of information
  2. doesn’t use reasoning to consolidate information to formulate a search result
  3. search results are not narrow or specific
  4. results may not be relevant to keywords or phrase
  5. does not show mathematical steps of computed results
  6. hinders the student’s ability to compute equations mentally

The key is to give a user relevant results related to their search topic. You don’t want to give the user over 15 search results because it will then become a tedious process of elimination for the user. But, you do what the user to go through a thinking process to find exactly what they want. If the search engine was to just give an user an answer it will create negative impact on users learning ability. For example: most people have lost the skill to computed mathematical equations mentally because they have been crippled by calculators.

My current research will apply solutions to address these problems while  increasing search engine accuracy.

 

Are you tired of searching millions of web pages for one answer?

April 22, 2011 in Research

Natural Language Processing

I will begin the saga of my research with natural language processing. Within this discipline I will focus on developing and efficient and robust way to process natural language. Once a phrase, sentence, or clause is interpreted the extracted keywords or buzzwords will be used for searching. A single search result will be selected with the use of a fuzzy logic algorithm. The purpose of this research is to optimize the way we search and receive information from the World Wide Web.