DBMS - The underlying software mechanism of every database is a database management system

Database Management Systems (DBMS)

The underlying software mechanism of every database is a database management system (DBMS). Whitemarsh provides materials that describe computer science technology from which the features of a DBMS are configured.

Most DBMS's are based on the SQL language standardized by ANSI and ISO. Whitemarsh, an officer and member of the ANSI INCITS DM2 Technical Committee on Database since 1978 has participated in the development of all SQL standards.

Since SQL buyers cannot avail themselves of any conformance tests, Whitemarsh provides detailed features evaluation questionnaires that can be employed by DBMS buyers to select the DBMS must suitable to their needs.

ANSI Database Standards

Form: Paper

Sample?

This book contains the history of database management systems with an emphasis of the ANSI process. ANSI database standardization started in 1978 upon the foundation that was built by the various CODASYL journals of development. Featured are the CODASYL JODs, ANSI/NDL, ANSI SQL, and the standards related to ANSI/SQL including SQL?1986, 1989, 1992, 1999, and 2003.

DBMS Selection and Evaluation

Form: Book

Sample?

This material contains a very detailed questionnaire that can be used to select and evaluate network, hierarchical, independent logical file and ANSI/SQL based DBMSs. The questionnaire is about 150 pages long and is organized into a yes/no answer format.Supplementing the questionnaire are weighting factors for the various levels of questions within the hierarchically organized questionnaire.

DBMS Technology

Form: Book

Sample?
New!

The DBMS Technology book was originally written in 1991. This book has been updated to reflect the DBMS status of 2005. In 1991 when the book was first published it's central tenant was that there was an overarching architecture to all DBMS technology and that all the different DBMSs were a subset of that DBMS Technology Architecture. That is still true. What has now changed is that instead of just four data models, there are now five. The new data model is the SQL data model. It is new because it represents a melding of Network, Hierarchical, Independent Logical File, and Relational. Most of the "old tyme" DBMSs are still here but they are updated to be able to "speak" the SQL language. This book represents a good technology book for any DBMS course. Use it as such. Remember, however, this is a DBMS textbook, not a database textbook.

DBMS Technology

Form: Course

Sample?
New!

The DBMS Technology book contains just six chapters. The course materials therefore has a same number of chapters. Each of the six separate pdf-based files is about 75 to 125 overheads. These overheads follow the book very closely. Many database courses have almost no material about DBMSs. This course and the DBMS Technology book focuses entirely on DBMS. Thus, the traditional database course book and course and these DBMS Technology book and course are perfect complements. We therefore recommend that these materials provide an infusion of DBMS technology into any database course.

Enterprise Data Management in an ANSI Standards Environment

Form: Paper

Sample?

This paper presents key topics relevant to implementing ANSI standards relevant to data management. Topics include, Data Is Executed Policy, T2 (Conceptual Schemas), L8 (Business Fact Representation), H2 (Database Management Systems), Data Management Standards Synergy, Open and Closed Data Management Architectures, Enterprises and Architectures, External Data Management Standards Role, Internal Data Management Standards Role, Government's External Data Management Standards Role, Government's Internal Data Management Standards Role of Government, and the NIST's Congressional Mandates.

Essential Paradigm of IT Standards

Form: Paper

Sample?

This paper identifies the key components of a successful information technology standard and provides examples of successes and failtures. The paper then presents the role that should be undertaken by government, that is, conformance testing.

Great News - The Relational Model Is Dead

Form: Paper

Sample?

This 24 page paper shows how SQL1999 is clearly NO LONGER relational. Rather it includes aspects of the Codasyl network, hierarchical, and independent logical file data models as well.

Is SQL a Real Standard Any More

Form: Paper

Sample?

This paper asks the question because a survey of SQL vendors during 2000 and 2001 showed that a significant quantity of vendors do not seem to be implementing a significantly common portion of the new standard. The paper presents the key areas and then provides response tables (without vendor names) as to the implementation plans of the SQL vendors.

SQL 1999 Impact on Data Administration

Form: Course

Sample?

This course presents the key features of the SQL:1999 standard and then shows the impact that this standard has on data administration, database administration, database design, and database application development.

SQL1999 DBMS

Form: Course

Sample?

This 70+ page presentation presents the materials from the Great News paper and includes overheads that show examples of some of the syntax and data structures possible under SQL. The SQL standard for $20 per portion from www.ncits.org.

For Sales and Corporate: 1-301-249-1142 Whitemarsh@Wiscorp.com

Whitemarsh Information Systems Corporation

Bowie, Maryland 20716 USA