Menu

Database

—————————-IN-MEMORY DATABASE—————————-
A databse that saves data in-memory (RAM), instead of saving data in disk.
—————————-IN-MEMORY DATABASE—————————-

 

—————————————-ROW—————————————-
Also called a record & tuple.
—————————————-ROW—————————————-

 

—————————DATA PARTITIONING—————————
Data partitioning is logically separating data from the same table based on given column values.
—————————DATA PARTITIONING—————————

 

—————————–PARTION EXCHANGE LOADING—————————–
Basically, this is just data partitioning.
Improves performance when loading or purging data in a target system.
PEL is recommended when loading a relatively small amount of data into a target containing a much larger volume of historical data.
—————————–PARTION EXCHANGE LOADING—————————–

————————————————MYSQL————————————————
Start MySQL Server in Windows:
1. Open Task Manager
2.Click on “Services” tab
3. Search for a service called “MySQL<versionNumber>”
4. Right click on the “MySQL<versionNumber>” service and select “start”

How to access MySQL CLI in Widnows:
1. Open CMD
2. Type cd “C:\Program Files\MySQL\MySQL Server <versionNumber>\bin” & press enter
3. Type mysql -u root -p & press Enter
4. Type in the root password you gave during your MySQL installation & press Enter

Login to MySQL CLI with custom user (Replace username with your user):
mysql -u username -p

Create a user with all privelleges in MySQL (Replcae username & password with your desired username & password):
1. GRANT ALL PRIVILEGES ON *.* TO ‘username’@’localhost’ IDENTIFIED BY ‘password’;

Create a database (Replcace dbname with desired database name):
1. CREATE DATABASE dbname;

Start working in a database (Replcace dbname with database name):
USE dbname;

Check current database: SELECT DATABASE();

Display Tables in Database:
SHOW TABLES;

Create Table:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

View Table All Rows:
SELECT * FROM credentials;

Delete All Rows In Table:
DELETE FROM table_name;

Delete a Table:
DROP TABLE table_name;
————————————————MYSQL————————————————

—————————————-CONNECTION POOLING—————————————-
A cache of database connections maintained so that the connections can be reused when future requests to the database are required.
—————————————-CONNECTION POOLING—————————————-