HomeworkLib
Question

. Make a recommendation of each type of database system and justify your recommendation. 1Oracle 2...

. Make a recommendation of each type of database system and justify your recommendation.

1Oracle

2 MySQL

3 Apache Cassandra

4 Velocis

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
Name Cassandra   MySQL   Oracle
Description Wide-column store based on ideas of BigTable and DynamoDB Widely used open source RDBMS Widely used RDBMS
Primary database model Wide column store Relational DBMS Relational DBMS
Additional database models Document store
Key-value store		 Document store
Key-value store
DB-Engines Ranking ranking trend
Trend Chart
Score 124.79
Rank #8   Overall
#1   Wide column stores
Score 1298.83
Rank #2   Overall
#2   Relational DBMS
Score 1348.80
Rank #1   Overall
#1   Relational DBMS
Website cassandra.apache.org www.mysql.com www.oracle.com/­database/­index.html
Technical documentation docs.datastax.com dev.mysql.com/­doc docs.oracle.com/­en/­database
Developer Apache Software Foundation Oracle Oracle
Initial release 2008 1995 1980
Current release 3.11.1, October 2017 5.7.20, October 2017 12 Release 2 (12.2.0.1), March 2017
License Open Source Open Source commercial
Cloud-based no no no
Implementation language Java C and C++ C and C++
Server operating systems BSD
Linux
OS X
Windows		 FreeBSD
Linux
OS X
Solaris
Windows		 AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data scheme schema-free yes yes
Typing yes yes yes
XML support yes yes
Secondary indexes restricted yes yes
SQL SQL-like DML and DDL statements (CQL) yes yes
APIs and other access methods Proprietary protocol ADO.NET
JDBC
ODBC		 ODP.NET
Oracle Call Interface (OCI)
JDBC
ODBC
Supported programming languages C#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript
Perl
PHP
Python
Ruby
Scala		 Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl

C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic

Velocis

Raima introduced Raima Database Server (RDS) in 1992. A year later it was renamed to "Velocis." That name lasted through the 1990s but was changed to RDM Server in 2002. Many C/C++ application developers still know it as Velocis.

When RDS was introduced by Raima in 1992, it was Raima's first full SQL client/server DBMS product. It was also the first DBMS to utilize Microsoft's new Open Database Connectivity (ODBC) SQL API as its native SQL API. It was also the first commercial DBMS to provide SQL access to a network model database through the create join statement.

Key Architectural Features

Key Velocis architectural features are still a part of RDM Server. In the 1990s, there were a variety of local-area network protocols in use. To support all of them, Raima built into Velocis a multiple network communications processor (MNCP) which could communicate with any of the standard protocols (Netware, PC-Net, TCP/IP, shared-memory, etc.). That feature is still available in RDM Server however the TCP/IP and shared-memory protocols accounts for the vast majority of current usage.

One of the key architecture's features of Velocis/RDM Server is the ability to place significant application-specific operations on the server itself using extension modules and SQL user-defined functions and procedures. This reduces the overhead associated with client/server communication. This ability to tightly integrate the application with the database server is at the heart of Raima's embedded DBMS philosophy.

0 0
Add a comment
Know the answer?
Add Answer to:
. Make a recommendation of each type of database system and justify your recommendation. 1Oracle 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Find another database that Python can connect to. Make sure no other student picked that database...

    Find another database that Python can connect to. Make sure no other student picked that database -you may want to post the name of the database you chose before you explore it to "reserve it". Describe one or two major differences you see between SQL Lite and your chosen database. You Have to choose database other than these: Databases already posted are: postgresql, MySQL, mssql server, Apache Cassandra, ms access, Google cloud sql

  • System administrators are frequently called upon to set up and administrate MySQL databases. MySQL is the...

    System administrators are frequently called upon to set up and administrate MySQL databases. MySQL is the M in LAMP (Linux, Apache, MySQL, PHP/Perl/Python), an open-source enterprise software stack. Many programming languages provide an interface to MySQL, including C, PHP, and Perl. Select and discuss 2 features of MySQL. Explain how the features work and why you selected them. In addition, provide an example of an application that might use a MySQL database.

  • System administrators are frequently called upon to set up and administrate MySQL databases. MySQL is the...

    System administrators are frequently called upon to set up and administrate MySQL databases. MySQL is the M in LAMP (Linux, Apache, MySQL, PHP/Perl/Python), an open-source enterprise software stack. Many programming languages provide an interface to MySQL, including C, PHP, and Perl. Select and discuss 2 features of MySQL. Explain how the features work and why you selected them. In addition, provide an example of an application that might use a MySQL database.

  • imagine you are the consultant who has to make the recommendation on whether or not to...

    imagine you are the consultant who has to make the recommendation on whether or not to purchase Anheuser-Busch. Determine the rate of return you could expect from your investment and the method you would use to evaluate the investment decision. Assess the disadvantages and advantages of each investment method located in Chapter 4, and choose the one that would provide the most accurate measure for your anticipated rate of return requirement. Justify your recommendation.

  • MySQL 11. Final challenges Reset challenge database If you make a mistake while editing the database...

    MySQL 11. Final challenges Reset challenge database If you make a mistake while editing the database in this section or just want to reset the database back to its original state, return to this page and click the “Reset Section Database” button below. RESET CHALLENGE DATABASE If I have seen further, it is by standing on the shoulders of giants. (Bernard of Chartres). Databases are fun. Let’s honour some of the most popular scientists of all times by creating a...

  • Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y dat...

    Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...

  • Database Principles Question.. ... Answers to those question..Answer in required formet.. 1) Draw the ERDs needed...

    Database Principles Question.. ... Answers to those question..Answer in required formet.. 1) Draw the ERDs needed to describe this database showing all attributes, relations, cardinality, and modality. 2) In your own words, explain which normal form that each table is in and justify your conclusion 3) Using the MySQL command line, create a database named in SBL and build the normalized ERDs that resulted from steps 1 and 2

  • imagine you are the consultant who has to make the recommendation on whether or not to...

    imagine you are the consultant who has to make the recommendation on whether or not to purchase Anheuser-Busch. Determine the rate of return you could expect from your investment and the method you would use to evaluate the investment decision. Assess the disadvantages and advantages of each investment method located in Chapter 4,(net present value, IRR, capital budgeting by payback, and account rate of return) and choose the one that would provide the most accurate measure for your anticipated rate...

  • For each of the following data elements, provide your recommendation for the appropriate type of data...

    For each of the following data elements, provide your recommendation for the appropriate type of data entry field: Patient Last Name Social Security Number Discharge Date Account Number Address Zip Code City State Allergies Medications

  • Write code for mySQL 1) create a new one database ; to create your table 2)...

    Write code for mySQL 1) create a new one database ; to create your table 2) Every table should have a primary key 3) Table relationship has to be based on foreign key and shown within your physical table 4) Insert 5 data records in every table 9) Create a database view that return result set of all record and all columns within all 6 table

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT