[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

SQL5 (bringing DBMS in correspondence to modern communication requiremen

• From: Dmitry Turin <dev3os@n...>
• To: xml-dev@l...
• Date: Thu, 31 Jan 2008 12:59:08 +0200

Let me state several ideas in separate graphic file
http://sql50.euro.ru/sql5.ppt

Abstract:

New era of computer world has approached - a companies and independent sysadmins
scattered their own platforms in internet. But as before it's exceedingly
burdensome for simple user to create similar, and he is forced to graze on
platforms, given by companies and sysadmins. Reason is that, as before (as this
was 40 years ago) program of data conversion refuse to communicate with browser,
as before it's required to install intermediate programs, write for them or
adjust them and the main program for collaboration. User is not capable to do
this job. Removal of this barrier for database means possibility to output of
tree into browser by operator 'select' and execution automatic 'insert' for
tree, received from browser. First part of presentation is dedicated for detail
development of this question.

Question about processing of xml-data is close to this. Today's usage of XQuery
for this is practically equal to existence of second, foreign query language.
Author is proposing to use SQL instead of it, and demonstrates this also in the
first part of presentation.

But huge corporations suffer too: as before, SQL is being built, like
distributing of data does not exist. It's known, it's difficult to support tens
of large applications and thousands of parallel working users in one database,
so it is divided into smaller databases. Not secret great increase of amount of
transactions at panic on exchange, seasonal activity of buyers. But attempt to
use additional programs for database integration destroys homogeneity of
situation, created by SQL, bring inconvenience. Distributed requests of language
itself are required clearly, and second part of presentation is dedicated for
them. Foreign key, referencing to data of other database, is also proposed in
this part of presentation.

In the third part, author considers search in reference system by name, entering
with mistakes of spelling and other mistakes, and proposes operator to sort
records by degree of resemblance with sample.

Aspects, needed for full completing of DBMS by communication possibility, are
listed in the fourth part: operator of selecting of next portion of sorted data;
window, slitherring on flow of input data (table with limited quantity of
records); reading of data by SQL from html-document of remote Web-server; timer,
and increase to safety by giving permission for each record of table (up to
invisibility of some records at absence of permission).

Partial description of slides: http://sql50.euro.ru/site/sql50/en/author/index_ru.htm

References:
SQL Standard - SQL/XML Functionality. ISO/IEC JTC1/SC32 #1293, 2005-04-22. http://jtc1sc32.org/doc/N1251-1300/32N1293-WG3-Presentation-for-SC32-20050418.pdf
K.Kulkarni. Overview of SQL:2003. p. 65, part 14 "SQL/XML", Silicon Valley Laboratory, IBM Corporation, San Jose, 2003-11-06. http://www.wiscorp.com/SQL2003Features.pdf
Folksonomy. //Wikipedia. http://en.wikipedia.org/wiki/Folksonomy
Mash-up, syndication. //Wikipedia. http://en.wikipedia.org/wiki/Web_2.0
N.Mattos, H.Darwen, P.Cotton, P.Pistor, K.Kulkarni, S.Dessloch, K.Zeidenstein. SQL99, SQL/MM, and SQLJ: An Overview of the SQL standards. http://www.wiscorp.com/sql1999_c3.zip
How to add style to XML. //W3C papers. http://www.w3.org/Style/styling-XML
CSS & XSL. //W3C papers. http://www.w3.org/Style/CSS-vs-XSL
XML Path Language (XPath). Version 1.0. //W3C Recommendation, 16 November 1999. http://www.w3.org/TR/xpath
XML submission. //Web Forms 2.0, Working Draft, 12 October 2006. http://www.whatwg.org/specs/web-forms/current-work/#x-www-form-xml
Sending of hidden tree of tags. //HTML6. http://sql50.euro.ru/site/sql50/en/author/hidden_eng.htm
Unification of WebForms2 and XForms. //HTML6. http://sql50.euro.ru/site/sql50/en/author/quest_eng.htm
Style of attribute (of virtual tag). //HTML6. http://sql50.euro.ru/site/sql50/en/author/forxml_eng.htm