Sunday, May 07, 2017

Nonstop SQL and ORACLE has lot in common.




ID Feature Nonstop Sql and ORACLE
1Database Type Both are multipurpose,
RDBMS supporting static and dynamic SQL,
ACID Transactions,
Referential Integrity,
Concurrency,
Distributed consistency,
Access Control,
Partitioning,
Replication and Online Hackups
2 Application Domain OLTP,
OLAP,
Mixed workload,
Big Data
3 Other Features Triggers,
Publish/Subscribe,
Sequence generators.
Multi-Tenancy
4 Connectivity ODBC,
JDBC

5 Programming LanguagesC,C++,Cobol, Java, Python, Node.Js*
6 User EnvironmentShell, Bash
7 Development IDEEclipse Support
8 Built in Functions60 Functions are same.
like aggregate, String or Date Manipulation
9 SchemasBoth Database can name tables as Schema Table


No comments: