Oracle impdp onlu one schema when expdp its use many schemas

I have the following problem and doubt in Oracle … I am trying to import with impdp a save from my database made in which I export several schemes … the problem comes when I try to import into the same database in another scheme completely empty one and only one of those schemes that are in the export (expdp) …. during the import show several errors of creation, of sequences, of data that already exist and of creation of other objects in general. How is this possible if the scheme where I import this empty? the expdp I execute it in the following way:

To export: 

expdp \ "/ as sysdba \" DIRECTORY=logic_bakups DUMPFILE=backup%U.dmp FLASHBACK_TIME=timestamp PARALLEL=5 SCHEMAS=SCH1,SCH2,SCH3,SCH4

To import:

impdp \ "/ as sysdba \" DIRECTORY=imp_logic_backups DUMPFILE=backup%U.dmp PARALLEL=5 REMAP_SCHEMA=SCH3:SCH3_V2 REMAP_TABLESPACE=source_tablespace:target_tablespace_V2

Thank you

Will my local business schema screw up my other location pages?

Hello,

I have a local business schema on the homepage of our company website. We also have multiple locations, and have pages set up for each of these locations. On these location pages I have a schema to show the reviews for each location. I am wondering if adding a standard localbusiness schema on the main homepage will screw anything up with the review schemas or the other location pages?

I do not have localbusiness schemas set up for the other locations, but I may just do that and throw it all on the homepage.

Let me know what you think,

Thanks and I look forward to your feedback 🙂

multiple ids table for accounting schema

I am trying to make a small accounting db and I have hit a dead end, my search bared no results as of how to make this idea work. what is the idea? In the picture below you can see it. My idea is to link multiple tables to one table CreditDebit in this case, so I can use its id to know which side is which instead of making multiple Bond tables. now what I have reached to is that in CreditDebit I will have multiple NULL values, also I wouldn’t be able to know which table is which. A creditor\debtor could be anything (safebox, employee, customer, …etc.) fastDrawing

Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes?

I have 3 postgres databases (up to date with current version) running in AWS that I would like to replicate into one location to build an Operation Data Store (ODS). I require the ability to query cross databases – I’ve primarily only used MSSQL – and I believe that you can only cross query schemas.

Or do I have to put this into another amazon product to be able to achieve this result?

Can I use Accommodation or Hotel Schema markup if customers can’t book it

We sell ferry travel, and want to capture customers browsing holidays to the destinations in order to raise awareness of going by ferry.

On this page we mention the different types of holiday accomm you could book on the islands and give 3 examples of each. 3 hotels, 3 resorts/holiday parks & 3 self catering apartments.

Can we use the accommodation markup schema, or as we don’t mention price and you can’t book would this be pointless?

Thanks!

How secure is this schema for Online Licensing System?

I’m trying to think a good way to make a licensing system without affecting user’s experience and at the same to make it as secure as possible. I know it’s impossible to make it 100% secure, but I would like to make it harder.

What I thought so far:

Registration:

  1. User downloads the software from a public permanent link (mega or something).
  2. User buys the software and receives a unique key on his mail (this key is then wrote on my DB)
  3. User opens the software and registers a new account with Username, Password and the key he received via e-mail. At the same time information about it’s pc is sent (will cover that later)
  4. API checks if the key is not already used and writes Username, Password and PC information on that key’s row.

Login:

  1. User opens software and writes Username and Password.
  2. Username, Password, PC information and Current time is sent to the server.
  3. Server checks Username, Password and PC information and sends an answer based on the current time (to make answer unique, idk if this is useful, read last question on “What I didn’t think about yet”).
  4. Every 1 or 2 minutes the software does 3. again to check if the information didn’t change.

There is a “Reset” button in case the users changed something in their Computers that made the key obsolete. This will ask the user to login, then will replace Computer’s information with the new one.

Computer information:

I’m still thinking about this, maybe Hardware information that cannot be faked, or something. I need all this information to be as hard to fake as possible and not changed so frequently that my users would have to reset their account every day/week.

What I didn’t think about yet:

  • What happens if the user tries to fake the Computer information, how should the server check that the information is wrong. Like if the key becomes “00000000” because all the data is NULL, empty or 0.
  • What happens if there are 2 Computers with the same information (for example, notebooks). Users would be able to use same serial / account for both computers. How often will this happen?
  • What happens if someone gets the source code of my program? Will it have any consequence on the rest of the users?
  • Is it possible to fake the answer from the server? What should I do to prevent that?
  • After thinking about this system I noticed that I don’t have any kind of serial key generated from user information. (I mean, I send Computer information to the server to compare instead of making a serial key with it and giving the user this serial key).

To be honest, I read a lot and came with this Schema that I “tested” in my mind to see if I find any easy way to bypass (I mean things like “if you block internet connection then the program will work without license”). Now after “testing” it in my mind, I need more experienced users to give me some advice. This will be my main source of money while I’m studying and I’m trying to protect it as much as possible. A good link I found was how XP license system works: https://www.licenturion.com/xp/fully-licensed-wpa.txt But is not very useful because I don’t use any kind of serial key containing user information.

