SQL (/ˌɛsˌkjuːˈɛl/ (About this soundlisten) S-Q-L, /ˈsiːkwəl/ "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables.
SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.
Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL),[a] a data definition language (DDL),[b] a data control language (DCL), and a data manipulation language (DML).[c] The scope of SQL includes data query, data manipulation (insert, update and delete), data definition (schema creation and modification), and data access control. Although SQL is essentially a declarative language (4GL), it also includes procedural elements.
SQL was one of the first commercial languages to use Edgar F. Codd’s relational model. The model was described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks". Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been revised to include a larger set of features. Despite the existence of standards, most SQL code requires at least some changes before being ported to different database systems.
Ipswich (/ˈɪpswɪtʃ/ (About this soundlisten)) is a historic county town in Suffolk, England. The town is located in East Anglia about 10 miles away from the mouth of the River Orwell and the North Sea. Ipswich is both on the Great Eastern Main Line railway and the A12 road, it is 66 miles (106 km) north-east of London, 54 miles (89 km) east-southeast of Cambridge, and 45 miles (72 km) south of Norwich. Ipswich is surrounded by two Areas of Outstanding Natural Beauty (AONB); Suffolk Coast and Heaths and Dedham Vale.
Ipswich's modern name is derived from the medieval name Gippeswic, likely taken either from an Old Saxon personal name or from an earlier name given to the Orwell Estuary (although unrelated to the name of the River Gipping). It has also been known as Gyppewicus and Yppswyche. The town has been continuously occupied since the Saxon period, and is contested to be one of the oldest towns in the United Kingdom. Ipswich was a settlement of great economic importance to England throughout its history, particularly in trade. The town's historical dock, present-day Ipswich Waterfront, was known as the largest and most important dock in the kingdom.
Ipswich is a non-metropolitan district and is a large settlement despite its town status. The urban development of Ipswich overspills the borough boundaries significantly, with 75% of the town's population living within the borough at the time of the 2011 Census, when it was the fourth-largest urban area in the United Kingdom's East of England region, and the 42nd-largest urban area in England and Wales. In 2011, the town of Ipswich was found to have a population of 133,384, while the Ipswich built-up area is estimated to have a population of approximately 180,000 in 2011.
The town is split into various quarters, with central and the waterfront drawing the most footfall. Central is home to the town's retail shopping and the historical town square, the Cornhill. The waterfront is located south of the town centre on the bend of the River Orwell and is a picturesque setting housing the town's impressive marina. The waterfront was historically an industrial port but has since been transformed into a trendy area lined with high-rise apartment buildings, restaurants, bars and cafés. The waterfront is also home to one of the UK's newest universities, the University of Suffolk, which was formed in 2016.
Ipswich has become a tourist hotspot in the UK with 3.5 million people reported to have visited the county town in 2016. In 2020, Ipswich was ranked as an emerging global tourist destination by TripAdvisor. Ipswich was voted as the 7th most desirable place to live and work in England by the Royal Mail in 2017. In 2007, Ipswich was awarded the cleanest town award, and in 2015, Ipswich was rated as the third happiest place to live in the UK.