![]() Instaclustr: Fully Hosted & Managed PostgreSQLĭatasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL ClustersĭbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure. Related products and services 3rd parties SQLFlow: Provides a visual representation of the overall flow of data. We invite representatives of system vendors to contact us for updating and extending the system information,Īnd for displaying vendor-provided information such as key customers, competitive advantages and market metrics. no User concepts Access control fine grained access rights according to SQL-standard fine grained access rights according to SQL-standard More information provided by the system vendor Triggers yes yes Partitioning methods Methods for storing different data on different nodes partitioning by range, list and (since PostgreSQL 11) by hash Replication methods Methods for redundantly storing data on multiple nodes yes, with always 3 replicas available Source-replica replication other methods possible by using 3rd party extensions MapReduce Offers an API for user-defined Map/Reduce methods no no Consistency concepts Methods to ensure consistency in a distributed system Immediate Consistency Immediate Consistency Foreign keys Referential integrity yes yes Transaction concepts Support to ensure data integrity after non-atomic manipulations of data ACID ACID Concurrency Support for concurrent manipulation of data yes yes Durability Support for making data persistent yes yes In-memory capabilities Is there an option to define some or all structures to be held in-memory only. Tcl Server-side scripts Stored procedures Transact SQL user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc. ![]() Streaming API for large objects Supported programming languages. Secondary indexes yes yes SQL Support of SQL yes yes standard with numerous extensions APIs and other access methods ADO.NET yes yes specific XML-type available, but no XML query functionality. support for XML data structures, and/or support for XPath, XQuery or XSLT. ![]() Windows Data scheme yes yes Typing predefined data types such as float or date yes yes XML support Some form of processing data in XML format, e.g. Implementation language C++ C Server operating systems hosted FreeBSD
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |