Forum Forum MESA !! Strona Główna
 Strona glówna  •  FAQ  •  Szukaj  •  Użytkownicy  •  Grupy  •  Galerie  •  Rejestracja  •   Profil  •  Zaloguj się, by sprawdzić wiadomości  •  Zaloguj 
ugg online bestellen Points in favor 
Napisz nowy temat   Odpowiedz do tematu    Forum Forum MESA !! Strona Główna -> Cracovia Kraków
Zobacz poprzedni temat :: Zobacz następny temat  
Autor
Wiadomość
43nike9485qt
ORANGE EKSTRAKLASA



Dołączył: 26 Paź 2010
Posty: 812
Przeczytał: 0 tematów

Ostrzeżeń: 0/5
Skąd: England

PostWysłany: Sob 12:22, 26 Lut 2011  

Open Source Database Features
There are positives as well as negatives for PostgreSQL,[link widoczny dla zalogowanych], Ingres, and Firebird. All the three have similar features. It's really difficult to justify the best among the three. It's a particular feature in the wish list or inclination with (out) reasons (like the support community which is usually positive,
But an opinion clash could always be there) - which impacts in the choice. All the three have their limitations and have also proved their worth as a part of successful enterprise Ecommerce solutions
In general, most Open Source database features are supported by all databases with minor OEM application development. To name a few, we can categorize them as follows:
? SQL Compliance
? ACID compliance, Locking and concurrency support,[link widoczny dla zalogowanych], Foreign
Key constraint & Transaction support
? Functional features:
1. Views, schemas, sub-select, stored procedure, triggers, xml support
2. Tablespace feature
3. UNICODE support
4. API support
? Non-functional factors:
1. Performace & Availability
2. Stability & Flexibility
3. Web and Data-warehousing strengths
4. Security, Authorization,[link widoczny dla zalogowanych], and SSL support
5. Replication, Load-balancing, and Clustering support
6. Ease of installation, configuration, management, and administration
7. Hot backups
8. Admin and migration tools/scripts
9. Easy to learn & use
10. Good documentation
11. Distribution License & Support
It would be a continuous task to figure out what features distinguish one database from others. To begin with,[link widoczny dla zalogowanych], here are a few pointers
Comparison of Selling Points
MySQL Points in favor -? This is the most widely accepted open source database in use. This simple reason is quite compelling to select among various options.
? It claims to be comparatively easier to learn and use.
? The popularity provides for a lot of options in Administrative
tools.
? The architecture provides for plugging storage engines.
Many options exist in the market to cater to various needs e.g. InnoDB.
? Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.
? It is available on Novell Netware OS also besides the generic lot of Win, UNIX, and Mac family.
Points against it -?
Even the current version lacks many SQL RDBMS features.
For instance, its handling of dates allows storing a date with a day beyond the last day of a month with less than 31 days, and arithmetic operations are vulnerable to either integer overflow or floating point truncation. Though these can be taken care of by running special SQL modes.
There are many such features that have been criticized and are slowly being taken care of in newer releases. Version 5.0, for example, supports views, stored procedures and cursors, and version
More articles related to topics:


ralph lauren outlet Arbonne Skin Care Products The

abercrombie outlet Bank Balance Loss Via Lottery_3

uggs nederland 8 Reasons Why Atkins Works_2221


Post został pochwalony 0 razy
Powrót do góry
Zobacz profil autora
Wyświetl posty z ostatnich:   
Napisz nowy temat   Odpowiedz do tematu    Forum Forum MESA !! Strona Główna -> Cracovia Kraków Wszystkie czasy w strefie EET (Europa)
Strona 1 z 1
   
 
Opcje 
Zezwolenia Opcje
Kto jest na Forum Możesz pisać nowe tematy
Możesz odpowiadać w tematach
Nie możesz zmieniać swoich postów
Nie możesz usuwać swoich postów
Nie możesz głosować w ankietach
Kto jest na Forum
 
Jumpbox
Kto jest na Forum
Skocz do:  


fora.pl - załóż własne forum dyskusyjne za darmo
Theme FrayCan created by spleen & Download
Powered by phpBB © 2001, 2005 phpBB Group
Regulamin