I'm embarking on a new web map project that seeks to display simple geometries (lines, points, polygons) and rasters/basemaps. Ideally, the map will also allow authorized users to add/remove/edit geometries and their attributes.
What are the available options for the storage of data (e.g. SQL Server Spatial)?
What are the available options for the presentation of data (e.g. ArcGIS Server)?
I'm new to web mapping and am attempting to build a solid understanding of the available options and their pros/cons. Examples would help tremendously.