SQL - Historical Information
In the 60's database software required the use of complex mainframe machines that were difficult to maintain and run. Information technologists worked around the clock monitoring, updated, and manually uncorrupting these machines.
Each mainframe ran different software from different manufacturers. IBM pulled ahead in software development internationally with efforts of software aimed at database management. The problem was that each mainframe ran a different type of "language".
Enter SQL. The new standard for any database program: Structured Query Language. SQL bridged the barriers between mainframes and allowed large corporations to network their efforts. SQL was introduced in the 1970's and quickly gained international popularity. SQL allows a programmer to tell a program exactly what data to retrieve and how to display it.
SQL - Under Development
Software at the time was still underdeveloped and several continuous problems plagued database storage. Transactions happening at the same time were often combined, mixed together, or even lost altogether. For instance, say two individuals place make a deposit at exactly the same time from two different locations, often times the software was unable to cope with this and their bank transactions could be completely switched. Suzy deposited $10,000 while Joe withdrew $15. Because of the faulty software it was not uncommon to see Joe's withdrawal post on Suzy's account while Suzy's deposit is posted on Joe's account.
Along came Relational Database Management Systems (RDBMS). This software is still being used and is quite powerful. Relational databases allow the developer to build relationships between databases and tables. This provides tremendous opportunities for data management and is still the favorite software used today. MySQL, SQL Server, DB2, and Oracle are all RDBMSs and each have a substantial hold in the market share to this day.
|