Schema
Should I separate redundant data in my database?
I have a database app that stores prices for things in different places. Each price has the following data associated with it:[详细]
2023-04-10 06:16 分类:问答XML Schema Multiple Elements and Attributes
I have this code: <root> <skill id=\"1\">C++</skill> <ski开发者_StackOverflow社区ll id=\"2\">C#</skill>[详细]
2023-04-09 18:18 分类:问答Use <xs:all> in XML schema's complexType?
I have the following XML complexTypes defined: <xs:complexType name=\"loss\"> <xs:all> <xs:element name=\"lossCause\" type=\"xs:string\"/>[详细]
2023-04-09 17:10 分类:问答Oracle: Change Schema based on role
There is this post that describes setting up a trigger to change the schema on login. Is there a way to check the role of the user to see if it matches a specific role instead of the username itself?[详细]
2023-04-09 11:05 分类:问答XML Schema regex for integer range, excluding 0
I\'m developing an XML schema and I need to restrict an integer to being within a ranger of -20 to 20, but not 0.[详细]
2023-04-09 05:21 分类:问答Schema name vs. table name - how to avoid conflicts?
I\'ve to solve a problem using Oracle database. In Oracle database there are two schemas: XXX and YYY The schema XXX contains a table named YYY (the same name as the second schema).[详细]
2023-04-09 04:14 分类:问答ActiveRecord::Migration - Referencing a table in another schema
I\'m using Ruby and PostgreSQL and have created 3 distinct DB schemas: billing (for billing related data), customer (for customer related data) and edocs (for electronic documents related data).[详细]
2023-04-08 15:55 分类:问答Changing schemas in mongoDB/mongoose
I开发者_开发问答 am getting started with mongoDB and mongoose. I was wondering how people manage evolving schemas. For example if i started with a schema like this:[详细]
2023-04-07 20:13 分类:问答Super column vs serialization vs 2 lookups in Cassandra
We have: users, each of which has events, each of which has several properties (time, type etc.). Our basic use case is to fetch all events of a given user in a given time-span.[详细]
2023-04-07 18:32 分类:问答When is tuple length too long?
Here is a logical schema for my largest relation: {(id, uName, supplies, score, playerType, storageSupplies, supplyDrop, barracks, armourDepot, hangar, droneHangar, storage, offensive, defensive, inf[详细]
2023-04-07 07:55 分类:问答