w*****s
发帖数: 122 | 1 April 14, 2000] W3C XML Schema 1.0 Published as a Last Call Working Draft Specification.
The W3C XML Schema Working Group has released a last-call public working draft specification for
XML Schema 1.0, published in three parts: XML Schema Part 0: Primer, XML Schema Part 1:
Structures, and XML Schema Part 2: Datatypes. Reference: W3C Working Draft, 7-April-2000. The last
call review period is expected to end on 12-May-2000. Primer: XML Schema Part 0: Primer, edited by
David C. |
|
M*****r
发帖数: 1536 | 2 In SQL Server 2K5, schema is introduced.
Any comparison to Oracle's schema?
SQL Server 2K5:
Server
Database
Schema
Login -- User account
Oracle:
Server
Database
Schema -- User account
What's the benefit of adding the schema layer? Why it is not designed like
Oracle's? (I may have some mis-understanding for the concept)
Also, in SQL Server, login and user account are different? What the benefit? |
|
c***c
发帖数: 6234 | 3 Friends,
I am toally not understanding XML schema. By google and researching in this XM
board, I know how to wite schema and the purpose of schema.
It seems that I do not need any special applications for XML schema (IE can
handle everything). However, it is not.
But there is a key problem for me that how to use xml schema?
Can some one teach me how to use schema step by step?
Or the links that can answer my question? |
|
g********s
发帖数: 3652 | 4 【 以下文字转载自 DBA_BI_Club 俱乐部 】
发信人: greenlands (sunflower), 信区: DBA_BI_Club
标 题: 聊Data Warehouse 1. Star Schema
发信站: BBS 未名空间站 (Sun Mar 16 19:54:31 2014, 美东)
（祝贺今天下午大家和ROseleaf 学SQL！这是很有意义的开始！）看到你们这么热情积
极向上，我也想凑个热闹，聊聊你们将来的的工作环境：Data Warehouse
BI Business Intelligence 简单说：从公司的数据里面找出信息来帮助公司继续挣钱！
银行老板们从报表中看到各个部门业绩：哪个fund上个季度销售减少或增加了，哪个地
区的房屋贷款数目增加或减少了，这些问题会由分析师们讨论，找出对策。这个过程就
是BI。目前几乎各行各业包括政府部门医疗保险，科学研究都用BI。
那么提供BI的信息是怎么整理出来的呢？我就聊Data Warehouse吧，这是最普遍广泛使
用的工具，也是我使用过的工具。
Data Warehouse 就是个Database ，关键是... 阅读全帖 |
|
c***c
发帖数: 6234 | 5 Thank you for answering.
I do not use parser. Actually I do not have server. I just wrote xml file and
schema file. Then put them in the same folder.
OK I am new in XML and I am a little stupid. I just used XML to store data
(some servlet info) for JSP server. No schema and DTD
2 more questions. Please help
1. To use schema, do I need a server (or application like java, perl) to
handle it?
2. If no need server, how can I validate the schema (to check are there bugs
in schema)
If doesn't matte |
|
a*****u
发帖数: 1712 | 6 fb的feed全是pull的，不是push，你网上搜搜有一篇facebook写的论文，叫什么TAO的
，讲了些细节。
database schema把所有的数据抽象成graph里面的点或者边，点一种schema，边一种
schema，也是那个TAO论文提到过
fb/twitter这类的social network的data base schema大致是怎样的?是每个user 一个
news feed table吗?还是一个大tabl........ |
|
n********a
发帖数: 68 | 7 Schema shouldn't take up much space.
Just make sure that all you need
is schema, no data.
You could use exp/imp utilities.
exp with rows=n and then imp.
If you use indexfile option of imp,
you could get the sql script that
will generate the same schema.
a |
|
M*****r
发帖数: 1536 | 8 That's what I want to discuss:
Why Oracle doesn't implement it this way? Any Pros/Cons for different
implementation?
SQL Server now has 3 things:
User account
User login
Schema
While in Oracle, a database user account (commonly referred to as a schema)
is used to store database objects, applications, and components, and to
determine a user's database privileges.
Still confused by:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx
, |
|
c*****d
发帖数: 6045 | 9 en, beijing is right
"show user" displays the username to access SQL*Plus, which is the same as
schema in most cases. In case of switching schema, they are not the same
sys_context can get the current schema. It is much convenience and accurate
than "show user" |
|
w****x
发帖数: 138 | 10 在它們之間作比較：也就是在每個schema下建立與另一個schema不相干擾的表，再與另
一個schema下的表作比較。以上是同一用戶。 |
|
y****3
发帖数: 131 | 11 【 以下文字转载自 Database 讨论区 】
发信人: yh1213 (yh), 信区: Database
标 题: An interview question: data store schema design
发信站: BBS 未名空间站 (Sat Mar 24 18:30:54 2012, 美东)
Design a backend store for storing metadata about files and directories
belonging to different users as part of an online storage service. The
logical data model is as follows:
--a user has zero or more files or directories
--a directory contains zero or more files or sub-directories
--a file or directory has a relative path that is up to 32K... 阅读全帖 |
|
b*****m
发帖数: 438 | 12 【 以下文字转载自 TAX 讨论区 】
发信人: bigworm (不要搞错,是老虎!), 信区: TAX
标 题: federal tax e file出错信息：schema validation
发信站: BBS 未名空间站 (Mon Feb 18 12:06:10 2013, 美东)
Issue : Business Rule X0000-005 - The XML data has failed schema
validation.
是什么问题？ |
|
b*****m
发帖数: 438 | 13 【 以下文字转载自 TAX 讨论区 】
发信人: bigworm (不要搞错,是老虎!), 信区: TAX
标 题: federal tax e file出错信息：schema validation
发信站: BBS 未名空间站 (Mon Feb 18 12:06:10 2013, 美东)
Issue : Business Rule X0000-005 - The XML data has failed schema
validation.
是什么问题？ |
|
b*****m
发帖数: 438 | 14 【 以下文字转载自 TAX 讨论区 】
发信人: bigworm (不要搞错,是老虎!), 信区: TAX
标 题: federal tax e file出错信息：schema validation
发信站: BBS 未名空间站 (Mon Feb 18 12:06:10 2013, 美东)
Issue : Business Rule X0000-005 - The XML data has failed schema
validation.
是什么问题？ |
|
s***m
发帖数: 28 | 15 I am trying to export a production oracle database schema of a tablespace to a
test system. However, I have limited space on test system. On production
system, many data files are created for different indexes and tables. These
datafile is created using large disk spaces. How can I export the production
tablespace schema but with smaller datafile size definition?
Thanks |
|
s******y
发帖数: 68 | 16 在Oracle下,
怎么才能知道当前的schema是什么 ?
对于某个table, 如何查看在不同 schema中的accessibility 是什么?
thanks
|
|
y*h
发帖数: 107 | 17 yes, I downloaded oracle sql developer already, and can access to
each schema.
next, how do I compare two schemas for missing indices |
|
B*****g
发帖数: 34098 | 18 I did not use sql developer for 3 years, try below, not sure will it work
for you
http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm
Schema Diff
Compare and create SQL Difference statement between 2 schemas
Select objects to compare
Report of objects to be compared
List of differences and SQL Code to be executed
Run script output to SQL Worksheet to be executed against connection
of choice.
Or
Just compare in all_indexes table |
|
j*****n
发帖数: 1781 | 19 I believe the schema is based on your login. so you have to explicitly
specify the schema name other than your login default. |
|
e******r
发帖数: 220 | 20 比如我delete a table, 可是在schema browser 里还能看到那个table的名字,
即使它已经不存在了. 这给我的工作带来了很多不便.
请问有什么办法让schema browser只反应当前存在的table, 试了按F5键不行.
谢谢 |
|
a*******5
发帖数: 3 | 21 是SOCIAL MEDIA公司关于USER ANALYTICS方面的职位的面试题. 本人在SCHEMA AND
LOGICAL MODEL DESIGN这方面实践经验很少,急切期待各位指点这一类问题的切入点和
解决思路。如果对任何一题有线索,或EXAMPLE,或者LINK...我都非常感激!
- Design a database schema http://en.wikipedia.org/wiki/Database_schema to be used internally for user analytics (ad hoc analysis and automated reporting) of its mobile applications.
- For a typical social network product, describe the logical data model for
related fact and dimension tables, the aggregation tables you'd want to
build for analytics,... 阅读全帖 |
|
n****f
发帖数: 905 | 22 schema A 有 TABLE X;
schema B 有 TABLE Y;
User login AS W
W has SELECT RIGHT ON A.X AND B.Y
Now, 你想比较什么？COUNT ？ |
|
w****x
发帖数: 138 | 23 俺基本一窍不通，需要详细点的指导，
比如具体步骤、命令是什么？
还有比较的时候，总要在某个schema里面操作吧，那么是不是要给另一个schema创建个
alias或者link什么的？因为要比较的表格都是同名的。 |
|
n****f
发帖数: 905 | 24 A schema 里面的表 X or Y , 名字是 A.X, A.Y
B schema 里面的表 X or Y, 名字是 B.X, B.Y
比如你用 W 用户 登录，
去看 A 里面的 X 表的总 ROW 数目， 你可以：
SELECT COUNT(*) FROM A.X
去看 B 里面的 X 表的总 ROW 数目， 你可以：
SELECT COUNT(*) FROM B.X
假如你要比较 A.X 和 B.X 在结构上有什么不同， 你可以用上面 BJ 说的一些工具，
比如 TOAD， 或者用去检查 Oracle 的系统 TABLE, 比如 DBA_TAB_COLUMNS 等等。（
这需要你有一定的权限。） |
|
s*****i
发帖数: 650 | 25 If I have a xsd file, I can convert it into DTD file, how can I get the
binding schema name extension is xjs? Any tool can convert XSD file into
DTD AND binding schema file?
Thanks. |
|
c********1
发帖数: 421 | 26 schema , as in "database schema", or schemaless db
scheme, as in "Maven's versioning scheme...." |
|
c***y
发帖数: 8 | 27 only a parser for xml is not enough.
项目开发schema，如何支持呢？
需要什么呢？其功能又是什么呢？
首先，需要一个xml parser，
其次，还需要一个xml schema processor (???)
是这样么？那么2个怎么一起用呢。。。
偶非常糊涂，可是项目迫在眉睫:((
偶选择了oracle xdk， 好像一般般。。。
可是不知道怎么一起用！！！
十万火急！！！！ |
|
c***c
发帖数: 6234 | 28 I am new in XML and need some help.
for example
xml schema is
http://www.w3.org/2001/XMLSchema"
targetNamespace="http://www.demo.org"
xmlns="http://www.demo.org"
elementFormDefault="qualified">
|
|
P*****x
发帖数: 72 | 29 I don't know if there is way to validate XML file against schema w/o parser.
If using parser is ok w/ ur situation, u can find a parser and reference
at apache.org
To check bugs in schema is easy, if you have visual studio .net, just
load it into ide.
I am not expert of XML either but I happen to mess w/ apache C++ parsers
a lot. |
|
P*****P
发帖数: 57 | 30 新手上路，问得胡涂请别见怪
想把一些数据serialize成xml stream，xml schema已经做好了，dataset的class也自动
生成了，现在就是不知道怎么把数据“赋值”到dataset里，
m_xmldataset.Tables.Add()
m_xmldataset.Tables[0].Rows.Add(？？) -- 这里就不知道怎么做了，求高手相助，多
谢
我也看了一些简单的例子，比如生成一个简单的dataset，然后把数据按row加进去，但xm
l schema生成的dataset怎么做我就不懂了，糊涂中 |
|
m*******n
发帖数: 154 | 31 load schema stored in the XML file into your progam memory and treat the
schema as a standard dataset object. e.g.
m_xmldataset.Tables[0].Rows.Add(new datarow(...))
动
多
xm |
|
t*****e
发帖数: 1700 | 32 Design a database schema will be used internally at Facebook for analytics .
how will you design it? |
|
e********3
发帖数: 229 | 33 fb/twitter这类的social network的data base schema大致是怎样的?是每个user 一个
news feed table吗?还是一个大table存储所有news feed,然后用user id 和 event
id做key? 还是其他的设计方式?
如果是前者,当有new event的时候,可以用push model把meta data push到所有
follower 的news feed table里.下次user login就可以一次性全部抓取出来.这样对吗
?
求大牛解惑 |
|
e********3
发帖数: 229 | 34 那能大致说说这种的data base schema要怎么design不? |
|
b*****m
发帖数: 438 | 35 Issue : Business Rule X0000-005 - The XML data has failed schema
validation.
是什么问题？ |
|
s****o
发帖数: 26 | 36 Code synthesis会内存泄露。
xerces要自己写代码，每次更新schema都要改，不好 |
|
c*****s
发帖数: 8 | 37 could anybody please tell me how to get information about
schema in C given an input of any database in ACCESS? |
|
h********n
发帖数: 2 | 38 Does anyone can tell me what tool can be used to design the
DB E-R Modal schema? Thnaks! |
|
w*****h
发帖数: 139 | 39 export and import with schema option. |
|
o*****e
发帖数: 23 | 40 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: oldbare (bearhill), 信区: Java
标 题: How could I get the lable of schema of a table in sql?(a project due)
发信站: The unknown SPACE (Mon Apr 30 14:26:26 2001) WWW-POST
with jdbc or sql itselt.
Thanks a lot. |
|
r**e
发帖数: 57 | 41 有一张很大的database schema 图，想把他打印出来，用A4的纸
有没有什么软件可以自动一部分，一部分打印出来，我好最后
拼起来？ |
|
j*******r
发帖数: 12 | 42 erwin 好象就可以.
BTW,你的SCHEMA图是用什么画的? |
|
s*******e
发帖数: 151 | 43 Schema did take space sometimes. especially tablespace.
to
These
production |
|
s***m
发帖数: 28 | 44 Yes, I want to import full database schema from production system to test
system. However, I don't want to import any of the data. I just need the
tablespace definition, trigger, storedproc, functions and constraints. Owing
to the production system's size, at which many datafiles has been created for
userspace and index space, my export captures the size of the those index
datafiles. If you have a documention on how to do this, it will be very
helpful.
Thanks
test
before
to
These
production |
|
B*****g
发帖数: 34098 | 45 kick, lz needs schema not user.
select sys_context('USERENV','SESSION_SCHEMA') from dual |
|
c**t
发帖数: 2744 | 46 How to switch schema in SQL Developer? (Query window, like Toad) |
|
c**t
发帖数: 2744 | 47 like "Current Schema" selection in sql editor |
|
z*3
发帖数: 33 | 48 貌似没有什么办法，只能重新建一个connection，然后再连一遍了。。。
如果使用sql developer连sql server的话，可以直接进management studio，也有个和
toad差不多的东西，切schema |
|
a*****p
发帖数: 1285 | 49 设计一个关于电影院得schema。本人新手，设计如下，求指教，哪里不对？？ |
|
g***l
发帖数: 18555 | 50 没经验就别去了，问的这种问题，做一年也不定能做好，让我就说，你以为你是
FACEBOOK，我为什么要告诉你怎么做，我告诉你你不就不雇我了么，你要是FACEBOOK我
就告诉你。问这种问题，摆明了就是想从人身上捞点东西，根本就不考察的你的真才实学，就是DATA MODELR也得告诉我一下你的SCHEMA和RELATIOSNHIP，人家是不会雇你的。 |
|
