PostgreSQL

While doing research on PostgreSQL, I have found a lot of articles about comparing postgreSQL to other database server technologies. PostgreSQL is made for a large company, for large volumes, and with a lot more features.

Features: PostgreSQL is able to do subqueries, stored procedures, and have other views. These features could be vital to the more experienced database designer. If you are running a small business these features are not that important.

Speed: Speed is a question on everyone's mind today. If you are not able to download files fast enough, get up to date information, or have purchases in the system in an instant, the program is useless. When starting with Postgre SQL it my seem slow. But the stability of the software is able to keep up with large volumes of customers, employees, and management.

I hope this is abel to help you understand more about Postgre SQL.

 

http://www.odesk.com/blog/2009/06/postgresql-vs-mysql/

http://www.databasejournal.com/features/mysql/article.php/3288951/PostgreSQL-vs-MySQL-Which-is-better.htm

Technology and Business

We all know one of the best ways to make money is to spend money. If you are a business owner, you see the Iphone, internet, and office tools as a way to make money. These tools can be useful but also costly. With my research online I have found a lot of different answer for each situation. One person put all IT related expenses on a website and gave the pros and cons.

He first discusses monitors. You wouldn't think that monitors would even come up as something to MAKE money would we? A lot of companies now are buying the 17" to 19" flat panel monitors. They are saving money in the long run. They use less heat and power, they save desk space, and just the weight of old CRT monitors could hurt strain somebody's back. He also said you could spend up to $300 per flat panel monitor. If you were a business owner how would you make that decision?

These are real world experiences that come almost every day now to businesses. These are decisions that Systems Analysis has to make on a daily basis. They could help with software choice, or hire someone to program one, to hardware, to even hiring a professional on that certain area.

I want to become a systems analysis. Where I work, I am able to help my boss on certain situations on finding a solution on cutting costs and making money. I will use this knowledge in the future.

http://askville.amazon.com/employer-spend-computers-computer-related-services-employee-year/AnswerViewer.do?requestId=8381463

Data Flow Diagram

Data flow. One of the most sought out systems in the world now. There is so much information at stake that people need a plan of attack to make their orders go right.

Microsoft has come up with a program just for planning out situations. It is called visio. This program helps companies come up with business flow charts, data flow, and even brainstorming charts. These are all helpful tools to use.

In our system design book on page 184 (Systems Analysis and Design, Shelly, pg.184) we had to make a data flow chart for a shipping company. It was like coming up with a system for Amazon. It was interesting to know how the actually data is able to flow from the website to your front door.

One of the situations analysis are put in are to come up with systems to design a data flow charts. It could be from anything from fast food to banks.

Businesses use data now to come up with ways to make the business better. Soon every buesiness will need data flow from the internet to a walk customer. The data will always continue to flow.

What is wrong pg 118

Last Thursday, I was asked to do a presentation in front of the class about what is on page 118 of the Custom program for CIS. It is a WHAT IS WRONG problem out of the book. The situation that was giving me was when a lower skilled employee made a spreadsheet of projected sales for the near future and he tells me just to print it and present. Obviously, there was something wrong with it. I checked it and it was all wrong.

This is a real world experience. When I heard that Ernest Hemingway, one of the greatest writers, made a lot of mistakes when he would write. I made it a point to have myself and someone else check it for me.

Last semester, I was taking an English class and the teacher was strict on mistakes. The first paper I turned in was a D. I was determined not to have that happen again. On the second paper, I proofread myself, I found a lot of mistakes that I didn't even know were there. Then I had my wife proofread it. She found a lot more.

Another example just today. I went to have one of my tires replaced. The advertisement behind them read," Is your A/C running Godd." Obviously no one read that.

This is a great example of proofing what you present. How would it of been if I had just presented what the intern had given me. I would of been the laughing stock of the whole company.

Remember, proofread what you write in word, in excel, in power point, and in any other report type situation.

http://ezinearticles.com/?The-Writing-Style-of-Hemingway&id=70613

The Business Case

In class, for my presentation of chapter 2 (analyzing business cases) in systems designs and analyst, I started out by coming with an idea for a business that we could discuss in this presentation. It turned out to be a great success, to the point where we actually wanted to open this company. The idea was to open up an IT company that would specialize making IT systems for privately owned gyms.
We started out with a SWOT for our business. A SWOT is tool to determine your weaknesses, strengths, opportunities, and threats to our company or system. Some of the strengths would be an untapped market, better controls for their gyms, new technology, and a prepaid idea where someone could pay for 5 to 10 visits instead for a whole month or year. Weaknesses not enough money at first, programmers not experienced enough. Threats would be bigger gyms would want to sell their technology to these gyms. Opportunities would be untapped market and developing new technology and selling that also.
We went to the mission statement for our company. It is “Bring technology to Health.” We will help out these small businesses with good technology that would help control money flow, the customers, and put out a great competition.
This is actually not a bad idea to start. If you have the right people, this could take off. Some other technologies that we came up with is an application on their iphone to track your workout or another app that would tell you how many visits you have left. Another would be to rig the machines to a server and you scan a card that would tell you which machines you used and how long. If you have a personal trainer this would help him or her out a lot.
Stephen Lee

The IF Function

The IF function in excel is for testing data in certain cells in a spreadsheet. This data can be used to tell you if data is true or false. How you use the IF function is simple. First you type an = symbol then you type IF. For example, =IF(. This tells the excel sheet that you are about to do an IF function. Then in the parenthesis select a cell in the spread sheet, for example, B3. Then you tell it if it is greater than with this symbol > or less than < or equal to = then you type in a quotations if it is true or false. =if(b3>0,”love”,”not love”). If b3 is is greater than 0 it will say love in the cell, if it is not it will say not love. This function can be copied for a group of cells.
This Function can be implanted in businesses all over the world. This world can give you a logical test to say if you should sell if b3 is less than this or you should buy vice versa. Try and use this function in business situations and see what it can do for you.

Excel Problem with Worksheet

In excel there is an HLookup function that helps companies to narrow their search for data. This is a great tool to have if you have thousands of different cells of data. Instead of trying to look through all of the cells. You can put in a function to find what you are looking for in a couple of steps.

Today, the exercise that we got was to look at the formula and figure out what the problem is in the formula. In the formula =HLOOKUP($C$3,'Historical Data'!$B$2:$F$9,3,FALSE). I thought it was the first set of cells that it was getting wrong. The last number where the 3 is that is what row to look at on the sheet. But, it was on the other sheet, That was saying what row to look at on the other sheet. That was wrong. The last number should be 4. The rows on the other sheet start different. 2 is actually 3, 3 is actually 4. I didn't know this. That is the solution that I overlooked. The solution is this =HLOOKUP($C$3,'Historical Data'!$B$2:$F$9,4,FALSE)

 

The other problem in the worksheet is that the Vlookup didn't have a range lookup. This tells the solution what you are looking for if it is true or false. I simply put false at the end of the statement and it was right. =VLOOKUP($C$9,'Stock Data'!$A$2:$C$7,3,FALSE)