Oracle product support the broadest operating system platform, the Oracle relational database market share rate at the top, the Oracle was among the first to put forward one of the products of relational database based on standard SQL database language, introduced in 1979, nearly two decades of all kinds of advanced technologies of database, in the field of minicomputers and microcomputers relationship database system, occupies an important position, since the beginning of the fifth edition, support the client/server and collaborative server, the latest version was launched in 1998, ORACLE8.0, compatibility, portability, associativity, high productivity, also has the following features:
(1) the veritable large database: ORAQCLE established database, maximum data quantity can reach hundreds of GB;
(2) Shared SQL and multithreading server architecture: the combination of these two features, reduce the resource usage ORACLE, enhance the capacity of processing, can support hundreds or even thousands of users,
(3) the cross-platform ability: the ORACLE database management system can be run on more than 100 hardware and software platform, this platform for other PC database products,
(4) distributed database: can make the data on the physical distribution various multiple databases, is seen as a complete logical database, while the data manipulation of a single transaction may be run in many places, but this is transparent to the application, application developers feel as if all the data are physically stored in the local database,
(5) excellent security mechanisms, including the database access control, decision can execute commands, limit the number of single process of the available resources and define the data in the database access level, (6) to support the client/server mode, support a variety of network protocols,
2. DB2
The version of the goal is to provide the new scheme promised simplicity, data correlation and user productivity, recently launched the DB2 Universal Database 6.1 is the Universal Database model, is the first to have the function of online multimedia relational Database management system, support a range of platforms, including Linux,
DB2 series across various platforms, including: UNIX, Linux and Windows platform and IBM iSeries (OS/400 operating system), DB2 Everyplace supporting hand-held devices and embedded Linux environment, and provides data synchronization with the larger system, for the entire series of application development and database management provides a commonly used tool, the IBM DB2 universal database belongs to type of object relationship database system, is the universal database products the translation service this article source: bengbu. Ourtimes. Asia,
Characteristics shown in the following aspects: (1) support the object-oriented programming (2) to support multimedia applications (3) high performance and high scalability (4) support the autonomic computing
(5) to support a wide variety of access to remote information
3. Ormix
Informix aims to open such as Unix operating system to provide professional relational database products, Informix
The first real support of relational database SQL language product is Informix SE (StandardEngine), InformixSE is at the time of the main microcomputer Unix environment database products, it is also the first to be ported to Linux on the business database products,
4. SQL Server
SQL Server 2000 is Microsoft's SQL Server database management system, this version is inherited the merits of the SQL Server version 7.0, at the same time, increased many more advanced features, than it is easy to use good scalability and related software integration degree higher advantages, can span from the run Microsoft Windows 98 laptop to run Microsoft Windows 2000 large multiprocessor servers and other platform using the translation service this article source: bengbu. Ourtimes. Asia,
SQL Server 2005 is a comprehensive database platform, the use of the integrated business intelligence (BI) tools provides enterprise data management, SQL Server 2005 database engine for relational data and structured data provides a more secure and reliable storage capabilities, allowing you to build and manage for the business of high availability and high performance data application,
SQL Server 2005 data engine is the core of the enterprise data management solutions, in addition to SQL Server 2005 combined with the analysis of the report, integration and notifications, which your company can build and deploy cost-effective BI solution, to help your team through the scorecard, Dashboard, Web services and mobile data applications to various areas of the Business, and Microsoft Visual Studio, Microsoft Office System, and the new Development kit (including Business Intelligence Development Studio) close integration of SQL Server 2005 different, whether you are a developer, database administrator, information workers and decision makers, SQL Server 2005 can provide you with innovative solutions to help you benefit more from the data,
5. PostgreSQL
PostgreSQL is a very complete free software features object - relational database management system
(ORDBMS), many of its features is the precursor to many commercial databases, PostgreSQL Ingres project began in the earliest BSD, PostgreSQL covers the characteristics of SQL and SQL - 3-2/SQL - 92, first of all, it includes is currently the world's most abundant data type support; Second, PostgreSQL is currently the only supports transactions, subqueries, parallel version control system, data integrity check the only a kind of free software features such as database management system.
6. MySQL
Because of its small size, speed, overall has low cost, especially the feature of open source, many small and medium-sized network
Station in order to reduce the total cost of ownership website and chose the MySQL database as Web site, MySQL is a multi-user, multi-threaded relational database management system, work mode is based on client/server structure, it can support almost all operating systems, including: small subsidiary, Win98 and NT and the Unix operating system, such as MySQL has become one of the most used in current network database, especially on the Web application, which occupies the absolute advantage of small and medium-sized application, all this due to its small and easy to use, safe and effective, open permission and multi-platform, more important is the perfect combination of it with PHP,
MySql is an open, quick, multithreaded, many users of SQL database server, its characteristics: (1) open (2) the multithreaded
(3) support for multiple API (4) across the database connection (5) international
(6) the huge volume of MySQL database commonly used commands:
Host address to connect MySQL: MySQL - h - u username - p user password to exit the MySQL command: exit
Change password: mysqladmin -u username - p according to old password "password," new password database: show the databases
Create a database: create database name
7. Access database
It has friendly interface, easy to learn and easy to use, to develop a simple, flexible interface and other characteristics, is typical of a new generation of desktop database management system, its main characteristics are as follows:
(1) perfect the management of a variety of database objects, is a powerful data organization, user management, security checks, and other functions, (2) the powerful data processing function, in the level of a working group of network environment, use Access development of multi-user database management system with traditional XBASE (generally referred to as DBASE, FoxBASE) database system cannot be achieved by the client/Server (Cient/Server) structure and the corresponding database security mechanism, Access have many advanced large database management systems have characteristics, such as transaction processing error/rollback capability,
(3) can be easily generated a variety of data objects, forms and reports, was established based on the data stored good visibility, (4) as part of the Microsoft Office suite, can be integrated with the Office, to achieve seamless article source: national translation services bengbu. Ourtimes. Asia connection,
(5) be able to use the Web to retrieve and publish data, with the Internet connection, Access is mainly suitable for small and medium-sized application system, or the client as a client/server system database,
8. Visual FoxPro database
FoxPro on the function and performance improvement, mainly introduces Windows, buttons, list box and text box control, further improve the ability of system development, is easy to use and powerful query function, support for SQL, object-oriented programming, convenient way of management, can with multiple developers to work together, also has the following new features:
(1) the ability to quickly create the database and application: Visual FoxPro offers all kinds of the wizard, the generator, the designer as well as many Visual artifacts, used to help users with no programming or less programming way, quickly create the database, to establish the relationship between database tables and quickly generate database applications,
(2) support object-oriented programming: Visual FoxPro allows the user to use the object model to get all the characteristics of the object-oriented programming, including encapsulation, inheritance and polymorphism, the programming level through the Xbase to the expansion of the object-oriented programming languages, allows the user to use this new type "class" to describe the object model. Users can be used directly in the Visual programming environment variety is relatively complete, fully encapsulated by object-oriented standard generic components to quickly assemble applications, (3) support the client/Server applications: although Visual FoxPro is not a database Server, but it will provide data promotion function to the FoxPro data format conversion into a format of the SQL Server or Oracle Server, and through the remote view or SQL statements to manipulate,
CodePudding user response:
CodePudding user response:
No one, the topCodePudding user response:
You said this is all a few mainstream basic information database, big data to recommend you look at the https://www.zhihu.com/question/24761255