Lab - 1 Two Open-Source project reviews

-

 The two open source projects I have chosen to review are: MySQL and WordPress

MySQL





Description: Relational database management system MySQL is free and open-source (RDBMS). The acronym "SQL," which stands for "Structured Query Language,". In a relational database, data is arranged into one or more tables where it may be connected to other data. SQL is a programming language that allows developers to restrict user access to the relational database as well as create, edit, and extract data from it. 

License: MySQL is licensed under GPLv2.

Patching Process: These are the steps to take:
  1. Check that you have signed the Oracle Contributor Agreement (OCA).
  2. Submit a bug report at http://bugs.mysql.com.
  3. Attach your code to the "contributor" tab in the bug report.
After that, the Oracle manager in charge of keeping track of contributions will be notified immediately via the bug system when a new patch is available. The patch will either be accepted for inclusion or denied, and the bug and contribution will be assigned to a MySQL Server developer as soon as possible. You will be informed and given an explanation in the latter scenario.

The patch will go through the same code reviews and quality assurance checks as any other change made by a MySQL developer if it is approved.

Advantages of MySQL: 
  • With the help of the internet or a local network, MySQL offers the option of running the server and clients on the same machine or on different ones.
  • More than 50 million records can be handled by MySQL because to its scalability. This is adequate to manage practically any amount of data. Although the maximum file size is 4GB by default, it may be extended to 8TB.
Disadvantages of MySQL: 
  • When it comes to managing really large databases, MySQL is not particularly effective.
  • None of the COMMIT, stored procedure, or ROLE features are supported by MySQL versions below 5.0.






Description: MongoDB is a cross-platform document-oriented database application that is open source. MongoDB, a NoSQL database application, employs documents that resemble JSON and may or may not include schemas. The Server Side Public License (SSPL), which is used to distribute MongoDB and is developed by MongoDB Inc., is viewed as non-free by some distributions.

License: MongoDB is licensed under Server Side Public License.

Patching Process: These are the following steps:
  1. To the relevant repository, post an issue outlining the modification you propose.
  2. Your question will receive a timely response from the repo owner.
  3. If your suggested modification is approved and you haven't done so before, sign a Contributor License Agreement (see details above).
  4. Create a fork of the appropriate repository, then work on and test your code modifications.
  5. Submit a pull request.
Advantages of MongoDB:
  • Utilize a scale-out design to quickly handle enormous amounts of data.
  • Platform for all cloud-based applications and data.
  • Access that is widely used and natural to the code.
Disadvantages of MongoDB:
  • Its lack of support for transactions is one of MongoDB's drawbacks. There are still certain applications that need transactions in order to change numerous documents or collections, despite the fact that this is happening less frequently.

Comments

Post a Comment

Popular posts from this blog

Lab 5 - Algorithm Selection Lab

-
In this lab, I wrote a set of programs that generates sound samples in a data array. It generates 5000000 samples as specified in the provided "vol.h" file, then scales the samples by a factor of 0.75 and returns them to the array. As a result, the program generates and displays a sum from the output array. To test the run time for each program, we'll use the command "time./programName," which will run the program and output the results as well as the time it took to run it. The program's real time is the sum of two sections: "user time" and "system time." Task 1: I obtained the base run time data we will work with when I ran the initial program, "vol1." This program runs with the volume factor unchanged. This allows us to test the other programs and observe any significant changes in run time data. Running the same program will not always produce the same results; there may be slight differences. This could be due to initial r
Read more

SPO600 - Project Stage 2

-
Introduction: This tool generates three versions of the function specified as the second argument. Then, while building the main output file from these functions, this tool employs the ifunc capability to select the best method.  The tool was written in Python, while the ifunc resolver function is written in C. In this blog, I will explain the tool's working mechanism and limitations, as well as the procedure for testing the tool. Accessing the tool: The tool is hosted on GitHub. The tool is available for download at https://github.com/puja1102/SPO600Project . The GPL version 2 licence governs the use of this tool. The tool's main files are as follows: tool.py: the main tool written in Python that builds the functions and generates the output binary files using the best SIMD implementation. template.txt: This is a text file containing the template for the ifunc function, as well as the resolver function for the ifunc. The ifunc.c file is created using this template. This tool
Read more

Auto Vectorization

-
 I'm working on a blog post about the concept of automatic vectorization in parallel computing, which can help reduce the number of cycles and chains in loops. It means that instead of scalar implementation, code can be converted to perform vector operations, which means a single operation can be performed on multiple operands. The GCC compiler is sophisticated enough to use vectorization to optimise code and improve performance. It is possible to accomplish this by using optimization flags such as -03 and -ftree-vectorize. AArch64 supports three extensions: SMID (Single Instruction, Multi Data), SVE, and SVE2. SVE  and SVE2 Scalable Vector Extension 2 (SVE2) is an armv9 extension that provides variable-width SMID capability. The main difference between SVE2 and SVE is the functional coverage of the instruction set. SVE and SVE2 both allow for large amounts of data to be collected and processed. For an aarch64 system, run the following command to enable SVE: gcc -g -O3 -c march=arm
Read more