Structured Query Language
SQL 1 is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
SQL 1 Solve:
- Need to update
- Change Date to Database
- Change Cache
- Trigger-SQL
- Select
o Count (*) client-count, website.name
- From
o Website
o Join Client onwebsite.websiteID = Client.WebsiteID
- Group by
o Website.name
- Order by
o Client-count desc
Booking Failures-Database/Clients
Available Error (Implementation-bypass caching/How the customer is searching)
Subscriber Type-Subscribe to a specific notification
Execute-Stalled procedure in the database; give an idea to do everything for you
Synchronization-solution for caching to update our applications
*Database is domains only; failure point; measured by 99%; huge loss of 8 hours with no bookings can result in 99.9999 minutes down
Cluster-group of servers
Storage, Software, server, the hardware is other problems that affect the system going down (maintenance installation every week)
SQL-Kept in an external storage
Disco-Disconnected Database
MSN Q-; sends messages to service
Don’t mess with a Sohan
Troubleshooting
notifies web service if the database isn’t working; monitoring and sending emails to production send reservations in a queue
NOC-Network Operating Control; Pingdom.com
Searches we are not using the database:
- ISP
- Load Balancer for ISP
- Anti Dos
- Firewall
- LB
- WS
- SQL 1
Ping from the client depends on distance; “ping www.google.com/t
QA-Reproduce the problem; try it; open SOAPUI and do a search query; Reproduce and interview