0
голосов
2ответов
138 просмотров

Related posts: Get records by tags from different tables

I'm working on a news site. Like every news site there will be news, columns, videos and photo galleries. I'm planning to keep these different types of records in different tables but relate them with tags. Here is a simple schema: Tables: News, Videos, Galleries, Columns, Tags, Post_to_tags Po...

3
голосов
5ответов
30836 просмотров

How to copy a table schema and constraints to a table of different database?

What SQL can be used to copy the schema of a specified table to a table in different database?

2
голосов
3ответов
881 просмотров

Sourcing multiple xml docs from single xslt

I am trying this and cannot seem to get it to work. Can someone take a look and see if I am missing something obvious. I am referencing the extra doc like this in test.xsl. <xsl:value-of select="document('/customercare/library/test/test1.xml')/resources/resource/name" /> This is the xml...

0
голосов
3ответов
1619 просмотров

Separation of logic and UI

I understand that I should keep my business logic and UI separate, but I don't know if what I'm doing now violates that rule. I'm designing my financial program's table structure. I've had a little trouble visualizing some parts, so I mocked up some screens to help me sort out what all will be ...

5
голосов
5ответов
1213 просмотров

Complete XML Schema Validation

I am looking for a tool that will tell me all of the XML Schema validation failures. All the other tools I have looked at so just tell me the first couple, and then I have to fix those before it will tell me the next errors. I realize that some errors may be dependent on other nodes being in di...

2
голосов
2ответов
1583 просмотров

MySQL: Can stored procedure information be extracted from the information schema?

Is it possible to retrieve stored procedure information like name, parameter nane/position/type from the Information Schema in MySQL or possible in some other way?

1
голосов
4ответов
4616 просмотров

Cannot validate against multiple xsd schemas in C#

I wanna verify a digitally signed xml against its schema definition while this schema actually contains this tag <xs:import namespace="http://www.w3.org/2000/09/xmldsig#" schemaLocation="xmldsig-core-schema.xsd" id="schema"/> Then I tried to load schemas: XmlReaderSettings settings = ne...

2
голосов
6ответов
205 просмотров

What is the proper name for this table schema?

We have a common database schema that we use for some tables in our system. Them main reason is that we are running a multi-tenant database so not all of our users require the same fields. However, I do not know what the 'proper' name for this type of schema is. Here's an example of what one o...

4
голосов
2ответов
3849 просмотров

Importing a schema LDIF and content LDIF on every startup of ApacheDS?

I want my embedded ApacheDS to start up with a fresh schema/content when I run my tests. I tried to import a LDIF with this lines: LdifFileLoader ldifLoader = new LdifFileLoader(service.getAdminSession(), "path/to/my/export.ldif"); ldifLoader.execute(); But now ApacheDS stores the info...

9
голосов
1ответов
7129 просмотров

XML Schema: "use='required'" with default value

In an XML Schema, is it possible to have an element which has use='required' and a default value (e.g. <xs:attribute name="Version" type="U8" use="required" default="02"/>)?

9
голосов
6ответов
2624 просмотров

Why are SQL fields lengths always (2^n)-1 unless less than 127?

A lot of Database schemas seem to follow the following standard: (2^n)-1 for large fields: varchar(511) varchar(255) varchar(127) ...then (2^n) for smaller ones varchar(64) varchar(32) varchar(16) varchar(8) I understand why numbers of (2^n)-1 are used, what I don't understand is why it is...

6
голосов
5ответов
24144 просмотров

Can I set a default schema for within a stored procedure?

I'm working on the next update for StackQL. One thing I want to do is have the ability to query over several releases. So when I loaded the October data, for example, I didn't delete the old September database. It's still out there. In fact, you can even still query it by including the databa...

0
голосов
2ответов
77 просмотров

What is the default type of an attribute?

<xs:element name ="ID"> <xs:complexType> <xs:simpleContent> <xs:attribute name="OFFSET" type="U8" fixed="00"/> </xs:complexType> </xs:simpleContent> However i want to make OFFSET greater than 1024 .in that case i get error 102...

2
голосов
3ответов
1046 просмотров

Valid XML, Valid schema. Where have I gone wrong?

Once upon a time I had a valid doctype and valid XML. I put the former on top of the latter, cntrl-s'd and behold: all was as all should be. Nowadays I have a valid schema (custom built for my still valid XML). I tried my same tried and true approach - but alas, no success. I get different error...

1
голосов
3ответов
1460 просмотров

trying to figure out the best database schema

I want to come up with a generic schema (if possible) to use for a number of different events that I am managing. These events can be weddings, birthday parties, etc. So far I have 3 main tables: Contact Table - the usual info like address, phone, etc. Events Table - a list of events with s...

