What is DB2? Story, video editing and graphics
Posted by adminMar 7
Background
DB2 is a management system relational database from IBM, IBM, which refers to a data server. ” What is a relational database? A relational database is a collection of files that were analyzed for the overall relationship between the fields. The fields are considered as the original files are saved to eliminate redundancies in data. For example, instead of storing information that the AMT is the state of Tennessee, in each case, the information is from the original file and stored only once in a code file.
The idea of a relational database was not until 1970, when Dr. EF Codd has officially declared a series of rules of calculation, data manipulation could be applied. IBM has exited the principles of Codd to a group of programmers who have created a language that was finally SQL (Structured Query Language). DB2 has been named in the system database management in 1982, and is the first database using SQL.
In the beginning was only DB2 on IBM mainframes, but in the 1990s, spread to many other platforms, DB2 LUW (Linux, Unix, Windows), mid-range computer i5/OS (formerly AS/400 ) and even PDAs. During the 90 years he led IBM’s Universal Server. The universal server, the technology shift to an object in the context of SQL DBMS developers to define their own types of data more primitive data types.
In 2001, IBM bought Informix database and incorporates many features to the DB2 product suite.
In 2006, IBM “Viper said that” the codename for DB2 9 on distributed platforms and DB2 9 for z / OS. DB2 9 provides the ability to store XML “natively”, and it also allows d ‘compression save storage to reduce storage space on your hard drive. pureXML ™ is the name that IBM used to talk about the possibility of storing XML natively.
The biggest competitors are IBM Data Warehouse Teradata and Oracle. Microsoft SQL Server and MySQL are serious competitors in the smaller circles.
Editions
IBM Product Summary page for DB2 (http://www-306. Ibm. Com/software/data/db2 /) allows you to download the various editions after registration. DB2 Express-C Edition is free, and other editions allow you to have a 90 day free trial.
IBM To send a free DVD of discovery (https: / / www14. Software. Ibm. Com / webapp / IWM / prelogin web /. Do? Lang = en & source = db2kit SWG) which # DB2 Express-C 9 ( Linux and Windows), # DB2 Developer Workbench (Linux and Windows), # a comparison of all editions Express Company, # webcasts, tutorials, and much more!
Here is a list of some of the most important functions of several editions of DB2:
1. DB2 Express 9 for Linux, Sun Solaris x86, Windows is EXCELLENT! Initial data model server. Suitable for transaction processing or complex workloads application servers with a maximum of two processors. (2 processors and 4 GB of RAM) Starting at $ 4874 per processor to $ 165 per user (minimum of 5 users).
1. A. DB2 Express-C is a free version of DB2 Express Edition (DB2 Express) for the community. DB2 Express-C is a free database server, which can be used in the development and deployment of applications: XML, C / C + +, Java,. NET, PHP and more. DB2 Express-C can up to 2 dual-core CPU for servers with up to 4 GB of memory, a configuration storage system without any restriction on the size of databases or other artificial restrictions . (Linux and Windows)
2. DB2 Workgroup 9 for LUW – offers all the features of DB2 Express with scalability for large servers. (4 processors and 16 Gig RAM)
3. DB2 Enterprise 9 for LUW contains – all the features of DB2 Workgroup and functionality required to manage scalability to user acceptance and offer loads provide 24
Related posts:
No comments