Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

SQL etc

Posted Jun 28, 2001

Beginning SQL Programming: Pt. 1 - Page 7

By DatabaseJournal.com Staff

  • Database Engine: The part of the DBMS that works with the data

    An engine typically has code that can search, read, write, index and otherwise execute the actual interaction with the information. A database engine performs the largest share of work in most databases and thus it is the subject of an intense optimization effort by the DBMS creators. Some of the most advanced DBMS have engines which can self-optimize after monitoring the actual conditions after deployment. A DBMS will have additional features that are not part of the data engine, including query analyzing, replication and back-up tools, user management, security tools and performance monitoring.

    Database Terminology Diagram
    (click image to view full size)

  • Results: The term "Result" frequently confuses folks learning SQL because the term can be used in three ways:

    • First, and most common, we mean a set of data that is returned after a front end sends a SQL statement to a DBMS. You ask for "The first and last names of all the employees that started after 1995" and you get back a block of characters (a recordset) containing those names.

      But what if the SQL statement instructs the DBMS to modify data rather than just read it?

    • The second case is when the "result" refers to a change in the data. We do not necessarily receive any characters back from the DBMS although we may get a status message noting that the operation was successful.

    • Third, we may make changes to the data and have the DBMS report back to us on the changes. Frequently this is a notice of how many records were changed or what errors arose or a True/False that the SQL statement was executed successfully. In this case we get a result back, but it is not actual data; it is a message or code indicating the number of records changed, an error or success.

    In this book we use the term all three ways since there is no common alternative vocabulary.

  • "SQL" and "SQL Server": SQL is the name of an open-standard language for communicating with databases. Microsoft SQL Server and Sybase SQL Server are proprietary DBMS products that can handle SQL statements. Microsoft SQL Server is popular, but it is only one of many DBMS that can handle your data and your SQL statements.

SQL etc Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM