If I create a view, is the view reflect physical table real time or it is just a materialized view and synchronize with physical table every n seconds/minutes. If I want to update something, may I update the materialized view, then would db synchronize the view and table?
Asked
Active
Viewed 197 times
0
-
1***SQL*** is just the *Structured Query Language* - a language used by many database systems, but not a a database product... many things are vendor-specific - so we really need to know what **database system** (and which version) you're using (please update tags accordingly).... – marc_s Jun 25 '13 at 12:15
-
I am using solid db. solid 7. – user84592 Jun 25 '13 at 21:53
2 Answers
7
The view reflects the table structure. Any changes made to the tables data will be reflected in the view.
Darren
- 68,902
- 24
- 138
- 144
0
Yes, you may update data using views, changes will apply to the base table immediately. In fact views do not contain any data at all.
Alex
- 1,186
- 10
- 12
-
If one db operation update one view, the other db operation update the other view. If they are both updating same row in the physical table, will be a db conflict? Or the db management would serialize the operation? – user84592 Jun 26 '13 at 05:35
-
It may depend on your database system, but generally first query will use row lock, and second will wait. After first update is completed the second update will be performed. – Alex Jun 26 '13 at 06:04
-
It seems solid db has conflicts if I update two view which points to same data. – user84592 Jun 27 '13 at 13:04