INFORMATION_SCHEMA被描述为标准代谢。 原则上,元数据可卸入XML,以进一步处理和扭转使用XSLT和其他XML工具的化学元数据。
INFORMATION_SCHEMA?N.B: I m 问这个问题,因为我想把一个数据库的图象输入一个标准<代码> INFORMATION_SCHEMA XML structure in ,然后在第二个工艺中再产生Javabjects代码。 为此,我更希望不要推出我自己的科学、科学和技术司,而是使用一种先前存在的同标准相加的XSD。
ANSI/ISO尚未确定使用XML代表数据库图示的具体方式。
最新标准是:2011年。
这里,你可以看到官方标准清单。 但是,正如你所看到的那样,他们没有自由:
清单中ISO/IEC 9075-x。 你可以看到,现在仍然只有老的信息。
So, your only option is to look for something widely used. Altova has its own way of doing this (a function named "Create XML Schema from DB Structure"). Look at this link: How to Convert a Database to an XML Schema
这一申请还有可能从出口表中建立数据库。
我认为,这是你能够找到的最接近标准(Altova是主要的XML软件公司之一)。 如果存在某种标准,他们应当知道和使用。
Oxygen XML也有自己的办法,它像一些“IOS”草案一样:
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...