PostgreSQL 9.1.5-1 لادارة قواعد بيانات المواقع

[ahmed_new]

PostgreSQL 9.1.5-1












نظام قواعد البيانات الترابطية القوي مفتوح المصدر


PostgreSQL له اكثر من 15 عاما من التنمية النشطة و البناء المعترف بقدراته الذي اكتسب سمعة قوية للموثوقية وسلامة البيانات وصحتها. PostgreSQL يعمل على جميع أنظمة التشغيل الرئيسية ، بما فيها Linux ، UNIX (AIX، BSD، HP-UX، SGI IRIX، Mac OS X، Solaris، Tru64) ،و ويندوز.


PostgreSQL متوافق تماما مع ACID ، و به دعم كامل للمفاتيح الخارجية ، الصلات، المشاهدات ، والمشغلات ، والإجراءات المخزنة (في لغات متعددة). وهو يشمل معظم أنواع البيانات SQL92 و SQL99 ، بما في ذلك الصحيح- INTEGER ، رقمي - NUMERIC ، منطقية- BOOLEAN ، CHAR ، VARCHAR ، تاريخ- DATE ، فاصل زمني- INTERVAL ، والطابع الزمني- TIMESTAMP.


PostgreSQL سيدعم أيضا تخزين الكائنات الكبيرة الثنائية ، بما في ذلك الفيديو والأصوات ، أو الصور. PostgreSQL له واجهات البرمجة الأصلية ل C/C++، Java، .Net، Perl، Python، Ruby، Tcl، ODBC ، من بين أخرى ، و التوثيق الاستثنائي.


قاعدة البيانات مؤسسية الفئة ، PostgreSQL يضم ميزات متطورة مثل رصد التزامن متعدد النسخ (MVCC ) ، الاستعادة في الوقت المناسب ، tablespaces ، والنسخ غير المتزامن ، المعاملات المتداخلة (savepoints) ،النسخ الاحتياطي الساخن / عبر الإنترنت ، ومخطط/ محسن الاستعلام المتطور ، و تسجيل الكتابة قدما لسماحية الخطأ.


PostgreSQL يدعم مجموعات الحروف الدولية ، ترميزات الحروف متعددة وحدات البايت ، يونيكود ، وعلم الإعدادت المحلية للفرز ، والحساسية لحالة الحرف ، والتنسيق. PostgreSQL ذو تدرجية عالية سواء في الكم الهائل من البيانات التي يمكنه إدارتها ووعدد المستخدمين المتزامنين الذي يمكن أن يستوعب.


وهناك نظم PostgreSQL نشطة في بيئات الإنتاج التي تدير ما يزيد على 4 تيرابايت من البيانات.

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows


File Size : 46.2 MB


Requirements : Windows XP |Server 2003 | Vista |Server 2008 | Win 7


Languages : English | .....


License : Freeware
















It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

Featureful and Standards Compliant

• PostgreSQL prides itself in standards compliance. Its SQL implementation strongly conforms to the ANSI-SQL:2008 standard. It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. And while PostgreSQL has a fully relational system catalog which itself supports multiple schemas per database, its catalog is also accessible through the Information Schema as defined in the SQL standard.

• Data integrity features include (compound) primary keys, foreign keys with restricting and cascading updates/deletes, check constraints, unique constraints, and not null constraints.

• It also has a host of extensions and advanced features. Among the conveniences are auto-increment columns through sequences, and LIMIT/OFFSET allowing the return of partial result sets. PostgreSQL supports compound, unique, partial, and functional indexes which can use any of its B-tree, R-tree, hash, or GiST storage methods.

• GiST (Generalized Search Tree) indexing is an advanced system which brings together a wide array of different sorting and searching algorithms including B-tree, B+-tree, R-tree, partial sum trees, ranked B+-trees and many others. It also provides an interface which allows both the creation of custom data types as well as extensible query methods with which to search them. Thus, GiST offers the flexibility to specify what you store, how you store it, and the ability to define new ways to search through it --- ways that far exceed those offered by standard B-tree, R-tree and other generalized search algorithms.

• GiST serves as a foundation for many public projects that use PostgreSQL such as OpenFTS and PostGIS. OpenFTS (Open Source Full Text Search engine) provides online indexing of data and relevance ranking for database searching. PostGIS is a project which adds support for geographic objects in PostgreSQL, allowing it to be used as a spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.

• Other advanced features include table inheritance, a rules systems, and database events. Table inheritance puts an object oriented slant on table creation, allowing database designers to derive new tables from other tables, treating them as base classes. Even better, PostgreSQL supports both single and multiple inheritance in this manner.

• The rules system, also called the query rewrite system, allows the database designer to create rules which identify specific operations for a given table or view, and dynamically transform them into alternate operations when they are processed.

• The events system is an interprocess communication system in which messages and events can be transmitted between clients using the LISTEN and NOTIFY commands, allowing both simple peer to peer communication and advanced coordination on database events. Since notifications can be issued from triggers and stored procedures, PostgreSQL clients can monitor database events such as table updates, inserts, or deletes as they happen.

للتحميل




32-bit







64-bit





المصدر : مدونة ساسو سوفت