-There were a lot of things that I learned this week on databases, so once again this is a muddy topic for me. I have heard of previously about 95% of the stuff in this class, however, this stuff is unknown to me because I have never done any research on these topics before. Sure I have heard of data and information, like who hasn’t right? But to learn that information is data just presented in a context that people can understand it. There is use to putting all sorts of numbers into databases like sales and losses, or new members vs. members that left the club, and so on. There are programs that filter all of this information and help companies with marketing and other areas of their business to help with growth and sales.
-I had not a clue what SQL was or is, a structured query language that is used to create and manipulate databases. Microsoft has SQL server which probably costs a ton of money and opensource has MySQL which was noted in a previous lesson, is free for the most part. To analyze the data is just amazing with how much data is out there, it was noted in the book that walmart has more than 125 times the data than the US congress or something in that area.
-There was also talk this week about big companies having a lot of data but nothing to do with it. Like if two companies merge and the data is different or the systems are not compatible what is the company to do? And I have never heard of a data warehouse or a data mart? Definitely a first for me, but all very interesting. Like I said last week, I have only made two databases and this project will be my second one. Not too hard but I guess I will find out by my grade L. Here is a short video on the basics of data warehousing that I found helpful on Youtube, with permission “standard Youtube license.”
No comments:
Post a Comment