smrfdady’s blog

So after some thought I guess I can see the value of squidoo.  It is like a wiki only a little different.  Unlike a wiki, users cannot change the content of squidoo.  I guess Squidoo would prove more valuable if I was actually selling some product or service.  Even though I am not charging I guess people can look at my lens on squidoo and baffle their brain with information about database management. I know some of the information may seem incomplete.  There is a lot or room for some expansion on the topics.  Without some depth of knowledge regarding the inner workings of network technology one will become lost.  I might have just lost some in the last sentence.  Well database management is an important topic for everyone even if you don't read it on Squidoo.

Well I have tried squidoo.  I don't really know what to think.  It is neat...I suppose. I guess I haven't explore the full potential of the site.  I created my lens.  I was not able to link this blog to the lens.  It couldn't find it or something.  It wasn't the most user friendly.  I finally did it. So now what do I do with my Squidoo?  I guess I have the option to send it out to the world and market it. Here is the link to see a touch of what database management is...it is the same information you read here only all together. http://www.squidoo.com/database_managemet. You to can squidoo...haha.

I had no idea that computers had so many languages. In researching this topic after uncovering a couple of languages I thought I was done. Here are four more languages that are used in databases and management systems. Fourth-generation languages, 4GL are programming languages closer to human languages than typical high-level programming languages. Most 4GLs are used to access databases. For example, a typical 4GL command is: FIND ALL RECORDS WHERE NAME IS "SMITH".  The first generation language is machine language.  The second is assembly language.  The third generation is high-level programming languages, such as C, C++, and Java. The fourth generation contains languages used for artificial intelligence and neural networks.

SQL is a standardized query language for requesting information from a database. The original version called SEQUEL (structured English query language) was designed by an IBM research center in 1974 and 1975. SQL was first introduced as a commercial database system in 1979 by Oracle Corporation. SQL has been the favorite query language for database management systems running on minicomputers and mainframes. We are currently seeing more PC databases supporting because it supports distributed databases (databases that are spread out over several computer systems). This enables several users on a local-area network to access the same database simultaneously. There are different dialects of SQL, however, it is the closest thing to a standard query language that currently exists.  After further research I found the newest standard is known as SAG SQL.  SQL Access Group (SAG) was a group of software companies that was formed in 1989 to define and promote standards for database portability and interoperability.  The SAG started the development of the SQL Call Level Interface which later was published as an X/Open specification.

Database management is used in internet businesses to manage tens of thousands of users and their information. This allows the company to process extreme amounts of transactions with ease. Database management allows companies to handle information in one location that can be accessed at any satellite location or workspace. Data management systems help to increase business intelligence by allowing managers access to specific data when it is needed to make crucial decisions. This is made possible by mySQL applications in database management software. As you can see data management makes the world go around. It is essential in business or any other area of focus.

I guess this would be more appropriate if it read, What areas can database management not be used?  Database management can be use in all areas of business or in almost every profession.   Database management can be used alongside any technology. It can be used to warehouse or store data. There are mobile applications that allow data to be stored and managed in mobile devices, handheld or laptop. This is done with SQL anywhere programs. It can be used in personal businesses, country clubs, hospitals, even construction job sites. Database management software is used by government agencies, for example the Internal Revenue Service (IRS), to manage taxpayer information. 

Unlike other types of documents, databases have a more complex programming.  In MS Word or MS Excel you just type info and save it or formulate cells and then input and save. Requests for information from a database are made in the form of a query, which is a stylized question. There is a specific protocol to constructing queries.   The set of rules for constructing queries is known as a query language. Different DBMSs support different query languages, although there is a semi-standardized query language called SQL (structured query language). Sophisticated languages for managing database systems are called fourth-generation languages, or 4GLs for short.

After looking into relational databases I found that they go deeper than basic columns and rows.  Relational database management systems divide into four major classes:

The first is High-end OLTP (OnLine Transaction Processing) relational DBMS. Oracle is the flagship for this category, followed by DB2. The second is specialty data

warehouse DBMS. Teradata is the leader here, followed by

Netezza, DATAllegro, ParAccel, Vertica, Infobright, Greenplum, Kognitio, Sybase IQ, and a host of others. The third class is mid-range relational database management systems. Most of the contenders here fall into one or more of three categories: Open-source-based relational DBMS (MySQL, PostgreSQL, EnterpriseDB); reseller-focused relational DBMS (Progress OpenEdge, Pervasive PSQL); or crippled “editions” of high-end systems. Microsoft SQL Server was once a clear mid-range system, but now is better classified as high-end OLTP. The forth class is embedded relational database management systems. The leader of this category is Sybase’s SQL Anywhere. Also significant are memory-centric products Oracle TimesTen and solidDB.

I know that we all know about database management systems...right?  Well, there are many companies that have their own system or software for creating the management systems.  The most popular is of course Microsoft Access. Their are several other system or system software providers out their: Zoho Create, Google, Dabble DB, Base Portal, Bitcut and CorneliOS.  These are all sites and/or services that can be used to manage databases on Web 2.0.  Database management systems(DBMS) come in a couple of different types and each has its benefits.  One is the relational DBMS.  In a relational database, data is stored in rows and columns.  The other type is object-oriented DBMS.  This is mainly used for multimedia applications and Java applets.  The DBMS stores the data and procedure that act on those data as objects that can be automatically retrieved and shared. There is a third type that are somewhat new.  it is a hybrid of the first two.  It is object-relational DBMS.  It has the capabilities of both previously mentioned DBMS.  Exciting stuff huh?

We just finished a class of self education about computers and now we delve into the realm of Web 2.0 and all of the cool and/or complicated technology. I chose a topic that is essential to any operation in web 2.0, database management.  I know...I thought it was over too.  I never wanted to see another section on database management or anything of the like.  What is it?  Database management is what differentiates web2.0 form web 1.0.   Database management is also the common core competency of most successful web 2.0 companies.  What does database management software and applications do?  They help to create online database applications to collect and manage it online. But that's not all................