Home » Fusion Middleware & Colab Suite » Collaboration & Content Management » We all are looped on Internet: request + transport = invariant
We all are looped on Internet: request + transport = invariant [message #262197] Sat, 25 August 2007 00:15
turin
Messages: 6
Registered: August 2007
Junior Member
We all are looped on Internet,
thus the most widespread transport protocol is HTTP,
and the most general format for data is XML (XHTML).
When we made

create table a (
id num primary key,
data float
);
create table b (
id num primary key,
ref num references a(id),
data float
);
create table c (
id num primary key,
link num references b(id),
data float
);
insert into a values (1, 12.3);
insert into b values (10, 1, 23.4);
insert into b values (20, 1, 34.5);
insert into b values (30, 1, 45.6);
insert into c values (100,10,56.7);
insert into c values (101,10,67.8);
insert into c values (200,20,78.9);
insert into c values (201,20,89.1);
insert into c values (300,30,91.2);

we need simple request 'a.b.c' to get

<a id=1 data=12.3>
<b id=10 data=23.4>
<c id=100 data=56.7/>
<c id=101 data=67.8/>
</b>
<b id=20 data=34.5>
<c id=200 data=78.9/>
<c id=201 data=89.1/>
</b>
<b id=30 data=45.6>
<c id=200 data=91.2/>
</b>
</a>

Request 'a.b.c' allow to avoid php,etc,
that is very necessary for unskilled users!

Details are on:
http://sql40.chat.ru/site/sql40/en/author/introduction_eng.htm
http://sql40.chat.ru/site/sql40/en/author/determination_eng.htm
http://sql40.chat.ru/site/sql40/en/author/inout_eng.htm


User sends to remote database (HTTP will ask login):
c:/dir> xml2http.exe database.my.com username password a.xml
for example
c:/dir> dbf2xml.exe a.dbf | xml2http.exe database.my.com username password

User sends to local database (at transformation data between DBMS-s):
c:/dir> xml2http.exe 127.0.0.1 username password a.xml
for example
c:/dir> dbf2xml.exe a.dbf | xml2http.exe 127.0.0.1 username password

Database sends to local file (at transformation data between DBMS-s):
sql> copy a.b.c to filename.xml;
Database sends to remote database
(if fields username and password of table sys are equal null,
then database sends as 'anonymous'):
sql> update sys set
ral="database.remote.com",
username="tomson",
password="my_pwd";
sql> a.b.c ;
or
sql> update sys set
ran="101.102.103.104",
username="tomson",
password="my_pwd";
sql> a.b.c ;
or if you prefer to export per table
sql> update sys set ral="database.remote.com";
sql> create view av as select * from a where ...
sql> create view bv as select * from b where ...
sql> create view cv as select * from c where ...
sql> av ;
sql> bv ;
sql> cv ;
Previous Topic: Installation hangs at 91% while relinking
Next Topic: oracle content management
Goto Forum:
  


Current Time: Thu Mar 28 17:54:20 CDT 2024