Discussion on Data Access Interface System and Data Object Model - [Appendix]

zhaozj2021-02-16  45

Discussion on Data Access Interface System and Data Object Model (BEAT 1.0)

81_redstar81@163.com Tomhornson.student@www.sina.com.cn

Personal collection: http://www.9cbs.net/develop/author/netauthor/redstar81/ This note is the query information. Since many problems are very vague. Therefore, some reference books may be taken in, please pay attention. American Famous Database Product Notepad (Reference)

Manufacturer

time

Time description

A-T

82

DBASE II listing (8 digits)

85

DBASE III listing (8 digits, 16)

88.10

DBASEV listing (1. Support SQL 2. Has compilation function 3. Provide menu system 4. Provide control center)

Borland

x

Successfully launched DBASEIV 2.0, DBase 5.0 for Windows, Paradox

Fox

86

Foxbase listing

87.7

FoxBase listing (performance is far better than DBASE)

88.7

FoxBase 2.10 (1. Have a pseudo-compilation ability: generated code is not executable 2. Provide interfaces with other languages)

89

FoxPro 1.0 (providing window interface)

91

FoxPro 2.0 (1. Increase SQL Interface 2. Realize true compilation: package code and running environment together 3. Provide API interface)

Microsoft

93.1

Microsoft launches FoxPro2.5 for DOS (interface characteristics like DBASE control center) and FoxPro2.5 for Windows

94

FoxPro 2.6 (add a variety of wizards than FoxPro 2.5 to simplify the user's operation)

95

Visul FoxPro

Sybase

84.11

1. Database product of the first C / S structure 2. Interactive language with SQL as standard

87

Sybase SQL Server

Xx

Sybase system 10

Xx

Sybase System 11

Oracle

77

First DBMS listing

79

The first use SQL as a standard interactive language

83

Third Edition: The original system is rewritten with C

84

1. Fourth Edition: Allows the large, medium, and small machines to share data 2. Implemented Oracle's microcomputer version.

86

Fifth Edition: Increased interfaces with various advanced languages, decision support tools, and network communication software, forming an open distributed RDBMS architecture (SQL * STAR)

88

Sixth Edition: With online transaction

IBM

1982

SQL / DS and DB2 implement SQL interactive interface

Other Information

SQL related

1.Sequel is the predecessor of standard relational database language SQL, and brought by Boyce and Chamberlin in 1974 2.1974-1977, the US IBM California San Jase Lab has developed the first relationship database of SEQUEL 2, System R 3.1976.10.16 ANSI Approve SQL as a national standard. Later ISO will also receive a draft ISO standard

C / S related

1.1984, Sybase launched the first C / S structure for the 2.90-year C / S structure is widely popular, Oracle, Informix, Ingrs have launched a distributed database product with C / S structures and the corresponding client tools 3. Natural earlier distributed structure is to achieve multi-point query and directory service, the C / S structure is to handle some of the DBMS's partial functions to client, so that the diet is detailed 3. The microcomputer appears as a premise of the C / S structure solution

------------------------------------------------statement- --------------------------------------------------

This document describes the development history of the data access interface and the data object model, which describes its trajectory. I hope to help the data system developer. In this article, For a long time (for myself), please refer to books, there is a mistake, please point out 81_redstar@163.com This document is labeled, the purpose is to hope that you will find yourself or wrong or need to add places, contact I, modify it, improve it. Make it a lasting online reference.

BEAT 1.0 2003.2.25 -----------------------------------

转载请注明原文地址:https://www.9cbs.com/read-23572.html

New Post(0)