write an opened file! "Exit subEnd if'Check whether the Excel file exists. If yes, delete it.If Dir (App. Path "/myexcel.xls") 'For Data ConversionDim dbs as database'Open the databaseSet DBS = opendatabase ("", false, false, "ODBC; DSN = IDMS; database = IDMS; uid = sa; Pwd =;") 'connection string, modify as needed'Import data to excelDBS. Execute "select" "personid as resident number, name as name, sex
widely used relational data systems.
Oracle relational database products:
Oracle Database has the following excellent features.
(1) Compatibility
Oracle adopts standard SQL and has been tested by NIST. Compatible with ibm SQL/DS, DB2, INGRES, IDMS/R, etc.
(2) portability
Oracle products can run on a wide range of hardware and operating system platforms. It can be installed on 70 or more large, medium, and small computers. It can be installed in VMS,
, SetThe Database Management System has laid the foundation for the mesh database, which was widely promoted and applied at that time.As a database product in the initial stage, IDS can only run on the host of a general company.1971, number in the US Data Systems Commission (CODASYL)Data Base Task Group (DBTG) presents a well-known DBTG report for the mesh Data model andThe language was defined and modified and supplemented twice in 1978 and 1981. Therefore, the mesh Data Model is also called CO
adopts standard SQL and has been tested by NIST. Compatible with ibm SQL/DS, DB2, INGRES, IDMS/R, etc.
(2) Portability
Oracle products can run on a wide range of hardware and operating system platforms. It can be installed on 70 or more large, medium, and small computers, and can work in VMS, DOS, UNIX, Windows, and other operating systems.
(3) connectability
Oracle can be connected to multiple communication networks and support various protocols (TC
Technology (NIST). Compatible with IBM SQL/DS,DB2,INGRES,IDMS/R.
(2) Portability
Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different types of large, medium and small machines, can be in VMs, DOS, UNIX, Windows and other operating systems under a variety of operation.
(3) Connectivity
Can be connected with a variety of communication networks, support various protocols (TC
industry. In 1984, the relational database was first transferred to the desktop computer. Then,Oracle5 pioneered the new concepts of distributed databases, client /server architectures, and more. The latest Oracle 12c increases the object technology and becomes the relational-object database system. Oracle is now one of themost widely used relational data systems in the world , covering dozens of models, including large, medium and small machines.
Advantages:
Compati
COBOL.
2, Nonrelational DBMS (non-relational database management system)
In the 1980s, the database management system is divided into two categories, one is the hierarchical system, such as IBM's IMS, SAS Institute Inc. system 2000, the second is network systems, such as CA IDMS, Oracle DBMS (VAX DBMS predecessor), Today, however, they are replaced by relational database systems expressed in SQL, such as DB2, Oracle, and SQL Server.
3, non-IP network
, connectivity, high productivity, and openness. Oracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM sql/ds,db2,ingres,idms/r. Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different large, medium and small machines, can be in VMs, DOS, UNIX, Windows and other operating systems under the work. Can be c
database was first transferred to the desktop computer. Then, Oracle5 pioneered the new concepts of distributed databases, client/server architectures, and more. Oracle 6 first-line lockdown mode and support for Chenduo processing computers ... The latest Oracle 8 increases the object technology and becomes the relational-object database system. Oracle is now one of the most widely used relational data systems in the world, covering dozens of models, including large, medium and small machines.O
) CompatibilityOracle adopts standard SQL and has been tested by NIST. Compatible with ibm SQL/DS, DB2, INGRES, IDMS/R, etc.(2) portabilityOracle products can run on a wide range of hardware and operating system platforms. It can be installed on 70 or more large, medium, and small computers. It can be installed in VMS,Work in multiple operating systems, such as DOS, UNIX, and WINDOWS.(3) connectabilityCan be connected to multiple communication network
, INGRES, IDMS/R, etc.
2) portability
Oracle products can run on a wide range of hardware and operating system platforms. It can be installed on 70 or more large, medium, and small computers, and can work in VMS, DOS, UNIX, WINDOWS, and other operating systems.
3) connectability
Can be connected to multiple communication networks and support various protocols, such as TCP/IP, DECnet, and LU6.2 ).
4) High Productivity
A variety of development tools are
databases at the same time.
22. multiple versions of Oracle Database can be installed on one operating system (either Unix or NT ).
23. A set of Oracle Database Systems can contain multiple Oracle databases and their corresponding instances.
24. Each Oracle database has one database instance (except OPS ).
25. Therefore, multiple Oracle database instances can be started on one operating system at the same time.
Excellent features of Oracle database products
(1) Compatibility
Oracle adopts stand
1951: The UNIVAC system uses tape and punched cards for data storage.
1956: IBM first introduced a disk drive in its model 305 ramac
1961: Charles Bachman OF Ge developed the first database management system, IDs.
1969: e.f. codd invented relational database.
1973 Cullinane, led by John J. Cullinane, developed IDMS, a network model-based database for IBM hosts.
1976: Honeywell launched multics relational data store, the first commercial relationa
have the following excellent features.
(1) Compatibility
Oracle products adopt standard SQL and are tested by the United States National Standards Technology (NIST). Compatible with IBM SQL/DS,DB2,INGRES,IDMS/R.
(2) Portability
Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different types of large, medium and small machines, can be in VMS,DOS, UNIX, Windows and many other operat
have the following excellent features.
(1) Compatibility
Oracle products adopt standard SQL and are tested by the United States National Standards Technology (NIST). Compatible with IBM SQL/DS,DB2,INGRES,IDMS/R.
(2) Portability
Oracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different types of large, medium and small machines, can be in VMS,
DOS, UNIX, Windows and many other o
features.(1) CompatibilityOracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM Sql/ds, DB2, INGRES, IDMS/R, and more.(2) PortabilityOracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different large, medium and small machines, can be in VMs, DOS, UNIX, Windows and other operating systems under the work.(3)
processing computers ... The latest Oracle 8 increases the object technology and becomes the relational-object database system. Oracle is now one of the most widely used relational data systems in the world, covering dozens of models, including large, medium and small machines.Oracle database products have the following excellent features.(1) CompatibilityOracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM Sql/ds, DB
systems in the world.Oracle database products have the following excellent features.(1) CompatibilityOracle products are standard SQL and tested by the U.S. National Institute of Standards and Technology (NIST). Compatible with IBM Sql/ds, DB2, INGRES, IDMS/R, and more.(2) PortabilityOracle's products can run on a wide range of hardware and operating system platforms. Can be installed in more than 70 different large, medium and small machines, can be
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.