6
голосов
3ответов
3891 просмотров

Best database design for a "sensor system"

I'm doing a schoolwork and.. I have to do a vehicle tracker system. I thought of these three designs. What do you think? My database schemas Opinions?

177
голосов
12ответов
186983 просмотров

What is difference between XML Schema and DTD?

I have googled this question, but I do not understand clearly what is an XML schema and DTD (document type definition), and why the XML schema is more powerful compared to DTD. Any guidance would be highly appreciated.

15
голосов
5ответов
10834 просмотров

How might you clone a database table via Rails migration?

I want a migration to create a clone of an existing table by just suffixing the name, including all the indexes from the original table. So there's a "snapshots" table and I want to create "snapshots_temp" as an exact copy of the table (not the data, just the table schema, but including the in...

2
голосов
5ответов
1177 просмотров

SQL Server 2008: N small databases VS 1 database with N schemas

I have a database server with few main databases, and few dozens of small ones. These small databases are kind of intermediary/staging databases for data import from various sources into main database. Data import is a daily task. They are all quite similar in structure as the implementation of ...

32
голосов
3ответов
34975 просмотров

Database schema for organizing historical stock data

I'm creating a database schema for storing historical stock data. I currently have a schema as show below. My requirements are to store "bar data" (date, open, high, low, close volume) for multiple stock symbols. Each symbol might also have multiple timeframes (e.g. Google Weekly bars and Googl...

4
голосов
1ответов
302 просмотров

schema validate xml containing boolean values

Hi I have a xml like this: <xml><fullname> <name attrib="true"/> <lastname1 attrib="false"/> <lastname2 attrib="false"/></fullname></xml> I need to create a schema to validate it in such a way that it will allow only 1 attrib with value "true" (and the...

1
голосов
2ответов
2090 просмотров

convert xsd to WSDL?

I am very confused how i am suppose to send data to a server. I have a .xsd file and i only realized 1 hour ago (and did research) that the schema is actually describing the XML data i am suppose to send. But i have NO idea how i am suppose to generate a XML from it. I dont think i am suppose to ...

-1
голосов
1ответов
974 просмотров

XSD schema, SOAP, REST and a MESS!

I think this person hit on my problem Link I have a schema and a pdf that has something like the below I have NO WSDL file. Absolutely none, i do have a large schema (apiName.xsd). It seems like i need to do something with it but i have no clue what. <xs:element name="CheckDomain"> <...

0
голосов
4ответов
1219 просмотров

SOAP, HTTP(S) POST. XML and Schema mess

I am very confused. I have a xsd file, no wsdl and apparently i send this data through SOAP. Now looking at all i went back and notice this (using ssl) The regular session begins with a HTTP POST request sent by the client. The body of the request contains XML document compliant with ...

0
голосов
1ответов
312 просмотров

Is it possible to use both automapping and schema generation with Fluent NHibernate?

I'm using the following: Fluently.Configure() .Database(MsSqlConfiguration.MsSql2005.ConnectionString(connectionString)) .Mappings(m => m.AutoMappings.Add(AutoMap.AssemblyOf<Incident>() .Where(t => t.Namespace.StartsWith("EDA.DomainModel.POCO")))) .Exp...

2
голосов
5ответов
994 просмотров

Over Simple Database Schema: Good and Bad points? with example

I apologise for the long-winded, rantyness of this but I'm up at 3am dreading having to go to work tomorrow and deal with this database... it just feels wrong but maybe I'm wrong and just like things done my way... Please tell me what you think. Our database schema looks something like: page: i...

387
голосов
5ответов
473454 просмотров

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

5
голосов
9ответов
1137 просмотров

Explanation for the term "Schema"

I need a plain English explanation of "schema", as in Database schema & XML schema. EDIT: When someone says to create a database schema, does it mean creating constraints for the fields in the tables?

5
голосов
3ответов
3664 просмотров

Schema validation, how to display user friendly validation messages?

Is there a way to avoid or set up a schema to display better user friendly messages? I am parsing the string and using reg ex to interpret them, but there might be a better way. Ex. "cvc-complex-type.2.4.b: The content of element 'node' is not complete. One of '{\"\":offer,\"\":links}' is ex...

4
голосов
2ответов
2971 просмотров

ActiveRecord - Self Referencing Associations

I'm a total Ruby/Rails/AR noob. I have a very basic sort of database schema that I can't seem to figure out the best way to represent in the Rails Way. Table Post String title, author Text content Timestamp posted Post parent The idea here is that top level posts will have pa...