I'm trying to write an XML schema that allows XML to be expressed in the following ways: pets can containt both cat and dog elements: <root> <pets> <cat /> <dog /> </pets> </root> pets can contain just cat or dog elements <root> <pets> <cat /> </pets> </root> ----------- <root> <pets> <dog /> </pets> </ro...
I am refactoring an old Oracle 10g schema to try to introduce some normalization. In one of the larger tables, there is a text field that has at most, 10-15 possible values. In my mind, it seems that this field is an example of unnecessary data duplication and should be extracted to a separate table. After examining the data, I cannot...
Note: This is a community wiki entry and is mainly to document a problem together with its solution. I was hardly able to find information on the net to solve this. Hope it helps someone! I have a SQL-Server 2005 DB with the data tables being on the dbo schema. For a new component on the project, I created a new data access layer (us...
I'm working on a custom XML format that involves a formatted list of points. We would like to support multiple types of coordinates systems, such as Cartesian and Spherical. Can this be done? Example: <point type="cartesian"> <c1>5.0</c1> <c2>5.6</c2> <c3>9.1</c3> </point> <point type="spherical"> <c1>5.0</c1> <c2>5.6</c2> <c3>9.1</c3>...
I am looking for a schema to hold video metadata such as Title, Source, Description, Transcription, Copyright date, URL, etc. It would be used to store information about the video in a database and make that searchable. Is there a standard XSD or other schema for this type of data? ...
I have a page and it lists bunch of tables in a drop down list. I need to load up a list of columns in the database dynamically. In Subsonic 2.0 it could have been done by Subsonic.Schema.BuildTableSchema but not sure how to do it in 3.0. I tried using the code below but does not work .. SubSonic.Schema.DatabaseTable D = new SubSonic.S...
I posted this at ServerFault and was told this would be a better spot for it. I have some experience as a developer but am a complete novice when it comes to SQL administration and database design. I'm converting my company's ordering and quoting process from a excel spreadsheet to something a little more robust using an ASP.NET applic...
What does this icon mean is Visual studio, visual Data Set designer. I have several stored procedures. can you help me understand, why the one on top of the list has a small "check mark" why I can't delete it if I need to. This is not the case with the rest. Why is this "special" ? Thanks ...
I am trying to extend and tailor an external xsd schema (of the fixml standard). I need to change the data type of some of the elements, without touching the original schema, but by redefining it; but have been finding it exceedingly cumbersome. What exists: fields-base.xsd <xs:simpleType name="LastUpdateTime_t"> <xs:restr...
So it's a standard in basically every address form out there and I'm questioning why? Address Line 2. It's in every form that asks for address details. It's never actually seemed necessary to me. It requires another field in the database and all the goofy maintenance that goes with it. Every time you use an address, you have to concaten...
Hi All I am looking for the best way to delete all schema changes(all tables really) made when unit testing. I am using fluent to map my entities and create the schema in the Setup of my tests. I want to be able to delete the schema changes at the end of the tests in the Teardown. I am using nhibernates SchemaExport to generate the sc...
Hi, I need to validate a xml file against DTD schema. I found out that I need to pass the source of schema file for validation. Is that possible to make libxml2 find the declaration of schema in XML file and do the validation on its own, or do I have to retrieve the declaration manually? Thanks in advance Michal ...
does anybody know how data in google analytics is orginized? Difficult selection from large amounts of data they perform very-very fast, what structure of database is it? ...
I have a number of XML schema that use JAXB (Java Architecture for XML Binding) markup, similar to the following: <?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:jxb="http://java.sun.com/xml/ns/jaxb" jxb:version="1.0"> <xs:element name="H"> <xs:annotation> <xs:appinfo> ...
I'm working on an ASP.NET web application that uses a lot of JavaScript on the client side to allow the user to do things like drag-drop reordering of lists, looking up items to add to the list (like the suggestions in the Google search bar), deleting items from the list, etc. I have a JavaScript "class" that I use to store each of the ...
When xml schema validation fails .Net throws some exception. Based on parsing this exception I know how to do some stuff. The problem is that this exception is localized, e.g. on a Japanese machine it is in Japanese. I do not want to build my application so it will parse every error in any language. I am an add-in to some other system...
Hi there, not sure if the subject entirely conveys what I'm trying to achieve, but let me explain: We are building an application that uses Oracle as storage backend. Each year, last years dataset will be "Archived", and a new instance created and populated from scratch. What are the options to do this within the same schema? Keep ve...
We have an asp.net application that uses the Oracle client. In the connection string, we specify the 3 basic attributes: data source, User Id, and Password. We are using connection pooling. Our data resides in 2 different Oracle schemas. Most of the requests are for data from Schema1. The timeouts are coming from calls for data from...
One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This leads to the trigger not being created at all with an error as follows: ORA-39083: Object type TRIGGER failed to create with error: ORA...
Hi! Just to be concise I want to obtain something like this: <root> <field value="..." text="...">fixed_value1</field> <field value="..." text="...">fixed_value2</field> <field value="..." text="...">fixed_value3</field> <!-- in some cases we can choose the «fixed_value» among different ones --> ... <field value=...