Databases By Naveena Bellam, Ryan Hallinan, Joseph Marks, and Brett Merriam Introduction to Databases Databases are a collection of organized information that categorizes its content into relevant information. Data about cats will be found with other data about cats. Data about dogs will fall under other data about dogs. Both of these would fall under data about animals. A database base system is expected to be of high quality. By following the database management system, this is measured by accuracy of data and the availability and usability of the data. These databases are located on servers. Databases management systems are general software programs that meet the requirements to manage a large and complex database system. Some of the most common database management system programs include: Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite. Databases databases are designed to work with a specific dbms but since the standards used between many of the listed dbms are similar, such as sql, and the programs are interchangeable. Databases are used everywhere, from school research, to business and work or to just common internet browsing. We need databases as a reliable way of quickly accessing information. We also need them to keep information secure. On top of that, we need them to be accurate. Our dbms's provides exactly that. History of Databases Databases have been around since we started to write to later referred back to it for future generations. Some databases were used in the government offices, hospitals, business, and organizations. This essentially was the start of a library were you could share and learn about information. Database has been a concept for a long time. In the 1960’s we wanted to use this concept to put information in the computer memory so we could direct access it easily then going to a library looking through books to find your answer. This task would be difficult to do because of the little memory you had and the processors of the computer. These databases systems had several levels of quality in things like accuracy, usability, resilience, and availability. These databases were very complex and had to be properly maintained. Real World Databases There are many different types of databases out there today. They have many purposes for each one. There is a scientific database that is used for genome research and related research area in molecular an cellular biology. This contains gene catalogs for completely sequenced genomes and some partial genomes, genome maps, and organism information, and data about sequence similarities among all known genes in all organism. Nonprofit organizations like having and antique automobile club and that these nonprofit organizations don’t have many members and that would make the database smaller than other databases. That it could store names addresses, color, year what condition it is in. It can also tell who owns it. Another real world database that I use almost every day is IMDB. This is International Movie Data Base that you can find almost any movie that was made. You can look up who is the actors on it, have a background of the movie/plot, trivia, goofs, quotes, and much more. It also shows what movies will be coming out in theaters in the near future. It also shows which movies/television season that had come out recently. IMDB shows what is also popular. There are many more like Google Cloud, HP Cloud, Microsoft Database, Oracle Database Cloud, IBM SmartCloud, Rackspace Cloud Databases, and many more. Types of Databases There are different types of databases. They are:
Database Language The programming languages that are used to define, work and inquire a database are called as database language. Each database language is based on specific data structure. There are few examples of database languages they are: SQL This Structured Query Language is a language used especially for relational database management system. The following is the example of SQL database  The subsets of the SQL language are:
The standard query language for object oriented databases is called as Object Query Language. The following is the example of OQL language.  Future of Databases As of today, the year 2012, we have devices that are always connected. We as humans are more connected to the world around us than we have ever been in history, all thanks to the Internet. Devices that can give you directions to anywhere around the world, applications that can track your every movement minute by minute, music players that can create personalized playlists of ones choosing, and most importantly, access to the internet wherever and whenever you want via Wi-Fi or through cellular service. All of these services utilize some sort of database to sort and store user information and movement through their system, and these systems are just in their infancy. Databases are in our everyday life with or without us realizing that that is what we are using. Your music playlists on your device are small portable databases that are always on and always with you. The menus that are used thousands of times a day in restaurants are part of a database, albeit an analog database, but nonetheless a database that we use every day. This is just the beginning when it comes to what databases can be used for when it comes to technology. In the next decade we could see the creation of database systems that allow you to ask your device to schedule and appointment with your doctor or dentist, make a payment on a credit card just thorough voice commands, ask your device to play music based on your mood. All these ideas could be brought to life by the use of smarter, more efficient databases that store user preferences and make smarter judgments about what the user wants based on their style and mood. When we look even farther into the future, humans could be integrated even more so by combining processors with the brain to create a connection to the Internet and databases just by thought. The idea is that we could do every day activities with just our thoughts. Things like ordering take-out, starting your car through your wireless device, or asking Google to search the score of the game, all through an imbedded processor in our brains. This last idea seems extreme by our standards to say, but in ten or twenty years time, the ideas and opportunities are endless. Databases are just in their infancy, and the sky is the limit on what they can be used for in this growing technological age. Conclusion Databases have evolved steadily through the evolution of humanity. From libraries to lunch menus, to the Internet and iTunes, databases have evolved and revolutionized the way we live our lives, and the way we connect to the rest of the world. We as a society have gone from having to leave our homes to do everything from going to the library to do research, purchasing groceries, buying a new car, seeing the world, to being able to, through the use of smarter and smarter databases, do all the things that were mentioned before and then some. Society and technologies, like databases have made it perfectly acceptable, and possible, to do everything from your home computer or wireless device. Only time will tell what the future holds, and with the way that database technology has been improving and revolutionizing the way we live, there is no way to be certain what we will be able to do through their use. Works Cited (2012, October 10). Database Languages. Retrieved from, http://en.wikipedia.org/wiki/Database#Database_languages (2012, October 10). OQL Database Language. Retrieved from, http://en.wikipedia.org/wiki/OQL (2012, October 10). SQL Data Types. Retrieved from, http://en.wikipedia.org/wiki/SQL#Data_types (2012, October 10). Database Type Examples. Retrieved from, http://en.wikipedia.org/wiki/Database#Database_type_examples (2012, October 10). Cloud Database. Retrieved from, http://en.wikipedia.org/wiki/Cloud_database (2012, October 10). Active Database. Retrieved from, http://en.wikipedia.org/wiki/Active_database (2012, October 10).Data Mart. Retrieved from, http://en.wikipedia.org/wiki/Data_mart (2012, October 10). Data Warehouse. Retrieved from, http://en.wikipedia.org/wiki/Data_warehouse (2012, October 10). Distributed Database. Retrieved from, http://en.wikipedia.org/wiki/Distributed_database (2012, October 10). Document-Oriented Database. Retrieved from, http://en.wikipedia.org/wiki/Document-oriented_database (2012, October 10). Embedded Database. Retrieved from, http://en.wikipedia.org/wiki/Embedded_database
Intuit (2012). A Timeline of Databases. Retrieved from,
http://quickbase.intuit.com/articles/timeline-of-database-history
One Stop Web Site Shop (2012). Database type. Retrieved from,
http://www.theonestopwebsiteshop.com/web-design/database-type.htm
Susuan de Sousa (2012). Different Types of Databases. Retrieved from
(2012, October 10). Types of Databases. Retrieved from, http://en.wikipedia.org/wiki/Category:Types_of_databases Derrick Harris (2012).Cloud Databases 101, Who builds em and what they do. Retrieved from
http://gigaom.com/cloud/cloud-databases-101-who-builds-em-and-what-they-do/
Thomas Claburn (2012). Google Introduces Cloud Database. Retrieved from
etutorials (2012). Real-Life Databases Examples. Retrieved from
IMDB (2012). Example of a Real Database. Retrieved from
Barry Williams (2012). The Future of Databases; The Vision. Retrieved from
http://www.databaseanswers.org/Future_of_Databases/the_vision.htm |