Now its SQLserver 2008 R2 - Ive just tried it. But how did I get there ?The engineers who know me like Tam, Rasmus and Lars will know I have a long standing love affair with databases, going back to the linked list RTE-A database of FLS Automation lore.
At AN I worked on many factory database projects with Novo in Hillerød and FLS order handling system
There I invented having state action tables and procedures stored in an Oracle tablespace. I also learned the importance of precompiling and database tuning, because before that was done by FLS expert, the bright system worked in syrup...
One lovely thing in debugging was that the Pro*C data events cold be rolled back before commit enabling a datainput scenario to be replayed as many times as needed.
Later at AN I ws quite fascinated by Arnes DB2 developer interface tables with not just ER descriptions but functional sequence descriptions enabling each developer to understand the dynamic context of each attribute, e.g. reading a barcode from a ingredients bag, triggering a lookup for next serial number to be printed.
Simple, well, Yes but if You compared to the usual terse attribute names You realise that Arnes notation with a functional comment enables one to supplement e.g. 'Serial/Lot Number' with information describing the data update direction.
That is : Is the serial number to be read from the bag or is it to be printed to the bag.
So in this way we could individually adapt SW to the interface tables, and join together ourselves and our code on site. Beautiful engineering.
At Bombardier /Adtranz we worked with off-line databas schemas paralleling the SW structure insofar as the adaptation to the rail autority standard pictures, symbols, user commands and the particular line infrastrure objects, as well the current status for Hot standby operation, enabling seamless failover.
Also this enabled updates from the online 'kangaroo' databases to the Oracle schemas, allowing for precise backup and restore following Oracles standard tools.
Later at H:S working with the Lotus Learing database on Websphere I used a Oracle 9 system. purchasing licenses. definning tablespaces, users and storing the base on SAN for efficiency and safety.
Contrary to the H:S guys way of using KVM switches I decided to use my Bombardier. experience witt X-Windows servers for PCs, finding LabF from Tampere to maintain the DBA job.
When starting trial run with hospitals we had quite some mysterious breakdowns of the DB, which nobody could figure out, until I realised the breakdowns coincided with stand-by events on my PC thus closing the X-session on the AIX machine. Well, In my defense, even if I created the problem by using X on PC, I also was the only one to realise the source of errror.
The SAN proved to be a mixed blessing though, as some will know a IBM SAN provides storage through dedicated interface cards acting as AIX/ volumes. Budgetary reasons prevented me from attending the IBM courses on the connected issues, and when the SAN connection broke down at one time I was unable to reach Hvidovre in person, and could just point out that a 'hard' reset would prevent either accessing either the still online backup files not yet spooled out to tape, as well as the online database setting back learning system configuration one week.
While I was been killed remote over the mobile and probably from the sound of him, in effigium by the manager, I did point out that we should call IBM before deciding.
Could IBM solve the issue ? Of course they had a proper way of reeastablishing the connection, and just as sure good old big blue had made certain You either needed to have taken the SAN courses OR had to call for technical service.
Moral: Even if a SAN is supposed to be better than RAID anything make sure You dont put all You eggs in there...
Lastly I've worked with SQLserver at ITS holding schemas for the EDIFACT systems orders and recognition fields, and while its different to Oracle, Microsoft seems to be building the Technet to a comparable level.
You know what ? Back when I first started to juggle SQLnet connections and using SQL professionally, the logic and mental challenge of designing queries I've found it just as if not more exciting than coding because the dataset could be anything in the world.
That leaves me with associations (smiling) to Mickey Mouse in the Vizards Apprentice.
At AN I worked on many factory database projects with Novo in Hillerød and FLS order handling system
There I invented having state action tables and procedures stored in an Oracle tablespace. I also learned the importance of precompiling and database tuning, because before that was done by FLS expert, the bright system worked in syrup...
One lovely thing in debugging was that the Pro*C data events cold be rolled back before commit enabling a datainput scenario to be replayed as many times as needed.
Later at AN I ws quite fascinated by Arnes DB2 developer interface tables with not just ER descriptions but functional sequence descriptions enabling each developer to understand the dynamic context of each attribute, e.g. reading a barcode from a ingredients bag, triggering a lookup for next serial number to be printed.
Simple, well, Yes but if You compared to the usual terse attribute names You realise that Arnes notation with a functional comment enables one to supplement e.g. 'Serial/Lot Number' with information describing the data update direction.
That is : Is the serial number to be read from the bag or is it to be printed to the bag.
So in this way we could individually adapt SW to the interface tables, and join together ourselves and our code on site. Beautiful engineering.
At Bombardier /Adtranz we worked with off-line databas schemas paralleling the SW structure insofar as the adaptation to the rail autority standard pictures, symbols, user commands and the particular line infrastrure objects, as well the current status for Hot standby operation, enabling seamless failover.
Also this enabled updates from the online 'kangaroo' databases to the Oracle schemas, allowing for precise backup and restore following Oracles standard tools.
Later at H:S working with the Lotus Learing database on Websphere I used a Oracle 9 system. purchasing licenses. definning tablespaces, users and storing the base on SAN for efficiency and safety.
Contrary to the H:S guys way of using KVM switches I decided to use my Bombardier. experience witt X-Windows servers for PCs, finding LabF from Tampere to maintain the DBA job.
When starting trial run with hospitals we had quite some mysterious breakdowns of the DB, which nobody could figure out, until I realised the breakdowns coincided with stand-by events on my PC thus closing the X-session on the AIX machine. Well, In my defense, even if I created the problem by using X on PC, I also was the only one to realise the source of errror.
The SAN proved to be a mixed blessing though, as some will know a IBM SAN provides storage through dedicated interface cards acting as AIX/ volumes. Budgetary reasons prevented me from attending the IBM courses on the connected issues, and when the SAN connection broke down at one time I was unable to reach Hvidovre in person, and could just point out that a 'hard' reset would prevent either accessing either the still online backup files not yet spooled out to tape, as well as the online database setting back learning system configuration one week.
While I was been killed remote over the mobile and probably from the sound of him, in effigium by the manager, I did point out that we should call IBM before deciding.
Could IBM solve the issue ? Of course they had a proper way of reeastablishing the connection, and just as sure good old big blue had made certain You either needed to have taken the SAN courses OR had to call for technical service.
Moral: Even if a SAN is supposed to be better than RAID anything make sure You dont put all You eggs in there...
Lastly I've worked with SQLserver at ITS holding schemas for the EDIFACT systems orders and recognition fields, and while its different to Oracle, Microsoft seems to be building the Technet to a comparable level.
You know what ? Back when I first started to juggle SQLnet connections and using SQL professionally, the logic and mental challenge of designing queries I've found it just as if not more exciting than coding because the dataset could be anything in the world.
That leaves me with associations (smiling) to Mickey Mouse in the Vizards Apprentice.
Ingen kommentarer:
Send en kommentar