I don’t know if this is the page for this, I decided to post this here because I’m not asking about code or “how do i do the following”, I’m asking if this is easy to bypass.

Everything is appreciated, I’m still on the first step (thinking about everything and checking if it fails before I start to code it).

Thanks in advance.

Erro ao gerar schema para o GraphQL com o Graphcool

Estou tentando criar um Schema com o Graphcool em uma aplicação Angular. Os tipos são os seguintes:

type User @model { id: ID! @isUnique name: String! email: String! @isUnique password: String! createdAt: DateTime! updatedAt: DateTime! chats: [Chat!]! @relation(name: "UsersOnChats") messages: [Message!]! @relation(name: "MessagesOnUser") photo: File @relation(name: "UserPhoto") } type Chat @model { id: ID! @isUnique title: String isGroup: Boolean @defaultValue(value: "false") createdAt: DateTime! updatedAt: DateTime! users: [User!]! @relation(name: "UsersOnChats") messages: [Message!]! @relation(name: "MessagesOnChat") photo: File @relation(name: "ChatPhoto") } type Message @model { id: ID! @isUnique text: String! createdAt: DateTime! sender: User! @relation(name: "MessagesOnUser") chat: Chat! @relation(name: "MessagesOnChat") } type File @model { id: ID! @isUnique secret: String name: String size: Int url: String contentType: String user: User @relation(name: "UserPhoto") chat: Chat @relation(name: "ChatPhoto") }

Ao rodar a aplicação e tentar executar o console para verificar minha mutation, recebo o seguinte erro: ERROR Error: "GraphQL error: A unique constraint would be violated on User. Details: Field name = email"

Alguém poderia me dar uma sugestão sobre o que se trata? Obrigado.

Database Schema for a multiplayer quiz game

I’m not an expert in noSQL nor MongoDB but reading I found that doing a quiz with mongoDB should be good.

I’m trying to accomplish this scenario :

There are 2 types of users, let’s say Admin and Worker, and there have different roles.

Admin can do a CRUD of questions, and also can create a room where the users can join to play together (this is just a name) but maybe is a good idea to create more attributes inside of it like, WHO is playing in this room, POINTS for everyone but let’s talk it afterwards when I show you the design.

Worker can play solo or multiplayer.

Ok the thing is, on my design I have :

Collection named User which contains :

  1. _id
  2. username
  3. password

This is a default one, but then I’m wondering how do I define the Role if it’s an Admin or a Worker, something like isAdmin:true and then I check this Bool? Also I’d like to have the reference for those questions where the user has failed more, I mean like a wrongQuestionNumber which contains the _id of the question and the times he/she failed

Then I’d like to have the Question collection where contains :

  1. _id
  2. question_name
  3. answers[1,2,3,4]
  4. correctAnswer or answers because it can be multi option chooser
  5. topic
  6. isExamQuestion

Then the Room collection should contains :

  1. _id
  2. name
  3. capacity
  4. type (game can be as a group or solo) that’s why this attribute
  5. exam (this is an object created by Admin means that when he creates a question he can select many and create an exam with those)
  6. ranking (This is the top X from 1 to X)
  7. don’t think if I have to add the winner here because if I get the position 0 from ranking I get the winner…

There’s a collection named Topic as well, if my question have a topic then I can select the question by Topic. An example of Topic should me Math so user can do only exams or do tests with math questions.

  1. _id
  2. Name
  3. Questions[…]

Any tip is welcome, and improvement as well.

Apache DS LDAP Server Fails to Start After Schema Addition

In an attempt to add the memberOf and sAMAccountName attributes from MSFT, I’m importing the LDIF found in this answer. The import succeeds and the new attributes appear in the tree but when I restart the server it fails to launch. There are no errors in “%userprofile%\.ApacheDirectoryStudio\.metadata\.log”.

In fact, I can reproduce this by adding only the first part of the LDIF:

dn: cn=microsoft, ou=schema objectclass: metaSchema objectclass: top cn: microsoft 

gif of what happens

I’m starting from a brand new server instance. Any ideas?

Win 10 x64

Apache Directory Studio Version: 2.0.0.v20180908-M14

How to create a db schema for “if this then… elseif …. elseif …” and so on?

I want to create an app where a user will go through a series of steps every day. All the subsequent step will depend on the previous ones, that is, 2 users can have different experiences depending on the choices they make every day in my app.

Something like

   if .... then .... =>        ..... if ... then =>            ... if ... then =>       ..... elseif ... then =>       ..... elseif ... then =>        ..... default ... then =>     else if ..... then =>     ...............    ..... default ... then =>     // and so one 

I struggle to start off. How can I create a database schema for this — for the steps and dependencies between them?